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

lally · 2008-11-07

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 · 2008-11-08

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

lally · 2008-11-08

Thanks MrSSingla,

Is it possible to customiza that exports?

Could u throw what are points i need to consider .

Share your experience.

ssingla · 2008-11-08

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 · 2008-11-10

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 · 2008-11-10

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 · 2008-11-11

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 · 2008-11-11

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 · 2008-11-11

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 · 2008-11-11

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 · 2008-11-12

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 · 2008-11-12

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.

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

Comments

Categories