Problem in RG entry creation While Posting Invoice

hemantOne
Member Posts: 98
Hi,
I am using Nav 5.0 SP1.I create a receipt with amounts in FCY and RG Entry created for this receipt.Now i create an invoice use copy document and Get receipt lines to get that Receipt. now when i post the invoice for RG register system is rounding and converting Excise amount in LCY and check the difference from Purchase receipt line.
Now in this case Purchase Receipt line having Excise amount in Customer Currency (in import case, it is in FCY) so lets say my excise duty was 10 $ @ 50 Rs. in Purchase receipt and when i post the invoice for the same without any changes system calculates like Invoice Excise ( 10*50 ) 500 - Pur.Rcpt Line Excise 10 so it gets difference of 490, which is wrong. and now with this 490 system against convert it to LCY 490 * 50 and again post it in RG register.
Please help me to solve this problem.
I am using Nav 5.0 SP1.I create a receipt with amounts in FCY and RG Entry created for this receipt.Now i create an invoice use copy document and Get receipt lines to get that Receipt. now when i post the invoice for RG register system is rounding and converting Excise amount in LCY and check the difference from Purchase receipt line.
Now in this case Purchase Receipt line having Excise amount in Customer Currency (in import case, it is in FCY) so lets say my excise duty was 10 $ @ 50 Rs. in Purchase receipt and when i post the invoice for the same without any changes system calculates like Invoice Excise ( 10*50 ) 500 - Pur.Rcpt Line Excise 10 so it gets difference of 490, which is wrong. and now with this 490 system against convert it to LCY 490 * 50 and again post it in RG register.
Please help me to solve this problem.
Regards,
Hemant
They can conquer who believe they can.
Hemant
They can conquer who believe they can.
0
Comments
-
Hi,
I am using Nav 5.0 SP1.I create a receipt with amounts in FCY and RG Entry created for this receipt.Now i create an invoice use copy document and Get receipt lines to get that Receipt. now when i post the invoice for RG register system is rounding and converting Excise amount in LCY and check the difference from Purchase receipt line.
Now in this case Purchase Receipt line having Excise amount in Customer Currency (in import case, it is in FCY) so lets say my excise duty was 10 $ @ 50 Rs. in Purchase receipt and when i post the invoice for the same without any changes system calculates like Invoice Excise ( 10*50 ) 500 - Pur.Rcpt Line Excise 10 so it gets difference of 490, which is wrong. and now with this 490 system against convert it to LCY 490 * 50 and again post it in RG register.
Please help me to solve this problem.Regards,
Hemant
They can conquer who believe they can.0 -
Excise is a Indian Tax leviable on Indian entities. How are you receiving FCY (Import) invoice with excise duty on it. If it is custom duty (available as Cenvat Credit) then you should use custom duty functionality originally introduced in 4.0 sp3 hotfixes.CA Sandeep Singla
http://ssdynamics.co.in0 -
Thanks a lot Sir,Excise is a Indian Tax leviable on Indian entities. How are you receiving FCY (Import) invoice with excise duty on it. If it is custom duty (available as Cenvat Credit) then you should use custom duty functionality originally introduced in 4.0 sp3 hotfixes.
I will try it and let you Know...Regards,
Hemant
They can conquer who believe they can.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions