detailed VAT report to reconcile with summary

(0) Share

Report

Posted on by jaybeegee

119

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?

Categories:

Financial Management

All responses (9)

Answers (0)

jaybeegee 119 on at

Like (0)

Report

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 33,153 on at

Like (0)

Report

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 119 on at

Like (0)

Report

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 33,153 on at

Like (0)

Report

RE: detailed VAT report to reconcile with summary

Check out the simple object designer from appsource.
jaybeegee 119 on at

Like (0)

Report

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 119 on at

Like (0)

Report

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 119 on at

Like (0)

Report

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 33,153 on at

Like (1)

Report

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 2,333 on at

Like (1)

Report

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.

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

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

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

Hope this helps

Thanks

Gavin