We are working on Cloud, not on Prem
Is there a way to delete transaction data in the cloud?
Hi,
SQL Queries can be used if you have OnPrem version and you have access to Database. You can use SQL Server Management Server to write queries.
how to write SQL queries to delete transaction data from the production environment.
Is there a tool to delete the transaction data?
Hi,
It is not advisable to delete transactional data because one transaction can have relations to multiple tables.
But still if you need then write AL code to delete entries from tables. If you have On-Prem version then you can write SQL queries to delete.
I want to delete transactions data
We are currently in production environment (not in a testing environment), and the customer wants to remain in this environment .
If all transactions are incorrect and you need to have a company without transactions then you should create a new company based on this master company. You can use Rapid Start services config packages to copy Master, setup and base tables.
Hi,
For transactional data if you mean General Ledger Entries, Customer Ledger Entries etc. then you cannot delete it. If there are some wrong transactions then you can correct them by posting correcting entries.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,129 Most Valuable Professional
nmaenpaa 101,154