Inventory on Hand on Item List does not match Adjust Quantity/Value on Hand form

Legacy KB ID: 4523

Question

Why does the Current Quantity listed in the Adjust Quantity/Value on Hand form differ to the On Hand shown on the Item List?

Answer

The most likely cause of this difference is that the Adjustment Date on the Adjust Quantity/Value on Hand form  is before the date of the latest Inventory transaction.

The Item List shows the On Hand for All Dates in the company file; the Current Qty column of  the Adjust Quantity/Value on Hand form shows the Quantity on the Adjustment Date.

Workaround

1. Find the last date an inventory transaction was processed:

a.    Lists > Item List > highlight the inventory item > right-click > QuickReport;

b.    Set dates to All Dates;

c.    View the last transaction and note the date;

d.    If the date is incorrect, change it to the correct date.

1. Set the Adjustment Date on the Adjust Quantity/Value on Hand form to no earlier than the date of the last inventory transaction;
2. Check that the Quantity on Hand now matches the Item List On Hand.

Additional Information

See https://kb.reckon.com.au/issue_view.asp?ID=3730 for a general guide on locating discrepancies between Inventory Account balances and Inventory Valuation reports.

Need more help?

Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts

Or Log a Support Ticket: https://www.reckon.com/au/support/