on 11-06-2008 3:09 PM
Hi,
How can I get a status REPORT of all inventory as on a date in the PAST with BATCH numbers and VALUE?
The following ready reports do not solve my problem:
1. Inventory Status: This gives CURRENT date inventory QUANTITY only.
2. Inventory in Warehouse Report: This gives CURRENT date only, no BATCHES.
3. Inventory Audit Report: Doe not give BATCH numbers and ignores qty without transactions.
4. Inventory Valuation Report: Meant for "what-if" only.
5. Inventory Posting List: Does NOT give BATCH numbers
6. Batch Number Transactions Report: Doe NOT give VALUE.
I suppose an SQL will be required for this requirement?
Thanks,
Ajay Audich
Hi
Yes only an SQL query can give value in batch no. report. Try using he IBT1 batch no. table and relate it to the Doc value for that Doc no. The standard SAP reports only mention the batch no and transaction details but not the value.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.