Share
ReportHow does NAV matches invoices against orders
*This post is locked for comments
You’re offline. This is a read only version of the page.
420
How does NAV matches invoices against orders
*This post is locked for comments
This is all based on what method you are following for posting of invoice.
Direct posting from sales order or Sales invoice creation separately and posting from it.
If you want to know about Sales invoices here it goes,
Table Level :
If invoice was created and posted directly using Sales Orders then the sale order number will get update in the "Order No." field in the Posted Sales Invoice Table.
If you ship it and then invoice then it will not get updated. In that case you will have to drill down to Sales Shipment Header (110) and Sales Shipment Line (111) and in the header table you will find the Order No. and in the Line table you will get the Order No. and Line No.
As the same way once you invoice the order after the shipment, Order details get updated in the Sales Invoice Header (112) and Sales Invoice Line (113) table.
Form Level :
Go to Order page and in the Home Tab, Document Group you will have two different action buttons. If the order is been shipped and Invoiced separately at two occasions then you will have to click these buttons to to drill down the details.
If you need any more help please revert back.
In case, if Invoice is posted directly from the sales order then the sales order number will get updated in "Order No." Field of Posted invoice (purchase or sales both) but if the receipt or shipment done separately and invoice is created separately then this field will not get updated with the order number.
so in that case, you need to drill down to the shipment or receipt and from there you can get the order number.
If you need to make it available in function or report, let us know so we can guide you to do that.
Regards,
Saurabh Shah
It is three way matching (Qty in order, GRN and invoice ) and Sales qty, DC, Sales Invoice in case of sales.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (