AR Adjustments - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update AR Adjustment records within Sage Intacct leveraging the Sage Intacct SDK. In addition, Custom Fields can be added for data that is unique to your business practices.

An AR adjustment is a transaction that applies a credit or debit in order to modify the amount owed by a customer.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ACTION	ACTION	Action	Optional	Use `Draft` or `Submit`. (Default: `Submit`)
ADJUSTMENTNO	RECORDID	Adjustment number	Optional	Expected value is free text (45)
BASECURRENCY	BASECURR	Base currency	Optional	Base currency code. Expected value is free text
CONTROLID			Optional
CURRENCY	CURRENCY	Transaction currency	Yes/Optional	Transaction currency code. Yes - for multicurrency environment. Expected value is free text
CUSTOMERID	CUSTOMERID	Customer ID	Yes	Expected value is free text
DATECREATED	WHENCREATED	Date	Yes	Transaction date in format `mm/dd/yyyy`
DATEPOSTED	WHENPOSTED	GL posting date	Optional	Posting date in format `mm/dd/yyyy`
DESCRIPTION	DESCRIPTION	Description	Optional	Expected value is free text (1000)
EXCHANGERATEDATE	EXCH_RATE_DATE	Exchange rate date	Optional	Exchange rate date in format `mm/dd/yyyy`. If null, defaults to `BATCH_DATE`.
EXCHANGERATETYPE	EXCH_RATE_TYPE_ID	Exchange rate type	Optional	Required if multi-currency enabled and `EXCHANGE_RATE` left blank. Expected value is free text (40) Do not use if `EXCHANGE_RATE` is set. (Leave blank to use `Intacct Daily Rate`)
EXCHANGERATEVALUE	EXCHANGE_RATE	Exchange rate value	Optional	Do not use if `EXCH_RATE_TYPE_ID` is set. Required if multi currency enabled and `EXCH_RATE_TYPE_ID` left blank. Exchange rate amount to 4 decimals.
EXTERNALID	EXTERNALID	External ID	Optional
INVOICENUMBER	DOCNUMBER	Reference invoice number	Optional	Expected value is free text
NOGL	NOGL	Do not post to GL	Optional	Use `false` for No, `true` for Yes. (Default: `false`)
RECORDNO	RECORDNO	Record number	Yes/Optional	Yes for Update or Delete. Expected value is Record name
SUMMARYRECORDNO	BATCHKEY	Summary record number	Optional	Expected value is integer
TARGET_ENTITY	ENTITY	Customer entity	Optional	For multi-entity environment. Data Target setting “Post To Multiple Entities” should be ON. Expected value is free text (21)
TAXSOLUTIONID	TAXSOLUTIONID	Tax solution	Optional	Tax solution name, such as `United Kingdom - VAT` or `Australia - GST`. Required only if the company is configured for multiple tax jurisdictions and the transaction is occurring at the top level of the company. The available tax solution names can be found in the Sage Intacct UI in the Taxes application from the top level of a multi-entity company. (GB, AU, and ZA only). Expected value is free text

Line Items

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
LINE_ACCOUNTLABEL	ACCOUNTLABEL	Account label	Yes/Optional	Expected value is free text. Required if not using `glaccountno`.
LINE_ALLOCATIONID	ALLOCATIONID	Allocation	Optional	Expected value is free text
LINE_CLASSID	CLASSID	Class	Optional	Expected value is free text (50)
LINE_CONTRACTID	CONTRACTID	Contract	Optional	Expected value is free text (50)
LINE_CUSTOMERID	CUSTOMERID	Customer	Optional	Expected value is free text (20)
LINE_DEPARTMENTID	DEPARTMENTID	Department	Yes/Optional	Expected value is free text
LINE_EMPLOYEEID	EMPLOYEEID	Employee	Optional	Expected value is free text (20)
LINE_GLACCOUNTNUMBER	GLACCOUNTNO	Account	Yes/Optional	Expected value is free text. Required if not using `accountlabel`.
LINE_ITEMID	ITEMID	Item	Optional	Expected value is free text (30)
LINE_KEY	KEY	Key	Optional
LINE_LINENO	LINE_NO	Line no.	Optional	Expected value is free text (4)
LINE_LOCATIONID	LOCATIONID	Location	Yes/Optional	`LOCATIONID` of an active location. Required if company is multi-entity enabled. Expected value is free text.
LINE_MEMO	ENTRYDESCRIPTION	Memo	Optional	Expected value is free text (1000)
LINE_OFFSETGLACCOUNTNUMBER	OFFSETGLACCOUNTNO	AR account	Optional	Expected value is free text
LINE_PROJECTID	PROJECTID	Project	Optional	Expected value is free text (20)
LINE_TAX_DETAILID	DETAILID	Tax detail	Optional	Unique ID of a tax detail with the tax rate to use. Expected value is free text
LINE_TAX_TRXTAX	TRX_TAX	Transaction tax	Optional	Transaction tax, which is a manually calculated value to override the calculated value for the tax. The amount of the tax line is automatically included in the read-only transaction amount (`trx_amount`).
LINE_TOTALDUE	TRX_TOTALDUE	Total transaction due	Optional	Used when `nogl` on bill is `true`
LINE_TOTALPAID	TRX_TOTALPAID	Total transaction paid	Optional	Used when `nogl` on bill is `true`
LINE_TRANSACTIONAMOUNT	TRX_AMOUNT	Transaction amount	Yes	Use a positive number to create a debit memo or a negative number to create a credit memo.
LINE_VENDORID	VENDORID	Vendor	Optional	Expected value is free text (20)
LINE_WAREHOUSEID	WAREHOUSEID	Warehouse	Optional	Expected value is free text (40)