on 05-19-2014 2:42 PM
Hi guys! I really need your piece of advice.
Lets take an example:
I have an order with great number of items with given net value.
Item1: 1 308,15
Item2: 130,82
Item3: 2 616,32
Item4: 130,81
Item5: 1 308,15
Item6: 654,08
When I want to execute billing of such a document, SAP calculates tax per item(for example 10%):
Item1: 1 308,15
TAX calculated value: 130,82
Item2: 130,82
TAX calculated value: 13,08
Item3: 2 616,32
TAX calculated value: 261,63
Item4: 130,81
TAX calculated value: 13,08
Item5: 1 308,15
TAX calculated value: 130,82
Item6: 654,08
TAX calculated value: 65,41
Sum: 6148,33 TAX: 614,84
If we calculate total tax per document: 6148,33 * 10% = 614,83
We have 0,01 discepancy for document with 6 items, for document with hundred intems this discrepancy will be huge.
Do you have any idea how to fix it?
I hope my description is fine however I am just an abaper
Thanks for your help,
Adam Tomaszewski
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Adam,
Were you able to correct this issue by simply changing the condition to a group condition.
I have the same exact issue you initially described. However, when i update or create a new sales order after updating the condition type, the taxes are still not correct at the header level.
Please let me know if there was anything else that you had to do to correct this issue.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Create new routine , In that routine write code to add correction factor to last item in the billing document at item level.This will solve your issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
See SAP Note 315792 - Group conditions of the same amount on item
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.
Hi Adam,
In pricing master routine level just check how many digits it is capturing.
means 1st line item 130815 is your base value then tax 13082 if it is rounding off for tax
2nd line item 13082 is your base value then tax 1308..
actual your tax value is 13081.5+1308.2 = 14389.70
so do the necessary changes in the routine field length increase to 2 to 3 decimals then you will get the accurate values.
Regards,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
First of all, your description of your issue is clear.
Now regarding your issue, system always do the rounding of one Condition Value based on the rounding rule you apply, and it is for one Line Item. So the calculation is correct as per the line item.
System simply add the values of Taxes from different line item to have a Total Value of the document at Header Level, so certainly you mayget a minor difference, as you have already explained.
As far as I am aware there is no standard solution for this. However since you are an ABAP Consultant so you may think of some Z-development for updating the value at Header Level.
Thankis and regards,
Amitesh Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.