Sage 100

Client used VI to export and then import Salesperson codes into the SO_ShipToAddress Table. Issue is that the location codes were 001, 002 etc, and of course, Excel stripped the zeros and now they have duplicate ship to codes (1 and 001). Short of exporting the info, wiping the table and re-importing the correct data, is there a better way to delete or merge the ship to's? There are about 6500 records in the excel file, so doing it manualy is not an option. (Version 4.50.7 Standard) Thoughts?

You are going to have to export the table. Clean it up. Reinitialize the table and reimport with the correct data. Sorry :( No easy way.

Darn! I was hoping there was a secret ninja move I didn't know about. Thanks anyway, @TyiDuncanWhitcomb

How long ago did they do this?? You could restore the ship to table from backup if one exists that is ""clean"". Other wise, wipe and redo....

@JeffSchwenk Good idea! It was only yesterday afternoon, I think it would be more trouble than it was worth to try and restore that table though. I think their backup is off-site and you have to download the whole Mas90 folder then pick and choose what you want once downloaded (26 gigs). I will check on that though, it would save me several hours! Outside of restoring that table and rebuilding/resorting (AR and SO?) would there be anything else I needed to do? I think I have only restored a single table once, and I feel like I am forgetting something.

Rebuild sort files for AR/SO should be all you need to do after restoring that file. You will want to make sure the client knows that if any new ship to codes were added since your backup, then they will need to re-add those or you could end up with errors on any orders/invoices that might reference those. this is off topic but I would probably rebuild sort files on all modules; If I rebuild any module sort files I tend to just run through all of them while I have users out. That way you recalculate the ""on SO"", ""on PO"" amounts and such.

Good call @DavidOverholt Thank you everyone!!

Good call on the sorts and added records. You could extract the ship to codes from the SO header record to compare to the ship to table information. From my perspective of having the IT restore a table, they should be able to get the exact table (and only that table). If this restore is such an issue, then they need to practice it more often so they are prepared in a REAL emergency. It is also a good way to find out if the backup is working at all.....