Sage 100

Does anyone have the job cost purge utility that needs to be run in order to clear history from pre-framework change (2020) jobs?  Sage is having trouble locating it.  Without it we'll need to manually delete hundreds and hundreds of old records via DFDM.  Apparently the Job and Cost Code History does not get cleared when running the new framework purge utility on old jobs. And if a job gets restored for use, all of the ancient history appears.  The utilities on v2022 or newer are not clearing the cost code history and job cost billing history files where the data was kept in the old framework. 

Attached is the updated utility from Sage, which apparently only works on jobs created 2018 and prior.  Basically the already-existing utility up until 2019 did not purge jobs restored from old framework.  So they ran the updated utility in v2022 and it got rid of history prior to 2018 that the out-of-box utility missed.

(Got this info second-hand.)

Attachment(s)

JC_JobHistoryDataFix_utl.docx   71 KB 1 version

JC_JobHistoryDataFix_utl - updated.zip   3 KB 1 version

Added to our KB:  Looking for Job Cost History Purge utility re_ old pre-framework jobs _ Sage 100