Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

AP Adjustment - Sage Intacct REST Data Target Requirements

DataBlend supports the standard API calls to Create, Update, and Delete AP 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
ACME-001 vendorid Yes — Create ID of the vendor for this adjustment. Use vendorid or vendorkey — not both.
7701 vendorkey No Key of the vendor.
09/01/2026 createddate Yes — Create Date the adjustment was created. Format: YYYY-MM-DD.
USD currencybasecurrency Yes — Create Base currency code. Typically matches the company base currency (e.g. USD).
USD currencytxncurrency Yes — Create Transaction currency code (e.g. USD, EUR).
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 referencenumber No Reference number for the adjustment.
Credit for returned goods description No Description of the adjustment.
draft action No Submission action. Options: draft, submit.
posted state No State of the adjustment. Options: reversed, reversal, draft, noValue, posted, paid, partiallyPaid, selected.
FALSE istaxinclusive No Whether tax is inclusive in the line amounts. Use true or false.
Columbus target_entity No Target entity ID for multi-entity Sage Intacct environments.
09/01/2026 currencyexchangeratedate No Date used to determine the exchange rate. Format: YYYY-MM-DD.
Intacct Daily Rate currencyexchangeratetypeid No Exchange rate type ID as configured in Sage Intacct.
1.25 currencyexchangerate No Fixed exchange rate. Use when specifying a rate instead of a rate type.
BATCH-2026-09 adjustmentsummaryid No ID of the adjustment summary (batch) this adjustment belongs to. Use adjustmentsummaryid or adjustmentsummarykey — not both.
8801 adjustmentsummarykey No Key of the adjustment summary.
09/30/2026 adjustmentsummaryglpostingdate No GL posting date for the adjustment summary. Format: YYYY-MM-DD.
TAX-001 taxsolutionid No Tax solution ID for this adjustment. Use taxsolutionid or taxsolutionkey — not both.
5501 taxsolutionkey No Key of the tax solution.
PAYTO-001 contactspaytoid No ID of the pay-to contact. Use contactspaytoid or contactspaytokey — not both.
6601 contactspaytokey No Key of the pay-to contact.
TAXGRP-001 contactspaytotaxgroupid No Tax group ID for the pay-to contact. Use contactspaytotaxgroupid or contactspaytotaxgroupkey — not both.
6701 contactspaytotaxgroupkey No Key of the pay-to tax group.
TAX-ID-001 contactspaytotaxtaxid No Tax ID for the pay-to contact.
RETURNTO-001 contactsreturntoid No ID of the return-to contact. Use contactsreturntoid or contactsreturntokey — not both.
6801 contactsreturntokey No Key of the return-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_txnamount Yes — Create Transaction currency amount for the line item.
500 line_baseamount No Base currency amount for the line item.
500 line_totaltxnamount No Total transaction currency amount including tax for the line item.
9902 line_key No System-assigned key of the line item record.
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.
OFFSET-4000 line_overrideoffsetglaccountid No Override offset GL account ID. Use line_overrideoffsetglaccountid or line_overrideoffsetglaccountkey — not both.
7201 line_overrideoffsetglaccountkey No Key of the override offset GL account.
TRUE line_hasform1099 No Whether this line has a 1099 form. Use true or false.
MISC line_form1099type No 1099 form type (e.g. MISC, NEC).
7 line_form1099box No 1099 form box number.
09/01/2026 line_currencyexchangeratedate No Exchange rate date for the line item. Format: YYYY-MM-DD.
Intacct Daily Rate line_currencyexchangeratetypeid No Exchange rate type ID for the line item.
1.25 line_currencyexchangeraterate No Fixed exchange rate for the line item.
TAXDET-001 line_taxentrypurchasingtaxdetailid No Purchasing tax detail ID for the line. Use line_taxentrypurchasingtaxdetailid or line_taxentrypurchasingtaxdetailkey — not both.
7401 line_taxentrypurchasingtaxdetailkey No Key of the purchasing 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.
40 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-ADJ-001 line_dimensionsadjustmentassetid No Adjustment asset ID dimension. Use line_dimensionsadjustmentassetid or line_dimensionsadjustmentassetkey — not both.
8301 line_dimensionsadjustmentassetkey No Key of the adjustment asset dimension.
ASSET-001 line_dimensionsassetid No Asset ID dimension.
8401 line_dimensionsassetkey No Key of the asset dimension.
CLASS-A line_dimensionsclassid No Class ID dimension.
8501 line_dimensionsclasskey No Key of the class dimension.
CONTRACT-001 line_dimensionscontractid No Contract ID dimension.
8601 line_dimensionscontractkey No Key of the contract dimension.
COSTYPE-001 line_dimensionscosttypeid No Cost type ID dimension.
8701 line_dimensionscosttypekey No Key of the cost type dimension.
CUST-001 line_dimensionscustomerid No Customer ID dimension.
8801 line_dimensionscustomerkey No Key of the customer dimension.
EMP-001 line_dimensionsemployeeid No Employee ID dimension.
8901 line_dimensionsemployeekey No Key of the employee dimension.
ITEM-001 line_dimensionsitemid No Item ID dimension.
9001 line_dimensionsitemkey No Key of the item dimension.
LOAN-001 line_dimensionsloanaccountid No Loan account ID dimension.
9101 line_dimensionsloanaccountkey No Key of the loan account dimension.
PROJ-001 line_dimensionsprojectid No Project ID dimension.
9201 line_dimensionsprojectkey No Key of the project dimension.
TASK-001 line_dimensionstaskid No Task ID dimension.
9301 line_dimensionstaskkey No Key of the task dimension.
VEND-001 line_dimensionsvendorid No Vendor ID dimension.
9401 line_dimensionsvendorkey No Key of the vendor dimension.
WH-001 line_dimensionswarehouseid No Warehouse ID dimension.
9501 line_dimensionswarehousekey No Key of the warehouse dimension.
WO-001 line_dimensionsworkorderid No Work order ID dimension.
9601 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-payable/groups/adjustments.