Net value of the document item in sales order after tax

[Former Member]

Dear All,

Is there any possibility to make the Net value of the document item, which appears on top of "Conditions" tab, to be after tax. Right now this value is giving an amount before tax. I want this amount after tax.

Please let me know if this is possible..

Rgds

Akber

[Lakshmipathi]

Search SCN with the text "Tax inclusive in price" so that you can decide whether that is what you were looking for

G. Lakshmipathi

[Former Member]

Thanks Mr Lakshmipathi,

But unfortunately this is not what Im looking for. Below is the scenario. Right now "Value of goods" highlighted in orange is getting picked in the "Net" value which is 1642.11 hihglighted in dark brown/maroon. Now I have some tax conditions below "Value of goods".

ZSED = PKR 149.27

ZTAX= PKR 32.84

ZUAX = PKR 146.62

I have added one more line in my access sequence "Net Value of Goods" and put routine 2 in calulation type, and I thoought that Sum of the 3 taxes would get subtracted from Value of goods (the amount would be PKR 1313.38) . PKR 1313.38 would get picked in "Net" value, but still it is not getting picked. I want that Net value should be inclusive of tax. What is the procedure to do this ?

[former_member184771]

Dear Akber,

You want net price as adddition of 1642.11 + 149.27 + 32.84 + 146.62?

[Former Member]

Dear Sumeet,

No I want net price as subtraction of 1642.11-149.27-32.84-146.62= 1313.38

Regards

Akber

[Former Member]

If there is not way to get 1313.38 in "Net" value, then please suggest a calc type or routine that does this (1642.11-149.27-32.84-146.62= 1313.38). I will get 1313.38 printed on the invoice script.

Rgrds

Akber

[jobis]

Hi Akbar,

What process is this..? You have the basic price, then discount and taxes. then you have the net basic price = basic price - discount.

normally tax has to be added into the net basic price. Why you want the tax to be a discount..?

What's this business scenario..?

Thanks

Jobi

[former_member184771]

Dear Akber,

Request you to please explain the process, why tax amount need to be subtracted from base price.

If you want to subtract the same why you craeting it as tax condition?

Thanks.

[moazzam_ali]

Hi

This is not possible with this way. You are using conditions for tax with condition type D which is always added in tax. For meeting your requirement you have to use condition types for tax with condition category A which is discount and surcharge. With this tax amount will not be shown in Tax field and you can add or subtract the way you want.

With this you also have to use accrual settings and assign debit credit both GLs.

For better understanding if you can share the required accounting entry than this would be helpful for me to understand the requirement and suggest you solution.

Thank$