Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Deleted Sales Orders

Posted on by 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.

  • Suggested answer
    Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 2,874 User Group Leader on at
    RE: Deleted Sales Orders

    You can find theses tables with this ID number.

    Sales Invoice Header

    Table Id: 112 

    Sales Invoice Line

    Table Id: 113

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,861 Moderator on at
    RE: Deleted Sales Orders

    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.

  • TerryMitchell Profile Picture
    TerryMitchell 10 on at
    RE: Deleted Sales Orders

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

    Thanks.

  • TerryMitchell Profile Picture
    TerryMitchell 10 on at
    RE: Deleted Sales Orders

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

    Thanks.

  • Suggested answer
    Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 2,874 User Group Leader on at
    RE: Deleted Sales Orders

    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.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans