NEW!

Account allocations let you automatically distribute amounts across multiple dimensions such as departments, locations, projects, or classes. For example, you can create an allocation that distributes expenses across revenue-earning departments, then run the allocation for the dates you want.

Note that intra-entity (not inter-entity) revenue and expense allocations are supported at this time.

Your company must have a subscription for Dynamic Allocations, and you need the appropriate permissions for account allocations. Usage information for account allocations is available in the Sage Intacct product help.

Transaction Allocations also let you distribute transaction amounts across multiple dimensions—such as departments, locations, projects, or classes. However, a transaction allocation is intended for use on single line item as a one-time action.


List Account Allocation Definitions

readByQuery

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

Parameters

Name Required Type Description
object Required string Use GLACCTALLOCATION
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 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.
ACTIVITYDELTA Optional string Activity delta. Use T for Activity Delta selected or F for not selected.

Get Account Allocation Definition

read

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

Parameters

Name Required Type Description
object Required string Use GLACCTALLOCATION
keys Required string Account allocation definition 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 Account Allocation Definition

create

Distributes expenses for the month to the departments that generate revenue:

<create>
    <GLACCTALLOCATION>
        <ACCTALLOCATIONID>Monthly expenses</ACCTALLOCATIONID>
        <DESCRIPTION>Monthly allocation of expenses</DESCRIPTION>
        <METHODOLOGY>Expense allocation across revenue earning departments</METHODOLOGY>
        <FOCUSLOCATION>Preserve values</FOCUSLOCATION>
        <FOCUSDEPARTMENT>Allocation focus</FOCUSDEPARTMENT>
        <FOCUSPROJECT>Preserve values</FOCUSPROJECT>
        <GLACCTALLOCATIONSOURCE>
            <GLACCTGRP>Expenses</GLACCTGRP>
            <PERCENT2ALLOCATE>100</PERCENT2ALLOCATE>
            <REPORTINGBOOK>ACCRUAL</REPORTINGBOOK>
            <GLACCTALLOCATIONSOURCEADJBOOKS>
                <GLACCTALLOCATIONSOURCEADJBOOK>
                    <ADJBOOKID>GAAPADJ</ADJBOOKID>
                </GLACCTALLOCATIONSOURCEADJBOOK>
                <GLACCTALLOCATIONSOURCEADJBOOK>
                    <ADJBOOKID>TAXADJ</ADJBOOKID>
                </GLACCTALLOCATIONSOURCEADJBOOK>
            </GLACCTALLOCATIONSOURCEADJBOOKS>
            <SOURCEINCLUDEREPORTINGBOOK>Main reporting book and alternate books</SOURCEINCLUDEREPORTINGBOOK>
            <TIMEPERIOD>Current Month</TIMEPERIOD>
            <LOCNO>1st Level Locations--Level 1 Locations</LOCNO>
        </GLACCTALLOCATIONSOURCE>
        <GLACCTALLOCATIONBASIS>
            <GLACCTGRP>Revenues</GLACCTGRP>
            <ACCUMULATION>Activity</ACCUMULATION>
            <ALLOCATIONMETHOD>Dynamic-relative account financial</ALLOCATIONMETHOD>
            <TIMEPERIOD>Current Month</TIMEPERIOD>
            <REPORTINGBOOK>ACCRUAL</REPORTINGBOOK>
            <SKIPNEGATIVE>false</SKIPNEGATIVE>
            <LOCNO>1st Level Locations--Level 1 Locations</LOCNO>
        </GLACCTALLOCATIONBASIS>
        <GLACCTALLOCATIONTARGET>
            <REPORTINGBOOK>ACCRUAL</REPORTINGBOOK>
            <JOURNALSYMBOL>Travel</JOURNALSYMBOL>
            <GLACCOUNTNO>8000</GLACCOUNTNO>
        </GLACCTALLOCATIONTARGET>
        <GLACCTALLOCATIONREVERSE>
            <USESOURCEACCOUNT>true</USESOURCEACCOUNT>
        </GLACCTALLOCATIONREVERSE>
    </GLACCTALLOCATION>
</create>

Parameters

Name Required Type Description
GLACCTALLOCATION Required object Object to create

Provides basic information for the allocation and specifies how dimensions are to be handled in the allocation calculations.

GLACCTALLOCATION

Name Required Type Description
ACCTALLOCATIONID Required string Allocation ID. Must be 20 character or fewer.
DESCRIPTION Required string Description of the allocation definition
STATUS Optional boolean Status of the allocation definition. Use active or inactive. (Default: active)
METHODOLOGY Optional string Description of methodology used for the allocation definition
ACTIVITYDELTA Optional string Activity Delta. Use true to specify that source balances should be cleared with each allocation run so that only new activity is used on the next run. This option is only available if the source account is used for the pool reversal in the allocation target&either via GLACCOUNTNO or USESOURCEACCOUNT. (Default: false)
FOCUSLOCATION Optional string Dimensions treatment for Location. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSVENDOR Optional string Dimensions treatment for Vendor. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSPROJECT Optional string Dimensions treatment for Project. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSDEPARTMENT Optional string Dimensions treatment for Department. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSCUSTOMER Optional string Dimensions treatment for Customer. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSITEM Optional string Dimensions treatment for Item. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSCLASS Optional string Dimensions treatment for Class. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSEMPLOYEE Optional string Dimensions treatment for Employee. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSWAREHOUSE Optional string Dimensions treatment for Warehouse. Specifies how the dimension is used in the allocation calculation. Currently, only Not considered is allowed.
FOCUSCONTRACT Optional string Dimensions treatment for Contract. Specifies how the dimension is used in the allocation calculation. Currently, only Not considered is allowed.
GLACCTALLOCATIONSOURCE Required object Source pool for the allocation
GLACCTALLOCATIONBASIS Required object Basis information that specifies how the allocation splits source amounts into each target
GLACCTALLOCATIONTARGET Required object Allocation destination in the target entry. Specifies where the allocation will be recorded. The debit and credit accounts selected depend on your allocation setup. For example, expense allocations typically have the allocation as a debit.
GLACCTALLOCATIONREVERSE Required object Reversing source pool in the target entry

GLACCTALLOCATIONSOURCE

If choosing dimensions for filtering from the source pool, remember your choices for dimension treatment. For example, if you specified that the Vendor dimension should not be considered, choosing a Vendor ID for the source does not impact the allocation calculations.

GLACCTGRP Required string Account group for the source of the allocation. To use a single account, provide an account group with one account.
PERCENT2ALLOCATE Required string Percentage to allocate.
REPORTINGBOOK Required string Reporting Book. Accounting method to use. Use ACCRUAL or CASH.
GLACCTALLOCATIONSOURCEADJBOOKS Optional GLACCTALLOCATIONSOURCEADJBOOK[] Alternate Book selections
SOURCEINCLUDEREPORTINGBOOK Optional string Use entries from. Use Main reporting book and alternate books or Alternate books only. (Default: Main reporting book and alternate books)
TIMEPERIOD Required string Source pool time period. Use Current Month, Prior Month, Current Quarter, Prior Quarter, Current Year, Current Year To Date, Prior Year, Prior Year Current Month, Prior Year Current Quarter, Fiscal - Current Quarter, Fiscal - Prior Quarter, Fiscal - Current Year, Fiscal - Current Year To Date, Fiscal - Prior Year, or Inception to Date (applies only for Project dimension allocation focus).
LOCNO Optional string Entity/Location for dimension filtering from the source pool
VENDORID Optional string Vendor for dimension filtering from the source pool
PROJECTID Optional string Project for dimension filtering from the source pool
DEPTNO Optional string Department for dimension filtering from the source pool
CUSTOMERID Optional string Customer for dimension filtering from the source pool
WAREHOUSE Optional string Warehouse for dimension filtering from the source pool.
CONTRACTID Optional string Contract for dimension filtering from the source pool
ITEMID Optional string Item for dimension filtering from the source pool
CLASSID Optional string Class for dimension filtering from the source pool
EMPLOYEEID Optional string Employee for dimension filtering from the source pool

GLACCTALLOCATIONSOURCEADJBOOK

Name Required Type Description
ADJBOOKID Optional string Book ID for the adjustment book. Use GAAPADJ, TAXADJ, or a user-defined book.

GLACCTALLOCATIONBASIS

If choosing dimensions for filtering for the basis, remember your choices for dimension treatment. For example, if you specified that the Vendor dimension should not be considered, choosing a Vendor ID for the basis does not impact the allocation calculations.

ALLOCATIONMETHOD Required string Allocation method. Use Dynamic-relative account financial or Dynamic-relative account statistical
GLACCTGRP Required string Account group for the basis of the allocation. To use a single account, provide an account group with one account.
ACCUMLUATION Required string Accumulation. Use Activity.
REPORTINGBOOK Required string Reporting Book. Set this to ACCRUAL.
GLACCTALLOCATIONBASISADJBOOKS Optional GLACCTALLOCATIONBASISADJBOOK[] Alternate Book selections.
BASISINCLUDEREPORTINGBOOK Optional string Use entries from. Use Main reporting book and alternate books or Alternate books only. (Default: Main reporting book and alternate books)
TIMEPERIOD Required string Basis time period. You can use the same time period as the source pool, or you can select a different time period for your basis. Use Current Month, Prior Month, Current Quarter, Prior Quarter, Current Year, Current Year To Date, Prior Year, Prior Year Current Month, Prior Year Current Quarter, Fiscal - Current Quarter, Fiscal - Prior Quarter, Fiscal - Current Year, Fiscal - Current Year To Date, Fiscal - Prior Year, or Inception to Date (applies only for Project dimension allocation focus).
SKIPNEGATIVE Optional boolean Drop negative basis lines from consideration. Use true to drop negative lines. (Default: false)
LOCNO Optional string Entity/Location for dimension filtering to narrow the scope for the basis methodology
VENDORID Optional string Vendor for dimension filtering to narrow the scope for the basis methodology
PROJECTID Optional string Project for dimension filtering to narrow the scope for the basis methodology
DEPTNO Optional string Department for dimension filtering to narrow the scope for the basis methodology
CUSTOMERID Optional string Customer for dimension filtering to narrow the scope for the basis methodology
WAREHOUSEID Optional string Warehouse for dimension filtering to narrow the scope for the basis methodology
CONTRACTID Optional string Contract for dimension filtering to narrow the scope for the basis methodology
ITEMID Optional string Item for dimension filtering to narrow the scope for the basis methodology
CLASSID Optional string Class for dimension filtering to narrow the scope for the basis methodology
EMPLOYEEID Optional string Employee for dimension filtering to narrow the scope for the basis methodology

GLACCTALLOCATIONBASISADJBOOK

Name Required Type Description
ADJBOOKID Optional string Book ID for the adjustment book. Use GAAPADJ, TAXADJ, or a user-defined book.

GLACCTALLOCATIONTARGET

When choosing dimensions for filtering to the target, you can override dimension treatments. For example, if you specified that the Vendor dimension should not be considered, you can use the vendor override parameter to provide a vendor to be used in the allocation for the target.

GLACCOUNTNO Required string Account that is the target destination of the allocation.
JOURNALSYBMOL Required string Journal for the allocation journal entries
OVERRIDELOCATION Optional string Dimension override for Entity/Location. Applies only if the dimension treatment for Location is set to Not considered.
OVERRIDEVENDOR Optional string Dimension override for Vendor. Applies only if the dimension treatment for Vendor is set to Not considered.
OVERRIDEPROJECT Optional string Dimension override for Project. Applies only if the dimension treatment for Project is set to Not considered.
OVERRIDEDEPARTMENT Optional string Dimension override for Department. Applies only if the dimension treatment for Department is set to Not considered.
OVERRIDECUSTOMER Optional string Dimension override for Customer. Applies only if the dimension treatment for Customer is set to Not considered.
OVERRIDEWAREHOUSE Optional string Dimension override for Warehouse. Applies only if the dimension treatment for Warehouse is set to Not considered.
OVERRIDECONTRACT Optional string Dimension override for Contract. Applies only if the dimension treatment for Contract is set to Not considered.
OVERRIDEITEM Optional string Dimension override for Item. Applies only if the dimension treatment for Item is set to Not considered.
OVERRIDECLASS Optional string Dimension override for Class. Applies only if the dimension treatment for Class is set to Not considered.
OVERRIDEEMPLOYEE Optional string Dimension override for Employee. Applies only if the dimension treatment for Employee is set to Not considered.

GLACCTALLOCATIONREVERSE

GLACCOUNTNO Optional string Account to use for the reversal pool for the account allocation. Required if not using the source account.
USESOURCEACCOUNT Optional boolean Use the source account for the reversal pool for the account allocation. Required if not providing an account.
OVERRIDELOCATION Optional string Dimension override for Entity/Location.
OVERRIDEVENDOR Optional string Dimension override for Vendor.
OVERRIDEPROJECT Optional string Dimension override for Project.
OVERRIDEDEPARTMENT Optional string Dimension override for Department.
OVERRIDECUSTOMER Optional string Dimension override for Customer.
OVERRIDEWAREHOUSE Optional string Dimension override for Warehouse.
OVERRIDECONTRACT Optional string Dimension override for Contract.
OVERRIDEITEM Optional string Dimension override for Item.
OVERRIDECLASS Optional string Dimension override for Class.
OVERRIDEEMPLOYEE Optional string Dimension override for Employee.

Update Account Allocation Definition

update

Change the account allocation such that negative basis lines are excluded:

<update>
    <GLACCTALLOCATION>
        <RECORDNO>46</RECORDNO>
        <GLACCTALLOCATIONBASIS>
            <SKIPNEGATIVE>true</SKIPNEGATIVE>
        </GLACCTALLOCATIONBASIS>
    </GLACCTALLOCATION>
</update>

Parameters

Name Required Type Description
GLACCTALLOCATION Required object Object to update

Provides basic information for the allocation and specifies how dimensions are to be handled in the allocation calculations.

GLACCTALLOCATION

Name Required Type Description
RECORDNO Required integer Record number of account allocation to update.
DESCRIPTION Optional string Description of the allocation definition
STATUS Optional boolean Status of the allocation definition. Use active or inactive. (Default: active)
METHODOLOGY Optional string Description of methodology used for the allocation definition
ACTIVITYDELTA Optional string Activity Delta. Use true to specify that source balances should be cleared with each allocation run so that only new activity is used on the next run. This option is only available if the source account is used for the pool reversal in the allocation target&either via GLACCOUNTNO or USESOURCEACCOUNT. (Default: false)
FOCUSLOCATION Optional string Dimensions treatment for Location. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSVENDOR Optional string Dimensions treatment for Vendor. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSPROJECT Optional string Dimensions treatment for Project. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSDEPARTMENT Optional string Dimensions treatment for Department. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSCUSTOMER Optional string Dimensions treatment for Customer. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSITEM Optional string Dimensions treatment for Item. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSCLASS Optional string Dimensions treatment for Class. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSEMPLOYEE Optional string Dimensions treatment for Employee. Specifies how the dimension is used in the allocation calculation. Use Allocation focus to allocate the dimension, Preserve values to retain the values for the dimension, or Not considered to exclude the dimension from the calculation. Dimensions set to Not considered can have a value applied using the override parameters in the allocation target. (Default: Not considered)
FOCUSWAREHOUSE Optional string Dimensions treatment for Warehouse. Specifies how the dimension is used in the allocation calculation. Currently, only Not considered is allowed.
FOCUSCONTRACT Optional string Dimensions treatment for Contract. Specifies how the dimension is used in the allocation calculation. Currently, only Not considered is allowed.
GLACCTALLOCATIONSOURCE Required object Source pool for the allocation
GLACCTALLOCATIONBASIS Required object Basis information that specifies how the allocation splits source amounts into each target
GLACCTALLOCATIONTARGET Required object Target entry that specifies where the allocation will be recorded. The debit and credit accounts selected depend on your allocation setup. For example, expense allocations typically have the allocation as a debit.
GLACCTALLOCATIONREVERSE Required object Reversing source pool

GLACCTALLOCATIONSOURCE

If choosing dimensions for filtering from the source pool, remember your choices for dimension treatment. For example, if you specified that the Vendor dimension should not be considered, choosing a Vendor ID for the source does not impact the allocation calculations.

GLACCTGRP Optional string Account group for the source of the allocation. To use a single account, provide an account group with one account.
PERCENT2ALLOCATE Optional string Percentage to allocate.
REPORTINGBOOK Optional string Reporting Book. Set this to ACCRUAL.
GLACCTALLOCATIONSOURCEADJBOOKS Optional GLACCTALLOCATIONSOURCEADJBOOK[] Alternate Book selections.
SOURCEINCLUDEREPORTINGBOOK Optional string Use entries from. Use Main reporting book and alternate books or Alternate books only. (Default: Main reporting book and alternate books)
TIMEPERIOD Optional string Source pool time period. Use Current Month, Prior Month, Current Quarter, Prior Quarter, Current Year, Current Year To Date, Prior Year, Prior Year Current Month, Prior Year Current Quarter, Fiscal - Current Quarter, Fiscal - Prior Quarter, Fiscal - Current Year, Fiscal - Current Year To Date, Fiscal - Prior Year, or Inception to Date (applies only for Project dimension allocation focus).
LOCNO Optional string Entity/Location for dimension filtering from the source pool
VENDORID Optional string Vendor for dimension filtering from the source pool
PROJECTID Optional string Project for dimension filtering from the source pool
DEPTNO Optional string Department for dimension filtering from the source pool
CUSTOMERID Optional string Customer for dimension filtering from the source pool
WAREHOUSE Optional string Warehouse for dimension filtering from the source pool
CONTRACTID Optional string Contract for dimension filtering from the source pool
ITEMID Optional string Item for dimension filtering from the source pool
CLASSID Optional string Class for dimension filtering from the source pool
EMPLOYEEID Optional string Employee for dimension filtering from the source pool

GLACCTALLOCATIONSOURCEADJBOOK

Name Required Type Description
ADJBOOKID Optional string Book ID for the adjustment book. Use GAAPADJ, TAXADJ, or a user-defined book.

GLACCTALLOCATIONBASIS

If choosing dimensions for filtering for the basis, remember your choices for dimension treatment. For example, if you specified that the Vendor dimension should not be considered, choosing a Vendor ID for the basis does not impact the allocation calculations.

ALLOCATIONMETHOD Optional string Allocation method. Use Dynamic-relative account financial or Dynamic-relative account statistical
GLACCTGRP Optional string Account group for the basis of the allocation. To use a single account, provide an account group with one account.
ACCUMLUATION Optional string Accumulation. Use Activity.
REPORTINGBOOK Optional string Reporting Book. Set this to ACCRUAL.
GLACCTALLOCATIONBASISADJBOOKS Optional GLACCTALLOCATIONBASISADJBOOK[] Alternate Book selections.
BASISINCLUDEREPORTINGBOOK Optional string Use entries from. Use Main reporting book and alternate books or Alternate books only. (Default: Main reporting book and alternate books)
TIMEPERIOD Optional string Basis time period. You can use the same time period as the source pool, or you can select a different time period for your basis. Use Current Month, Prior Month, Current Quarter, Prior Quarter, Current Year, Current Year To Date, Prior Year, Prior Year Current Month, Prior Year Current Quarter, Fiscal - Current Quarter, Fiscal - Prior Quarter, Fiscal - Current Year, Fiscal - Current Year To Date, Fiscal - Prior Year, or Inception to Date (applies only for Project dimension allocation focus).
SKIPNEGATIVE Optional boolean Drop negative basis lines from consideration. Use true to drop negative lines. (Default: false)
LOCNO Optional string Entity/Location for dimension filtering to narrow the scope for the basis methodology
VENDORID Optional string Vendor for dimension filtering to narrow the scope for the basis methodology
PROJECTID Optional string Project for dimension filtering to narrow the scope for the basis methodology
DEPTNO Optional string Department for dimension filtering to narrow the scope for the basis methodology
CUSTOMERID Optional string Customer for dimension filtering to narrow the scope for the basis methodology
WAREHOUSEID Optional string Warehouse for dimension filtering to narrow the scope for the basis methodology
CONTRACTID Optional string Contract for dimension filtering to narrow the scope for the basis methodology
ITEMID Optional string Item for dimension filtering to narrow the scope for the basis methodology
CLASSID Optional string Class for dimension filtering to narrow the scope for the basis methodology
EMPLOYEEID Optional string Employee for dimension filtering to narrow the scope for the basis methodology

GLACCTALLOCATIONBASISADJBOOK

Name Required Type Description
ADJBOOKID Optional string Book ID for the adjustment book. Use GAAPADJ, TAXADJ, or a user-defined book.

GLACCTALLOCATIONTARGET

When choosing dimensions for filtering to the target, you can override dimension treatments. For example, if you specified that the Vendor dimension should not be considered, you can use the vendor override parameter to provide a vendor to be used in the allocation for the target.

GLACCOUNTNO Optional string Account that is the target destination of the allocation.
JOURNALSYBMOL Optional string Journal for the allocation journal entries
OVERRIDELOCATION Optional string Dimension override for Entity/Location. Applies only if the dimension treatment for Location is set to Not considered.
OVERRIDEVENDOR Optional string Dimension override for Vendor. Applies only if the dimension treatment for Vendor is set to Not considered.
OVERRIDEPROJECT Optional string Dimension override for Project. Applies only if the dimension treatment for Project is set to Not considered.
OVERRIDEDEPARTMENT Optional string Dimension override for Department. Applies only if the dimension treatment for Department is set to Not considered.
OVERRIDECUSTOMER Optional string Dimension override for Customer. Applies only if the dimension treatment for Customer is set to Not considered.
OVERRIDEWAREHOUSE Optional string Dimension override for Warehouse. Applies only if the dimension treatment for Warehouse is set to Not considered.
OVERRIDECONTRACT Optional string Dimension override for Contract. Applies only if the dimension treatment for Contract is set to Not considered.
OVERRIDEITEM Optional string Dimension override for Item. Applies only if the dimension treatment for Item is set to Not considered.
OVERRIDECLASS Optional string Dimension override for Class. Applies only if the dimension treatment for Class is set to Not considered.
OVERRIDEEMPLOYEE Optional string Dimension override for Employee. Applies only if the dimension treatment for Employee is set to Not considered.

GLACCTALLOCATIONREVERSE

GLACCOUNTNO Optional string Account to use for the reversal pool for the account allocation. Required if not using the source account.
USESOURCEACCOUNT Optional boolean Use the source account for the reversal pool for the account allocation. Required if not providing an account.
OVERRIDELOCATION Optional string Dimension override for Entity/Location.
OVERRIDEVENDOR Optional string Dimension override for Vendor.
OVERRIDEPROJECT Optional string Dimension override for Project.
OVERRIDEDEPARTMENT Optional string Dimension override for Department.
OVERRIDECUSTOMER Optional string Dimension override for Customer.
OVERRIDEWAREHOUSE Optional string Dimension override for Warehouse.
OVERRIDECONTRACT Optional string Dimension override for Contract.
OVERRIDEITEM Optional string Dimension override for Item.
OVERRIDECLASS Optional string Dimension override for Class.
OVERRIDEEMPLOYEE Optional string Dimension override for Employee.

Delete Account Allocation Definition

delete

<delete>
    <object>GLACCTALLOCATION</object>
    <keys>46</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use GLACCTALLOCATION
keys Required string Account allocation RECORDNO to delete

List Account Allocation Runs

readByQuery

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

Parameters

Name Required Type Description
object Required string Use GLACCTALLOCATIONRUN
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 Custom page size between 1 and 1000 items (Default: 100)
Name Required Type Description
STATE Optional string State of the allocation run. Use Q for in queue, I for in progress, F for failed, or P for passed.

Get Account Allocation Run

read

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

Parameters

Name Required Type Description
object Required string Use GLACCTALLOCATIONRUN
keys Required string Account allocation run 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 Account Allocation Run

create

<create>
    <GLACCTALLOCATIONRUN>
        <GLACCTALLOCATION>Monthly expenses</GLACCTALLOCATION>
        <ASOFDATE>2018-09-01/</ASOFDATE>
        <GLPOSTINGDATE>2018-09-25</GLPOSTINGDATE>
        <EMAIL>myEmailAddress.com</EMAIL>
    </GLACCTALLOCATIONRUN>
</create>

Parameters

Name Required Type Description
GLACCTALLOCATIONRUN Required object Object to create

GLACCTALLOCATION

Name Required Type Description
GLACCTALLOCATION Optional string Account allocation ID. Required if not providing an account allocation group.
GLACCTALLOCATIONGRP Optional string Account allocation group name. Required if not providing an account allocation ID.
ASOFDATE Required string As of date for processing the account allocation
GLPOSTINGDATE Required string GL posting date
EMAIL Required string Your email address

Provide feedback