Excise, vat percentage in invoice report.

austin

Hi all to experts,
I have a typical scenario for which i would like your assistance.

In sales invoice U have report Excise and sales tax.
When taking print out in that report we need to have how much excise percentage we assigned to that customer and how much sales percentage percentage we assigne d to that customer.If it is cst how much we assigned to that customer. I want that amount and percentage.
what i assign to that customer , that should come in report.
Example:

Excise = 2000;
vat/cst = 500;
the above process is general process.

we want like this.

Excise (16 %) = 2000;
VAT (4%) = 500;
or
CST ( 3%) = 400;

Like this we want.
Sorry, I've never had any training on codes or on this part of Navision, so I have no clues on what to do. Thanks again for your helps
I am not getting where to start . Could u provide solution.Please.........

thanks

ufuk

I could not understand exactly. Are these rates constant or variant?

If constant:

First get the total value of excise in related table. Then filter the table by customer and get the customer's amount. Use a variant of type decimal and divide this values.

If variant:

Get the values by arrays if the rates are not table data then assign this sums to related array variant.

Regards

austin

Thanks UFUK,


We are using indian version anvision 4.0 sp1.
I think u dont know about indian excise, vat , cst.
For each customer that excise , vat or Cst will change depend up on location.
some customers will get excise 16 % some will get excise 8%.
Vat Or Cst depend up on State That is 3 % and 4 %.
We set up these excise and vat in Excise set up and Sales tax set up. From these we have to get values. Please provide some code.
I hope u can under stand now.
Please...............
thanks and regards,

ufuk

Basically, if I understood right :

SalesInvoiceLine.CALCSUMS(Amount);
TotalAmount := SalesInvoiceLine.Amount; //total amount
SalesInvoiceLine.SETCURRENTKEY("Sell-to Customer No.","VAT %")
SalesInvoiceLine.SETRANGE("Sell-to Customer No.",CustomerX);
CustAmount := SalesInvoiceLine.Amount; // customer's total amount
SalesInvoiceLine.SETRANGE("VAT %",VatCode1);
VatAmount1 := SalesInvoiceLine.Amount; //amount of related VatCode1
SalesInvoiceLine.SETRANGE("VAT %",VatCode2);
VatAmount2 := SalesInvoiceLine.Amount; //amount of related VatCode2

Or you can create a flowfield in the setup table. You can add customerfilter, vatratefilter, datefilter etc. fields in this table and calculate the vat (etc.) with any rate for any customer more simple.

In Turkey I also get monthly totals of VAT by rate . I am using ValueEntry for cross-check and get the values by flowfield.

austin

Hi navision experts,

Thanks UFUK,

It is not working which code u send to me. u r code showing only line amount. It is not showing any vat % .
I hope u are not understanding my problem.
Just see sales invoice report. in that report u have excise amount and tax amount fields. Both fields showing just amounts like this
excise amount = 2000;
vat = 300 in report like this showing.

but i want excise amount ( 16%) = 2000;
vat ( 3%) = 300;

in report i want percentage of both with amount.

I hope u can under stand meeeee........

thanks in advance

Deep

Use the fields BED% and VAT% from the sales invoice line.