Skip to Content
Nov 01, 2019 at 01:21 PM

SAP Business One - How to get Current Batch/Serial Cost value by Query for Reports

1273 Views Last edit Nov 02, 2019 at 07:09 AM 2 rev

Dear All,

Right now, I've some customized reports for a retail customer, where all the reports run based on the Current Batch/Serial Cost.(It's a retail customer so for same ItemCode Cost Price may be in range Rs. 300 - Rs. 2500 Maintained by Batch. Margin is tracked through ItemCode and Batch) .

I couldn't take the Cost from OINM table, as i've multiple Batches in IBT1 for a Transaction Line like Goods Receipt PO(PDN1), AR Invoice(INV1), Goods Receipt(IGN1) and Goods Issue(IGE1). Kindly provide me a Query to find the as on date Batch Cost.