Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
VAT Reconciliation in Navision
alsol
Member Posts: 243
Hello there,
Because all Auditors ask the same question during their audit ("can you show me a VAT reconciliation report?") I started to develop such a report.
The idea is to match each VAT related G/L entry with the correspoding VAT entry and to show for each G/L account all used VAT codes (VAT product posting group) and the total amounts for Gross, Base and VAT.
So far I was quite successfull but I have one problem on the sales VAT. As soon there is a line discount, Navision creates a G/L entry for the gross income and another one for the discount. But there is only one VAT entry for the balance of the two entries. So the gross income is marked as VAT related, but the discount isn't. On my report I select only gross income and there is a difference between calculated and posted VAT.
Does anybody has an idea about how this could be solved? This problem occured in 3.70 CH and I am going to test if it has been solved in later versions.
Best regards,
Felix
Because all Auditors ask the same question during their audit ("can you show me a VAT reconciliation report?") I started to develop such a report.
The idea is to match each VAT related G/L entry with the correspoding VAT entry and to show for each G/L account all used VAT codes (VAT product posting group) and the total amounts for Gross, Base and VAT.
So far I was quite successfull but I have one problem on the sales VAT. As soon there is a line discount, Navision creates a G/L entry for the gross income and another one for the discount. But there is only one VAT entry for the balance of the two entries. So the gross income is marked as VAT related, but the discount isn't. On my report I select only gross income and there is a difference between calculated and posted VAT.
Does anybody has an idea about how this could be solved? This problem occured in 3.70 CH and I am going to test if it has been solved in later versions.
Best regards,
Felix
0
Comments
However the fields:
Gen. Bus. Posting Group
VAT Bus. Posting Group,
VAT Prod. Posting Group
Gen. Prod. Posting Group
are deliberately left blank on the GL posting for this discount line.
Why might this be and if I change codeunit80 in function PostDiscount to fill them might I cause other issues elsewhere?
The issue is that when running VAT reports these fields are filtered to find lines that have VAT relations to the VAT statement. Without them a line in the statement doesnt find the relevant line in the GL Entries.