I have been asked to create a report showing the Actual Costs versus the Quoted Costs for every shipment. We utilize Quantity Price Breaks in the Quote Module, so I need to be able to find the correct Quantity Break based on the Order Quantity.
For instance, Quote Line has Quantity Breaks of 10, 20, 50, and 100.
Order entered is for 60. I need to get the information tied to the 50 Quantity Break.
Are BAQ’s powerful enough to get specific quantity break I need? Or do I need to pass all the info to SSRS and then narrow it down to the correct quantity break?
Either way, has anyone ever successfully done this that can provide some guidance?
Thanks in advance.