Overview

There is a mismatch between inventory stocks on different screens for inventory items.
In the example below, you can see there is a mismatch between the different locations and the main stock:

Solution

Prerequisites

Access to the Everest  SQL database.

Environment

Everest Standard 6.36.4 and above.

How to identify

1. Use the query below to identify the correct quantity calculation for the item stock
   (note the ITEM_CODE parameter may vary according to the item code):
   

   SELECT qty_stk,
          *
   FROM   items
   WHERE  itemno = 'ITEM_CODE' 
   

2. Use the query below to identify any stock entries where there may be a mismatch in numbers:
   

   SELECT *
   FROM   x_stk_area,
          stk_area
   WHERE  stk_area.area_code = x_stk_area.area_code
          AND stk_area.type < 2
          AND stk_area.active = 'T'
          AND item_no = 'ITEM_CODE'
          AND q_stk <> 0 
   

3. Identify if there are any negative entries or old entries that might be causing a conflict in the calculation.

Resolution

Sample Results:

If the above queries produce results similar to the samples in the table above, please run the following query:

UPDATE x_stk_area
SET    q_stk = 0
WHERE  ( x_stk_area_id = '11111'
          OR x_stk_area_id = '11112' )
       AND item_no = 'ITEM_CODE' 

The Query above will clear the Q_STK fields to zero. Please replace the X_STK_AREA_ID and ITEM_NO parameters with the values from your environment.

Testing

The correct quantities and calculation should now display correctly on all browser screens.