Presented at INFOCUS 2023
Session ID: 100440
CJ Inventory Diagnostics has partnered with MFA Oil to produce a suite of comprehensive custom Inventory Reconciliation tools within JD Edwards which assists with reconciling the Item Balance (F41021), Item Ledger (F4111), and General Ledger (F0911) tables. This suite of online tools replaces the cumbersome reporting process and manual Excel spreadsheets making the month end process streamlined, faster, and more efficient. Variance analysis and finding the root cause for inventory integrity issues has never been easier!
We will demonstrate a full Inventory Reconciliation including:
• Quantifying quantity, amount, and GL variances at the Company, Business Unit, and Account levels of detail
• Why it's important to include the Item Balance as part of your reconciliation
* How Inventory Quantity and Value are calculated and compared to Item Ledger Quantity and Value
• Finding root causes to common quantity, amount, and GL variances using drill down functionality and determining what actions to take and why
* Understanding commit fails, why they happen, and how to fix them
* Understanding primary UOM and conversion changes/deletions and what impacts they have on inventory integrity
* Understanding cost variances caused by weighted average cost
* Understanding the impact of using the wrong line types with inventory GL Class Codes and vice versa
* Etc.
• How end of day processing impacts your reconciliation
• Automated Inventory Level-Set
• Automated GL Level-Set
The custom suite of applications that will be demonstrated in this overview are: Inventory Reconciliation Workbench, Item Balance/Ledger Integrity, Item/Account Ledger Integrity, Unprocessed End of Day, General Ledger Summary, Running Weighted Average Cost Analysis, Item Ledger Variance Analysis, General Ledger Variance Analysis, Sales Ledger Variance Analysis, and Purchasing Ledger Variance Analysis.