Home Discussions Questions & Answers Inventory GL Reconciliation Issues after Closing Period

Inventory GL Reconciliation Issues after Closing Period

Avatar photoCustomer April 6, 2023 at 12:31 pm

We’ve noticed differences between our cumulative inventory accounting entries and the onhand valuation after closing an inventory period. How can I use Blitz Report to investigate this reconciliation issue?

Viewing 4 reply threads
  • Author
    Replies
    • Support April 7, 2023 at 5:53 pm  

      Run the CAC Inventory Out-of-Balance report. This report compares summary and detail item cost information against the period end snapshot created during period close, highlighting any differences that could cause reconciliation issues.

    • Avatar photoCustomer April 8, 2023 at 1:32 am  

      Which parameters are mandatory for running this check for a specific month?

    • Support April 8, 2023 at 4:19 pm  

      The mandatory parameters are ‘Period Name (Closed)’, which is the closed inventory accounting period you wish to report, and ‘Minimum Value Difference’. The default minimum difference is one, but you can set it to zero to view all differences.

    • Avatar photoCustomer April 9, 2023 at 2:41 pm  

      I only want to look at large discrepancies. Should I adjust the Minimum Value Difference parameter?

    • Support April 11, 2023 at 6:06 am  

      Yes, adjusting the ‘Minimum Value Difference’ parameter higher than the default of one will restrict the report output to only show larger discrepancies, helping you prioritize high-value reconciliation issues.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: