cancel
Showing results for 
Search instead for 
Did you mean: 

Negative quantities

Former Member
0 Kudos

Hi guys we recieved a Ticket for Demand Planning saying that :

 

Negative quantities in Open Orders key figure

any clue where should this be fixed please

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ganesh,

This needs to be fixed in ECC to resolve the root cause, however, you can avoid negative quantities from being loaded into APO planning area at one of these places:

1. Avoid loading negative quantities into the open order key figures into the planning area - This is a key figure setting (Checkbox to not allow negatives) in the planning area - T. Code /SAPAPO/MSDP_ADMIN. Checking this setting in production system may lead to data loss, therefore, please be careful. Also, presence of any negative quantities in APO cube may cause the load from APO history cube to planning area job fail.

2. Avoid passing negative quantities from BI to APO, by changing the transformation rules in DTP, load quantities greater than or equal to 0 only.

3. Change the open orders load from acquisition layer of BI to final cube to "Full Mode" instead of "Delta Mode". This is because ECC distinguishes between open orders and closed orders based on delivery status of an order, this leads to negative deltas being passed from an acquisition DSO to a cube if an existing open order becomes closed due to complete delivery. This may lead to negative quantities due to improper time bucketing of the quantities.

4. Find out in ECC, what is causing negative quantities for open orders, Is it because of improper status mangagement of orders, too many cancellations, reversals, etc. withour proper reason codes. You have to work with your SD team to figure this piece out. This will resolve the root issue.

Thank you,

Regards,

Jagjeet.

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you, you have answered my question

Former Member
0 Kudos

Ganesh,

Can you mark my answer as "Correct Answer" if you are satisfied.

Thank you,

Regards,

Jagjeet