How to delete transaction data from business central in master company

(0) Share

Report

Posted on by Abd Alsameea Nat

181

I want to delete transaction data from business central in master company

I have the same question (0)

All responses (7)

Answers (0)

Abd Alsameea Nat 181 on at

Like (0)

Report

RE: How to delete transaction data from business central in master company

We are working on Cloud, not on Prem

Is there a way to delete transaction data in the cloud?

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 391 on at

Like (0)

Report

RE: How to delete transaction data from business central in master company

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.

Was this reply helpful? Yes No
Abd Alsameea Nat 181 on at

Like (0)

Report

RE: How to delete transaction data from business central in master company

how to write SQL queries to delete transaction data from the production environment.

Is there a tool to delete the transaction data?

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 391 on at

Like (0)

Report

RE: How to delete transaction data from business central in master company

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.

Was this reply helpful? Yes No
Abd Alsameea Nat 181 on at

Like (0)

Report

RE: How to delete transaction data from business central in master company

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 .

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 391 on at

Like (1)

Report

RE: How to delete transaction data from business central in master company

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.

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 391 on at

Like (1)

Report

RE: How to delete transaction data from business central in master company

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.

Was this reply helpful? Yes No