Dear All,
I am facing a problem of automatic change of purchase quantity in the following situation:
1. I have three materials: A, B and C.
2. Rounding values are:
240 PC for material A
240 PC for material B
400 PC for material C
3. Let's assume the MRP calculated requisitions for the given materials as follows:
A 240 PC
B 0 PC
C 400 PC
and ...
Part A ... Qty 240 PC divided by Rounding value 240 PC = 1 (let's call it set)
Part B ... Qty 0 PC divided by Rounding value 240 PC = 0 set
Part C ... Qty 400 PC divided by Rounding value 400 PC = 1 set
The sum of such sets equals 1 + 0 + 1 = 2.
4. Now, the business requests the total number of sets for these three materials (A,B and C) must be divisible by 3 and 4.
5. In our sample 2 is not divisible by 3 or 4 and the system should increase an order of one of the materials by as many sets as the total of them is divisible by 3 or 4.
A 240 PC changed to 480 PC -> 2 sets
B 0 PC -> 0 sets
C 800 PC -> 1 set
3 sets are divisible by 3 and the requirement is fulfilled.
Now the question is - can SAP in standard handle this?
Many thanks in adance for any suggestions.
Regards,
Grzegorz