exclude tax amount

[Former Member]

hi gurus

my customer enter order amount manually and include tax amount, now he needs the system to calculate tax amount when his employee enter the price manually. i tried to create tax condition with minus sign of the condition amount but the condition calculates tax wronge. the right calculation of the tax is price X (100/108) and the result will be diducted from price to get tax amount, example:

1- price amount: 1000X (100/108) = 925.92

2- tax amount: 1000-925.92 = 74.04

this is my issue any help

[venu_ch8]

Dear Islam

as lakshmipathi sir said it is possible by using Revere pricing calculation process

please check it once

[Former Member]

Hi,

plz try the following solution, and hopefully it helps.

- in condition type maintenance, set the condition type for price (e.g., PR00) subject to manual update

- set pricing type of the pricing procedure to something like 'leave manual updated condition unchanged, and reprice others'

- in your case, tax is 7.4% of the price, so go to maintain corresponding condition record of that kind

with the above set, go for sales document entry, and go to condition tab in sales item, manually update the price, e.g., in your example, to 1000, and click update button, price value will remain unchanged and tax will be recalculated on that basis

[Lakshmipathi]

Have you explored the backward pricing functionality?  If not, search the forum on this topic so that you will get some inputs.

G. Lakshmipathi

[ravi_kumar100]

Hi,

Kindly do confirm if your requirement is that the user enters the final price then the tax value and the price should be split accordingly.

For Example: 880 SAR- Final Price

Will be split into 872 INR - Selling Price

and Tax of 10 % as Tax - 88 INR

Regards,

SRK

[former_member183155]

Hi all ;

It is possible with pricing procedure customizings --> like belowed.

Condition formula for alternative calculation type

Alternative formula for condition base value

To modify any condition for example :

---- ****----

FORM FRM_KONDI_WERT_910.

  IF KOMK-FKART = 'F2' OR KOMK-FKART = 'S2'.

    DATA: LS_KNUMV LIKE VBAK-KNUMV,

          LS_KWERT LIKE KONV-KWERT.

    CLEAR: LS_KNUMV, LS_KWERT.

    SELECT SINGLE KNUMV INTO LS_KNUMV FROM VBAK

                  WHERE VBELN = KOMP-AUBEL.

    IF SY-SUBRC = 0.

      SELECT SINGLE KWERT INTO LS_KWERT FROM KONV

                    WHERE KNUMV = LS_KNUMV

                    AND KPOSN = KOMP-AUPOS

                    AND KAPPL = 'V'

                    AND ( KSCHL = 'ZKD1' OR KSCHL = 'ZKD2' ).

      CHECK: SY-SUBRC = 0.

      XKWERT = LS_KWERT..

    ENDIF.

  ENDIF.

ENDFORM.

---  ***  ----

Alternative formula for example :

* Pricing procedure subtotal 1

form frm_kond_basis_005.

  xkwert = komp-kzwi1.

endform.

Assign subtotal1 to your amount entered manually and calculate taxes with formulas.

Regards.

M.Ozgur Unal