I hope this article will be useful for some developers who will try to sync “Sales Invoice Line” table to Dataverse separately.
I created replication for many Business Central tables to Dataverse using steps described here:
Today I would like to discuss how to view Outstanding Order Lines and Invoices Order Lines in Business Central. For example, sales lines and posted sales invoice lines.
As you know, when you create a new sales order in BC, you first enter header information and then lines, which is a one-to-many relationship.
Microsoft Dynamics NAV’s Incoming Document helps the user to efficiently upload and reference outside documents within their ERP database. Incoming Documents may be attached to unposted documents or journal lines and follow the posting to the resulting entries throughout NAV, notably posted documents and ledgers.
Learn how Microsoft Dynamics NAV can be setup with 2 workflows as part of the same business process. One workflow requires approval for a purchase invoice using the approval setup, which will notify the first direct approver. Upon approval of the purchase invoice, the invoice will be released automatically which triggers the 2nd workflow.
Learn how Microsoft Dynamics NAV can be setup to automatically post a purchase invoice, create a Payment Journal Line, and notify a specified user, all upon changing the Purchase Invoice status to ‘Released’. This video walks you through how to setup a workflow process for this in Microsoft Dynamics NAV2017.