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

 

[Rorqual]

Hi ,
If you have advanced pricing .. than it can be tricky .. and if you have customer - sku group combinations then it might be even more tricky ..

I suggest you make a query and join them on
ICID field (so KIICID = BPICID)
Linked as F4106 primary file link as 1 to F4094 and take F4101 for items ..