AR Advance - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls to Create, Update, and Delete AR Advance records within Sage Intacct leveraging the Sage Intacct API. In addition, Custom Fields can be added for data that is unique to your business practices.
| DataBlend Query Object (SDK) | Sage Intacct Object (API) | Required | Notes |
| CUST-001 | customerid | Yes — Create | ID of the customer for this advance. Use customerid or customerkey — not both. |
| 7701 | customerkey | No | Key of the customer. |
| Acme Corp | customername | No | Customer name. Informational only. |
| 9901 | key | Yes — Update, Delete | System-assigned key of the advance record. Required to identify the record for Update or Delete operations. |
| REF-2026-001 | referencenumber | No | Reference number for the advance. |
| Customer advance for Q3 | description | No | Description of the advance. |
| posted | state | No | State of the advance. Options: reversed, reversal, draft, reconciled, fullyApplied, partiallyApplied, posted, selected. |
| 1000 | totalentered | No | Total base currency amount entered for the advance. |
| 1000 | txntotalentered | No | Total transaction currency amount entered for the advance. |
| Columbus | target_entity | No | Target entity ID for multi-entity Sage Intacct environments. |
| 09/01/2026 | paymentinformationpaymentdate | Yes — Create | Date the payment was made. Format: YYYY-MM-DD. |
| 09/01/2026 | paymentinformationreceiptdate | Yes — Create | Date the payment was received. Format: YYYY-MM-DD. |
| cash | paymentinformationpaymentmethod | Yes — Create | Payment method. Options: printedCheck, creditCard, eft, cash, ach. |
| USD | paymentinformationcurrencybasecurrency | Yes — Create | Base currency code for the payment (e.g. USD). |
| USD | paymentinformationcurrencytxncurrency | No | Transaction currency code for the payment. |
| 1.25 | paymentinformationcurrencyexchangerate | No | Fixed exchange rate for the payment. |
| 09/01/2026 | paymentinformationcurrencyexchangeratedate | No | Date used to determine the exchange rate. Format: YYYY-MM-DD. |
| Intacct Daily Rate | paymentinformationcurrencyexchangeratetypeid | No | Exchange rate type ID as configured in Sage Intacct. |
| BANK-CHK | paymentinformationfinancialentityentityid | No | Entity ID of the financial account used to receive the payment. Use paymentinformationfinancialentityentityid or paymentinformationfinancialentityid — not both. |
| 4401 | paymentinformationfinancialentityid | No | Key of the financial entity. |
| 1000 | glaccountid | No | GL account ID for the advance. Use glaccountid or glaccountkey — not both. |
| 5501 | glaccountkey | No | Key of the GL account. |
| 1001 | glaccountundepositedglaccountnumber | No | Undeposited funds GL account number. |
| BATCH-2026-09 | advancesummaryid | No | ID of the advance summary (batch) this advance belongs to. Use advancesummaryid or advancesummarykey — not both. |
| 6601 | advancesummarykey | No | Key of the advance summary. |
| ATT-001 | attachmentid | No | ID of an attachment to associate with this advance. Use attachmentid or attachmentkey — not both. |
| 6701 | attachmentkey | No | Key of the attachment. |
| 4000 | entry_glaccountid | Yes — Create | GL account ID for the entry line. Use entry_glaccountid or entry_glaccountkey — not both. |
| 7001 | entry_glaccountkey | No | Key of the GL account. |
| 1000 | entry_txnamount | Yes — Create | Transaction amount for the entry line. |
| Customer advance received | entry_memo | No | Memo or description for the entry line. |
| ACCTLBL-001 | entry_accountlabelid | No | Account label ID for the entry. Use entry_accountlabelid or entry_accountlabelkey — not both. |
| 7101 | entry_accountlabelkey | No | Key of the account label. |
| LOC-BASE | entry_baselocationid | No | Base location ID for the entry. Use entry_baselocationid or entry_baselocationkey — not both. |
| 7201 | entry_baselocationkey | No | Key of the base location. |
| LOC-001 | entry_dimensionslocationid | Yes — Create | Location ID dimension for the entry. Use entry_dimensionslocationid or entry_dimensionslocationkey — not both. |
| 8001 | entry_dimensionslocationkey | No | Key of the location dimension. |
| DEPT-001 | entry_dimensionsdepartmentid | No | Department ID dimension. |
| 8101 | entry_dimensionsdepartmentkey | No | Key of the department dimension. |
| ENTITY-B | entry_dimensionsaffiliateentityid | No | Affiliate entity ID dimension. |
| 8201 | entry_dimensionsaffiliateentitykey | No | Key of the affiliate entity dimension. |
| ASSET-001 | entry_dimensionsassetid | No | Asset ID dimension. |
| 8301 | entry_dimensionsassetkey | No | Key of the asset dimension. |
| CLASS-A | entry_dimensionsclassid | No | Class ID dimension. |
| 8401 | entry_dimensionsclasskey | No | Key of the class dimension. |
| CONTRACT-001 | entry_dimensionscontractid | No | Contract ID dimension. |
| 8501 | entry_dimensionscontractkey | No | Key of the contract dimension. |
| COSTYPE-001 | entry_dimensionscosttypeid | No | Cost type ID dimension. |
| 8601 | entry_dimensionscosttypekey | No | Key of the cost type dimension. |
| CUST-002 | entry_dimensionscustomerid | No | Customer ID dimension. |
| 8701 | entry_dimensionscustomerkey | No | Key of the customer dimension. |
| EMP-001 | entry_dimensionsemployeeid | No | Employee ID dimension. |
| 8801 | entry_dimensionsemployeekey | No | Key of the employee dimension. |
| ITEM-001 | entry_dimensionsitemid | No | Item ID dimension. |
| 8901 | entry_dimensionsitemkey | No | Key of the item dimension. |
| LOAN-001 | entry_dimensionsloanaccountid | No | Loan account ID dimension. |
| 9001 | entry_dimensionsloanaccountkey | No | Key of the loan account dimension. |
| PROJ-001 | entry_dimensionsprojectid | No | Project ID dimension. |
| 9101 | entry_dimensionsprojectkey | No | Key of the project dimension. |
| TASK-001 | entry_dimensionstaskid | No | Task ID dimension. |
| 9201 | entry_dimensionstaskkey | No | Key of the task dimension. |
| VEND-001 | entry_dimensionsvendorid | No | Vendor ID dimension. |
| 9301 | entry_dimensionsvendorkey | No | Key of the vendor dimension. |
| WH-001 | entry_dimensionswarehouseid | No | Warehouse ID dimension. |
| 9401 | entry_dimensionswarehousekey | No | Key of the warehouse dimension. |
| WO-001 | entry_dimensionsworkorderid | No | Work order ID dimension. |
| 9501 | entry_dimensionsworkorderkey | No | Key of the work order dimension. |
| custom.entry.{custom_field_name} | {custom_field_name} | No | Custom fields for this object. Replace {custom_field_name} with the custom field's object ID as defined in Sage Intacct. |
More questions about Sage Intacct API requirements? Please visit the Sage Intacct API site https://developer.sage.com/intacct/apis/intacct/1/intacct-openapi/groups/accounts-receivable/tags/accounts_receivable_advances.