Menu Object
 
Syntax
 
Menu.FinBalanceSheet [ReportType][, FiscalYear][, DateFrom][, DateTo][, WarehouseCode][, ProductGroupCode][, ShowMonthlyTotals]
 
Description
Opens the Balance Sheet reporting application. Optionally, the report type, fiscal year, date range, warehouse, product group, and monthly totals display can be specified.
 
Parameter
Description
ReportType
Optional. The type of balance report to generate. Default value brtTotalBalance.
Valid values:
brtColumnBalance (0) = Column balance,
brtTrialBalance (1) = Trial balance,
brtTotalBalance (2) = Total balance,
brtProfitLoss (3) = Profit and loss statement,
brtStockBalance (4) = Stock balance,
brtXMLAuditFile (5) = XML audit file (XAF),
brtQuickStockList (6) = Quick stock list,
brtSnapshotFinancial (7) = Financial snapshot,
brtSnapshotLogistics (8) = Logistics snapshot.
FiscalYear
Optional. Fiscal year for the report. Default value 0 (current year).
DateFrom
Optional. Start date of the reporting period.
DateTo
Optional. End date of the reporting period.
WarehouseCode
Optional. Code of the warehouse to include in the report.
ProductGroupCode
Optional. Code of the product group to include in the report.
ShowMonthlyTotals
Optional. When True, monthly subtotals are included in the report. Default value False.
See Also
FinBalansOverzicht (Dutch variant)
Example
 
Sub Main
    Menu.FinBalanceSheet ReportType:=brtProfitLoss, FiscalYear:=2026
End Sub