IFS purchase to pay and order to cash: see where each order waits

What does Duaer read from IFS?

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_ORDER_TAB), Goods received (PURCHASE_RECEIPT_TAB), Invoice posted (supplier invoices naming the order), Paid (the invoice turns paid).
• Order to cash: Order created (CUSTOMER_ORDER_TAB), Delivery created and Goods issued (CUSTOMER_ORDER_DELIVERY_TAB), Invoice created (customer order invoices), Paid (the invoice turns paid).
• Canceled documents are left out.

How do you connect IFS to Duaer?

1. In IFS's Oracle 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 Oracle Database Credentials API credential for this user.
4. As an owner or admin, open Data sources, select Add source, choose IFS under Purchase to pay or Order to cash, choose the credential, the schema is IFSAPP unless you enter another, select Check connection and confirm.

How often does it read, and how much?

Each run reads the streams by ROWVERSION, the change time every IFS table has, one page each at most; 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.
• Managed IFS Cloud offers no database and is not supported yet.