Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Difference in VAT
Microsoft Dynamics NAV (Archived)

Difference in VAT

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

I get a difference of 368,15 DKK in VAT when printing report no. 12 VAT Statement and 20 Calc. and Post VAL Settlement. I have looked at code behind it, but I am abit confused since there are 250 lines of code in one of the reports and 400 in the other with different variables names and different methods calculating the amount.

How do I find where something have been posted different in the system so I can make it the same amounts in both reports?

I will link the 2 reports below (could not upload here).

In report 12 Row No. 1195 shows 574.192 and in report 20 it shows -573,823.85.

http://docdro.id/mIvr6kX

http://docdro.id/O6k0bFr

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference in VAT

    Thanks!!! It worked. I removed the start filter date from report 20 and got the result i wanted.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference in VAT

    Just to further clarify, if you look at the top of report 12, you have selected "VAT entries before and within the period".

    So, the date filter is not doing what you think it should be doing on this report.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference in VAT

    They might well have the same date filter, but my suggestion is that report 12 is including transactions before that date filter, and the other one is not.

    I suggest you re-run report 20, with a different date filter and see what happens

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference in VAT

    They have the same date filter. At the top of report 20 you can see the date period is: 01-01-16..31-03-16.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Difference in VAT

    I think you'll have a sales transaction from last year that is showing up in report 12, but has been excluded from report 20 because of the date filter.

    So, report 12 includes previous transactions, (outside of the date filter), which have not been posted through the VAT settlement process. Report 20 has excluded the transaction.

    If you re-run report 20, but put a date filter of 01/01/01..31/03/16 what does it show you?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans