Skip to Content
0

Does anyone know the table where the field "Product Price" of bills of materials is stored?

Jan 12, 2017 at 04:26 PM

36

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

1 Answer

Best Answer
Alexander Nosov Jan 13, 2017 at 09:34 AM
0

Hi Raúl,

the price is stored in the Price List, defined in the bill of Material. In your case it's the price list "07 - Costes de..." (the full name is not visible on the screenshot). So, what you need, is:

select Price from ITM1 where ItemCode = 'Z14A' and PriceList = (select ListNum from OPLN where ListName = '07 - Costes de...')

Show 1 Share
10 |10000 characters needed characters left characters exceeded

You're right, thank you!

0