Inventory Reporting
Inventory reporting is horrible! Stock on Hand Report doesn't list all inventoried items, and therefore doesn't agree to the Balance Sheet. Item List Report lists all items, but doesn't list qu...
Forum Discussion
Hi Essentials ,
Mike_James gave an excellent summary, reports and stock on hand should agree at all times, are you still having issues? If so please let me know and I will be happy to schedule a call to investigate it further.
Thanks for the feedback re: supplier item ID, we are looking into adding it to the PO/Bill pdfs soon.
Regards,
Bruno
Hi Bruno,
Yes, I am still having issues, but they are minor compared to previously.
I worked out that quantities were not updating correctly where I had simply edited an existing invoice or purchase. I went through and manually re-entered all sales invoices and purchase invoices, then deleted the previous versions, and this updated the records so that everything matched.
An absolute pain in the neck, but this was the only way to fix it.
After finally getting everything to agree exactly, I'm now having issues with the reports being out of balance a few hundred dollars. I'm putting this down to rounding due to some items having an average cost value of $14.11656321571 (or similar).
Still frustrating, and not ideal, but I'm putting up with it because a discrepancy of a few hundred dollars is better than the $75,000 discrepancy I had before. I still can't understand how three reports all designed to show the same thing can arrive at three different figures.........and how none of them actually agree with the Balance Sheet.
David.
I will reach out via email to get steps to replicate chat soon Essentials
