You’re offline. This is a read only version of the page.
Announcements
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
Dirk is right. This report filters on Open entries and close them on posting. So regeneration is not possible using this same report.
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
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.
Regards,
Bilal Rai
#1
André Arnaud de Cal...
294,069
Super User 2025 Season 1
#2
Martin Dráb
232,858
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
