Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 270 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
Intercompany feature does not cater for VAT Bus Posting
engsiong75
Member Posts: 143
Hi
I was using Intercompany for NAV 2013 to export the Sales Invoice in one company to the Purchase Invoice in another.
This works fine if there is no change in the VAT Business Posting group on the Vendor of the company that is receiving the Purchase Invoice. If the VAT Business Posting Group needs to be changed on the purchase invoice, the pricing data imported will be deleted and the purchase line recreated (This is the standard design in Navision).
In my opinion, this lack of feature of catering for the VAT Business Posting Group from the originating Sales Invoice is a major issue. This is logical that if I am charging VAT on the Sales Invoice, the receipt of the Invoice needs to pay for the VAT.
I also understand from the developers point of view that it is not logical to expect the VAT Business Posting group to match between companies. In this case a mapping table between the different VAT Business Posting Group will need to be setup. With the use of VAT in more countries, I see that lack of Intercompany VAT is going to a major concern going forward.
Does anyone have a workaround on this matter? I am currently exposing the VAT Business Posting Group at the line level for the users to change but this is not an efficient solution going forward as each invoice has an average of 300 lines.
Regards
I was using Intercompany for NAV 2013 to export the Sales Invoice in one company to the Purchase Invoice in another.
This works fine if there is no change in the VAT Business Posting group on the Vendor of the company that is receiving the Purchase Invoice. If the VAT Business Posting Group needs to be changed on the purchase invoice, the pricing data imported will be deleted and the purchase line recreated (This is the standard design in Navision).
In my opinion, this lack of feature of catering for the VAT Business Posting Group from the originating Sales Invoice is a major issue. This is logical that if I am charging VAT on the Sales Invoice, the receipt of the Invoice needs to pay for the VAT.
I also understand from the developers point of view that it is not logical to expect the VAT Business Posting group to match between companies. In this case a mapping table between the different VAT Business Posting Group will need to be setup. With the use of VAT in more countries, I see that lack of Intercompany VAT is going to a major concern going forward.
Does anyone have a workaround on this matter? I am currently exposing the VAT Business Posting Group at the line level for the users to change but this is not an efficient solution going forward as each invoice has an average of 300 lines.
Regards
0