cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory status for a date in the PAST with BATCHES with VALUE

a_a
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

a_a
Participant
0 Kudos

Hi Rozario,

Thanks for the pointer. Could you or anyone of the gurus out there have a code for doing this which will achieve this?

Thanks,

Ajay

Edited by: Rui Pereira on Dec 9, 2008 5:08 PM

former_member583013
Active Contributor
0 Kudos

Please take a look at this thread..

Answers (0)