View source for MYOB Endpoint: ProfitAndLossSummaryReportTable

== Overview ==

The MYOB '''ProfitAndLossSummaryReportTable''' [[MYOB Endpoints|endpoint]] provides the net movement values between a start date and an end date. This report only '''includes detail accounts''' and '''excludes header accounts'''.

Note this endpoint is an alternate format of the [[MYOB Endpoint: ProfitAndLossSummaryReport|ProfitAndLossSummaryReport]] endpoint.  It 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.


== Parameters ==

The ProfitAndLossSummaryReportTable endpoint is a [[Function Endpoints|function]] that accepts the following parameters.

;StartDate
:A [[Field Type: Date|date field]] that determines the start date for which to produce values.
:If omitted, it will use the first date of the last calendar month.

;EndDate
:A [[Field Type: Date|date field]] that determines the end date for which to produce values.
:If omitted, it will use the last date of the last calendar month.

;ReportingBasis
:A [[Field Type: Text|text field]] that determines the way the values will be calculated.
:Possible values are:
:* '''Accrual''': Indicates values should be on an accrual basis (based on invoice dates).
:* '''Cash''': Indicates values should be on a cash basis (based on payment dates).

;YearEndAdjust
:A [[Field Type: Boolean|true/false field]] that determines if year end adjustment should be included or excluded.


== Fields ==

The following fields are available for the ProfitAndLossSummaryReportTable endpoint.

;DataFileID
:A [[Field Type: GUID|guid field]] that provides the id of the xero data file as setup in OdataLink.

;DataFileName
:A [[Field Type: Text|text field]] provides the name of the xero data file as setup in OdataLink.

;DataFileCode
:A [[Field Type: Text|text field]] provides the code of the xero data file as setup in OdataLink.

;StartDate
:A [[Field Type: Date|date field]] that indicates the start date for which to produce values.
:This will match the StartDate entered as [[#Parameters|parameter]].

;EndDate
:A [[Field Type: Date|date field]] that indicates the end date for which to produce values.
:This will match the EndDate entered as [[#Parameters|parameter]].

;ReportingBasis
:A [[Field Type: Text|text field]] that indicates the way the values will be calculated.
:This will match the ReportingBasis entered as [[#Parameters|parameter]].

;YearEndAdjust
:A [[Field Type: Boolean|true/false field]] that indicates if year end adjustment should be included or excluded.
:This will match the YearEndAdjust entered as [[#Parameters|parameter]].

;AccountUID
:A [[Field Type: GUID|GUID field]] representing the internal id of an account. This field can be used to link to other endpoints.

;AccountName
:A [[Field Type: Text|text field]] used as the account name.

;AccountDisplayID
:A [[Field Type: Text|text field]] used as the account number.

;AccountTotal
:A [[Field Type: Decimal|decimal field]] that provides the total for a given account.



== MYOB API ==

For a detailed run through of the endpoint, you can see the [https://developer.myob.com/api/accountright/v2/report/profitandlosssummary/ MYOB API].


== Related Fields ==

None


== Related Endpoints==

:[[MYOB Endpoint: BalanceSheetSummaryReport|BalanceSheetSummaryReport]]
:[[MYOB Endpoint: BalanceSheetSummaryReportTable|BalanceSheetSummaryReportTable]]
:[[MYOB Endpoint: BalanceSheetSummaryReportMultiPeriodTable|BalanceSheetSummaryReportMultiPeriodTable]]
:[[MYOB Endpoint: ProfitAndLossSummaryReport|ProfitAndLossSummaryReport]]
:[[MYOB Endpoint: ProfitAndLossSummaryReportMultiPeriodTable|ProfitAndLossSummaryReportMultiPeriodTable]]


== Related Topics ==

:[[MYOB Models]]
:[[MYOB Endpoints]]