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

[former_member396783]

bills-of-materials.jpg

[alexander_nosov · Accepted solution]

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...')

[former_member396783 · Accepted solution]

You're right, thank you!