Sage 100 ERP 2013: How to generate a list of all accounts that have special pricing methods set, like price overrides, price discount amounts, etc.

Question

Hi everyone, 
 I'm wondering if anyone knows how to generate a list of all customers that have special pricing methods set, including: Cost Markup Amount, Cost Markup %, Price Discount Amount, Price Discount % and Price Override. The one that's chiefly used is Price Override, but also Price Discount Amount. If it's not possible to get a list of any special pricing method (special meaning pricing that's set per account by item), I'd be mostly interested in generating a list I can export to Excel that has just the customers (with name and account number preferably) that have any Price Overrides or Price Discount Amounts set. If the list has each customer with all of the items that have special pricing methods, I can organize the data in Excel, so that would work too. 
 I've been trying to figure this out and haven't been able to find any information about doing what I'd like to do. 
 Thank you

BShockley · Accepted Answer

Query the IM_PriceCode file in Excel, or create a Crystal Report using this table.

David Speck · Answer

Did you try the Accounts Receivable > Reports > Customer Pricing Report with the "Print Customer Pricing Information" option checked?

socasue · Answer

in version 2013 Sage Intelligence was not embedded in Sage 100, that happened in Sage 100 v 2014. In your case SIR (Sage Intelligence Reporting) functioned much like Crystal reports as a stand along reporting tool

neuropathy · Answer

Thank you - this proved to be very useful for me and I was able to retrieve the data I needed quickly and in an efficient way.

Sage 100

Sage 100 ERP 2013: How to generate a list of all accounts that have special pricing methods set, like price overrides, price discount amounts, etc.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING