Item balance reconciliation

When you reconcile item balances, the physical count is compared to the adjusted current balance for each item. You can reconcile item balances for counts that match the current balance from the Count Books application.

To reconcile the balance of items from the Count Books application, the physical count must be a match with the system-calculated current balance. That is, it must be within tolerances as defined in the Organizations application or in the Inventory application. For matches, the adjusted current balance is reset to the physical count value when you select Reconcile. After you reconcile item balances and change the status of the count book to COMP (complete), the inventory balances in the database are updated.

Items with a physical count that is not a match must be reconciled manually in the Inventory application.

For non-rotating items, standard inventory processing is used to adjust the current balance and to account for the change in inventory value. You can also count rotating items. For rotating items, you must reconcile any counting discrepancies for each individual serial number by using the Move Asset action in the Assets application.

After you reconcile item balances, you can undo the reconciliation for individual count book lines or all count book lines. For some items, you might want to investigate count discrepancies, even if within tolerances, and manually adjust the current balance in the Count Book application. When you undo the reconciliation of item balances, the updated GL Debit Account and GL Credit Account values remain in place. You can undo the reconciliation of item balances until you change the count book status to complete (COMP).