Handling of CVD and BCD in NAV

hungryandfool
Member Posts: 114
Dear Experts,
My client imports goods and on his imports he pays CVD (countervailing duty) and BCD (basic custom duty) to the third party.
In order to handle the CVD I have created the excise posting setup and then created a CVD related structure along with that where I have put in the following values.
"CVD" = Yes
"CVD Payable to Third Party" = Yes
"CVD Third Party Code" = 225045 (The GL Account code for Third Party)
In NAV I was unable to locate any setup to capture the BCD value which should be posted to the third party (The third party here is same as the CVD third party mentioned above). So in order to handle the same I created a charge named BCD in the above mentioned structure and put in the following values for it:
"Payable to Third Party" = Yes
"Account No" = 320006 (GL Account code for the BCD charge)
In Purchase Order which use the above structure the user puts in the vendor code of the BCD related third party (I have created a vendor for the third party and tagged it to the GL Account code 225045 which is the common account code for CVD and BCD).
All the posting and calculation at the time of posting are happening fine. But the issue is that the GL Account code 225045 is showing correct figure including both CVD and BCD, but the ledger for the third party vendor is only showing the BCD charges as only BCD is posted using the vendor code. Thus the end user is getting confused when he seeing the vendor ledger.
Can anyone suggest me how to post CVD and BCD both either using same GL Account code or using same Vendor Code?
My client imports goods and on his imports he pays CVD (countervailing duty) and BCD (basic custom duty) to the third party.
In order to handle the CVD I have created the excise posting setup and then created a CVD related structure along with that where I have put in the following values.
"CVD" = Yes
"CVD Payable to Third Party" = Yes
"CVD Third Party Code" = 225045 (The GL Account code for Third Party)
In NAV I was unable to locate any setup to capture the BCD value which should be posted to the third party (The third party here is same as the CVD third party mentioned above). So in order to handle the same I created a charge named BCD in the above mentioned structure and put in the following values for it:
"Payable to Third Party" = Yes
"Account No" = 320006 (GL Account code for the BCD charge)
In Purchase Order which use the above structure the user puts in the vendor code of the BCD related third party (I have created a vendor for the third party and tagged it to the GL Account code 225045 which is the common account code for CVD and BCD).
All the posting and calculation at the time of posting are happening fine. But the issue is that the GL Account code 225045 is showing correct figure including both CVD and BCD, but the ledger for the third party vendor is only showing the BCD charges as only BCD is posted using the vendor code. Thus the end user is getting confused when he seeing the vendor ledger.
Can anyone suggest me how to post CVD and BCD both either using same GL Account code or using same Vendor Code?
0
Comments
-
Please help me out. :?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