How to get price used on issue for production in SAP B1?.

[former_member183402]

Hi all,

I want to do a query of production process where I will select quantity and price used on issue for production, I want to know how to get that price because I do know if it has table where it is saved or if it is calculations.

How can I do that in SAP B1?

Please anyone can help me.

[agustin_marcoscividanes · Accepted solution]

Hi

you can use stockprice or inmprice fields.

Kind regards

Agustín

[former_member183402 · Accepted solution]

Thank you so much Agustin, that's correct.

[kothandaraman_nagarajan]

Above query will show price regardless of issuing method.

[former_member183402]

I mean, the above query does not show the price of items uses FIFO as valuation method.

[former_member183402]

IGE1 table saves only price of item with standard cost (item cost), it does not save item with FIFO valuation method.

[Former Member]

Hi,

Maybe u need to check Item Costing for the price

Regards,

-Eric-

[kothandaraman_nagarajan]

Hi,

Try this,

SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price] FROM OIGE T0 INNER JOIN IGE1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[BaseRef] = 154 (This is your production order number)

Regards,

Nagarajan

[former_member183402]

Hi Nagarajan,

That query is displaying only price for item uses backflush method, it does not display price for item uses manual issue method.

How to display all prices?

[agustin_marcoscividanes]

Hi

the table is IGE1, and you have to filter by:

basetype = '202' and baseentry = yourworkorder.docentry

Select quantity and price.

Kind regards

Agustín

[former_member183402]

Hi Agustin,

Sorry, what is yourworkorder.docentry?