Share your ideas for improving the new AccountRight. Vote on ideas and discuss them with the MYOB product development team.

AccountRight

Inventory Reconciliation Report

Experienced Partner

39Posts

309Kudos

0Solutions

39 Posts
Experienced Partner
New Zealand

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

Current Status: Open
Last Changed: June 2014

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.

7 Comments
Ultimate Partner BooksInTheCloud
1,730 Posts
Ultimate Partner

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

Ultimate Partner jenniek
2,427 Posts
Ultimate Partner

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.

 

Ultimate Partner jenniek
2,427 Posts
Ultimate Partner

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

MYOB Moderator Liam_M
3,488 Posts
MYOB Moderator
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.
Ultimate Partner Mike_James
4,321 Posts
Ultimate Partner

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.

 

 

MYOB Moderator Liam_M
3,488 Posts
MYOB Moderator

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

Ultimate Cover User TonyLane
2,847 Posts
Ultimate Cover User

Hi @jenniek , @Kelly81 , @Trevor_H , @ASWatCR , @Mike_James , @Denise_Cimarosti , @BooksInTheCloud , @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.

Inventory Reconciliation Report omitting 0 values workaround.jpg