on 07-18-2019 2:58 PM
Need table details to pick batch wise item cost/ batch transaction value, transactions wise & not just closing stock.
Tried to pick Batch wise item cost in particular transactions where row level combined Qty is captured and its split will have multiple batches. Each batch may have different cost which is exactly captured in Inventory audit report but do not know how to derive it in SQL / HANA query.
Tables Tried: OINM, IBT1, OIBT, OILM
This article from Steve Lipton might help you understand the structure and contains lots of good detail on the batch transaction table structure:
https://www.linkedin.com/pulse/batch-numbers-writing-recall-report-sap-business-one-steven-lipton/
Hope this helps!
M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use OBVL Tables which stores batch cost for every transactions where the inventory movement is there in SAP Business One.
Thanks,
Prudhvi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
106 | |
12 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.