AR Adjustment - Sage Intacct REST Data Target Requirements
DataBlend supports the standard API calls to Create, Update, and Delete AR Adjustment 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 adjustment. Use customerid or customerkey — not both. |
| 7701 | customerkey | No | Key of the customer. |
| Acme Corp | customername | No | Customer name. Informational only; does not override the customer record. |
| 09/01/2026 | createddate | Yes — Create | Date the adjustment was created. Format: YYYY-MM-DD. |
| USD | txncurrencycurrency | Yes — Create | Transaction currency code (e.g. USD, EUR). |
| USD | basecurrencycurrency | Yes — Create | Base currency code. Typically matches the company base currency. |
| BATCH-2026-09 | adjustmentsummaryid | Yes — Create | ID of the adjustment summary (batch) this adjustment belongs to. Use adjustmentsummaryid or adjustmentsummarykey — not both. |
| 8801 | adjustmentsummarykey | No | Key of the adjustment summary. |
| 9901 | key | Yes — Update, Delete | System-assigned key of the adjustment record. Required to identify the record for Update or Delete operations. |
| ADJ-2026-001 | adjustmentnumber | No | User-defined adjustment number. |
| REF-001 | documentnumber | No | Document number reference for the adjustment. |
| Credit for returned goods | description | No | Description of the adjustment. |
| 9/1/2026 | glpostingdate | No | GL posting date. Format: YYYY-MM-DD. |
| posted | state | No | State of the adjustment. Options: reversed, reversal, draft, noValue, posted, paid, partiallyPaid, selected. |
| 500 | basecurrencytotaldue | No | Total amount due in the base currency. |
| 09/01/2026 | basecurrencypaiddate | No | Date the adjustment was paid in the base currency. Format: YYYY-MM-DD. |
| TAX-001 | taxsolutionid | No | Tax solution ID to use for this adjustment. Use taxsolutionid or taxsolutionkey — not both. |
| 5501 | taxsolutionkey | No | Key of the tax solution. |
| Columbus | target_entity | No | Target entity ID for multi-entity Sage Intacct environments. |
| 09/01/2026 | exchangeratedate | No | Date used to determine the exchange rate. Format: YYYY-MM-DD. |
| Intacct Daily Rate | exchangeratetypeid | No | Exchange rate type ID as configured in Sage Intacct. |
| 1.25 | exchangeraterate | No | Exchange rate value. Use when specifying a fixed rate instead of a rate type. |
| BILLTO-001 | contactsbilltoid | No | ID of the bill-to contact. Use contactsbilltoid or contactsbilltokey — not both. |
| 6601 | contactsbilltokey | No | Key of the bill-to contact. |
| SHIPTO-001 | contactsshiptoid | No | ID of the ship-to contact. Use contactsshiptoid or contactsshiptokey — not both. |
| 6701 | contactsshiptokey | No | Key of the ship-to contact. |
| TAXGRP-001 | contactsshiptotaxgroupid | No | Tax group ID for the ship-to contact. Use contactsshiptotaxgroupid or contactsshiptotaxgroupkey — not both. |
| 6801 | contactsshiptotaxgroupkey | No | Key of the ship-to tax group. |
| TAX-ID-001 | contactsshiptotaxtaxid | No | Tax ID for the ship-to contact. |
| ATT-001 | attachmentid | No | ID of an attachment to associate with this adjustment. Use attachmentid or attachmentkey — not both. |
| 6901 | attachmentkey | No | Key of the attachment. |
| 4000 | line_glaccountid | Yes — Create | GL account ID for the line item. Use line_glaccountid or line_glaccountkey — not both. |
| 7001 | line_glaccountkey | No | Key of the GL account. |
| 500 | line_txncurrencyamount | Yes — Create | Transaction currency amount for the line item. |
| USD | line_txncurrencycurrency | No | Transaction currency code for the line item. |
| Credit for returned goods | line_memo | No | Memo or description for the line item. |
| ACCTLBL-001 | line_accountlabelid | No | Account label ID for the line item. Use line_accountlabelid or line_accountlabelkey — not both. |
| 7101 | line_accountlabelkey | No | Key of the account label. |
| ADJ-001 | line_aradjustmentid | No | ID of the AR adjustment this line is associated with. Use line_aradjustmentid or line_aradjustmentkey — not both. |
| 7201 | line_aradjustmentkey | No | Key of the AR adjustment line. |
| OFFSET-4000 | line_overrideoffsetglaccountid | No | Override offset GL account ID. Use line_overrideoffsetglaccountid or line_overrideoffsetglaccountkey — not both. |
| 7301 | line_overrideoffsetglaccountkey | No | Key of the override offset GL account. |
| 09/01/2026 | line_exchangeratedate | No | Exchange rate date for the line item. Format: YYYY-MM-DD. |
| Intacct Daily Rate | line_exchangeratetypeid | No | Exchange rate type ID for the line item. |
| 1.25 | line_exchangeraterate | No | Fixed exchange rate for the line item. |
| TAXDET-001 | line_taxentryorderentrytaxdetailid | No | Order entry tax detail ID for the line tax entry. Use line_taxentryorderentrytaxdetailid or line_taxentryorderentrytaxdetailkey — not both. |
| 7401 | line_taxentryorderentrytaxdetailkey | No | Key of the order entry tax detail. |
| 0.08 | line_taxentrytaxrate | No | Tax rate for the line item (decimal, e.g. 0.08 for 8%). |
| 40 | line_taxentrytxntaxamount | No | Transaction currency tax amount for the line item. |
| 500 | line_taxentrybasetaxamount | No | Base currency tax amount for the line item. |
| LOC-001 | line_dimensionslocationid | Yes — Create | Location ID dimension for the line item. Use line_dimensionslocationid or line_dimensionslocationkey — not both. |
| 8001 | line_dimensionslocationkey | No | Key of the location dimension. |
| DEPT-001 | line_dimensionsdepartmentid | No | Department ID dimension. |
| 8101 | line_dimensionsdepartmentkey | No | Key of the department dimension. |
| ENTITY-B | line_dimensionsaffiliateentityid | No | Affiliate entity ID dimension. |
| 8201 | line_dimensionsaffiliateentitykey | No | Key of the affiliate entity dimension. |
| ASSET-001 | line_dimensionsassetid | No | Asset ID dimension. |
| 8301 | line_dimensionsassetkey | No | Key of the asset dimension. |
| CLASS-A | line_dimensionsclassid | No | Class ID dimension. |
| 8401 | line_dimensionsclasskey | No | Key of the class dimension. |
| CONTRACT-001 | line_dimensionscontractid | No | Contract ID dimension. |
| 8501 | line_dimensionscontractkey | No | Key of the contract dimension. |
| COSTYPE-001 | line_dimensionscosttypeid | No | Cost type ID dimension. |
| 8601 | line_dimensionscosttypekey | No | Key of the cost type dimension. |
| CUST-002 | line_dimensionscustomerid | No | Customer ID dimension. |
| 8701 | line_dimensionscustomerkey | No | Key of the customer dimension. |
| EMP-001 | line_dimensionsemployeeid | No | Employee ID dimension. |
| 8801 | line_dimensionsemployeekey | No | Key of the employee dimension. |
| ITEM-001 | line_dimensionsitemid | No | Item ID dimension. |
| 8901 | line_dimensionsitemkey | No | Key of the item dimension. |
| LOAN-001 | line_dimensionsloanaccountid | No | Loan account ID dimension. |
| 9001 | line_dimensionsloanaccountkey | No | Key of the loan account dimension. |
| PROJ-001 | line_dimensionsprojectid | No | Project ID dimension. |
| 9101 | line_dimensionsprojectkey | No | Key of the project dimension. |
| TASK-001 | line_dimensionstaskid | No | Task ID dimension. |
| 9201 | line_dimensionstaskkey | No | Key of the task dimension. |
| VEND-001 | line_dimensionsvendorid | No | Vendor ID dimension. |
| 9301 | line_dimensionsvendorkey | No | Key of the vendor dimension. |
| WH-001 | line_dimensionswarehouseid | No | Warehouse ID dimension. |
| 9401 | line_dimensionswarehousekey | No | Key of the warehouse dimension. |
| WO-001 | line_dimensionsworkorderid | No | Work order ID dimension. |
| 9501 | line_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/groups/adjustments/tags/accounts_receivable_adjustments.