Sage Intacct Data Target Requirements
      Back to home
      1. Knowledge Base
      2. How-To
      3. Sage Intacct Data Target Requirements

      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)

      TAX_DETAILID

      DETAILID

      Tax Details

      Optional

      		 Tax rate specified via the unique ID of a tax detail (AU, GB, ZA only)

      TAX_TRX_TAX

      TRX_TAX

      Transaction Tax

      Optional

      		 Transaction tax, which is your manually calculated value for the tax. (AU, GB, ZA only). Amount should be provided as absolute value, no matter if credit or debit impact.