Sage 100 ERP 2013: Remove price overrides for 10 specific customers at once in batch process?

Question

Hi everyone, 
 I'm using Sage 100 ERP 2013 and I'd like to remove the price overrides for about 10 specific customers. The customers have customer numbers that aren't sequential, but are scattered, in case that matters. 
 I want to do this in a safe, but efficient way using some sort of batch process. I vaguely know of an import/export option and that this requires apparently removing the entire company's data and then replacing it, which sounds a bit daunting. There are a lot of customers, invoices, items, etc. 
 I've read that this is usually done and tested with a test company - please help me understand how to create (or check for, if one already exists) a test company and ensure the data is intact upon import, if that's the process that needs to be performed here. 
 I'd like to learn to do this myself instead of contacting our reseller, but I'm unable to find clear instructions - if anyone knows of the correct procedure, please link to a document you know of. 
 Thank you

Sage100User · Answer

I can think of 2 ways to do this: 
 (1) Export the pricing file. Remove the records you don't want. Wipe the existing pricing file. Import the records you do want to keep. The data file you need to work with is IM_PriceCode. 
 (2) Write Business Objects Interface code to remove pricing file records if they are for a certain customer. The business object you need to reference is IM_PriceCode_bus. 
 Make a backup first, and practice in a test company. I would suggest when you run this live, do it when no one is in the system because you're affecting a file that's used every time you need to price something (example: entering sales orders).

Sage 100

Sage 100 ERP 2013: Remove price overrides for 10 specific customers at once in batch process?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING