Helen-Webley's avatar
Helen-Webley
Experienced Cover User
11 years ago
Status:
Open

Report: Inventory Value Reconciliation - Exclude 0.00 items

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's avatar
    CloudMindAcc
    Ultimate Cover User

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

    • jenniek's avatar
      jenniek
      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.

       

  • jenniek's avatar
    jenniek
    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.

  • Liam_M's avatar
    Liam_M
    Former Staff
    Status changed:
    New
    to
    Open
    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.
  • Liam_M's avatar
    Liam_M
    Former Staff

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

  • TonyLane's avatar
    TonyLane
    Ultimate Cover User

    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.

    Inventory Reconciliation Report omitting 0 values workaround.jpg