AP Account Labels

AP account labels provide more meaningful names for accounts and are useful for restricting account access. This functionality must be enabled by configuring AP in the Sage Intacct system.

List AP Account Labels

readByQuery

<readByQuery>
    <object>APACCOUNTLABEL</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>
<readByQuery>
    <object>APACCOUNTLABEL</object>
    <fields>*</fields>
    <query>STATUS = 'T'</query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use APACCOUNTLABEL
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
STATUS Optional string Status. Use T for Active and F for Inactive.

Get AP Account Label

read

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

Parameters

Name Required Type Description
object Required string Use APACCOUNTLABEL
keys Required string The label 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.

Get AP Account Label by Name

readByName

<readByName>
    <object>APACCOUNTLABEL</object>
    <keys>Travel Expenses</keys>
    <fields>*</fields>
</readByName>

Parameters

Name Required Type Description
object Required string Use APACCOUNTLABEL
keys Required string The label ACCOUNTLABEL 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 AP Account Label

create

<create>
    <APACCOUNTLABEL>
        <ACCOUNTLABEL>Travel Expenses</ACCOUNTLABEL>
        <DESCRIPTION>Travel Expenses</DESCRIPTION>
        <GLACCOUNTNO>6080</GLACCOUNTNO>
        <OFFSETGLACCOUNTNO></OFFSETGLACCOUNTNO>
        <STATUS>active</STATUS>
    </APACCOUNTLABEL>
</create>

Parameters

Name Required Type Description
APACCOUNTLABEL Optional object The object to create

APACCOUNTLABEL

Name Required Type Description
ACCOUNTLABEL Required string The account label to create
DESCRIPTION Required string Description
GLACCOUNTNO Required string Account number
OFFSETGLACCOUNTNO Optional string Offset AP account number
STATUS Optional string Status. Use active for Active otherwise use inactive for Inactive (Default: active)

Update AP Account Label

update

<update>
    <APACCOUNTLABEL>
        <RECORDNO>12</RECORDNO>
        <DESCRIPTION>Travel Expenses</DESCRIPTION>
        <GLACCOUNTNO>6080</GLACCOUNTNO>
        <OFFSETGLACCOUNTNO></OFFSETGLACCOUNTNO>
        <STATUS>active</STATUS>
    </APACCOUNTLABEL>
</update>

Parameters

Name Required Type Description
APACCOUNTLABEL Optional object The object to update

APACCOUNTLABEL

Name Required Type Description
RECORDNO Required integer Record number of account label
DESCRIPTION Optional string Description
GLACCOUNTNO Optional string Account number
OFFSETGLACCOUNTNO Optional string Offset AP account number
STATUS Optional string Status. Use active for Active otherwise use inactive for Inactive (Default: active)

Delete AP Account Label

delete

<delete>
    <object>APACCOUNTLABEL</object>
    <keys>112</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use APACCOUNTLABEL
keys Required string The label RECORDNO to delete

Provide feedback