MYOB Endpoint: BalanceSheetSummaryReport: Difference between revisions

Created page with "== Overview == The MYOB '''BalanceSheetSummaryReport''' endpoint provides a closing balance sheet values as at a given date. This report only '''includes detail..."
 
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Overview ==
== Overview ==


The MYOB '''BalanceSheetSummaryReport''' [[Endpoints|endpoint]] provides a closing balance sheet values as at a given date. This report only '''includes detail accounts''' and '''excludes header accounts'''.
The MYOB '''BalanceSheetSummaryReport''' [[MYOB Endpoints|endpoint]] provides a closing balance sheet values as at a given date. This report only '''includes detail accounts''' and '''excludes header accounts'''.
 
Note an alternate endpoint named [[MYOB Endpoint: BalanceSheetSummaryReportTable|BalanceSheetSummaryReportTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.


It is a [[Function Endpoints|function]] that accepts a series of parameters.
It is a [[Function Endpoints|function]] that accepts a series of parameters.
Line 21: Line 23:


The following fields are available for the BalanceSheetSummaryReport endpoint.
The following fields are available for the BalanceSheetSummaryReport endpoint.
;DataFile
:A [[Field Type: Record|record field]] that provides the [[Field: DataFile|DataFile]] associated with the data.


;AsOfDate
;AsOfDate
Line 58: Line 63:
== Related Endpoints==
== Related Endpoints==


:[[MYOB Endpoint: BalanceSheetSummaryReportTable|BalanceSheetSummaryReportTable]]
:[[MYOB Endpoint: BalanceSheetSummaryReportMultiPeriodTable|BalanceSheetSummaryReportMultiPeriodTable]]
:[[MYOB Endpoint: ProfitAndLossSummaryReport|ProfitAndLossSummaryReport]]
:[[MYOB Endpoint: ProfitAndLossSummaryReport|ProfitAndLossSummaryReport]]
:[[MYOB Endpoint: ProfitAndLossSummaryReportTable|ProfitAndLossSummaryReportTable]]
:[[MYOB Endpoint: ProfitAndLossSummaryReportMultiPeriodTable|ProfitAndLossSummaryReportMultiPeriodTable]]
== Related Topics ==
:[[MYOB Models]]
:[[MYOB Endpoints]]