You’re offline. This is a read only version of the page.
15
We have a ton of data that was input incorrectly over the years by users that were not familiar with GP. There are over 1000 entries in our UOM Schedule Table. I assumed that the easiest way to rebuild this table would be to start from scratch. With this being said, I went into SQL Server Management Studio and created backup copies of the IV40201 and IV40202, then deleted all entries in those tables (in our test company). This created an issue where any items that had any of these UOMs assigned were unmanageable. Going into the UOM schedule maintenance screen also proved to be unmanageable as well as it seemed to be looking for a base UOM that no longer existed. Once in this menu, it is unrecoverable as the logic will not allow a save of the current record nor will it allow a delete or cancel. I also see nothing useful in the PSTL that would help with this situation so I am asking here for some guidance in how to rectify this situation.
The question is, how would you go about cleaning up the UOM schedule (removing all incorrect entries, and rebuilding with only correct data)? I am trying to figure this out prior to us updating our item classes, price lists, and item numbers. We have a ton of cleanup to do and it seems every time we attempt to clean something up, it causes unexpected issues in GP.
Thanks,
Chris
I would start by finding a script that allows you to search a database for text in all tables. Search for each UofM. If you only find the UofM in the item UofM schedule table(IV40201) then you know it is safe to delete that UofM. Always make a backup first and do this in a test company.
Share
Report
All responses (
Answers (
