Advanced Pricing Report

[Mpeter]

Hi Listers,

We have advanced pricing enabled on our system.
So when we Inquire on an Item with Address Number & Item , in the CHECK & PRICE AVAILBILTY SCREEN ( P40721) it generates the Invoice price i.e. Unit Price - Discounts.

Now I need to generate a report which shows me the Invoice Price per each customer for the packs.

I believe there should be some report already provided by JDE which gives us this info.

I might be wrong as well , if it doesnot exist then , I need to create new report which gives me such Report which calculates the Invoice Price.

Please let me know your thoughts.

Thanks!
Mark

 

[EvoltaRobot]

I don't think JDE provides this type of report. If you want to create a new report, you need NOT to calculate it. Simply retrieve the selling price from file F4211 or F42119 (if F4211 is purged after sales update), field SDAEXT (Extended Amount) for each invoice. F4211 has 2 discount fields too, namely SDADSC and SDADSA.

 

[Randi Grover]

Advance Pricing creates the price on the fly so when you use Check Price & Availability or create a Sales Order, the price is calculated based on the date.

I know of no report in JDE. We have written query's to get the information.