List Account Balances

Account balances include a starting balance, for period/net change amounts, ending balance, and adjustments together with all book and dimension combinations.

readByQuery

List account balances for the given period

<readByQuery>
    <object>GLACCOUNTBALANCE</object>
    <fields>*</fields>
    <query>PERIOD = 'Month Ended June 2016'</query>
    <pagesize>100</pagesize>
</readByQuery>

List account balances for the given period, excluding entries with the specified zero balances

<readByQuery>
    <object>GLACCOUNTBALANCE</object>
    <fields>*</fields>
    <query>PERIOD = 'Month Ended May 2017' AND NOT (TOTDEBIT = 0 AND TOTCREDIT = 0 AND TOTADJDEBIT = 0 AND TOTADJCREDIT = 0 AND FORBAL = 0 AND ENDBAL = 0)</query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use GLACCOUNTBALANCE
fields Required string Comma separated list of fields on the account balance to list. Use * to return all fields.
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'. Must provide PERIOD as a parameter.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
PERIOD Required string Budgetable reporting period name. These are the reporting periods shown on the Reporting Periods list with the budgetable flag set to true. System periods (Today, Current Month, Current Year to Date, etc) and non-budgetable reporting periods are not supported.
BOOKID Optional string Reporting book ID. System standard book ID’s include ACCRUAL, CASH, GAAPADJACCRUAL, GAAPADJCASH, TAXADJACCRUAL, TAXADJCASH, GAAPACCRUAL, GAAPCASH, TAXACCRUAL, TAXCASH, GAAPTAXACCRUAL, and GAAPTAXCASH. Keep in mind, these are dependent on the Intacct company/GL configuration. In addition to these, an Intacct company may also have User Defined Books and/or Consolidation books. In the case of User Defined Books, the system appends ACCRUAL and CASH to the end of the User Defined Book ID to come up with the appropriate Book ID for GL Account Balances. For example, a UDB setup with the ID of TEST would have balances using the book ID’s TESTACCRUAL and TESTCASH.
CURRENCY Optional string Currency code. If the company is multi-currency and the request is run at the top level, your list will contain all currencies and not just the base. You should run the request privately in an entity or provide a currency filter with the base currency and whatever entity/location hierarchy needed.
OPENBAL Optional currency Opening account balance
TOTDEBIT Optional currency Total debits
TOTCREDIT Optional currency Total credits
TOTADJDEBIT Optional currency Total adjusting debits
TOTADJCREDIT Optional currency Total adjusting credits
FORBAL Optional currency For period account balance (debits - credits)
ENDBAL Optional currency Ending account account balance (opening + debits - credits)
WHENCREATED Optional string When the account balance was created in mm/dd/yyyy hh:mm:ss format
WHENMODIFIED Optional string When the account balance was last modified in mm/dd/yyyy hh:mm:ss format
CREATEDBY Optional integer User record number that created the account balance
MODIFIEDBY Optional integer User record number that last modified the account balance
ACCOUNTREC Optional integer Account record number
ACCOUNTNO Optional string Account number
ACCOUNTTITLE Optional string Account title
DEPARTMENTDIMKEY Optional integer Department record number
DEPARTMENTID Optional string Department ID
DEPARTMENTTITLE Optional string Department title
LOCATIONDIMKEY Optional integer Location record number
LOCATIONID Optional string Location ID
LOCATIONNAME Optional string Location name
PROJECTDIMKEY Optional integer Project record number
PROJECTID Optional string Project ID
PROJECTNAME Optional string Project name
CUSTOMERDIMKEY Optional integer Customer record number
CUSTOMERID Optional string Customer ID
CUSTOMERNAME Optional string Customer name
VENDORDIMKEY Optional integer Vendor record number
VENDORID Optional string Vendor ID
VENDORNAME Optional string Vendor name
EMPLOYEEDIMKEY Optional integer Employee record number
EMPLOYEEID Optional string Employee ID
EMPLOYEENAME Optional string Employee name
ITEMDIMKEY Optional integer Item record number
ITEMID Optional string Item ID
ITEMNAME Optional string Item name
WAREHOUSEDIMKEY Optional integer Warehouse record number
WAREHOUSEID Optional string Warehouse ID
WAREHOUSENAME Optional string Warehouse name
CLASSDIMKEY Optional integer Class record number
CLASSID Optional string Class ID
CLASSNAME Optional string Class name
CONTRACTDIMKEY Optional integer Contract record number
CONTRACTID Optional string Contract ID
CONTRACTNAME Optional string Contract name
GLDIM* Optional integer User defined dimension id field. UDD object integration name usually appended to GLDIM

Tips

If you only need to list the changes to account balances, you can use something like WHENMODIFIED &gt;= '04/19/2017 12:00:00' as part of your query.

Consider excluding fields you don’t need in order to avoid the underlying table joins in the Intacct system. For example, query for DEPARTMENTDIMKEY instead of DEPARTMENTID and DEPARTMENTNAME. Then query DEPARTMENTID and DEPARTMENTNAME separately and join them in your system with the DEPARTMENTDIMKEY.


Get Account Balance

read

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

Parameters

Name Required Type Description
object Required string Use GLACCOUNTBALANCE
keys Required string The balance RECORDNO to get
fields Required string Comma separated list of fields on the account group to get. Use * to return all fields.

List Account Balances (Legacy)

get_accountbalances

List an account of balances for a reporting period

<get_accountbalances>
    <reportingperiodname>Calendar Year Ended December 2016</reportingperiodname>
    <glaccountno>4000</glaccountno>
    <locationid></locationid>
    <departmentid></departmentid>
    <showzerobalances>false</showzerobalances>
</get_accountbalances>

List an account group of balances for a date range

<get_accountbalances>
    <startdate>
        <year>2016</year>
        <month>01</month>
        <day>01</day>
    </startdate>
    <enddate>
        <year>2016</year>
        <month>01</month>
        <day>31</day>
    </enddate>
    <accountgroupname>Total Revenue</accountgroupname>
    <locationid></locationid>
    <departmentid></departmentid>
    <showzerobalances>false</showzerobalances>
</get_accountbalances>

List an account range of balances for a date range

<get_accountbalances>
    <startdate>
        <year>2016</year>
        <month>01</month>
        <day>01</day>
    </startdate>
    <enddate>
        <year>2016</year>
        <month>01</month>
        <day>31</day>
    </enddate>
    <startaccountno>4000</startaccountno>
    <endaccountno>4999</endaccountno>
    <locationid></locationid>
    <departmentid></departmentid>
    <showzerobalances>false</showzerobalances>
</get_accountbalances>

Parameters

Name Required Type Description
reportingperiodname Optional string Reporting period name. Required if not using startdate and enddate.
startdate Optional object Start date. Required if not using reportingperiodname.
enddate Optional object End date. Required if not using reportingperiodname.
glaccountno Optional string GL account number. Required if not using accountgroupname or startaccountno and endaccountno.
accountgroupname Optional string Account group name. Required if not using glaccountno or startaccountno and endaccountno.
startaccountno Optional string Starting GL account number. Required if not using glaccountno or accountgroupname.
endaccountno Optional string Ending GL account number. Required if not using glaccountno or accountgroupname.
locationid Optional string Location ID
departmentid Optional string Department ID
showzerobalances Optional boolean Return zero balances. Use true or false. (Default: false)

Provide feedback