web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Microsoft Dynamics - VAT Settlement

(0) ShareShare
ReportReport
Posted on by 5

I currently use Microsoft Dynamics NAV and am having trouble reprinting a VAT Report that is issued after the Calc and post VAT settlement process.  Did not manage to save the report which lists all the transactions that have been posted to the VAT settlement account.  Is there a way to reprint this report having the document name

I have the same question (0)
  • Suggested answer
    Bilal Haider Profile Picture
    412 on at

    Hi,

    You can use the same report "Calculate and Post VAT" with same filters. Just keep the Post flag off and then it will create the same report without postings.

    VAT-Set.PNG

    Regards,

    Bilal Rai

  • Suggested answer
    Dirk Profile Picture
    on at

    Hi,

    What do you mean by ... having the document name?

    REP 20 - Calc. and Post VAT Settlement finds open entries and on "post" it closes these open entries and creates entries of type = Settlement.
    I think it's not possible to re-create the report because REP 20 filters on "VAT Entry::Open = true".
    And after using REP 20 with the option "Post VAT" the VAT Entries are not "Open" anymore.
    This way we ensure the entries whcih just have been closed will not be picked up again.
    And just using Start- and Enddate could also give wrong results as some times you will close the entries of a period + some entries that may have been registered for the period before and not closed by REP 20 yet.

    First thing I would do is to search for the G/L Register that has been created when you ran REP 20.
    It should be somehow easy to find that G/L Register if you filter on the Source Code ... should be "VATSTMT" (if default values are used).
    If you found the G/L Register the you can print the "G/L Register" report (REP ID 3).
    This gives you the infomation which new G/L Entries have been created.
    If you open the VAT Entries from the G/L Register page you'll get the VAT Entries of type = Settlement which have been created and which closed the original VAT Entries. 

    And if you then need further details ... like the information "which original VAT Entries have been closed" by the settlement entries, then you would need to take note of the VAT Entry Nos. of this "VAT Settlement", open all VAT Entries and use these VAT Entry Nos. as filter in field "Closed by Entry No." 
    This should give you a list of the original VAT Entries which have been closed.
    You can then copy these original VAT Entries to Excel and create a report from there.

    Hope this helps

      

  • Bilal Haider Profile Picture
    412 on at

    Dirk is right. This report filters on Open entries and close them on posting. So regeneration is not possible using this same report.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans