FINANCIAL_PROFIT_LOSS_SEARCH | FINANCIAL Endpoint | |
/rpc/financial/?method=FINANCIAL_PROFIT_LOSS_SEARCH | ||
If you are wanting to show a plain Profit & Loss, don't put 0 or 1 after the filters. If you are wanting to also show movement add the 0 or 1, for eg use enddate0 and enddate1 |
OPTIONS | TYPE | ||
Cash | y/n | Default n, which means it is calculated based on Accurals | |
IncludeChildAreas | y/n | Default n. If specifying an area, should it also process child areas | |
ShowZeroValues | y/n | Default n. |
AVAILABLE FILTERS | TYPE | ||
Area / Area0 / Area1 | Numeric | Specific Area, if areatype=3 | |
AreaType / AreaType0 / Areatype1 | Numeric | 1=All Areas (default),2=No Area,3=Specific Area as per Area filter | |
EndDate / EndDate0 / EndDate1 | Date | If not passed, or left blank, it will default to your personal Profile Setting of 351. If still blank, will default to today. | |
Project | numeric | ||
StartDate / StartDate0 / StartDate1 | Date | If not passed, or left blank, it will default to your personal Profile Setting of 351 |
RETURN | ||
EndDate | ||
GrossMargin | ||
GrossMarginPercentage | ||
NetMargin | ||
NetMarginPercentage | ||
OperatingMargin | ||
OperatingMarginPercentage | ||
StartDate | ||
TotalCostOfSales | ||
TotalCostOfSalesPercentage | ||
TotalOperationalExpenses | ||
TotalOperationalExpensesPercentage | ||
TotalOtherExpenses | ||
TotalOtherExpensesPercentage | ||
TotalOtherIncome | ||
TotalOtherIncomePercentage | ||
TotalSales | ||
TotalTaxExpenses | ||
TotalTaxExpensesPercentage | ||
Then rows with the following: | ||
Difference | Only returned if processing more than one date | |
FinancialAccount | ||
FinancialAccountText | ||
Header | Y/N | |
Indent | Help to display table. Each character represents how it should be indented. 0=blank space,1=downwards line,2=branch (with an item after it),3=branch (with nothing after it) | |
Percentage[n] | ||
SubTotalCount | ||
SystemReference | ||
Total[n] | ||
Type | 1=Operational Income,2=Cost of Sales,3=Operational Expenses,4=Other Income,5=Other Expenses,6=Tax Expenses |