MYOB Endpoint: BalanceSheetSummaryReportTable

Overview

The MYOB BalanceSheetSummaryReportTable endpoint provides a closing balance sheet values as at a given date. This report only includes detail accounts and excludes header accounts.

Note this endpoint is an alternate format of the BalanceSheetSummaryReport endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.

It is a function that accepts a series of parameters.

Parameters

The BalanceSheetSummaryReportTable endpoint is a function that accepts the following parameters.

AsOfDate: A date field that determines the date for which to produce values.; If omitted, it will use the last date of the last calendar month.

YearEndAdjust: A true/false field that determines if year end adjustment should be included or excluded.

Fields

The following fields are available for the BalanceSheetSummaryReportTable endpoint.

DataFileID: A guid field that provides the id of the xero data file as setup in OdataLink.

DataFileName: A text field provides the name of the xero data file as setup in OdataLink.

DataFileCode: A text field provides the code of the xero data file as setup in OdataLink.

AsOfDate: A date field that indicates the date used to produce the report.; This will match the AsOfDate entered as parameter.

YearEndAdjust: A true/false field that indicates if year end adjustment should be included or excluded.; This will match the YearEndAdjust entered as parameter.