Error message when you perform a stock count on a serialized item in Microsoft Dynamics GP: "The variance or counted quantity for this serial number does not equal the variance or counted quantity for this item"

Applies to: Dynamics GP 2010Dynamics GP 2013Microsoft Dynamics GP 2015

 

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

SYMPTOMS

When you perform a stock count on a serialized item in Microsoft Dynamics GP, you receive the following error message:

The variance or counted quantity for this serial number does not equal the variance or counted quantity for this item

This problem occurs when you perform the stock count and then click OK in the Stock Count Serial Number Entry window. This problem occurs even after you confirm the following:

• You confirm that the value in the Counted Qty field in the Stock Count Entry window is equal to the values in the Serial Numbers Counted field and in the Item Counted Qty field in the Stock Count Serial Number Entry window.

• You confirm that the physical counted quantity is correct.


     

CAUSE

This problem occurs if either of the following conditions is true:

• The stock count was already started when you performed the stock count, and the items in that stock count were sold. In this scenario, the values that appear in the Stock Count Serial Number Entry window reflect the stock count that existed before the items were sold.
• An interruption occurred that caused the variance quantities to be incorrectly updated.



     

RESOLUTION

To resolve this problem, use the appropriate method:

 

The stock count was already started

Method 1: Restart the stock count if you can

1. Click Transactions , point to Inventory , and then click Stock Count Schedule .
2. Click the lookup button next to the Stock Count ID field.
3. Click the stock count, and then click Select .
4. Click Cancel Count .
5. Click Start Count .

Method 2: Override the quantities

1. Click Transactions , point to Inventory , and then click Stock Count Entry .
2. Click the lookup button next to the Stock Count ID field.
3. Click the stock count, and then click Select .
4. Click the serialized item.
5. Click Serial/Lot .
6. Verify that the value in the Serial Number Variance field is equal to the number of serial numbers that are set to Not Found in the Count Status column.
7. If the value in the Serial Number Variance field matches the number of serial numbers, click OK . You receive the error message that is mentioned in the "Symptoms" section.
8. Click Override .

An interruption occurred

Update the Serial Number Variance field. To do this, follow these steps:
1. Start SQL Query Analyzer. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .
2. Log in as the sa user.
3. Select the company database in the database list.
4. Type the following statement.
SELECT * FROM IV10301 where STCKCNTID = '<XXX>' and LOCNCODE = '<YYY>'
Note In the statement, replace the <XXX> placeholder with the stock count ID. Replace the <YYY> placeholder with the site ID.

If the multiple-bins feature is enabled, add the BINNMBR field to the statement.
SELECT * FROM IV10301 where STCKCNTID = '<XXX>' and LOCNCODE = '<YYY>' and BINNMBR = '<ZZZ>'
Note In the statement, replace the <ZZZ> placeholder with the bin number.
5. Note the DEX_ROW_ID value of the retrieved record. The DEX_ROW_ID value is in the last column of the table.
6. Update the record by using the DEX_ROW_ID value. To do this, type the following statement.
UPDATE IV10301 SET STCKSRLLTVRNC = <##.#####> where DEX_ROW_ID = <BBB>
Note Make sure that you include five decimal places. If no values follow the first two digits, use zeros. For example, if the value in the Serial Number Variance field is supposed to be 12 , type 12.00000 .

Note In the statement, replace the <##.#####> placeholder with the serial-number variance value. Replace the <BBB> placeholder with the DEX_ROW_ID value.

DISCLAIMER 

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.