Gross/Net Price in pricing procedure

[former_member534382]

Hi Guys:

            I have a requirement that there are several  condition types with tax in sales order, users want to get the value without tax separately, because they will be in different G/L accounts.

            Is there any standard routine in pricing procedure can cover this?

            For example:

                   Condition<Input>           with tax       tax rate   

            Gross condition type 1         110USD         10%         

            Gross condition type 2         140USD         10%         

                  Condition<Output>          without tax

            Net condition type 1                100USD

            Net condition type 2               127.27USD

            Thanks.

Stephen

[former_member212707]

Stephen,

Have you tried using the "Step" process to sum your pre tax values? In the above you could add a step to sum up the Net condition types 1 and 2.

Thanks,

Ravin

[former_member534382]

Hi Ravin:

             How can I the net value base-on the gross value separately?

[former_member212707]

Can you attach a screenshot of your Pricing Procedure?

[former_member534382]

For example: ZV16 is condition with tax input by user, and then get the value without tax for condition ZV06

[Former Member]

Stephen, are you aware as how to do reverse calculation for your pricing schema? Here let's suppose

ZV16 = 58,000

tax (condition MWST) = 17%

calculation of tax would be 58000/(100%+17%)*17% = 8427.35

price w/o tax copied to ZV06 = 58000 - 8427.25 = 49,572.65

Now as per schema configuration, my first condition is final product price inclusive of tax entered manually on which I've calculated 17% tax after which got price without tax then in 3rd condition I've maintained value as 100% and copied above step which was price without tax. Rest i believe if you're managing that big step schema then you know well as at which step you need to assign account keys. I'm sharing snapshots for better understanding just try this and revert with your findings accordingly. Feel free to ask in case of any further assistance. Thanks.