AR Advances - Sage Intacct Data Target Requirements

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

AR advances let you receive customer advance payments before creating an invoice, such as if a customer sends you a retainer.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ACTION	ACTION		Optional	Action to execute on create. Use `Submit` or `Draft`. (Default: Submit)
BASECURRENCY	BASECURR	Base currency	Optional	Base currency code. Expected value is free text (3)
CONTROLID			Optional
DESCRIPTION	DESCRIPTION	Payment memo	Optional	Description of the advance. Expected value is free text
EXCHANGERATEDATE	EXCH_RATE_DATE	Exchange rate date	Optional	Exchange rate date in format mm/dd/yyyy.
ATTACHMENTID	SUPDOCID	Attachment	Optional	Attachments ID. Expected value is free text (21)
CURRENCY	CURRENCY	Currency	Optional	Transaction currency code. Expected value is free text (3)
CUSTOMERID	CUSTOMERID	Customer ID	Yes	ID of the customer who paid the advance. Expected value is free text (20)
DOCNUMBER	DOCNUMBER	Document or check no.	Optional	Reference number such as a check number, an authorization code received from a charge card company, or a transaction number. Expected value is free text (100)
EXCHANGERATE	EXCHANGE_RATE	Exchange rate	Optional	Exchange rate value. Do not use if `EXCH_RATE_TYPE_ID` is set. Expected value is decimal.
EXCHANGERATETYPEID	EXCH_RATE_TYPE_ID	Exchange rate type	Optional	Exchange rate type. Do not use if `EXCHANGE_RATE` is set. (Leave blank to use Intacct Daily Rate.) Expected value is free text (40)
FINANCIALENTITY	FINANCIALENTITY	Financial entity	Optional	ID of the checking or savings account to deposit the funds to. A `create` request must contain `FINANCIALENTITY` or `UNDEPOSITEDACCOUNTNO` when automatic summaries are enabled. Expected value is free text (20)
PAYMENTDATE	PAYMENTDATE	Payment date	Yes	Date the advance payment was made, in the mm/dd/yyyy format.
PAYMENTMETHOD	PAYMENTMETHOD	Payment method	Yes	Payment method used for the advance. Use `Printed Check`, `Cash`, `EFT`, or `Credit Card`. Expected value is free text (20)
PRBATCH	PRBATCH	Payment summary	Optional	Name of the summary to post to. A request must contain either `PRBATCH` or `PRBATCHKEY` if AR is configured for user-specified summary posting. Ignored if automatic summaries are enabled. (If values for both `PRBATCHKEY` and `PRBATCH` are included in your request and those values indicate different summaries, Sage Intacct posts to the summary identified by `PRBATCHKEY`.) Expected value is free text (100)
RECEIPTDATE	RECEIPTDATE	Receipt date	Yes	Receipt date in the mm/dd/yyyy format. If automatic summaries are enabled, this is the date on which the advance will be posted to the General Ledger.
UNDEPOSITEDACCOUNTNO	UNDEPOSITEDACCOUNTNO	Undeposited funds account no.	Optional	Undeposited funds account number. A `create` request must contain `FINANCIALENTITY` or `UNDEPOSITEDACCOUNTNO` when automatic summaries are enabled. Expected value is free text (40)
RECORDNO	RECORDNO	Record number	Yes for Update	`RECORDNO` of the AR Advance to update
TARGET_ENTITY			Optional

Line Items (Required)

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
LINE_ACCOUNTLABEL	ACCOUNTLABEL	Account label	Optional	AR account label. Required if AR configuration is set to Enable account labels. Expected value is free text (80)
LINE_ACCOUNTNO	ACCOUNTNO	Account	Optional	GL account number. Required if AR configuration is not set to Enable account labels. Expected value is free text (40)
LINE_CLASSID	CLASSID	Class	Optional	Class ID. Expected value is free text (50)
LINE_CONTRACTID	CONTRACTID	Contract	Optional	Contract ID. Expected value is free text (50)
LINE_LINE_CUSTOMERID	CUSTOMERID	Customer	Optional	Customer ID. Must be the same as the `CUSTOMERID` in the `ARADVANCE` object, or a child of that customer ID. Expected value is free text (20)
LINE_DEPARTMENTID	DEPARTMENTID	Department ID	Optional	Department ID. Expected value is free text (40)
LINE_EMPLOYEEID	EMPLOYEEID	Employee	Optional	Employee ID. Expected value is free text (20)
LINE_ENTRYDESCRIPTION	ENTRYDESCRIPTION	Memo	Optional	Memo
LINE_GLDIM	GLDIM	User Defined Dimension	Optional	User defined dimension id field. UDD object integration name usually appended to GLDIM.
LINE_ITEMID	ITEMID	Item	Optional	Item ID. Expected value is free text (30)
LINE_LOCATIONID	LOCATIONID	Location ID	Optional	LOCATIONID of an active location. Required if company is multi-entity enabled. Expected value is free text (20)
LINE_PROJECTID	PROJECTID	Project	Optional	Project ID. Expected value is free text (20)
LINE_TASKID	TASKID	Task ID	Optional	Task ID. Only available when the parent `PROJECTID` is also specified.
LINE_TRANSACTIONAMOUNT	TRX_AMOUNT	Transaction amount	Yes	Transaction amount of line. Expected value is decimal
LINE_VENDORID	VENDORID	Vendor	Optional	Vendor ID. Expected value is free text (20)
LINE_WAREHOUSEID	WAREHOUSEID	Warehouse	Optional	Warehouse ID. Expected value is free text (40)