Our inventory settlements table is growing exponentially, is there a problem with archiving last year’s records and then truncating them from the settlements table? Thanks! Melissa Ingram
I was told about the InventorySettlements clean-up job and have run it, it reduced the number of records in the table from 16 Million Plus to 10 Million Plus. This greatly increased the processing time for the month end close.
Thanks for your feedback!