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. A journal entry is an owned element of general ledger transaction (GLBATCH).


List Journal Entries

readByQuery

<readByQuery>
    <object>GLBATCH</object>
    <fields>*</fields>
    <query>JOURNAL = 'GJ'</query>
    <pagesize>100</pagesize>
</readByQuery>
<readByQuery>
    <object>GLBATCH</object>
    <fields>*</fields>
    <query>JOURNAL = 'GJ' AND STATE = 'S'</query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use GLBATCH
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
STATE Optional string State of the journal entry. Use I for Draft, S for Submitted, X for Partially Approved, A for Approved, P for Posted, R for Declined, L for Reversal Pending, or Z for Reversed.

Get Journal Entry

read

<read>
    <object>GLBATCH</object>
    <keys>31</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use GLBATCH
keys Required string The journal entry RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Create Journal Entry

create

Create a journal entry with a reversal

<create>
    <GLBATCH>
        <JOURNAL>PYRJ</JOURNAL>
        <BATCH_DATE>03/31/2016</BATCH_DATE>
        <REVERSEDATE>04/01/2016</REVERSEDATE>
        <BATCH_TITLE>Payroll accrual 03/31/2016</BATCH_TITLE>
        <ENTRIES>
            <GLENTRY>
                <ACCOUNTNO>2080</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>-1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Accrued salaries</DESCRIPTION>
            </GLENTRY>
            <GLENTRY>
                <ACCOUNTNO>6500</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Salary expense</DESCRIPTION>
            </GLENTRY>
        </ENTRIES>
    </GLBATCH>
</create>

Create a journal entry with a custom allocation

<create>
    <GLBATCH>
        <JOURNAL>PYRJ</JOURNAL>
        <BATCH_DATE>03/31/2016</BATCH_DATE>
        <REVERSEDATE>04/01/2016</REVERSEDATE>
        <BATCH_TITLE>Payroll accrual 03/31/2016</BATCH_TITLE>
        <ENTRIES>
            <GLENTRY>
                <ACCOUNTNO>2080</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>-1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Accrued salaries</DESCRIPTION>
            </GLENTRY>
            <GLENTRY>
                <ACCOUNTNO>6500</ACCOUNTNO>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Salary expense</DESCRIPTION>
                <ALLOCATION>Custom</ALLOCATION>
                <SPLIT>
                    <AMOUNT>450.80</AMOUNT>
                    <LOCATIONID>100</LOCATIONID>
                    <DEPARTMENTID>ADMIN</DEPARTMENTID>
                </SPLIT>
                <SPLIT>
                    <AMOUNT>700.00</AMOUNT>
                    <LOCATIONID>100</LOCATIONID>
                    <DEPARTMENTID>SUPPORT</DEPARTMENTID>
                </SPLIT>
                <SPLIT>
                    <AMOUNT>300.00</AMOUNT>
                    <LOCATIONID>100</LOCATIONID>
                    <DEPARTMENTID>SALES</DEPARTMENTID>
                </SPLIT>
            </GLENTRY>
        </ENTRIES>
    </GLBATCH>
</create>

Parameters

Name Required Type Description
GLBATCH Optional object The object to create

GLBATCH

Name Required Type Description
JOURNAL Required string GL journal symbol
BATCH_DATE Required string Posting date in format mm/dd/yyyy.
REVERSEDATE Optional string Reverse date in format mm/dd/yyyy. Must be greater than BATCH_DATE.
BATCH_TITLE Required string Description of entry.
HISTORY_COMMENT Optional string Comment added to history for this transaction.
REFERENCENO Optional string Reference number of transaction
BASELOCATION_NO Optional string Source entity ID. Required if multi-entity enabled and entries do not balance by entity.
SUPDOCID Optional string Attachments ID.
STATE Optional string State to create the entry in. Posted to post to the GL, otherwise Draft (Default: Posted)
ENTRIES Required array[GLENTRY] Must have at least two lines (one debit, one credit).
Custom fields Optional varies This object supports custom fields.

GLENTRY

Name Required Type Description
DOCUMENT Optional string Document number of entry
ACCOUNTNO Required string Account number
CURRENCY Optional string Transaction currency code. Required if multi-currency enabled.
TRX_AMOUNT Required currency Transaction amount. Absolute value, relates to TR_TYPE.
TR_TYPE Required string Transaction type. 1 for Debit, otherwise -1 for Credit.
EXCH_RATE_DATE Optional string Exchange rate date in format mm/dd/yyyy. If null, defaults to BATCH_DATE
EXCH_RATE_TYPE_ID Optional string Exchange rate type. Required if multi-currency enabled and EXCHANGE_RATE left blank. (Default Intacct Daily Rate)
EXCHANGE_RATE Optional currency Exchange rate. Required if multi currency enabled and EXCH_RATE_TYPE_ID left blank. Exchange rate amount to 4 decimals
DESCRIPTION Optional string Memo. If left blank, set this value to match BATCH_TITLE.
ALLOCATION Optional string Allocation ID. All other dimension elements are ignored if allocation is set. Use Custom for custom splits and see SPLIT element below.
DEPARTMENT Optional string Department ID
LOCATION Optional string Location ID. Required if multi-entity enabled.
PROJECTID Optional string Project ID
CUSTOMERID Optional string Customer ID
VENDORID Optional string Vendor ID
EMPLOYEEID Optional string Employee ID
ITEMID Optional string Item ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID
SPLIT Optional SPLIT[] Custom allocation split. Required if ALLOCATION equals Custom. Multiple SPLIT elements may then be passed.
Custom fields Optional varies This object supports custom fields.

SPLIT

Name Required Type Description
AMOUNT Required currency Split transaction amount. Absolute value. All SPLIT element’s AMOUNT values must sum up to equal GLENTRY element’s TRX_AMOUNT
DEPARTMENTID Optional string Department ID
LOCATIONID Optional string Location ID. Required if multi-entity enabled.
PROJECTID Optional string Project ID
CUSTOMERID Optional string Customer ID
VENDORID Optional string Vendor ID
EMPLOYEEID Optional string Employee ID
ITEMID Optional string Item ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID

Update Journal Entry

update

<update>
    <GLBATCH>
        <RECORDNO>1</RECORDNO>
        <JOURNAL>PYRJ</JOURNAL>
        <BATCH_DATE>03/31/2016</BATCH_DATE>
        <REVERSEDATE>04/01/2016</REVERSEDATE>
        <BATCH_TITLE>Payroll accrual 03/31/2016</BATCH_TITLE>
        <ENTRIES>
            <GLENTRY>
                <ACCOUNTNO>2080</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>-1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Accrued salaries</DESCRIPTION>
            </GLENTRY>
            <GLENTRY>
                <ACCOUNTNO>6500</ACCOUNTNO>
                <DEPARTMENT>ADMIN</DEPARTMENT>
                <LOCATION>100</LOCATION>
                <CURRENCY>USD</CURRENCY>
                <TR_TYPE>1</TR_TYPE>
                <AMOUNT>1450.80</AMOUNT>
                <EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID>
                <DESCRIPTION>Salary expense</DESCRIPTION>
            </GLENTRY>
        </ENTRIES>
    </GLBATCH>
</update>

Parameters

Name Required Type Description
GLBATCH Optional object The object to update

GLBATCH

Name Required Type Description
RECORDNO Required integer Record number of the journal entry
BATCH_DATE Required string Posting date in format mm/dd/yyyy.
BATCH_TITLE Required string Description of entry.
HISTORY_COMMENT Optional string Comment added to history for this transaction.
REFERENCENO Optional string Reference number of transaction
BASELOCATION_NO Optional string Source entity ID. Required if multi-entity enabled and entries do not balance by entity.
SUPDOCID Optional string Attachments ID
STATE Optional string State to update the entry to. Posted to post to the GL, otherwise Draft.
ENTRIES Required array[GLENTRY] Must have at least two lines (one debit, one credit)
Custom fields Optional varies This object supports custom fields.

GLENTRY

Name Required Type Description
DOCUMENT Optional string Document number of entry
ACCOUNTNO Required string Account number
CURRENCY Optional string Transaction currency code. Required if multi-currency enabled.
TRX_AMOUNT Required currency Transaction amount. Absolute value, relates to TR_TYPE.
TR_TYPE Required string Transaction type. 1 for Debit, otherwise -1 for Credit.
EXCH_RATE_DATE Optional string Exchange rate date in format mm/dd/yyyy. If null, defaults to BATCH_DATE
EXCH_RATE_TYPE_ID Optional string Exchange rate type. Required if multi-currency enabled and EXCHANGE_RATE left blank. (Default Intacct Daily Rate)
EXCHANGE_RATE Optional currency Exchange rate. Required if multi currency enabled and EXCH_RATE_TYPE_ID left blank. Exchange rate amount to 4 decimals
DESCRIPTION Optional string Memo. If left blank, set this value to match BATCH_TITLE.
ALLOCATION Optional string Allocation ID. All other dimension elements are ignored if allocation is set. Use Custom for custom splits and see SPLIT element below.
DEPARTMENT Optional string Department ID
LOCATION Optional string Location ID. Required if multi-entity enabled.
PROJECTID Optional string Project ID
CUSTOMERID Optional string Customer ID
VENDORID Optional string Vendor ID
EMPLOYEEID Optional string Employee ID
ITEMID Optional string Item ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID
SPLIT Optional SPLIT[] Custom allocation split. Required if ALLOCATION equals Custom. Multiple SPLIT elements may then be passed.
Custom fields Optional varies This object supports custom fields.

SPLIT

Name Required Type Description
AMOUNT Required currency Split transaction amount. Absolute value. All SPLIT element’s AMOUNT values must sum up to equal GLENTRY element’s TRX_AMOUNT
DEPARTMENTID Optional string Department ID
LOCATIONID Optional string Location ID. Required if multi-entity enabled.
PROJECTID Optional string Project ID
CUSTOMERID Optional string Customer ID
VENDORID Optional string Vendor ID
EMPLOYEEID Optional string Employee ID
ITEMID Optional string Item ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID

Delete Journal Entry

delete

<delete>
    <object>GLBATCH</object>
    <keys>1</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use GLBATCH
keys Required string The journal entry RECORDNO to delete

List Journal Entry Lines

readByQuery

<readByQuery>
    <object>GLENTRY</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use GLENTRY
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100)

Get Journal Entry Line

read

<read>
    <object>GLENTRY</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use GLENTRY
keys Required string The journal entry line RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Provide feedback