AR Invoices - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update AR Invoice 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 invoice object represents an invoice sent to a customer for goods or services provided.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
RECORDNO	RECORDNO	Record number	Yes	Record Name. Record number of the invoice to retrieve.
ACCOUNTLABEL	ACCOUNTLABEL	AR account label	Yes/Optional	Required if not using `glaccountno`
ACTION	ACTION	Action	Optional	Action. Use `Draft` or `Submit`. (Default: `Submit`)
ALLOCATIONID	ALLOCATIONID	Allocation ID	Optional	Expected value is free text
BASECURRENCY	BASECURR	Base currency	Optional	Base currency code. Expected value is free text
BILLTOCONTACTNAME	BILLTO	Bill to contact	Optional	Object. Bill to contact. Expected value is free text
CLASSID	CLASSID	Class ID	Optional	Expected value is free text
CONTACTNAME	CONTACTNAME	Contact name	Yes/No	For `billto & shipto.` Expected value is free text (200)
CONTRACTID	CONTRACTID	Contract ID	Optional	Expected value is free text
COSTTYPEID	COSTTYPEID	Cost type ID	Optional	Only available when `projectid` and `taskid` are specified. (Construction subscription)
CUSTOMERID	CUSTOMERID	Customer ID	Yes for Create	Expected value is free text
DEFFEREDREVGLACCOUNTNO	DEFREVACCOUNT	Deferred revenue GL account number	Optional	Expected value is free text
DEPARTMENTID	DEPARTMENTID	Department ID	Optional	Expected value is free text
DESCRIPTION	DESCRIPTION	Description	Optional	Expected value is free text (1000)
DONOTPOSTTOGL	NOGL	Do not post to GL	Optional	Expected value is boolean. Use `false` for No, `true` for Yes. (Default: `false`)
DUEDATE	DATEDUE	Due date	Optional	Object. Due date. Required if not using `termname`. Year `yyyy`, Month `mm`, Day `dd`
EMPLOYEEID	EMPLOYEEID	Employee ID	Optional	Expected value is free text
EXCHANGERATEVALUE	EXCHRATE	Exchange rate value	Optional	Exchange rate value. Do not use if `exchangeratetype` is set. Expected value is decimal.
EXCHANGERATEDATE	EXCHRATEDATE	Exchange rate date	Optional	Object. Exchange rate date.
EXCHANGERATETYPE	EXCHRATETYPE	Exchange rate type	Optional	Exchange rate type. Do not use if `exchrate` is set. (Leave blank to use `Intacct Daily Rate`)
EXTERNALID	EXTERNALID	External ID	Optional	Expected value is free text
GLACCOUNTNUMBER	GLACCOUNTNO	GL account number	Optional	Required if not using `accountlabel`. Expected value is free text
GLPOSTINGDATE	DATEPOSTED	GL posting date	Optional	Object. GL posting date. Year `yyyy`, Month `mm`, Day `dd`
INVOICENUMBER	INVOICENO	Invoice number	Optional	Expected value is free text
ITEMID	ITEMID	Item ID	Optional	Expected value is free text
KEY	KEY	Key	Yes/Optional	Invoice `RECORDNO` to update/delete
LINENO	LINE_NUM	Line number	Yes for Update	Line number to update. Expected value is integer
LOCATIONID	LOCATIONID	Location ID	Optional	`LOCATIONID` of an active location. Required if company is multi-entity enabled.
MEMO	MEMO	Memo	Optional	Expected value is free text
OFFSETGLACCOUNTNO	OFFSETGLACCOUNTNO	Offset GL account number	Optional	Expected value is free text
REFERENCENUMBER	DOCNUMBER	Reference number	Optional	Expected value is free text (100)
PRBATCHKEY	PRBATCHKEY	Summary key	Optional	Summary `RECORDNO`. Expected value is integer
PROJECTID	PROJECTID	Project ID	Optional	Expected value is free text
REVRECENDDATE	REVRECENDDATE	Rev rec end date	Optional	Object
REVRECSTARTDATE	REVRECSTARTDATE	Rev rec start date	Optional	Object
REVRECTEMPLATE	REVRECTEMPLATE	Rev rec template ID	Optional	Expected value is free text
SHIPTOCONTACTNAME	SHIPTO	Ship to contact	Optional	Object. Ship to contact. Expected value is free text
SUPDOCID	SUPDOCID	Attachment	Optional	Expected value is free text (20)
TASKID	TASKID	Task ID	Optional	Only available when the parent `projectid` is also specified. Expected value is free text
PAYMENTTERM	TERMNAME	Term	Optional	Expected value is free text. Payment term. Required if not using `datedue`
TOTALDUE	TOTALDUE	Total due	Optional	Used when `nogl` on bill is `true`. Expected value is decimal
TOTALPAID	TOTALPAID	Total paid	Optional	Used when `nogl` on bill is `true`. Expected value is decimal
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
TRANSACTIONAMOUNT	AMOUNT	Transaction amount	Optional	Expected value is decimal
TRANSACTIONCURRENCY	CURRENCY	Transaction currency	Optional	Transaction currency code. Expected value is free text
TRANSACTIONDATE	DATECREATED	Transaction date	Yes	Object. Transaction date. Year `yyyy`, Month `mm`, Day `dd`
VENDORID	VENDORID	Vendor ID	Optional	Expected value is free text
WAREHOUSEID	WAREHOUSEID	Warehouse ID	Optional	Expected value is free text
YEAR	YEAR	Year	Yes/Optional	For `datecreated, dateposted, datedue`, `exchratedate`. Format `yyyy`
TAX_DETAILID	TAX_DETAILID		Yes	Value can be null in Data Target
TAX_LINE_NO	TAX_LINE_NO		Yes	Expected value is integer
TAX_TRX_TAX	TRX_TAX	Transaction Tax	Optional	Needed only if overriding the tax amount calculated within Intacct; provide the amount to use in this field