Tax calculation on amount before discount

chrispaul

Hi All

Please help me with a solution for my query below :

I have a sales order with one sales line with qty as "1" unit price as "100 $" and there is a tax levied of 7 % on it ; now i have a discount of say 20 % i.e. 20 $ and when i post these lines my entries comes like this :-

Revenue Acc = -100
Tax Acc = - 5.6
Disc. Acc = 20
Debtors acc = 85.6

Which is correct from Navision point of view but i want the system to include GST on complete amount before discount and entries should be like this

Revenue Acc = -100
Tax Acc = - 7.0
Disc. Acc = 20
Debtors acc = 87.0

please tell me if there is any way to handle this scenario, Urgent

Thanks in Advance

vijayanderson

I didnt completely understand ur query, If my understanding is right, the solution given below will work

In Structure card uncheck include line discount and Invoice discount option and then try calculating it..

Regards
Vijay

chrispaul

Hi Vijay

Thanks for your reply but here my country localization does't have anything like structures like in india so tell me if there is any other solution for this .

Thanks

meikcremer

Hi,

I don't think you can get this working with Line Discounts, you should work with "Charge (Items)" in a separate SalesLine. Configure this Charge to work without tax and you should be fine.

Regards

chrispaul

Ya it works but in case i need it to work with Prepayment % as 100 in all d sales lines so navision does't allow to enter -ve quantity if prepayment % is > 0, Any ideas ?