Dynamics NAV purchase to pay and order to cash: see where each order waits

What does Duaer read from Dynamics NAV?

Each purchase or sales order is a case, with the supplier or customer, the company, currency and amount. The steps are:

• Purchase to pay: Order created (Purchase Header, or the posted invoice once NAV deleted the fully invoiced order), Goods received (Purch. Rcpt. Header), Invoice posted (Purch. Inv. Header), Paid (the closing date in Vendor Ledger Entry).
• Order to cash: Order created (Sales Header), Goods issued (Sales Shipment Header), Invoice created (Sales Invoice Header), Paid (the closing date in Cust. Ledger Entry).
• One source reads one company.

How do you connect Dynamics NAV to Duaer?

1. In Dynamics NAV's SQL Server database, create a read-only user with SELECT on the tables above.
2. If the database is only inside your network, start the Duaer on-premises data gateway (0.2.0 or later) there with tcp://database-host:port in ALLOWED_TARGETS; the credential's host and port must match it.
3. In Duaer, create a Microsoft SQL credential for this user.
4. As an owner or admin, open Data sources, select Add source, choose Dynamics NAV under Purchase to pay or Order to cash, choose the credential, enter the company name (such as CRONUS International Ltd.), select Check connection and confirm.

How often does it read, and how much?

Each run reads the streams by posting date. NAV documents carry dates only, so each read starts two weeks back to catch documents posted with a past date; a step is never written twice. Queries only.

What are the limits?

• The tables, entities and fields read follow the vendor's published documentation and are not yet checked against a real system; the first real read may need adjustments.
• Nothing is read until the company name is given.