Inventory Reconcile added RECONCILEXX lot or serial Numbers.

Issue:

You receive the error “Added lot number ReconcileXX” or the error “Added serial number ReconcileXX” when running an inventory reconcile.

Cause:

The cause of this issue is there are unsold records in the inventory receipts table (IV10200) that do not have available serial/lot numbers in the serial or lot tables (IV00200 or IV00300).

Each time a transaction with a positive quantity is posted in GP, a record will be added to the IV10200 table. This record will be assigned a unique receipt sequence number in the table. If the item associated with this transaction has a lot or serial number, lines will also be added to the IV00200 (Serial number table) or IV00300 (Lot number table) for the same quantity and the same sequence number as what is in the IV10200. The IV10200, IV00300, and IV00200 keep track of how many of the items have been used for each of these lines. The remaining quantity for each line (and receipt sequence number) should match between the IV10200 and the IV00300/IV00200.

The first thing reconcile does is reconcile the quantities between the Purchase Receipts table (IV10200) and the Item Serial Number Master file (IV00200) or Item Lot Number Master file (IV00300). It will look at each line with the unique receipt sequence number and make sure the there are available lot or serial numbers in the IV00200 or IV00300 to cover the remaining quantity in the IV10200 based in the item and receipt sequence number. If there are not enough serial or lot numbers to cover the remaining quantities in the IV10200, reconcile will add records to the IV00200 or IV00300 to cover the difference, and it will use RECONCILEXX for the missing serial or lot numbers.

Resolution:

Do the below steps to remove these serial or lot Reconcile numbers and bring in the correct serial/lot numbers if necessary.

• Do a negative inventory adjustment (Transactions | Inventory | Transaction Entry) and remove the quantities with the RECONCILEXX serial or lot numbers.
• Do a Stock Count to verify that that your stock quantities match the on-hand quantities for the items and that all serial or lot numbers are correct for your on-hand quantities.
• Do a positive adjustment to add the items (and correct serial or lot number) back into inventory if they are missing.