Rounding off amount on invoices created in SD

[Former Member]

I want to round customers invoices created in SAP-SD. I have added a new Condition Type to our Pricing Procedure, so that we are now able to 'manually' enter the rounding. What I would like to know is whether there is any way to calculate this rounding 'automatically'? and how?

Is there any user-exit, OSS note, etc. I can implement? Has anybody found this issue in another SAP implementation?

[Lakshmipathi · Accepted solution]

There is a standard condition type DIFF for rounding in SD which you can see in V/06. Assign this condition type to your pricing procedure so that your requirement would be fulfilled.

thanks

G. Lakshmipathi

[eduardo_hinojosa]

Hi,

Check:

Note 315792 - Group conditions of the same amount on item and related notes.

Note 80183 - Rounding will help you too.

Regards,

Eduardo

[Former Member]

Can you explain what is causing your rounding variances. I can probably help you if I know this info. I just want to determine if the rounding issue can be resolved at the order time so you don't have rounding issues during invoice or if it will be required during the invoice process based on the scenario.

[Former Member]

In fact, I have the rounding issue in the Sales Order, not in the Invoice.

For example, letu2019s say we create the following sales order:

Net Amount 45,00 SEK

VAT 25% 11,25 SEK

Total 56,25 SEK

I want SAP to round the total amount from 56,25 to 56,00, so that the sales order should include the rounding condition type:

Net Amount 45,00 SEK

VAT 25% 11,25 SEK

Total 56,25 SEK

Rounding -0,25 SEK

Total Invoice 56,00 SEK

I know how to enter this rounding manually, but we would like to know if it is possible to do it automatically (user exit?). The rule is very simple: more than 0,50 should be rounded up and less than 0,50 should be rounded down.

Please help

[Former Member]

You should consider a Condition formula for alternative calculation type and assign it to the line you want rounded in your pricing procedure. It sounds like you want to round a total line . Here is an example sudo code. Define a data field without decimals like

data: w_data_no_dec type I. .

w_data_no_dec = Price + tax.

xkwert = w_data_no_dec.

By default commercail rounding occurs on w_data_no_dec , so this should give your desired result.