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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Table sales orders
Business Central forum

Table sales orders

(0) ShareShare
ReportReport
Posted on by Community Member

Is there a table available in NAV where I can find all the sales orders?

Categories:
Other
I have the same question (0)
  • Suggested answer
    Oleksandr Shevchuk Profile Picture
    Oleksandr Shevchuk 175 on at

    Table 36 (Sales Header) where Document Type = Order - Sales Orders

    Table 37 (Sales Line) where Document Type = Order - Sales Order Lines

  • Community Member Profile Picture
    Community Member on at

    Correct, but after completeness of the order it disappears!

    I can only find the order in archive table.

    I was wondering if there was one table wiht all the orders?

  • Suggested answer
    Oleksandr Shevchuk Profile Picture
    Oleksandr Shevchuk 175 on at

    As far as I know, there is no such table, except the archive you already mentioned.

    Normally, the system deletes Sales Order after Posting and creates a separate Posted Sales Shipment\Posted Sales Invoice document (depends on the option you choose).

    Try to check tables 110 (Sales Shipment Header) and 112 (Sales Invoice Header), to find the information that was created from the Sales Order after posting.

  • Community Member Profile Picture
    Community Member on at

    Thanks for the help and information

  • MACYS Profile Picture
    MACYS 5 on at

    You have to link Sales header & Sales line table .

    Reference: https://macys.me/

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

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 > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans