MYOB Endpoint: AccountsTotals
Overview
The MYOB AccountsTotals endpoint allows you to access as list of account totals that can simplify creating Profit and Loss, Balance Sheet, Trial Balance or Cash Flow reports.
This endpoint is not part of the MYOB API but specific to OdataLink to ease development.
Fields
The following fields are available for the AccountsTotals endpoint.
- AccountTotalName
- A text field that provides the name of the total. Possible values are:
- Income
- Cost Of Sales
- Gross Profit / (Loss)
- Expenses
- Operating Profit / (Loss)
- Other Income
- Other Expenses
- Net Profit / (Loss)
- Assets
- Liabilities
- Net Assets
- Equity
- IsProfitLoss
- A true/false value that indicates if the account is a profit and loss account.
- IsBalanceSheet
- A true/false value that indicates if the account is a balance sheet account.
- IsAccountClassification
- A true/false value that indicates if the account represents a single account classification or total of multiple account classifications.
- This field is useful within DAX to produce totals for Gross Profit / (Loss) and other totals to hide the breakdown of accounts.
- Order
- A true/false value that provides the sort order of the total on a report.
- Classifications
- A record field containing classifications that are included to generate the total.
Classifications Fields
The Classifications field includes the following fields. It provides access to list of classifcations that are included to generate the total.
- Classification
- A text field that identifies the high-level type of accounts to include.
- This field can linked to the Classification field of either the Accounts or AccountsClassifications endpoints.
- DrCrSign
- A integer field provides a value of +1 or -1 indicating how to include values for the classification.
- As an example, Gross Profit / (Loss) would list Income with a +1 value, but CostOfSales with a -1.
MYOB API
This endpoint is not part of the MYOB API but specific to OdataLink to ease development.
Related Endpoints