Duaer

Guides

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

Connect NetSuite to Duaer. It reads the documents each purchase order and sales order goes through with SuiteQL, so you see where orders wait and for how long.

What does Duaer read from NetSuite?

Each purchase order or sales order is a case, and its steps come from the documents after it. Duaer finds how documents relate through NetSuite's own source links (PreviousTransactionLineLink); a payment reaches its order through the bill or invoice it pays. Voided documents are left out.

  • Purchase to pay: purchase requisition (Requisition created), purchase order (Order created), item receipt (Goods received), vendor bill (Invoice posted), bill payment (Paid), with the supplier, currency and order total.
  • Order to cash: sales order (Order created), item fulfillment (Goods issued), invoice (Invoice created), customer payment (Paid), with the customer, currency and order total.
  • The steps match the process templates, so the purchase to pay and order to cash boards in My processes on the employee portal work as they are; refer to process findings.

How do you connect NetSuite to Duaer?

  1. In NetSuite, open Setup › Company › Enable Features › SuiteCloud and turn on REST Web Services and Token-Based Authentication.
  2. Create an integration record with Token-Based Authentication checked. Save it and note the consumer key and secret; they are shown once.
  3. Give the role you will use the REST Web Services and Log in using Access Tokens permissions and read access to purchase and sales transactions. Create an access token for that role and user, and note the token ID and secret; they are shown once.
  4. In Duaer, create a NetSuite API credential with the account ID (Setup › Company › Company Information; a sandbox looks like 1234567_SB1) and the four values above.
  5. As an owner or admin, open Data sources in the sidebar, select Add source, choose NetSuite under Purchase to pay or Order to cash, choose the credential and select Check account. Any table the role cannot read is listed with its status code.
  6. The mapping is fixed. Preview, set the schedule and who sees the cases, and confirm.

How often does it read, and how much?

Each run reads the process's documents by last change, 100 at most, from where it stopped; a first read of many documents finishes over several runs. A step is never written twice. Read only: Duaer never writes to NetSuite.

What are the limits?

  • Token-based authentication only for now. NetSuite plans to stop new integrations of this kind from 2027.1, while existing ones keep working; OAuth 2.0 follows once it is tested with a real account.
  • Purchase order approvals and delivery dates have no reliable time fields, so they are not steps yet; credit memos and returns are not read yet.
  • A document voided after it was read keeps the step already written.

Questions

Does Duaer change data in NetSuite?

No. Duaer only reads through SuiteQL, which cannot write.

Can I connect a sandbox?

Yes. Enter the sandbox account ID (like 1234567_SB1); Duaer reaches that sandbox's address.

In this section

Process

Add a process source in Duaer

A process source tells Duaer where to read the steps of your cases: a CSV or XLSX file, PostgreSQL, MySQL, Microsoft SQL, Oracle, a Feishu Base or Feishu approvals. The wizard takes you through columns, mapping, a preview of issues and a schedule; after you confirm, Duaer reads new rows on that schedule.

Process

See the process in your data and generate workflows in Duaer

Duaer reads the steps every case went through from the tables, databases or Feishu apps you already have: where cases wait too long, where they branch and who did each step. From that it generates three kinds of workflow, Watch, Coordinate and Execute, and replays each over past days before you publish it.

Process

Process findings and SOP conformance in Duaer

Process findings list the steps where cases wait too long or are done again, and which kind of case they happen to most. Propose any of them as a card rule and compare the 30 days before and after it was adopted. SOP conformance compares the SOP in your knowledge base with the steps cases really took.

Follow-through

SAP S/4HANA purchase to pay: see where each order waits

Connect SAP S/4HANA, Cloud or on-premise, to Duaer. It reads each purchase order's steps from requisition to payment through SAP's standard OData APIs, so you see where orders wait and for how long.

Comparisons

Enterprise AI search vs process mining: what’s the difference?

Enterprise AI search answers “how do we do this, and where is the document?” by reading documents. Process mining answers “how does the process really run, and where does it stall?” by reading event logs from systems such as ERP and CRM. Glean is a well-known example of the first and Celonis of the second. Duaer puts knowledge answers and follow-up on due work together for mid-sized teams that need some of both.