Vat Calculation issue

ramesh.ayn

Hi All,

My clients need to calculate the VAT amount Before giving discount, and that discount should be posted to an Expenditure account. How i can achieve this? i am using navision 2009 sp1 w1 databse.


thanks and regards,

Ramesh

ramesh.ayn

Hi,

i am using Line Discount.
so my calculation is

line Amount :=100;
vat := 5%
Discount := 5%

first calculate vat on 100 so vat := 5;
then give discount of 5% on 100.

Transaction should be
G/L Account No. Debit Amount Credit Amount Amount
Discount 5 5
Sales 100 -100
vat 5 -5
Trade Debitor 100 100


please help me how can i configure navision according to above senario.

ssingla

I see no problem in your query. Just define the structure to calculate "Sales Tax" without considering Line Discount. Then define 5% as line discount in the line.

ramesh.ayn

Hello Sandeep,

I don't have any Structures setup in w1 Database.

regards,
Ramesh Kumar

Deep

The structure setup is easy, and you can check any Cronus database for reference. Go through the manuals too, and it will be a big help.

ramesh.ayn

Hi Deep,
you mean, i need to customise the w1 product for this type of calculation?

so i have to create Structure tables , and corresponding code.

is it the only way?

regards,
Ramesh Kumar