Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Business Central forum

Table sales orders

(0) ShareShare
ReportReport
Posted on by

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

Categories:
  • MACYS Profile Picture
    5 on at
    RE: Table sales orders

    You have to link Sales header & Sales line table .

    Reference: https://macys.me/

  • Community Member Profile Picture
    on at
    RE: Table sales orders

    Thanks for the help and information

  • Suggested answer
    Oleksandr Shevchuk Profile Picture
    175 on at
    RE: Table sales orders

    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
    on at
    RE: Table sales orders

    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
    175 on at
    RE: Table sales orders

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

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

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 forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans