| FINANCIAL_BALANCE_SHEET_SEARCH | FINANCIAL Endpoint | |
| /rpc/financial/?method=FINANCIAL_BALANCE_SHEET_SEARCH | ||
| If you are wanting to show a plain Balance Sheet, 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. Uses Profile Setting 244 to set the default starting date. If not set, if Profile Setting 245 is Y it works off the current financial year. Otherwise, all transactions are included Uses Profile Setting 383 for the Retained Earnings Financial Account and 384 for the Current Earnings Financial Account |
| OPTIONS | TYPE | ||
| 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, will default to today. | |
| StartDate / StartDate0 / StartDate1 | Date | If not passed, or left blank, it will default to your Profile Settings |
| RETURN | ||
| AssetTotal | ||
| EndDate | ||
| EquityTotal | ||
| LiabilityTotal | ||
| StartDate | ||
| Then rows with the following: | ||
| Amount | ||
| Difference | Only shown if you are reporting by 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) | |
| SubTotalCount | ||
| SystemReference | ||
| Type | 1=Asset,2=Liability,3=Equity |