ml-connector
Workday Financial ManagementCin7

Workday Financial Management and Cin7 integration

Workday Financial Management handles procurement, accounts payable, and general ledger for enterprise scale. Cin7 Core manages inventory and purchase operations for product-based businesses. Connecting the two keeps your procurement records and GL aligned across both systems. Purchase orders and invoices created in Workday flow into Cin7's procure-to-pay lifecycle without manual re-entry, and suppliers are kept in sync so accounts and cost codes match between systems.

How Workday Financial Management works

Workday Financial Management exposes purchase orders, supplier invoices, suppliers, GL accounts, worktags, and journal entries through two API surfaces: SOAP/XML at the tenant-specific Workday endpoint with WS-Security UsernameToken, and REST/JSON with OAuth2 bearer tokens from a manual refresh-token flow. The system has no native webhooks or event stream and requires polling with date-range filters on Get operations. Recommended polling intervals range from 15 to 60 minutes for transactional entities like invoices and orders, with a 5-minute minimum to avoid tenant-level rate throttling. Complex operations such as bulk invoice import and PO creation require SOAP; REST supports lighter read-only queries. ISU setup and security group assignments must be completed on the customer side before integration can connect.

How Cin7 works

Cin7 Core exposes suppliers, purchases, sales, customers, products, and chart of accounts through REST/JSON APIs using custom API key headers (api-auth-accountid and api-auth-applicationkey) rather than OAuth or Basic Auth. The platform supports webhooks for outbound events on sales, purchases, suppliers, and stock changes, configured via the UI Automation module rather than directly via API. Webhook payloads are not HMAC-signed, so mTLS or query-param token verification is recommended. The chart of accounts is read-only, and purchases cover the full procure-to-pay lifecycle via an Approach field that indicates ORDER, INVOICE, or RECEIVE status. Multiple API keys can be created per account with rate limits applied per application key.

What moves between them

Purchase orders and supplier invoices flow from Workday Financial Management into Cin7 Core on a polling schedule, typically daily or after each procurement cycle. Suppliers are synced bidirectionally so that new suppliers created in either system are available for purchase matching. GL accounts and cost allocations are mapped from Workday to Cin7 so that invoices posted into Cin7 land on the correct accounts and worktags. The flow is primarily inbound to Cin7, since Cin7's chart of accounts is read-only and Workday remains the source of truth for GL structure and supplier master data.

How ml-connector handles it

ml-connector manages Workday's OAuth2 access token refresh on each call, since tokens expire after one hour and must be re-acquired from the manual refresh token stored encrypted in the connector. It polls Workday's supplier invoices and purchase orders on a daily schedule using date-range filters to avoid re-reading historical data, and backs off on 429 responses if tenant rate limits are hit. Suppliers are fetched with a longer interval to reduce load, since master data changes less frequently than transactions. On the Cin7 side, ml-connector maps Workday purchase order and invoice records to Cin7's Purchase entity using the Approach field to set ORDER, INVOICE, and RECEIVE statuses in the correct sequence. GL accounts and worktags from Workday are validated against Cin7's chart of accounts before posting, so invoices land on accounts that exist in both systems. Cin7's read-only chart of accounts means invoice GL allocation happens at the Workday source, not at Cin7. Every record carries audit metadata including the original Workday transaction ID, source system timestamp, and sync outcome.

A real-world example

A growing mid-market distributor runs Workday Financial Management for AR, AP, and GL, and uses Cin7 Core to manage product inventory, purchase orders, and order fulfillment. Before integration, the procurement team created purchase orders in Cin7, then manually keyed them into Workday for AP and GL visibility, creating duplicate work and reconciliation friction at month-end close. When supplier invoices arrived, they entered them again into both systems and had to match GL account assignments by hand. With Workday and Cin7 connected, purchase orders created in Cin7 are automatically pulled into Workday's AP workflow, supplier invoices from Workday post into Cin7's purchase records, and the GL allocation decided in Workday is preserved in the audit trail. Inventory, procurement, and accounting now move together without re-keying.

What you can do

  • Sync purchase orders from Workday Financial Management into Cin7 Core's procurement workflow with order status tracking.
  • Pull supplier invoices from Workday and post them into Cin7 using the correct purchase and payment status via the Approach field.
  • Keep suppliers in sync between systems so new vendor records are available for matching and payment in both platforms.
  • Map Workday GL accounts and worktags to Cin7's chart of accounts so invoices land on the correct GL dimensions.
  • Poll Workday on a daily schedule with OAuth2 token refresh and rate-limit backoff, maintaining a full audit trail of every sync.

Questions

Can purchase orders and invoices move in both directions between Workday and Cin7?
No. The flow is primarily from Workday Financial Management into Cin7 Core. Purchase orders and invoices are read from Workday and posted into Cin7's procurement workflow. Cin7's chart of accounts is read-only, so GL allocation is determined by Workday's GL structure and does not move back to Workday.
How does ml-connector handle Workday's OAuth2 token expiry?
Workday access tokens expire after one hour. ml-connector stores the manual refresh token encrypted and automatically exchanges it for a new access token before each API call that would fail. The refresh token itself is long-lived and does not require regular renewal.
What happens if Workday and Cin7 have different GL account structures?
ml-connector maps Workday GL accounts and worktags to Cin7's chart of accounts before posting invoices. If an account in Workday does not exist in Cin7, the record is flagged in the audit trail and held for manual review rather than failing silently or posting to a default account.

Related integrations

Connect Workday Financial Management and Cin7

Free to use. Add your credentials, ping your real systems, and see if we fit.

Get started