Pricing - Calculations

[Former Member]

Trying to figure a way to achieve the below... Inputs are appreciated

we quote customer unit price tax incl. @ 109.23, order Qty is 3600

Then, total amount = 109.23*3600= 393,228

If we maintain price recorder as tax exclusive, then unit price is 93.3589 (assume SAP allow 4 decimals)

Then, SAP amount = 93.3589*1.17*3600 = 393,227.69

It would be several penny different.

As business usual in X Country , tax is calculated on based sum amount not unit price, which SAP works contrarily. So if it is multiplied by  the qty, the difference would amplify. For customer they want to receive invoice with total amount 393,228, which 100% matches contract.

On what basis would i go ahead and write a routine against MWST ?

More inputs :

How about this :

      - you agree on inclusive price with customer (in this case 109.23)

      - you take price and divide by 1.17 - in this case you would get 93.3589.   You then take this price and round to two decimals - in this case 93.36.   You enter this in our zb05 price condition.  This is the price we charge to customer.

      - then in pricing procedure we calculate the tax.  In this case 93.36 * .17 = 15.8712.   We would round this to 15.87.

      - to get the total price (which we would print on the order ack and invoice) we would add the zb05 and the tax - in this case 93.36 + 15.87 = 109.23)   

Let take this scenario with the 3600 qty example :

       unit price is 93.36 * 3600 = 336096 * 1.17 = 393232.32

       I know if you take 109.23 * 3600 = 393228

NOTe :  We would take the unit price per UOM , multiply the unit price by 1.17,  round the result (this would be contract price quoted to customer),     So in this case the tax would be 15.87 (rounded) * 3600 = 57132.      This would be in place of the 57136.32 which would result if we took 93.36 * 3600 * .17

Issue with our standard procedure :  the issue is that the way our pricing procedure is, is that we would take the unit price 93.36 * the qty (3600) and then mutiply by .17 to get the tax.   This results in a price of 393232.32 instead of 393228

Thanks

Prash

[saranglonkar]

Dear Prashanth,

Check OB90 setting for company code, currency and rounding unit.

Hope this will help you.

Regards

Sarang

[andrea_brusarestelletti]

Hello,

  did you check this OSS note?

80183 - Rounding

It talks about rounding in discounts but perhaps can give you some useful hints.

Best regards,

Andrea