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
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 |
---|---|
68 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.