Presented at INFOCUS 2023
Session ID: 101070
After being on JDE for a few years our data set was growing, and performance was starting to decline – it was time to look at archiving data! We enlisted the help of a JDE integrated tool called Purge-It! This tool allows us to archive the data from JDE from within JDE. Their applications and processes use the JDE interface and structure. As we embarked on this journey it helped us to discover process issues that needed to be addressed as well as some data issues that needed to be cleaned up.
Purge-It! Has standard archiving setups for our main JDE modules such as Sales Order, Procurement, Inventory, Accounts Receivable, Accounts Payable, and General Ledger. Their custom module allows us to create our own archiving routines for suggestions, shipments, sales ledger, and EDI. We were able to fully automate the archive process by making use of date offsets and setting the jobs to run on our JAMS job scheduler. All of the archived data is still viewable from JDE if we need it too. We have gained cleaner data and a lot of performance improvements!