Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
exciseduty caluclation help
austin
Member Posts: 191
Hi nav experts,
We are implementing navision to manufacturing firm. What my query is regarding Excise duty calculation.
Our firm make finished product in two process.
1. with their own raw material
2. with customer material
If it is client material there is no problem with exciseduty calucaltion.
But when in the case of customer rawmaterial there following different method.
I will explain the process. .
They do job work. that means customer will send raw material to our client directly from purchaser with sales invoice.. with customer material our client make finished product. For that they will charge conversion char ges per metric tone.They calculating this excise duty differentrly.
When they are creating sales invoice at that time they calculating excise duty on purchase rawmaterial cost per metric tone+conversion charges+ Some value addition tax = some value(yyy)
On this some value(yyy)* how much iam sending finished product = zzz
On this zzz they calculating 16 % excise duty.
Finally they are not calculating on sales line amount.
This process for conversion process according to Indian law.
This is process. Suppose Customer send (108.11 metric tone raw material).From that our client take some material and make finished product , send to customer. This is process. We did not send total quantity at a time . we send many many times with little bit quantities….like some time 2 MT, 6 MT, 8 Mt………
For example customer send 100 kgs rawmaterial to client Now we sending 3.366 finished product to customer out of 100 kgs.
On this how they are cluclating excise.
Line amount = 3.366*16000=53586
Excise duty calculation :
They are not calculating excise duty on sales amount, they calculate on this below method
First customer send raw material That total cost is XXXXXXX
Our client take raw material unit cost 71710(per metric tone) suppose
Conver sion charge 16000( per metric tone)(to convert raw material to finished goods)
Some value addition tax 8771
10 %( 10% on sum of above)
Total value (71710+16000+8771)= 96481
Now I am sending 3.366 to customer. Out of total qty how much I received
S0 total value 96481 *3.366= 324755.05
On this amount (324755.05)our client calculate excise duty 16% - 51916
To tal sales invoice amount = line amount + exciseduty = 53586+ 51916
I know excise duty can calucalte only on base amount,(is it sales line amount or purchase line amount)
they are caluclating in different way.
Guys provide help. They are following this calculation according to Indian rules for jobwork. It ‘s killing me. I am in dar with this query . throw powerful light on me.
experts throw u r valuable suggestions
I hope u can provide solution.
We are implementing navision to manufacturing firm. What my query is regarding Excise duty calculation.
Our firm make finished product in two process.
1. with their own raw material
2. with customer material
If it is client material there is no problem with exciseduty calucaltion.
But when in the case of customer rawmaterial there following different method.
I will explain the process. .
They do job work. that means customer will send raw material to our client directly from purchaser with sales invoice.. with customer material our client make finished product. For that they will charge conversion char ges per metric tone.They calculating this excise duty differentrly.
When they are creating sales invoice at that time they calculating excise duty on purchase rawmaterial cost per metric tone+conversion charges+ Some value addition tax = some value(yyy)
On this some value(yyy)* how much iam sending finished product = zzz
On this zzz they calculating 16 % excise duty.
Finally they are not calculating on sales line amount.
This process for conversion process according to Indian law.
This is process. Suppose Customer send (108.11 metric tone raw material).From that our client take some material and make finished product , send to customer. This is process. We did not send total quantity at a time . we send many many times with little bit quantities….like some time 2 MT, 6 MT, 8 Mt………
For example customer send 100 kgs rawmaterial to client Now we sending 3.366 finished product to customer out of 100 kgs.
On this how they are cluclating excise.
Line amount = 3.366*16000=53586
Excise duty calculation :
They are not calculating excise duty on sales amount, they calculate on this below method
First customer send raw material That total cost is XXXXXXX
Our client take raw material unit cost 71710(per metric tone) suppose
Conver sion charge 16000( per metric tone)(to convert raw material to finished goods)
Some value addition tax 8771
10 %( 10% on sum of above)
Total value (71710+16000+8771)= 96481
Now I am sending 3.366 to customer. Out of total qty how much I received
S0 total value 96481 *3.366= 324755.05
On this amount (324755.05)our client calculate excise duty 16% - 51916
To tal sales invoice amount = line amount + exciseduty = 53586+ 51916
I know excise duty can calucalte only on base amount,(is it sales line amount or purchase line amount)
they are caluclating in different way.
Guys provide help. They are following this calculation according to Indian rules for jobwork. It ‘s killing me. I am in dar with this query . throw powerful light on me.
experts throw u r valuable suggestions
I hope u can provide solution.
0
Comments
Experts please provide some information on this query.it's killing me . i am not able understand how to do this. i hope already experts faced this problem and can solve.
throw u r valuable suggestions and put some light one me.
waiting for u r suggestions.........
have a nice day
You can do it only by way of manual excise customization.
MAITHAN ISPAT LIMITED.
I am unable to understand the scanario as you are using xxxx,zzzz etc insted of actual figures.
Write one example with one item, and the calculation steps with percentages and figures.
Deep
India
MAITHAN ISPAT LIMITED.
This is never an advisable option till a wayout can be found using the existing setups or else.
Manipulating the codeunits should always be the last resort.
Deep
India
Please confirm me a few things.
01. Complete calculation on their purchase bills with some numeric values.
02. Why they are adding some value added tax to determine excise? I believe this is not a correct practice or this is again to be regarded as some kind of conversion charges.
03. Calculation on sale bill with respect to purchase bill in 01 above.
I feel your problem can also be resolved by way of structures but 1st let me know the exact details.
MAITHAN ISPAT LIMITED.