Supplier Parts with Price Breaks

[mhunt (Michelle Hunt)]

What report can I run to see a supplier that has parts with price breaks?

[timshuwy (Tim Shoemaker)]

I dont believe that there is a base application to show a list of supplier prices. on the supplier tracker / supplier screen, in kinetic, you can click on the activity section and see a list of parts with prices for that supplier. There is also a “Supplier Price History” report but i believe it shows historical purchase orders and not the supplier price list.

[mhunt (Michelle Hunt)]

Hi Tim, what I’m trying to see is parts that have multiple price breaks. Is there a report for that?

[timshuwy (Tim Shoemaker)]

not that i know of.

[Mark_Wonsil]

We did a BAQ for the current price break, but you may be able to tweak it to do what you need:

BAQ Assistance Requested - I don't know how Joins work

So, to get the most current VendPart takes a subquery and a trick. This is baptism by fire my friend. Create a new innersubquery and drag VendPart to the screen. Create a criteria to eliminate any future EffectiveDates. [image] In your Display Fields, add Company, PartNum, EffectiveDate, and VendorNum. Create a new calculated field called RowNum: [image] What this does is assigns the ROW_NUMBER to each record within the part in descending order (most recent to oldest). I did this is in a…

VendPBrk is the table and there is only an EffectiveDate. Dumping that table to Excel might be good enough, or you can play with the BAQ to do a COUNT on the number of records to find multiple records for the supplier/part combo.