financial_statement
Generate P&L, Balance Sheet, or Trial Balance reports for a date range with Monthly, Quarterly, Half-Yearly, or Yearly periods. Trial Balance requires dates within one fiscal year.
Instructions
One of the standard financial statements over a date range: statement = "pnl" (Profit and Loss Statement), "balance_sheet" or "trial_balance". P&L/BS run filter_based_on="Date Range" with the given periodicity (Monthly/Quarterly/Half-Yearly/Yearly). Trial Balance needs the range inside ONE fiscal year (ERPNext requires a fiscal_year filter; it is resolved from the dates — a spanning range is refused rather than guessed). company defaults to the default company. Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| company | No | ||
| to_date | Yes | ||
| from_date | Yes | ||
| statement | Yes | ||
| periodicity | No | Monthly |