Share
Report
15We 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
All responses (
Answers (
