Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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
  • Suggested answer
    Community member Profile Picture
    Community member 12 on at
    How to change VAT Prod Posting Group for Posted Transactions
    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!
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,561 Super User 2024 Season 2 on at
    How to change VAT Prod Posting Group for Posted Transactions
    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

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! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans