Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

detailed VAT report to reconcile with summary

(0) ShareShare
ReportReport
Posted on by 144

Hello

We recently moved from SAGE and struggling to extract a detailed VAT Report to reconcile the figures in the default VAT report.

Is there no out of the box report to show the detailed entries for say B18 which will include Date, Account, Description, Net Amount, Vat Amount and Gross Amount?

pastedimage1636713603673v1.png

  • jaybeegee Profile Picture
    jaybeegee 144 on at
    RE: detailed VAT report to reconcile with summary

    Struggling to get the app installed with the following error and I tried both the account associated with our BC implementation and a generic one - any ideas?

    Thank you for choosing Dynamics 365 Business Central

    Let's get you started

    We're sorry, but Dynamics 365 Business Central isn't currently available for your account. Please check back later.

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: detailed VAT report to reconcile with summary

    If you want to bring a field which isn’t already available this is the quickest method. Faster than doing it as a discreet development

  • jaybeegee Profile Picture
    jaybeegee 144 on at
    RE: detailed VAT report to reconcile with summary

    Actually I can map the client name via a vlookup in excel - it was the actually description that I was after.

    Is the recommendation still the simple object designer?

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: detailed VAT report to reconcile with summary

    Check out the simple object designer from appsource.

  • jaybeegee Profile Picture
    jaybeegee 144 on at
    RE: detailed VAT report to reconcile with summary

    Sorry supplimentary question ... the sage report had Customer/Vendor name ... however I do not see it on the list of columns to add in the designer - is it not possible to add in?

  • jaybeegee Profile Picture
    jaybeegee 144 on at
    RE: detailed VAT report to reconcile with summary

    thank you sir.

    I am pretty handy with excel pivots so will give it a go with this option as do not have jet and neither powerBI! thanks nevertheless for your kind offer.

  • Suggested answer
    jaybeegee Profile Picture
    jaybeegee 144 on at
    RE: detailed VAT report to reconcile with summary

    wow that's great Gavin <3  

    thank you for taking the time to pull the response together which is exactly what I needed!

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: detailed VAT report to reconcile with summary

    Many movers from sage find this. As Gavin mentioned you can get the raw detail but then assemble it with a pivot into the grouped structure by posting groups. This of course isn’t the 9 box construct a VAT statement actually follows. If you have Jet Reports in your solution I can provide a report which does what you require. Failing that you can build what is needed in Power BI - I have an example file which does that too.

  • Gavin Profile Picture
    Gavin 2,341 on at
    RE: detailed VAT report to reconcile with summary

    Hi,

    The VAT Statement is based on the VAT Entries table so this would be the natural place to start. i.e.

    pastedimage1636716447754v1.png

    This opens the VAT Entries page and you can filter to the same parameters as the VAT statement:

    pastedimage1636716503541v2.png

    Please note you can also drill down on VAT amounts on the VAT Statement itself if you choose "Process > Preview"

    pastedimage1636716565738v3.png

    i.e. you can drill down on the "VAT Entry Totalling" columns:

    pastedimage1636716619315v4.png

    Hope this helps

    Thanks

    Gavin

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans