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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to change VAT Prod...
Small and medium business | Business Central, N...
Suggested Answer

How to change VAT Prod Posting Group for Posted Transactions

(0) ShareShare
ReportReport
Posted on by Ivan Levin 45
Good Day Everyone
 
Is there anyway to mass update the VAT Prod Posting Groups for Posted Transactions?
A client of ours has posted a large volume of transactions to the wrong VAT Prod Posting Group. The change which needs to happen will no affect the VAT amount as both VAT Prod Posting Groups are zero rated but this is required for reporting purposes.
 
I know this isn't possible on the front end. Is there a way to do this via config packages or any other way?
 
I am trying to prevent them having to reverse and recapture a large volume of transactions.
 
TIA
Ivan
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,597 Super User 2025 Season 2 on at
    Hi, unfortunately, as far as I know only customization can do it.
    But this is not recommended, because if you only modify a certain table, it will affect the consistency of the data in Business Central.
     
    If you insist on doing it despite knowing these risks, you can add Permissions Property to your program so that it can modify tables that have been posted.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    HV-21011334-0 Profile Picture
    HV-21011334-0 14 on at
    elaborating on the previous answer...
     
    what is it EXACTLY you are trying to do, what is the business case?
    - is the VAT statement wrong?
    It will be OK at Amount level (as stated in the question), but not shown in the VAT statement, due to incorrect use of the VAT posting groups.
    in that case: prepare a copy of the VAT statement, where you capture the VAT entries with the wrong combination, into their correct state... by molding the VAT Bus/VAT Prod combo's to your need.
     
    - is other reporting wrong?
    Please Be Warned: it will NOT be sufficient to just update the VAT Bus PG in the VAT entries... you will have to make the very sam change in the other operational records, where the field has been taken redundantly.
    It is a very tricky road, you are taking here!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,917

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans