AP Payments - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update AP Payment 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 payment is a transaction that records a payment against an AP bill or AP adjustment.

Create/Update an AP Payment

Create a Manual AP Payment

Create/Update an AP Payment

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
ACTION	ACTION	Action	Optional	Use `Draft` to move the payment to the outbox in the system, or `Submit` to submit/post the payment depending on the approval workflow (Default: `Submit`).
ADJUSTMENTAMOUNT	TRX_ADJUSTMENTAMOUNT	Adjustment transaction amount	Optional	Expected value is decimal
ADJUSTMENTENTRYKEY	ADJUSTMENTENTRYKEY	Debit memo entry record number	Optional	Expected value is integer
ADJUSTMENTKEY	ADJUSTMENTKEY	Debit memo record number	Optional	Expected value is integer
ADVANCEENTRYKEY	ADVANCEENTRYKEY	Advance entry record number	Optional	Expected value is integer
ADVANCEKEY	ADVANCEKEY	Advance record number	Optional	Expected value is integer
AMOUNTTOPAY	AMOUNTTOPAY	Amount to pay	Optional	Amount to pay in the currency of the financial entity making the payment. Only applicable when paying from a bank with a different currency than that of the transaction.
BASECURRENCY	BASECURR	Base currency	Optional	Base currency code. Expected value is free text
CURRENCY	CURRENCY	Transaction currency	Yes	Transaction currency code. Expected value is free text
DESCRIPTION	DESCRIPTION	Description	Optional	Description of the payment. Expected value is free text (1000). This field will not update if the ACTION field is included in the call that is being sent to Intacct.
DISCOUNTDATE	DISCOUNTDATE	Discount date	Optional	Discount date in format `mm/dd/yyyy`. All discounts available at this date are applied. You can supply a date in the past to access a discount whose deadline has already passed. You must provide the correct `TRX_PAYMENTAMOUNT` for the entire amount due (with the discount amount calculated in) for the discount to apply. Discounts are not applied when bill lines are provided.
DOCUMENTNUMBER	DOCUMENTNUMBER	Document number	Optional	Expected value is free text
ENTRYKEY	ENTRYKEY	Bill line record number	Optional	Not supported for discounts. Expected value is integer
EXCHANGERATEDATE	EXCH_RATE_DATE	Exchange rate date	Optional	Exchange rate date in format `mm/dd/yyyy` (Default: payment date of the request)
EXCHANGERATETYPE	EXCH_RATE_TYPE_ID	Exchange rate type	Optional	Exchange rate type (Default: `Intacct Daily Rate`)
FINANCIALENTITY	FINANCIALENTITY	Financial entity	Yes	Financial entity from which the payment will be paid. Can be a checking account ID, a savings account ID, or a credit card ID.
INLINEAMOUNT	TRX_INLINEAMOUNT	Negative bill transaction amount	Optional	Expected value is decimal
INLINEKEY	INLINEKEY	Negative bill transaction record number	Optional	Expected value is integer
INLINEENTRYKEY	INLINEENTRYKEY	Record number of a negative line on a bill	Optional	Expected value is integer
MEMOENTRYRECORDNO	POSADJENTRYKEY	Credit memo entry record number	Optional	Expected value is integer
MEMORECORDNO	POSADJKEY	Credit memo record number	Optional	Expected value is integer
PAYMENTAMOUNT	TRX_PAYMENTAMOUNT	Amount of the payment	Yes	Must be the full amount of the bill (with the discount amount calculated in) in order to apply a discount. Expected value is decimal
PAYMENTDATE	PAYMENTDATE	Payment date	Yes	Payment date in format `mm/dd/yyyy`. Parameter value is shown in `WHENCREATED` in subsequent read operations.
PAYMENTMETHOD	PAYMENTMETHOD	Payment method	Yes	Use `Printed Check`, `Cash`, `EFT`, `Credit Card`, `ACH`, `Check Delivery`, `Amex ACH`, `Amex Charge Card`, `WF Check`, `WF Domestic ACH`, or `WF USD Wire`
PAYMENTREQUESTMETHOD	PAYMENTREQUESTMETHOD	Approach for paying the bill	Optional	Use `vendorpref` to apply the preference for the vendor as specified in the Sage Intacct UI, `vendor` to pay all bills from the vendor in one payment, `bill` to pay each bill from the vendor as as separate payment, or `payto` to merge the request into one per vendor pay-to contact (Default: `vendorpref`).
POSTEDADVANCEAMOUNT	TRX_POSTEDADVANCEAMOUNT	Posted advance transaction amount	Optional	Expected value is decimal
RECORDKEY	RECORDKEY	Bill record number	Yes/Optional	Required if not using a credit memo record number. Expected value is integer
VENDORID	VENDORID	Vendor ID	Yes	Expected value is free text

See Create AP Payment and Update AP Payment for more information.

Create a Manual AP Payment

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
bankaccountid	bankaccountid	Bank account ID	Optional	Required if not using chargecardid.
chargecardid	chargecardid	Credit card ID	Optional	Required if not using bankaccountid.
vendorid	vendorid	Vendor ID	Yes	Expected value is free text.
memo	memo	Memo	Optional	Expected value is free text.
paymentmethod	paymentmethod	Payment method	Optional	Use Printed Check, Manual Check, Joint Check, Cash, EFT, or Credit.
checkdate	checkdate	Check date	Yes	Payment date.
batchkey	batchkey	Batch key	Optional	Summary record number to place this payment in.
checkno	checkno	Check number	Yes	Check number or payment reference number.
billno	billno	Bill reference number	Optional
basepaymentamount	basepaymentamount	Base payment amount	Optional
basecurr	basecurr	Base currency code	Optional	Base currency code. Expected value is free text.
currency	currency	Transaction currency code	Optional	Transaction currency code. Expected value is free text.
exchratedate	exchratedate	Exchange rate date	Optional
exchratetype	exchratetype	Exchange rate type	Optional	Do not use if exchrate is set. (Leave blank to use Intacct Daily Rate.)
exchrate	exchrate	Exchange rate value	Optional	Do not use if exchangeratetype is set.
paymentexchratetype	paymentexchratetype	Payment exchange rate type	Optional	Leave blank to use Intacct Daily Rate.
target_entity	target_entity		Optional
item_glaccountno	item_glaccountno	GL account number	Optional	Required if not using accountlabel.
item_accountlabel	item_accountlabel	AP account label	Optional	Required if not using glaccountno.
item_paymentamount	item_paymentamount	Transaction amount	Yes
item_item1099	item_item1099	Form 1099	Optional	Use false for No, true for Yes. Vendor must be set up for 1099s.
item_departmentid	item_departmentid	Department ID	Optional
item_locationid	item_locationid	Location ID	Optional	Required if company is multi-entity enabled.
item_projectid	item_projectid	Project ID	Optional
item_taskid	item_taskid	Task ID	Optional	Only available when the parent projectid is also specified.
item_costtypeid	item_costtypeid	Cost type ID	Optional	Only available when projectid and taskid are specified. (Construction subscription)
item_customerid	item_customerid	Customer ID	Optional
item_vendorid	item_vendorid	Vendor ID	Optional
item_employeeid	item_employeeid	Employee ID	Optional
item_itemid	item_itemid	Item ID	Optional
item_classid	item_classid	Class ID	Optional

See Create Manual AP Payment Legacy for more information.