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