FIN05: Inventory Balancing & Reconciliation Tips & Tricks

1. FIN05: Inventory Balancing & Reconciliation Tips & Tricks Brian Lounds - Greenlight Jan Dahl Sorensen - Greenlight Jason Reed - Microsoft

2. AX Inventory Balancing and Reconciliation Tips and Tricks • Welcome • Short Presentation • Interactive Discussion • Wrap-up

3. AX Inventory Balancing and Reconciliation Tips and Tricks Your Speakers • Brian Lounds Greenlight BTS blounds@greenlightbts.com • Jan Dahl Sorensen – Greenlight BTSjsorensen@greenlightbts.com • Jason Reed – Microsoftjason.reed@microsoft.com

4. AX Inventory Balancing and Reconciliation Tips and Tricks • Why are we here • What versions

5. AX Inventory Balancing and Reconciliation Tips and Tricks • What causes balancing issues: • Control Accounts not locked • A/P / Ledger entries • Configuration issues • Postings not configured consistently • Service items posting to control accounts • Understanding Reports / Posting Setup’s • Physical vs. Financial (Model group post / not) • Which report / which data on report • New Inventory Value Report SP1 • How does configuration relate to reports

6. AX Inventory Balancing and Reconciliation Tips and Tricks • What causes balancing issues con’t • Ledger Account on Purchase Order – Users entering an override account on the PO line that is something that should have gone to inventory • Lack of understanding on how expense items should be configured • Data Changes • Model group changes - post / not post • Item group changes – can affect ledger acct • Standard cost change ( prior to AX2009)

7. AX Inventory Balancing and Reconciliation Tips and Tricks • Where to start to solve issues: • Understand your configuration • Where do different status of transactions post • Understand Physical Inventory Reports • Based on your configuration use appropriate report data to tie out • New Inventory reports in AX2009 SP1 - KB982712

8. AX Inventory Balancing and Reconciliation Tips and Tricks • User Voucher reconciliation / exceptions • General Leger \Reconciliation reports • Run reports for specific items / item Groups and specific account • Use “!” ledger account for specific transaction types / items to find exceptions • Also do in reverse to find posting to account not from items / item groups desired • Use these reports to get voucher list from inventory sub-system to compare to voucher list from ledger transactions for exceptions (helps to narrow to short date range initially)

9. AX Inventory Balancing and Reconciliation Tips and Tricks • Things that help • Database log on key fields (item group, item posting setup, model group details) • Alerts on key control fields (item group, cost price, etc.) • Simplify posting structures and make consistent to be supported by reports in system • Minor changes to inventory reports to tie to configurations

10. AX Inventory Balancing and Reconciliation Tips and Tricks • Things that help (con’t) • Security on PO ledger account field if possible to prevent use • Get setups complete, balanced synchronized and validate process in test system – then get production system in sync. • Lock ledger control accounts • Understand Physical Inventory Reports • Which report / columns to use based on setup

11. AX Inventory Balancing and Reconciliation Tips and Tricks Round Table Discussion • What tips work for you