Price list used in Sales Order

[Former Member]

Hi experts,

I would like to know witch price list was used in a given sales order.

I know that RDR1 stores the price used (RDR1.price) , but i can't find what was the price list.

Thanks,

Ricarcdo Luiz

[former_member211473 · Accepted solution]

Hi

Check the default price list associated with customer, in BP master .

Thanks

[Former Member · Accepted solution]

Ranu,

Yes, but the list price in BP may change.

In my work we maintain all the ancient list prices for historic reasons and that specific sale order is about 1 year ago.

Thanks.

[frank_wang6 · Accepted solution]

I did some study, SAP order doesn't save the price list you used.

Frank

[kothandaraman_nagarajan]

Hi,

Please activate Price source  field  from form settings to know price list details.

Thanks.

[frank_wang6]

The price source field is just a Boolean to tell u if the price is manually entered or grabbed from price list.

Frank

[frank_wang6]

another field called Based Price By seems showed the correct result.

Frank

[frank_wang6]

OK, finally found the field in RDR1, it is called GrossBase.

Frank

[Former Member]

Ok, Frank.

Thanks for the tip.

Ricardo.

[frank_wang6]

Please mark the question is answered. Thanks.

Frank