Skip to Content
0
Former Member
Apr 14, 2014 at 11:09 AM

Stock Audit Report vs Balance Sheet

92 Views

I am having problems matching the balance sheet to our stock. I presume that the stock audit report is the best report for evaluating our stock but this does not match our balance sheet.

The balance sheet stock looks at 3 accounts, Finished Product, Work in Progress and Raw Materials. I set the audit report to only look at these accounts and to read all groups. I also ticked 'display OB for items/accounts with no transactions'.

This still does not match. The only thing I can surmise is that something has gone wrong or someone has posted something in these accounts to throw it out of balance but if so then I do not know how to find the problem as this could be going back years.

Is there a better stock report / query to use or is there some sort of query that can flag up any obvious errors?

Thanks for your help in anticipation.