web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Taxes - Italian VAT Re...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Taxes - Italian VAT Report

(1) Share

Report

Report

Posted on by CU28041059-1

2

Hi everyone,

I need some advice on how to resolve a sum discrepancy, in the trial balance for the main account "IVA su acquisti (in italian language)", we are talking about taxes based on purchases.

This issue, which occurred in February and March, seems to have arisen AFTER the closing of the specific VAT reporting period, within the voucher named “PGI*” associated with that month’s settlement.
Before the period closed, there was a perfect match between the figures reported on the VAT report and those in the general ledger.

This is the situation

What could be causing this discrepancy? How can I find the original cause of this difference?

Thank you in advance

Categories:

Dynamics 365 Finance

Dynamics 365 Project Operations

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Giorgio Bonacorsi 2,672 on at

Like (1)

Report
Copy link

Link copied!
Buongiorno, :-)

I suggest opening a ticket with Microsoft Support, as this may be an approximation issue. However, here are the solution and how to do the investigation:

Solution:

You cannot post manually because the account is locked for manual entry. During non-operational hours:

Temporarily unlock the main tax-related accounts (“Iva su credito” and “Iva su erario”).

Remove the posting type and uncheck “Do not allow manual entry” if enabled.

Post a General Journal entry to adjust the settlement.

Once finished, restore the original configuration.

Investigation:

Each time you settle sales tax, the system generates settlement transactions linked to the original tax transactions. Example: If you have 3 sales tax transactions from 3 purchase invoices, the system creates 3 settlement lines.

To investigate the delta:

Go in: Tax> Inquiries and reports> Sales tax inquiries> Posted sales tax

Export the Sales tax transactions (include the Source field).

Sum all amounts — it should equal 0 if correct.

Create a pivot table with settlement lines vs. original tax transactions to identify the difference.

Help with the export or pivot!

In bocca al lupo!

Giorgio

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 694

#2

André Arnaud de Cal... 646 Super User 2026 Season 1

#3

CP04-islander 301

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans