Report: Inventory Value Reconciliation - Exclude 0.00 items

[Helen-Webley]

Could you please add an option to include/exclude zero balances as is possible in the Accounts Receivable Reconciliation Report and Accounts Payable Reconciliation Reports

"Inventory Reconciliation Report"

[CloudMindAcc]

The inventory valulation report should have a tick box to remove zero balances.  I 

[jenniek]

I too would love this. Often clients have stock items that they no longer carry, or just don't have any stock. These can make the report very very long, so it would be good to just see the items they have in stock and the value of them. Anything with a value and/or quantity wouldbe included and an option to exclude the nil balances. I have 1 client with 30,000 stock codes - they certainly wouldn't be running this report in it's present form. Reality is they only use about 2500 of those codes.

[jenniek]

yes please - totally agree - some inventory reports are so long they just can't be printed because there are so many nil balances.

[Liam_M]

Thanks for your suggestion Helen. Anyone else who would like to be able to hide zero balances from the inventory value reconciliation report, please cast your vote here.

[Mike_James]

This is a duplicate of: http://community.myob.com/t5/AccountRight-Idea-Exchange/Inventory-Valuation-Report/idi-p/216487, which has 3 votes. Could MYOB please mark one as such and combine the votes.

[Liam_M]

Thanks for bringing this to our attention Mike. The copy with the least votes has now been marked as a duplicate.

[TonyLane]

Hi @jenniek , @Kelly81 , @Trevor_Harrison , @ASWatCR , @Mike_James , @Denise_Cimarosti , @CloudMindAcc , @David_Cree , @Bundy , @LFW02 

I've just created a workaround that you can use in the meantime to print a report that only has non-zero values displaying in it.  Please refer to the image below which illustrates how to print a Inventory Reconciliation report that only reports non-zero values.  You must already have the report open to apply the workaround; once you are satisfied with the result you could save it as a customised report for future use without having to repeat the first 2 steps again.