PO with UK VAT, EU VAT and ROW VAT all in one consolidated invoice from popular parcel service.

Ben_Dyson
Member Posts: 18
Customer ships all over the world and at some point in the past we've modded the Purchase Order and Purchase Invoice Subform pages to allow line level access to the VAT Business Posting Groups. So, when the delivery company sends in their consolidated invoice, they can setup an Invoice that matches what they were sent. (Example was a Credit Memo with EU VAT on it). This worked on NAV 2013, but since moving the NAV2018 CU35, there seems to have been a fundamental shift to the PO Posting routine. Before it posted on a per line basis, but now it seems to decide that the header VAT Business Posting Group needs applying to all lines - I guess MS can justify that by saying that the Line Level VAT Bus. Posting Group shouldn't be editable so the whole document should always just have ONE VAT Bus. Group.
That works fine in most cases, but since their shipping agent ships everywhere in the world, they get an invoice with multiple on.
So, the rules are that you have to make your Purchase Invoice match what was sent to you, but fundamentally NAV isn't designed to allow this.
Do you mod the Purchase Posting Codunit to post per line? Not a big fan of changing posting process'.
Is there another way of posting the Consolidated Invoice?
Thanks in advance.
Ben
That works fine in most cases, but since their shipping agent ships everywhere in the world, they get an invoice with multiple on.
So, the rules are that you have to make your Purchase Invoice match what was sent to you, but fundamentally NAV isn't designed to allow this.
Do you mod the Purchase Posting Codunit to post per line? Not a big fan of changing posting process'.
Is there another way of posting the Consolidated Invoice?
Thanks in advance.
Ben
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