on 09-22-2013 4:38 PM
Hi Experts,
I have a requirement wherein I am setting up a product allocation for order confirmation.
Our client does not use ATP at order level and after creation of delivery they will run custom ATP program to check availability and reduces the qty in delivery. The moment there is a reduce in qty in delivery I want the open allocation quantity to be adjusted accordingly.
For this, I also have to make us of delivery quantity. Therefore I have copied standard info structure S140 and added delivery quantity as a key figure in info structure. Scenario is something like this
Week1 | Week2 | Week3 | |
Incoming Orders Qty | 200 | 200 | 200 |
Allocation Qty | 200 | 400 | 400 |
Confirmed Qty | 200 | 200 | 200 |
Delivery Qty | 0 | 200 | 100 |
Open Allocation Qty | 0 | 200 | 300 |
For week 3, Open allocation qty is 300 even if the order confirmed is for 200. This is because the delivered qty is only 100. For this reason I want delivery qty to be updated in the info structure and I will make use of formula to get the required calculations.
Below are the questions / Issues I am facing
Pls share your expertise.
Thanks,
Sunny
It is a very good case, but the total allocation will be more than what is allocated if you implement this logic....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
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.