Let's walk through creating a standard Build VM
You are here
Clean Up Inventory Journals
Posted Inventory Journals hang around and can take up a fair amount of space if pruned. Let's take a look.
Inventory Journals Clean-up
Over time, the amount of inventory posted inventory journals can grow quite large. There is typically no value in keeping these journals around for closed years. Once a year is closed, I would expect that its inventory never changes. There is a way to clean up posted journals.
Where Is This In AX 2012 R3?
In Inventory Management > Periodic > Clean up, look for Inventory Journals Cleanup. This will let you clean up posted journals by type. This will first delete posted journals by type (InventJournalTable), skipping business logic and delete actions. Next, it will identify journal lines (InventJournalTrans) that donΓÇÖt have journals any longer and delete those, skipping business logic and delete actions. Next, if Tag journals were deleted, it will cleanup related records in the Tag counting table (inventJournalTrans_Tag). Finally, if BOM journals were deleted, it will delete all Inventory batch merge (InventBatchJournal) records skipping business logic. I suggest you run this in batch. Note: This functionality doesnΓÇÖt have a date or age filter as part of it so it will delete all inventory journals that have been posted. Run this in a test environment before trying it in Production.
Where is this in Dynamics 365 for Finance and Supply Chain?
This works the same as AX 2012 and can be found in the same place.
Other Versions
This was made available as part of R3 or with CU7 for R2. This is not available for AX 2009 or AX 2012 RTM. See https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/clean-up-... for more info.