Is there a table available in NAV where I can find all the sales orders?
You have to link Sales header & Sales line table .
Reference: https://macys.me/
Thanks for the help and information
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.
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?
Table 36 (Sales Header) where Document Type = Order - Sales Orders
Table 37 (Sales Line) where Document Type = Order - Sales Order Lines