Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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.
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.
Thank you for confirming that they can be deleted. My question is why in my system it appears they are not being deleted.
Also, I cannot locate a table with a name similar to "Posted Sales Invoice". Please advise.
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.
You can find theses tables with this ID number.
Sales Invoice Header
Table Id: 112
Sales Invoice Line
Table Id: 113
Business Applications communities