Skip to Content
0

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

Feb 08, 2017 at 09:42 AM

33

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Agustin Marcos Cividanes Feb 08, 2017 at 05:14 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded