Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
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:
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 73,339 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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans