Share
Report- I want to delete transaction data from business central in master company
You’re offline. This is a read only version of the page.
181
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.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
