Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Inventory As Of — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Inventory As Of

Received Response
edited Jul 1, 2020 9:22AM in Inventory Management 6 comments


Reconciling inventory balances with general ledger balances


Hi all,

I would like to share this topic: at month end we have to perform a balance reconciliation between inventory and general ledger.

We use standard cost as evaluation method, thus value is quantity x standard cost.

We have to consider for the reconciliation only transactions within the period, therefore we cannot use inventory on-hand, since this is changing continuously and cannot be frozen at date.

Currently we have built a report to calculate balances at month end from the very beginning, but in time the number of transactions to consider will increase and report duration will increase accordingly. Being a retailer, the number of record per month is several hundred thousands. 


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!