The Account Transaction Request/Response (also known as the General Ledger or GL integration) is the mechanism Unimarket uses to transmit financial transactions to an external system, such as an FMIS or ERP. This ensures that your financial system accurately reflects commitments and accruals in real-time as users procure goods and services.
Why Use GL Integration?
This integration keeps your ERP as the "master system of record" while allowing procurement activity to happen seamlessly in Unimarket. Transactions are automatically generated at three key stages of the procurement lifecycle:
Order Creation: Generates a commitment (Estimate).
Receiving: Generates an accrual (GRNI).
Invoicing: Reverses the accrual and records the actual liability (AP).
Setting Up Accounts
To start, you must configure accounts in Unimarket that mirror your external ledger. While configurations vary by organization, most use these three types:
| Account Name | Account Code | Type | Description |
|---|---|---|---|
| Estimate | ERP Account Code | Liability | Records the commitment when an order is first approved. |
| GRNI | ERP Account Code | Liability | "Goods Received Not Invoiced." Records the accrual when items are receipted. |
| AP | ERP Account Code | Liability | "Accounts Payable." Records the final amount once the invoice is matched. |
| Shipping | ERP Account Code | Expense | Optional. Records shipping charges if they are tracked separately. |
Configure Posting Manager
The Posting Manager defines the logic of how Unimarket updates your accounts to match your ERP's accounting practices.
Estimate (Commitments)
When an order is created, the system codes the commitment to your designated Estimate Account.
GRNI (Accruals)
When a buyer receives items, the system updates the GRNI Account.
Same Account: If your GRNI and Estimate accounts are the same, the commitment is adjusted to reflect the received amount.
Separate Accounts: If they are different, the amount is "backed out" of the Estimate account and updated in the GRNI account.
AP (Accounts Payable)
When an invoice is matched, it updates the AP Account.
Optional: Some organizations choose to handle AP transactions directly in their ERP. And omit them from the GL integration.
Note on Shipping: If you specify a separate shipping account, all header-level shipping charges post there. Otherwise, Unimarket spreads these charges proportionally across all line items.
Viewing and Reconciling the Ledger
Unimarket provides administrative tools, to ensure your data stays synchronized:
Ledger View: Administrators can search and view all transactions by GL account to see exactly what was sent to the ERP.
GRNI Reconciliation Report: This report provides a summary of accruals to compare against your ERP, typically used for month-end audit checks.
Closing Orders: If a supplier sends a final invoice that is less than the received quantity, you can Close the Order to release any remaining accrual back to your budget.