on 11-07-2013 8:34 AM
Hi experts,
Thanks in advance for your opinion & comment to my problem:
I created a SO and assign a header condition Z001 (a fixed amount surcharge) . However, the total amount of SO was not match with the billing document.
Process:
1. Create sales order (Net amount: $12,050)
2. Three delivery docs have been separate created base on the sales order.
3. Three separate TO docs have been created and confirmed in different time.
4. Post good issue (three delivery docs in one time)
5. Change the sales order and assign the handling fee $75 in surcharge(Z001). The total net value of the SO = $12050+$75= $12,125
6. Create the billing doc with collective billing function. And then the total net value of the invoice was $12,125.01 in which a "0.1" value difference was found.
7. Handling fee $75.01 was assigned to the default G/L also.
Here the condition difference in billing document:
The figures in blue are my calculation, I don't understand why system will come out a different values.
Article | Qty | Net | Subtotal net | Percentage | Z001 's value calculated | Z001 's value in system |
A | 3 | 84.00 | 252.00 | 0.02 | 1.57 | 1.57 |
B | 20 | 84.00 | 1,680.00 | 0.14 | 10.46 | 10.46 |
C | 5 | 84.00 | 420.00 | 0.03 | 2.61 | 2.62 |
D | 20 | 84.00 | 1,680.00 | 0.14 | 10.46 | 10.46 |
E | 39 | 53.30 | 2,078.70 | 0.17 | 12.94 | 12.94 |
F | 7 | 53.30 | 373.10 | 0.03 | 2.32 | 2.32 |
G | 20 | 53.30 | 1,066.00 | 0.09 | 6.63 | 6.63 |
F | 13 | 53.30 | 692.90 | 0.06 | 4.31 | 4.31 |
A | 17 | 84.00 | 1,428.00 | 0.12 | 8.89 | 8.89 |
C | 15 | 84.00 | 1,260.00 | 0.10 | 7.84 | 7.85 |
H | 20 | 53.30 | 1,066.00 | 0.09 | 6.63 | 6.63 |
E | 1 | 53.30 | 53.30 | 0.00 | 0.33 | 0.33 |
12,050.00 | 75.00 | 75.01 |
Please kindly let me know if additional information is needed for solving this issue. Thanks load.
Hi Gary,
Did you solve the issue?
We have the same situation here.
Regards,
Rodrigo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Select the third line item which is having issue and go to condition tab. There double click on Z001 and share the screen shot. Similarly for line item ten also, paste the screen shot for better understanding..
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It's rounding issue,
Take help of your ABAP'er and create a new routine or modify the existing routine and assign to that condition type in pricing procedure. V/08 t-code.
In standard system routine 16 & 17 available do some modification according to your requirement and some table entries may require.
So take help of the ABAPer to fix it.
regards
Pitabash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gary
It sounds to troubles related with rounding. Please, see SAP Note 80183 - Rounding
Check also SAP Note 24832 - Pricing rules / TVCPF, to check if you have any type of re-determination.
I hope this helps you
Regards
Eduardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
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.