i want enter Price List from Price Report to Discount Name in Sales Order

[Former Member]

I use Price Report in my Sales Order.And i have other fiels in Sales order(this names is Discount Name).When i enter any Price List from Price Report(for example 28%+1%),i want that Discount Name will get this Price List.But i dont know how i start query.And i use FMS.Any suggestion?

[agustin_marcoscividanes]

Hi

if you want to use a FMS you have two cases:

1. if the Price comes from OSPP or SPP1 or SPP2 tables, you have to use one of this in the priority SBO assign the Price.

2. if the Price comes from ITM1.

After this you have to join with OPLN table to obtain the description.

You can add an UDF to save this information in the document lines.

Kind regards

Agustín