AP Bills - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update AP Bill 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 AP bill is a transaction that tracks money owed to a vendor.

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
RECORDNO	RECORDNO	Record number	Yes	Record Number. Record number of the bill to Update.
ACCOUNTLABEL	ACCOUNTLABEL	AP account label	Yes/Optional	Required if not using `ACCOUNTNO`
ACTION	ACTION	Action	Optional	Action to execute on create. Use `Draft` or `Submit`. (Default: `Submit`)
ALLOCATIONID	ALLOCATIONID	Allocation ID	Optional	Expected value is free text
ATTACHMENTSID	SUPDOCID	Attachments ID	Optional	Expected value is free text
BASECURRENCY	BASECURR	Base currency	Optional	Base currency code. Expected value is free text
BILLABLE	BILLABLE	Billable	Optional	Check box. `false` - No (default), `true` - Yes
BILLNO	BILLNO	Bill number	Optional	Expected value is free text
CLASSID	CLASSID	Class ID	Optional	Expected value is free text
CONTRACTID	CONTRACTID	Contract ID	Optional	Expected value is free text
CUSTOMERID	CUSTOMERID	Customer ID	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)
DUEDATE	WHENDUE	Due date	Yes/Optional	Due date in format `mm/dd/yyyy`
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	WHENPOSTED	GL posting date	Optional	GL posting date in format `mm/dd/yyyy`. Not used if `PRBATCH` provided.
ITEM1099	ITEM1099	Form 1099	Optional	Check box. Vendor must be set up for 1099s. `false` - No, `true` - Yes
ITEMID	ITEMID	Item ID	Optional	Expected value is free text
KEY	KEY	Key	Yes/Optional	Bill `RECORDNO` to update/reverse/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
NOGL	NOGL	Do not post to GL	Optional	Check box. `false` - No (default), `true` - Yes
ONHOLD	ONHOLD	On hold	Optional	Check box. `false` - No (default), `true` - Yes
PAYMENTTERM	TERMNAME	Payment term	Optional	Expected value is free text
PAYTO	BILLTOPAYTOCONTACTNAME	Pay to	Optional	Expected value is free text
PROJECTID	PROJECTID	Project ID	Optional	Expected value is free text
REFERENCENUMBER	DOCNUMBER	Reference number	Optional	Expected value is free text (100)
RETURNTO	SHIPTORETURNTOCONTACTNAME	Return to	Optional	Expected value is free text
SUMMARYRECORDNO	PRBATCHKEY	Summary key	Optional	Expected value is integer
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
TAX_TRX_TAX		Transaction Tax	Optional
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
TRANSACTIONAMOUNT	TRX_AMOUNT	Transaction amount	Optional	Expected value is decimal
TRANSACTIONCURRENCY	CURRENCY	Transaction currency	Optional	Transaction currency code. Expected value is free text
TRANSACTIONDATE	WHENCREATED	Date	Yes	Transaction date in format `mm/dd/yyyy`
VENDORID	VENDORID	Vendor ID	Optional	Expected value is free text
NAME	VENDORNAME	Vendor name	Optional	Expected value is free text (100)
WAREHOUSEID	WAREHOUSEID	Warehouse ID	Optional	Expected value is free text

Header

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
TAX_DETAILID	TAX_DETAILID	Tax solution	Yes (Regardless of if client uses the tax services in Intacct)	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) This is header is case sensitive.
INCLUSIVETAX	INCLUSIVETAX	Inclusive taxes	Optional	Set to `true` to have the system calculate the transaction amount (`TRX_AMOUNT`) for the bill line and the transaction tax (`TRX_TAX`) for the tax entry based on the value supplied for `TOTALTRXAMOUNT` on the bill line and the tax rate of the tax detail (`DETAILID`) for the tax entry. (AU, GB, ZA only)
TAX_LINE_NO	TAX_LINE_NO		Yes (Regardless of if client uses the tax services in Intacct)	Expected value is integer

DataBlend Query Object (SDK)

Sage Intacct Object (API)

Sage Intacct UI Name

Required

Notes

TAX_DETAILID

Tax solution

Yes (Regardless of if client uses the tax services in Intacct)

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)

This is header is case sensitive.

INCLUSIVETAX

Inclusive taxes

Optional

Set to true to have the system calculate the transaction amount (TRX_AMOUNT) for the bill line and the transaction tax (TRX_TAX) for the tax entry based on the value supplied for TOTALTRXAMOUNT on the bill line and the tax rate of the tax detail (DETAILID) for the tax entry. (AU, GB, ZA only)

TAX_LINE_NO

Yes (Regardless of if client uses the tax services in Intacct)

Expected value is integer

Line

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
FORM1099TYPE	FORM1099TYPE	Form 1099 type	Optional	Expected value is free text
FORM1099BOX	FORM1099BOX	Form 1099 box	Optional	Expected value is free text
COSTTYPEID	COSTTYPEID	Cost type ID	Optional	Only available when `projectid` and `taskid` are specified. (Construction subscription). Expected value is free text
TOTALTRXAMOUNT	TRX_TOTALENTERED	Total transaction amount	Optional	Expected value is decimal
PARTIALEXEMPT	PARTIALEXEMPT	Partial exemption	Optional	Enables partial exemption so that you can reclaim a portion of your input VAT on purchases. (GB only) `false` - No (detault), `true` - Yes