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

There is also a standard report in Inventory>Reports>Inventory Price List.

Thank you - I had some issues, but managed to get a bit further and this is looking better. 

Do you happen to know how to get Customer Name in here since it's not in the Price Code table?

Also, guessing that under Pricing Method: 

O = Override

P = Percentage (not sure if discount or markup)

M = Markup (not sure if amount or percentage

D = Discount

These aren't that important - I really just need to know which accounts have any pricing methods set so I can clear them, as these are causing me to have to change pricing on the fly while entering orders, which is tedious and it's time I do something about it! 

Thanks again

Thank you, I looked, but wasn't able to find a way to see if there's anything set for Pricing Method in the Customer Maintenance files for each individual account and only report the ones that have data set there.

Here are the valid values for the PricingMethod column as per the online file layouts, https://help-sage100.na.sage.com/2020/FLOR/index.htm#File_Layouts/Inventory_Management/IM_PriceCode.htm%3FTocPath%3DFile%2520Layouts%7CInventory%2520Management%7C_____63.

• C=Cost markup amount
• D=Discount percentage
• M=Markup percentage
• O=Override Price to Notes
• P=Price discount amount

If a record has a value in the ARDivisionNo and CustomerNo columns, then it is linked to a customer on those fields. If these fields are blank, then it is just a standard price code record which is applied using the pricing hierarchy, https://help-sage100.na.sage.com/2020/Subsystems/IM/ConceptTopics/Pricing_Priorities.htm. 

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

@BShockley  any report that can be done in Crystal can be done in SIR except for payroll due to PII restrictions. 

That may be true but a direct Excel ODBC query is MUCH easier to create / refresh (vs working with SI).

A custom Crystal Report is probably close to the same effort to design, but is again much easier to refresh than anything in SI.

SI certainly has it's place... but for simple data queries (like looking for customers with override pricing) it is often not the most efficient solution.

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.

Thank you - I was finally able to get some time to try this as well and found that "Print Customer Pricing Information" was checked by default. I ran a Preview of the report and it seems to be processing, as I need this information from the entire customer base, which is a few thousand customers. It's taking quite a long time. Is this normal? I ended up terminating the process as this was taking a lot of time and CPU power, which had me concerned.