Returns a Balance Sheet Summary.
Table Specific Information
MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison types for server side filtering: AsOfDate, YearEndAdjust. All the other columns and operators are processed client side.
The default behavior is AsOfDate as today's date and YearEndAdjust as false; if the AsOfDate and YearEndAdjust filters are left unset.
SELECT * FROM BalanceSheetSummaryReportTo override this behavior, the values can be set directly in the query. For example:
SELECT * FROM BalanceSheetSummaryReport WHERE AsOfDate = '2021-05-31 00:00:00' AND YearEndAdjust = false
|AccountTotal||Decimal||Total Amount for the Account for the given date range.|
|AccountID||Uuid||Unique identifier for the account in the form of a guid.|
|AccountDisplayID||String||Account code. Format includes separator ie 4-1100|
|AccountName||String||Name of the account.|
|AccountURI||String||Uniform resource identifier associated with the account object.|
|AsOfDate||Date||Date of the period, format YYYY-MM-DD HH:MM:SS|
|YearEndAdjust||Boolean||If you are including Year end Adjustments. This is a true or False value.|
|CompanyFileId||String||The ID of the company file. Takes precedence over the CompanyFileId connection property.|