Other Receipt Transactions - Sage Intacct Data Target Requirements

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

Location is a dimension that can be defined by the company and set on transactions to expand report functionality and insight.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Required	Type	Notes
PAYMENTDATE	paymentdate	Required	object	Payment date (MM/DD/YYYY)
PAYER	payee	Required	string	Payer (the parameter is incorrectly named)
RECEIVEDDATE	receiveddate	Required	object	Received date
PAYMENTMETHOD	paymentmethod	Required	string	Payment method. Use Printed Check, Cash, EFT, or Credit Card.
undepglaccountno	undepglaccountno	Optional	string	Undeposited GL account. Required if not using bankaccountid.
BANKACCOUNTID	bankaccountid	Optional	string	Bank account ID. Required if not using undepglaccountno.
DEPOSITDATE	depositdate	Optional	object	Deposit date. Only used if bankaccountid is set.
REFID	refid	Optional	string	Reference ID
DESCRIPTION	description	Optional	string	Description
SUPDOCID	supdocid	Optional	string	Attachments ID
CURRENCY	currency	Optional	string	Transaction currency code
EXCH_RATE_DATE	exchratedate	Optional	object	Exchange rate date.
EXCH_RATE_TYPE_ID	exchratetype	Optional	string	Exchange rate type. Do not use if exchrate is set. (Leave blank to use Intacct Daily Rate)
EXCHANGE_RATE	exchrate	Optional	currency	Exchange rate value. Do not use if exchangeratetype is set.
((custom fields))	customfields	Optional	array of customfield	Custom fields on transaction object
INCLUSIVETAX	inclusivetax	Optional	boolean	Inclusive taxes. Set to true to have the system calculate the transaction amount (trx_amount) for the receipt line and the transaction tax (trx_tax) for the tax entry based on the value supplied for totaltrxamount on the receipt line and the tax rate of the tax detail (detailid) for the tax entry. (AU, GB, ZA only). (Default: false)
TAXSOLUTIONID	taxsolutionid	Optional	string	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)
SEE LINE ITEMS	receiptitems	Required	lineitem[1...n]	Receipt lines, must have at least 1

Line Items: Must have at least one (1) line item from the list below:

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Required	Type	Notes
GLACCOUNTNO	glaccountno	Optional	string	GL account number. Required if not using accountlabel.
ACCOUNTLABEL	accountlabel	Optional	string	AP account label. Required if not using glaccountno.
AMOUNT	amount	Required	currency	Transaction amount. Do not supply if inclusive tax is set to true.
MEMO	memo	Optional	string	Memo
LOCATIONID	locationid	Optional	string	LOCATIONID of an active location. Required if company is multi-entity enabled.
DEPARTMENTID	departmentid	Optional	string	Department ID
((Custom Fields))	customfields	Optional	array of customfield	Custom fields
PROJECTID	projectid	Optional	string	Project ID
TASKID	taskid	Optional	string	Task ID. Only available when the parent projectid is also specified.
COSTTYPEID	costtypeid	Optional	string	Cost type ID. Only available when projectid and taskid are specified. (Construction subscription)
CUSTOMERID	customerid	Optional	string	Customer ID
VENDORID	vendorid	Optional	string	Vendor ID
EMPLOYEEID	employeeid	Optional	string	Employee ID
ITEMID	itemid	Optional	string	Item ID
CLASSID	classid	Optional	string	Class ID
TRX_AMOUNT	totaltrxamount	Optional	currency	Total transaction amount. Required if inclusive tax is set to true.
TAXRATE	taxentries	Optional	taxentry[1...n]	Tax entries for the line. Required for VAT enabled transactions. Providing multiple entries is allowed if your tax solution supports it (AU and GB only). For ZA, only one tax entry is allowed.