I am trying to figure out how to relate a sales invoice to the sales order using the “sales invoice header” or “sales invoice line” table? Is there any documentation on the sales tables and how data transverses from order, invoice, archive, etc?
Relate in what way? The Sales Invoice Header table has a field called “Order No.” (Field#44) that gives you the invoices original order number.
Is this what you are lookng for?
Thank you , that helps a lot, I must have looked at the invoice header table 5 times and did not see the field. In our instance of Navision, I see rows in the invoice header table where the Order number is blank, others rows with a sales order. What does a blank order mean? Thanks again for the help
Hi Jim,
If you invoice from a sales order then the Order No. is populated. If you invoice using the “Get Receipts” function then the field is not populated. You will then need to find the corresponding shipment(s) using a combination of the value ledger entry and item ledger entry tables.
Thank you very much. I am a Navision newbie and your help is much appreciated.
As always, glad to help [:D]