Inventory Tracking and Reconciliation

[Former Member]

I have the following Issue when trying to reconcile inventory counts. When I go to :

INVENTORY> Inventory Transactions>Initial Quantities, Inventory Tracking and Posting>Inventory Tracking Tab>click OK.

I double click on the "Counted in Whse" to display quantities (from smallest to largest) and I can now view all items with a check mark in the "COUNTED" column.

The next step is to reconcile the count, you go to:

INVENTORY> Inventory Transactions>Initial Quantities, Inventory Tracking and Posting>Inventory Posting Tab>click Reconcile. This action should reconcile the count in SAP and in the inventory tracking screen you should see noting checked marked in the "COUNTED" column and no entries in the "Counted in Whse" column.

Our problem is, when you return the screen Inventory Tracking, you still see the check marks in the "COUNTED" column and a count in the "Counted in Whse" column. Its as if nothing was reconciled and the exact items are still listed as counted and they are awaiting to be reconciled.

I thought I would post this issue here before I submitted a request to SAP.

[Former Member]

Issue resolved and the problem was identified

[Former Member]

Hi Nate,

Have you checked the item on hand to see if the count has been posted? When you have multi warehouse, count is against each warehouse. You can have more than one count info for one item. Reconcile will only post one warehouse at one time.

Thanks,

Gordon

[jitin_chawla]

Hi Nate,

In the Inventory Tracking window is the quantity entered in the column Counted in Warehouse.

If there is a difference positive and negative in the Stock in warehouse and the counted in warehouse, the same will be updated and shown in the Inventory posting list to be reconciled.

Regards,

Jitin

SAP Business One Forum Team