So, what exactly is an inventory pipeline and why is it important to manage? It all has to do with the timing between when transactions appear in the cardex and when they are recorded in the general ledger.
There are 2 types of timings I like to refer to as “Batch Now” and “Batch Later”. “Batch Now” means that a GL batch is created at the same time the entry is made in the cardex. Examples of these would be issues, adjustments, transfers and purchase order receipts. The GL batch is created but posting is a separate process.
“Batch Later” means there is a time delay between cardex entry and GL recognition. There are additional steps that must be completed before the batch is created. This is what forms the pipeline. The main transactions are material issue to work orders, work order completion and shipment confirmation. Here is an example of the process flows with typical status codes:
The pipeline is important to manage for period end reconciliation purposes. It must be empty for the inventory reports to match the general ledger balances! How can it be managed? Via custom reporting! It is simple to create reports by status code for both the sales order and work order processes. Keeping the pipeline up to date during the period and emptying it during the close will make your reconciliation process much faster!
Happy reconciling …
Meet the Author
Ed Gutkowski - Chief Architect - RapidReconciler