Items Register

Question

When I run the Items register (Summary) report as at a date, it shows the no. of items on hand, but when I click into an item to look at the detail, the balance in the report does not agree to the transcations running balance as at the last transaction on the date selected.

Its like its randomly selecting a transaction in the middle of the date selected, rather than the last transaction on that date.

I'm trying to balance physical stock take to MYOB.

Can someone assist?

gavin12345 · Answer

Hi&nbsp;Bradworthington&nbsp;&nbsp;Suggest you use the Inventory Value Reconciliation (IVR) Report - it is much more reliable than the Items Register reports which have numerous bugs yet to be fixed.&nbsp;The IVR will give you the correct on hand count as at the specified date. It will also give you the value of the item in the item register which should match with the balance of the Inventory account. If not, a stocktake is a good time to fix it all up.&nbsp;RegardsGavin

bradworthington · Answer

And when I run the Items Register (Detail) I get a different tally to the summary report and the item screen report ?

mike_james · Answer

Hi&nbsp;Bradworthington&nbsp;, whilst there could be other reasons for these issues, are you using multiple locations?

bradworthington · Answer

Hi Mike, no, just the one location

Forum Discussion

Items Register

4 Replies

Related content

No items showing in Item Register or Inventory Reports

Items register

Change item to Inventoried Item

Items List and Items Register Differ

Purchases Register

Registering GST

Can't register app for APIs

Bulk Item Import: Changing Item Number