FORM. A.R.E. 1 / Indian Localization

lally

Hi experts,


When you are selling the exciseble goods for out country u need to create the excisable records


Like FORM. A.R.E. 1 ( Application for removal of excisable goods from a factory ) This form is for General Export.

If it is the Deemed Export then we need to submit FORM A. R. E. – 3.

Is it available in Standard Navision ?


Please throw some information on this .

ssingla

Exim module was discarded by MS India from version 4.0 onwards. You need to customize the reports.

lally

Thanks MrSSingla,


Is it possible to customiza that exports?

Could u throw what are points i need to consider .


Share your experience.

ssingla

The report needs data from the sales invoice header and sales invoice line and it is similar to sales invoice, the only difference is that it will always be based on LCY, so use the LCY Fields of the table.

lally

Thanks Mr. SSingla,

I hope that u know very well , when we are selling the Finished goods for Out of country there is no Excise calucation In Sales inVoice.
Just Invoice amount and Vat.
So sales invoice has Line amount and Vat.
But when it comes to A.R.E. 1 has Excise amount values .

So i think there is no use to take the sales Inv. Header , sales .Inv.Line.

So how to take that A.R.E .1 report with excise values.

Please throw some help on this................

vijayanderson

HI,

We have customized on the Same report which you were speaking about, There is no Navision Report in that. A separate table is created , which has excise and its components with the Starting date.. Based on the % Given we calculate for each line and store it in line and into posted invoices..
Note : What you have mention here is just 5% of a large customization.. Get the full requirment, It includes return, CT3 & CT2 .

Regards,
Vijay

lally

Thanks Mr Vijay,

Again I am not understanding y again u have to insert that Excise in Sales Invoice tables.

Because we are not caluclateing the excise for export.


Please throw some more explanation on this.

vijayanderson

Hi,

By Government rules, there is no excise calculation for Export (ie : excise is exempted), but the government,bank as well as company want to know how much amount they save without paying the Excise duty. Hence they calculate the amount saved due to duty cut.

Hence a separte table has to be created for calculating excise , if you use the excise setup in Navision throught structure it will update in Cutomer table, item table GL etc. its wrong so we create a table based on the percentage given there we calculate the excise amount and store in Sales line.

Note: Its virtual value , and doest affect any table, only for report purpose

Hope this helps u.

Regards,
Vijay

lally

Thanks Mr. Vijay,


Could throw some customization hints, and some detail functionality.

that means excatily hoe did u caluclate theat excise duty.

Just give some more explanation regarding functionality.

ssingla

Use standard Navision. There is no need of table customization. Define proper Excise Product Posting Group on the items. Create 2 Excise Bussiness Posting Group :
a) Exempt: To be defined on the customer card.
b) Dummy: To be used for calculation of Excise. Define the rates as needed.

Make the combination of Dummy and Item's excise product posting group for the excise calculation on ARE1. Create a custom field in the Sales & Receivable Setup table for selection of Dummy excise bussiness posting group.

Create your report using "Dummy" excise buss. posting group defined in the Sales setup and item's excise product posting group.

vijayanderson

Hi Sandeep,

Will the above solution calculate for all the invoice for that particular customer. For my client the above set up in on condition -( if ct3 is "yes" we dont have duty if "no" there is excise duty), we created a field in so with yes/no option, if yes it will calculate and store in the table.

Cheers,
Vijay

ssingla

You can always store the options in Sales Invoice Header table and make the excise calculation conditional in the report. What I fail to understand is the type of information you are storing in seaprate table that cannot be stored in standard table.