SAP B1 batch cost used in goods issue

[mark_ownby]

I need to find the batch cost used in a goods issue (issue for production) transaction in business one. IGE1 seems to hold the average of all the batch costs for all batches of an item issued, but if there are multiple batches, I need to determine the exact cost of each one, not the total average. Customer is using batch costing, not average cost. Note that due to additional receipts into the batches in question after the goods issue, simply using the current average cost of the batch will not work - I need to be able to look at the goods issue transaction, link to the batch(es) issued and then find the cost of each batch that was used at that time. I have looked in IBT1, IGE1 and cannot seem to find that actual batch cost., just the average.

Example: item 123 is issued to a production order. Qty 1 from batch 001, which has a cost of $5.00, qty 1 from batch 002, which has a cost of $10.00. IGE1 shows a qty of 2 and a cost of 7.50, both of which are correct. IBT1 shows each batch (001 and 002) and the quantities of each that was issued, but does not show the cost of each. I need to find the $5.00 and $10.00 that was used.

[msundararaja_perumal]

Have you tried using the inventory audit report to view the cost by batch/serial no.

Thanks.

[prudhvi_ravipati]

hey hi, have you achieved the following request. as i have same requirement to get the batch cost used in goods issue.

[prudhvi_ravipati]

hey hi, have you achieved the following request. as i have same requirement to get the batch cost used in goods issue.

[prudhvi_ravipati]

Hi @mark_ownby ,

Use following Query which give Batch Wise Cost for all transactions.

select
(case when T0."DocType"='60' then 'SO' when T0."DocType"='59' then 'SI' when T0."DocType"='162' then 'MR' when T0."DocType"='67' then 'IM' end) as "Type",
T0."DocEntry",T1."BaseNum",T1."DocDate",T0."ItemCode",T1."ItemName",T1."WhsCode",
(case when T0."ActionType"='1' then T0."Quantity" when T0."ActionType"='2' then -T0."Quantity" else 0 end) as "Quantity",T1."BatchNum",

T2."MnfSerial" as "Potency",T2."LotNumber" as "AR NUM",T2."ExpDate" as "Expiry Date",
(case when T0."ActionType"='1' then T0."Quantity"*T0."Cost" when T0."ActionType"='2' then -T0."Quantity"*T0."Cost" else 0 end) as "Value",
MonthName(T1."DocDate") as "Month",YEAR(T1."DocDate") as "Year",T0."MdAbsEntry" as "Line"

from OBVL T0 inner join IBT1_LINK T1 on T0."DocEntry"=T1."BaseEntry" and T0."DocType"=T1."BaseType" and T0."DocLineNum"=T1."BaseLinNum"
and T0."ITLEntry"=T1."LogEntry" and T0."ItemCode"=T1."ItemCode" and T0."DistNumber"=T1."BatchNum"
inner join OBTN T2 on T2."DistNumber"=T1."BatchNum" and T2."ItemCode"=T1."ItemCode"


Thanks,
Prudhvi.