cancel
Showing results for 
Search instead for 
Did you mean: 

Query Help

former_member1133820
Participant
0 Kudos

Dear Experts,

I am working on a yield report to calculate the input output yield. I store the WIP in different warehouses.

For example,

Input A in Warehouse A with qty 10

Output A1 in Warehouse B with qty 8

So the yield for A should be (8/10)*100 = 80%

My problem is I don't know how to get the total quantity in warehouse B to be divided by total quantity in warehouse A for item A.

Is it possible to get the total quantity in one warehouse divided by total quantity in another warehouse in SAP B1?

Thanks & BR,

Leng

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Do you need in this way?

Production order issued material /  completed quantity ,,, 10/8 = 0.8

Thanks & Regards,

Nagarajan

former_member1133820
Participant
0 Kudos

Hi Naga,

I wish to display the report like below:

Species  BatchNum   Input(warehouse A)   Output(warehouse B)   Yield(%)

Maple     QA12345     10                                 8                          80

Maple input store 10 qty in warehouse A

Maple output 8 qty and store in warehouse B.

Yield(%)  = output/input

The report will be filter by IBT1.DocDate.

Thanks & BR,

Leng