Tuesday, September 26, 2017

To Control AX database size when it keeps on growing (AX 2012)

General Ledger:  
General ledger> Periodic> Clean up > Clean up ledger journals 
Inventory and Warehouse Management: 
Inventory and warehouse management> Periodic> Clean up> Inventory journals cleanup 
Inventory and warehouse management> Periodic> Clean up> Inventory settlements cleanup 
Inventory and warehouse management> Periodic> Clean up> Dimension inconsistency cleanup 
Inventory and warehouse management> Periodic> Clean up> Inventory dimensions cleanup 
Organization administration: 
Organization administration> Periodic> Calendar cleanup 
Organization administration> Periodic> Delete inactivated addresses 
Procurement and Sourcing: 
Procurement and sourcing> Periodic> Clean up> Purchase update history cleanup  
Production control> Periodic> Clean up> Production journals cleanup 
Production control> Periodic> Clean up> Production orders cleanup  
Sales and Marketing: 
Sales and marketing> Periodic> Clean up> Sales update history cleanup 

No comments:

Post a Comment

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...