web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Deleted Sales Orders
Small and medium business | Business Central, N...
Suggested Answer

Deleted Sales Orders

(0) ShareShare
ReportReport
Posted on by TerryMitchell 10

Good day all.  I've been reading some posts that suggest Sales Orders are "deleted" when cancelled or completely shipped.

I'm looking at the database tables directly, and it appears that our sales orders are not being deleted from [$Sales Header] and [$Sales Line].  Does "deleted"  mean something other than a literal delete from these tables?  Perhaps that's a UI concept that is driven off a flag?

On a related note, if I can't rely on the data I'm finding in the Sales Header/Line table, where is reliable data for revenue calculations?

Thanks in advance.

I have the same question (0)
  • Suggested answer
    Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 3,049 User Group Leader on at

    Hi TerryMitchell,

    Sales Order created can be "deleted" when cancelled or completely shipped, that is true, but it if posted to a sales invoice, it will be transferred to another table "Posted Sales Invoices" that represent the reliable data for revenue calculations.

    If you find this information helpful, Click Yes to Verify the answer to share with other community members.

  • TerryMitchell Profile Picture
    TerryMitchell 10 on at

    Thank you for confirming that they can be deleted.  My question is why in my system it appears they are not being deleted.

    Thanks.

  • TerryMitchell Profile Picture
    TerryMitchell 10 on at

    Also, I cannot locate a table with a name similar to "Posted Sales Invoice".  Please advise.

    Thanks.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    A Sales Order is deleted if it it is fully invoiced (not shipped).

    If there is an outstanding quantity, the order will remain.

    There is no such thing as canceled in the system, unless you customize it. You basically delete and archive it manual.

    The page is called Posted Sales Invoice. The table is Sales Invoice Header and Sales Invoice Line.

  • Suggested answer
    Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 3,049 User Group Leader on at

    You can find theses tables with this ID number.

    Sales Invoice Header

    Table Id: 112 

    Sales Invoice Line

    Table Id: 113

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans