Returns a Profit and Loss Summary for an AccountRight file.
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: EndDate, StartDate, ReportingBasis, YearEndAdjust. All the other columns and operators are processed client side.
The default behavior is EndDate as today's date, StartDate as the first day of the year, ReportingBasis as Cash, and YearEndAdjust as false; if the EndDate, StartDate, ReportingBasis, and YearEndAdjust filters are left unset.
SELECT * FROM ProfitAndLossSummaryReportTo override this behavior, the values can be set directly in the query. For example:
SELECT * FROM ProfitAndLossSummaryReport WHERE StartDate = "12/01/2018" AND EndDate = "01/04/2019" AND ReportingBasis = "Cash" 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.|
|EndDate||Date||Starting date of the period.|
|StartDate||Date||Ending date of the period.|
|ReportingBasis||String||Reporting basis for the period, will either be Cash or Accural.|
|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.|