Sage 100

Client wants to start over with their customer pricing grid. IM.ItemPricing has 3000 lines. Any adverse affect if I just reinitialize the table?

I've done that for customers who redo their pricing. We've set up import routines for them to reimport what they want going forward after reinitializing the file. But you should probably make a backup copy first....

+1 what Therese said but I've done it before and it worked.

I've also written exports of their current pricing to Excel for them to use to modify it. Once they've finished, then we reinitialize and re-import it.

Made a copy of the table, then reinitialiized it. Added a couple items back to the table to develop the VI import. Client will start importing their own pricing. Way easier than what they were doing.....

We have a client that uses customer pricing extensively. About 15 years ago, we created an access data base and routines to create deals for a customer that might involve a whole product line, range of items or what ever. The access data base would create a record for each item affected. From that we would export the IMB type 0 and 1 price records, reinitialize IMB, import the type 0 and 1 records and then import the type 2 records from the access data base. It worked really well. A couple years ago, they reached about 600K records and we had issues with it taking all night. We gave up on the heavy importing and one of our guys wrote routines in BOI to Add, Change or Delete records as necessary based on the contents of the current records in Access. Under this system, it rarely takes over 10 minutes to do the job. They only do it about once a month except in the spring but it works so well, the BOI rouutines are run every night and if no changes have been made, it is done in a few seconds.