Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Batch cost

Hi,

Though the accounting works in fifo or moving average , can the cost be updated in the batch record when the goods receipt or landed cost is done.

Similarly can the sale price of the batch be updated in the batch record when the sale takes place in delivery or AR invoice.

Or is ther any query which gives the batch costing.

Pls advise.

Rgds,

Former Member
Former Member replied
SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T1.[DocEntry], T1.[LineNum], T2.[BatchNum],T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price], T1.[LineTotal], T1.[WhsCode] FROM [dbo].[OINV]  T0 INNER JOIN [dbo].[INV1]  T1 ON T0.DocEntry = T1.DocEntry INNER JOIN IBT1 T2 ON
T1.[ItemCode]=T2.[ItemCode] AND T1.[LineNum]=T2.[LineNum] AND T1.[BaseLine]=T2.[BaseLinNum]
WHERE T0.[DocNum]='[%0]'

Jeyakanthan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question