Skip to main content

Notifications

Business Central forum
Suggested answer

How to delete transaction data from business central in master company

Posted on by 181
  • I want to delete transaction data from business central in master company
  • Abd Alsameea Nat Profile Picture
    Abd Alsameea Nat 181 on at
    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?

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 43 on at
    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.

  • Abd Alsameea Nat Profile Picture
    Abd Alsameea Nat 181 on at
    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?

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 43 on at
    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.

  • Abd Alsameea Nat Profile Picture
    Abd Alsameea Nat 181 on at
    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 .

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 43 on at
    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.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 43 on at
    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.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans