Journal Entries - Sage Intacct Data Target Requirements

DataBlend supports the standard API calls (non-legacy) to Create and Update journal entry 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.

A journal entry can add, edit, or reverse a transaction to a journal. When writing journal entries, be sure to balance the General Ledger by posting offsetting entries. Importing Journal Entries with DataBlend Intacct Data Target Type “JournalEntry” creates and updates records in GLBATCH and GLENTRY objects within Intacct.

Statistical Entries:

DataBlend supports posting to both financial Journal Entries and Statistical Journal Entries. Stat entries will use specific Intacct journals and accounts via the same data target within DataBlend. Stat entries do not need balance in the same way as a financial entry (Debit/Credit).

Recording of the Process:

DataBlend Query Object (SDK)	Sage Intacct Object (API)	Sage Intacct UI Name	Required	Notes
RECORDNO	RECORDNO	Record Number	Yes/Optional	Required for Update
ACTION	STATE	State	Optional	State to create the entry in. `Posted` to post to the GL, otherwise `Draft`. (Default: `Posted`).
ALLOCATIONID	ALLOCATION	Allocation	Optional	Allocation ID. All other dimension elements are ignored if allocation is set. Use `Custom` for custom splits and see `SPLIT` element below.
ATTACHMENTSID	SUPDOCID	Attachment	Optional	Attachments ID. Expected value is free text
BILLABLE	BILLABLE	Billable	Optional	Check box. Billable option for project-related transactions imported into the GL through external systems. Use `true` for billable transactions (Default: `false`).
CLASSID	CLASSID	Class	Optional	Class ID. Expected value is free text (50)
CONTRACTID	CONTRACTID	Contract	Optional	Contract ID. Expected value is free text (50)
COSTTYPEID	COSTTYPEID	Cost type	Optional	Cost type ID. Only available when `PROJECTID` and `TASKID` are specified. (Construction subscription)
CUSTOMERID	CUSTOMERID	Customer	Optional	Customer ID. Expected value is free text (20)
DEPARTMENTID	DEPARTMENT	Department	Optional	Department ID. Expected value is free text (20)
DESCRIPTION	BATCH_TITLE	Description	Yes	Expected value is free text (1000)
DOCUMENTNUMBER	DOCUMENT	Doc	Optional	Document number of entry. Expected value is free text (30)
EMPLOYEEID	EMPLOYEEID	Employee	Optional	Employee ID. Expected value is free text (20)
EXCHANGERATEDATE	EXCH_RATE_DATE	Exchange rate date	Optional	Exchange rate date in format `mm/dd/yyyy`. If null, defaults to `BATCH_DATE`.
EXCHANGERATETYPE	EXCH_RATE_TYPE_ID	Exchange rate type	Optional	Exchange rate type. Required if multi-currency enabled and `EXCHANGE_RATE` left blank. (Default `Intacct Daily Rate`). Expected value is free text (40)
EXCHANGERATEVALUE	EXCHANGE_RATE	Exchange rate	Optional	Required if multi currency enabled and `EXCH_RATE_TYPE_ID` left blank. Exchange rate amount to 4 decimals.
GLACCOUNTNUMBER	ACCOUNTNO	Account	Yes	Account number. Expected value is free text
HISTORYCOMMENT	HISTORY_COMMENT		Optional	Comment added to history for this transaction. Expected value is free text
ITEMID	ITEMID	Item	Optional	Item ID. Expected value is free text (30)
JOURNALSYMBOL	JOURNAL	Journal	Yes	GL journal symbol. This determines the type of journal entry as visible in the UI, for example, Regular, Adjustment, User-defined, Statistical, GAAP, Tax, and so forth.
LOCATIONID	LOCATION	Location	Optional	Location ID. Required if multi-entity enabled. Expected value is free text (20)
MEMO	DESCRIPTION	Memo	Optional	Expected value is free text (1000)
POSTINGDATE	BATCH_DATE	Posting date	Yes	Posting date in format `mm/dd/yyyy`
PROJECTID	PROJECTID	Project	Optional	Project ID. Expected value is free text (20)
REFERENCENUMBER	REFERENCENO	Reference number	Optional	Reference number of transaction. Expected value is free text (40)
REVERSEDATE	REVERSEDATE	Reverse date	Optional	Reverse date in format `mm/dd/yyyy`. Must be greater than `BATCH_DATE`.
SOURCEENTITYID	BASELOCATION_NO	Source entity	Optional	Source entity ID. Required if multi-entity enabled and entries do not balance by entity. Expected value is free text
TARGET_ENTITY			Optional	Target Entity ID. To post to multiple entities.
TASKID	TASKID	Task	Optional	Task ID. Only available when the parent `PROJECTID` is also specified.
TAXIMPLICATIONS	TAXIMPLICATIONS	Tax implications	Optional	Use `None`, `Inbound` for purchase tax, or `Outbound` for sales tax. (Default: `None`) (AU, GB, ZA only).
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. See Tax Solutions for more information. (GB, AU, and ZA only).
TRANSACTIONCURRENCY	CURRENCY	Txn currency	Yes/Optional	Transaction currency code. Required if multi-currency enabled. Expected value is free text (3)
TRANSACTIONSOURCE	TRANSACTIONSOURCE		Optional	The source of the entry. Will be set to `BANK` if the entry is created from a bank transaction. (Default: Null). Expected value is free text
TRANSACTIONAMOUNT	TRX_AMOUNT	Trx amount	Yes	Transaction amount. Positive values will be debits and negative values will be credits. Expected value is decimal
VATCONTACTID	VATCONTACTID	Contact	Optional	Contact name for the customer `SHIPTO` contact for sales journals or the vendor ID for the vendor `PAYTO` contact for purchase journals (AU, GB, ZA only). Expected value is free text
VATCUSTOMERID	VATCUSTOMERID	Customer	Optional	Customer ID when tax implications is set to `Outbound` for tax on sales (AU, GB, ZA only). Expected value is free text
VATVENDORID	VATVENDORID	Vendor	Optional	Vendor ID when tax implications is set to `Inbound` for tax on purchases (AU, GB, ZA only). Expected value is free text
VENDORID	VENDORID	Vendor	Optional	Vendor ID. Expected value is free text (20)
WAREHOUSEID	WAREHOUSEID	Warehouse	Optional	Warehouse ID. Expected value is free text (40)