Expense Adjustments - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update Expense Adjustments 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.

Expense adjustments provide a way to fix the balance for an employee who was overpaid or underpaid for an expense.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ADJUSTMENTNO	ADJUSTMENTNO	Expense adjustment number	Optional	Expected value is free text
BATCHKEY	BATCHKEY	Summary `RECORDNO` to post adjustment to	Optional	Summary `RECORDNO` to post adjustment to. Expected value is integer
BASECURR	BASECURR	Base currency	Optional	Base currency code. Expected value is free text
CONTROLID			Optional	Expected value is free text
CURRENCY	CURRENCY	Reimbursement currency	Optional	Reimbursement currency code. Expected value is free text
DESCRIPTION	DESCRIPTION	Description	Optional	Expected value is free text (1000)
DATEGREATED	WHENCREATED	Date filed	Yes	Expected value is date in format `mm/dd/yyyy`
DATEPOSTED	WHENPOSTED	GL posting date	Optional	Expected value is date in format `mm/dd/yyyy`
DOCNUMBER	DOCNUMBER	Reference expense number	Optional	Expected value is free text (40)
EMPLOYEEID	EMPLOYEEID	Employee	Yes	Expected value is free text (200)
EXPENSEADJUSTMENT_AMOUNT	AMOUNT	Amount	Yes	Expected value is decimal
EXPENSEADJUSTMENT_CLASSID	CLASSID	Class	Optional	Expected value is free text (50)
EXPENSEADJUSTMENT_CONTRACTID			Optional
EXPENSEADJUSTMENT_CUSTOMERID	CUSTOMERID	Customer	Optional	Expected value is free text (20)
EXPENSEADJUSTMENT_DEPARTMENTID	DEPARTMENTID	Department	Optional	Expected value is free text (40)
EXPENSEADJUSTMENT_EMPLOYEEID	EMPLOYEEID	Employee	Optional	Expected value is free text (20)
EXPENSEADJUSTMENT_ITEMID	ITEMID	Item	Optional	Expected value is free text (30)
EXPENSEADJUSTMENT_LOCATIONID	LOCATIONID	Location	Optional	Expected value is free text (40)
EXPENSEADJUSTMENT_MEMO	DESCRIPTION	Memo	Optional	Expected value is free text (1000)
EXPENSEADJUSTMENT_PROJECTID	PROJECTID	Project	Optional	Expected value is free text (20)
EXPENSEADJUSTMENT_VENDORID	VENDORID	Vendor	Optional	Expected value is free text (20)
EXPENSEADJUSTMENT_WAREHOUSEID	WAREHOUSEID	Warehouse	Optional	Expected value is free text (40)
EXPENSEADJUSTMENT_EXPENSEDATE	ENTRY_DATE	Date	Optional	Expected value is date in format `mm/dd/yyyy`
EXPENSEADJUSTMENT_EXPENSETYPE	ACCOUNTLABEL	Expense type	Optional	Expected value is free text
EXPENSEADJUSTMENT_BILLABLE	BILLABLE	Billable	Optional	Checkbox
EXPENSEADJUSTMENT_QUANTITY	QUANTITY	Quantity	Optional	Expected value is decimal
EXPENSEADJUSTMENT_TRXAMOUNT	ORG_AMOUNT	Transaction amount	Optional	Expected value is decimal
EXPENSEADJUSTMENT_GLACCOUNTNO	GLACCOUNTNO	Account number	Optional	Expected value is free text (24)
EXPENSEADJUSTMENT_RATE	TAXRATE	Rate	Optional	Expected value is decimal
EXPENSEADJUSTMENT_EXCHRATE	ORG_EXCHRATE	Exchange rate	Optional	Expected value is decimal
EXPENSEADJUSTMENT_TASKID	TASKID	Task	Optional	Only available when the parent `projectid` is also specified. Expected value is free text
EXPENSEADJUSTMENT_TOTALTRXAMOUNT	TRX_TOTALPAID	Amount paid in transaction currency	Optional	Expected value is decimal
DETAILID	DETAILID	Unique ID of a tax detail	Yes/ Optional	Required for AU, GB, ZA only. Unique ID of a tax detail with the tax rate to use
TRXTAX	TRX_TAX	Transaction tax	Optional	For AU, GB, ZA only. 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`).
EXPENSEADJUSTMENT_EXCHRATEDATE	ORG_EXCHRATEDATE	Exchange rate date	Optional	Expected value is date in format `mm/dd/yyyy`
EXPENSEADJUSTMENT_EXPPMTTYPE	EXPPMTTYPE	Payment type	Optional	Expected value is free text (40)
EXPENSEADJUSTMENT_EXCHRATETYPE	ORG_EXCHRATETYPE	Exchange rate type	Optional	Expected value is free text (40)
EXPENSEADJUSTMENT_CURRENCY	ORG_CURRENCY	Transaction currency	Optional	Expected value is free text
EXPENSEADJUSTMENT_COSTTYPEID			Optional
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. See Tax Solutions for more information. (GB, AU, and ZA only)
INCLUSIVETAX	INCLUSIVETAX	Inclusive taxes	Optional	Checkbox. Set to `true` to have the system calculate the transaction amount (`trx_amount`) for the expense adjustment line and the transaction tax (`trx_tax`) for the tax entry based on the value supplied for `totaltrxamount` on the expense adjustment line and the tax rate of the tax detail (`detailid`) for the tax entry. (AU, GB, ZA only)
SUPDOCID	SUPDOCID	Attachments	Optional	Attachments ID. Expected value is free text
TARGET_ENTITY			Optional