MYOB Endpoint: AccountsTotals

From OdataLink
Jump to navigation Jump to search

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

Accounts
AccountsClassifications


Related Topics

MYOB Models
MYOB Endpoints