Indian Localization- problems in NAV13 in excise for trading
Yashojit_Pandhare
Member Posts: 38
Problem in NAV 2013 Indian Localization in case of excise for trading. (I haven't used it with other versions.)
1. If lot tracking/serial no. tracking is used on items, the system must pickup the excise for the lot/serial no. being delivered on sales.
However, the system still uses the FIFO method for picking up the excise rates. With this, the system does not pass on the correct excise for the lot being delivered, and creates a mismatch between available inventory and available RG lines. The inventory gets closed for the selected lot, while the RG gets closed on FIFO basis.
2. If the item is purchased in foreign currency where CVD is involved, system calculates the excise in foreign currency. Acceptable. But it also stores the Excise, BED, Custom cess AED etc. in RG 23 D in foreign currency. Now when this item is being sold in local currency (INR) system picks up the amounts per unit from this RG 23 D which is stored in foreign currency, and ends up calculating the excise in foreign currency factor, though the sale is being done in local currency.
Say for example, an item is purchased at an assessable value of 100 USD with a conversion factor of, say, 50, and the BED rate is 12% system will calculate BED 12USD, and store the same in RG 23 D. Now when this item is being sold in local currency, system picks up the BED 12 as it is, which rather should have been converted to LCY. So in the sales, instead of charging excise at 12x50=600, it is picking up 12.
Completely erroneous. Or are there some patches available for this.
I have fixed these in my current implementation though, but it should be there in the standard package!!
1. If lot tracking/serial no. tracking is used on items, the system must pickup the excise for the lot/serial no. being delivered on sales.
However, the system still uses the FIFO method for picking up the excise rates. With this, the system does not pass on the correct excise for the lot being delivered, and creates a mismatch between available inventory and available RG lines. The inventory gets closed for the selected lot, while the RG gets closed on FIFO basis.
2. If the item is purchased in foreign currency where CVD is involved, system calculates the excise in foreign currency. Acceptable. But it also stores the Excise, BED, Custom cess AED etc. in RG 23 D in foreign currency. Now when this item is being sold in local currency (INR) system picks up the amounts per unit from this RG 23 D which is stored in foreign currency, and ends up calculating the excise in foreign currency factor, though the sale is being done in local currency.
Say for example, an item is purchased at an assessable value of 100 USD with a conversion factor of, say, 50, and the BED rate is 12% system will calculate BED 12USD, and store the same in RG 23 D. Now when this item is being sold in local currency, system picks up the BED 12 as it is, which rather should have been converted to LCY. So in the sales, instead of charging excise at 12x50=600, it is picking up 12.
Completely erroneous. Or are there some patches available for this.
I have fixed these in my current implementation though, but it should be there in the standard package!!
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions