NexCommand AINexCom Knowledge Base
Field reference

Financial Report Template

How to use Financial Report Template in General Ledger & Closing: access, working steps, fields, related records and troubleshooting.

Finance & AccountingUpdated 12 October 2026Configuration-aware guidance
Open Financial Report Template ↗Module guide

Purpose and access

Establish the chart of accounts and fiscal structure, review journals and ledgers, and complete period-end checks. Reconcile subledgers to the general ledger before closing; preserve the audit trail for corrections.

This page is a record page in Finance & Accounting → General Ledger & Closing. Use the link above to open the configured destination; permissions are checked by the destination service.

ERP links open in a new tab. Sign in with your own account; record visibility, actions and approval authority follow your assigned permissions. Screens can differ by company and configuration.

Before you start

Prepare the required information: Template Name, Report Type.

Confirm the company, party, dates, units and source references that apply. Select existing links carefully and check for an existing record before creating a duplicate.

Working steps

  1. Open Financial Report Template from Finance & Accounting → General Ledger & Closing, or use ERP Search.
  2. Filter the list and open the relevant record. To add a record, use Add/New when your role provides that action.
  3. Complete the editable fields described below. Required fields and validation conditions must be satisfied; read-only values are set by the system or their source records.
  4. Add the required child rows. Review each row’s identifiers, linked records and values, using the child-table field reference below.
  5. Save the record and address validation messages. Reload and verify the saved values and relationships.
  6. Use any additional workflow actions only when the record and your role provide them. Saving this record does not automatically complete a related transaction or external action.

Field reference

These fields come from the installed ERP definition. Hidden fields and password inputs are omitted. Additional conditions, custom scripts and workflow rules can make a field required or read-only in a particular context.

FieldType / behaviorHow to use it
Template Nametemplate_nameData
Required		Descriptive name for your template (e.g., 'Standard P&L', 'Detailed Balance Sheet')
Report Typereport_typeSelect
Required		Type of financial statement this template generates
Available choices
  • Profit and Loss Statement
  • Balance Sheet
  • Cash Flow
  • Custom Financial Statement
Module (for Export)moduleLink
Optional		Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship.

Linked record: Module Def

DisableddisabledCheck
Optional		Disable template to prevent use in reports
Report Line ItemsrowsTable
Optional		Add the relevant child rows and review required columns, quantities and references before saving.

Linked record: Financial Report Row

Child tables

Report Line Items — child-row fields
FieldType / behaviorHow to use it
Line Referencereference_codeData
Optional		Code to reference this line in formulas (e.g., REV100, EXP200, ASSET100)
Display Namedisplay_nameData
Optional		Text displayed on the financial statement (e.g., 'Total Revenue', 'Cash and Cash Equivalents')
Indent Levelindentation_levelInt
Optional		Indentation level: 0 = Main heading, 1 = Sub-category, 2 = Individual accounts, etc.
Data Sourcedata_sourceSelect
Optional		How this line gets its data
Available choices
  • Account Data
  • Calculated Amount
  • Custom API
  • Blank Line
  • Column Break
  • Section Break
Balance Typebalance_typeSelect
Optional		Opening Balance = Start of period, Closing Balance = End of period, Period Movement = Net change during period
Available choices
  • Opening Balance
  • Closing Balance
  • Period Movement (Debits - Credits)
Value TypefieldtypeSelect
Optional		How to format and present values in the financial report (only if different from column fieldtype)
Available choices
  • Currency
  • Float
  • Int
  • Percent
ColorcolorColor
Optional		Color to highlight values (e.g., red for exceptions)
Bold Textbold_textCheck
Optional		Bold text for emphasis (totals, major headings)
Italic Textitalic_textCheck
Optional		Italic text for subtotals or notes
Hidden Line (Internal Use Only)hidden_calculationCheck
Optional		Calculate but don't show on final report
Hide If Zerohide_when_emptyCheck
Optional		Hide this line if amount is zero
Reverse Signreverse_signCheck
Optional		Enable or disable the named option only when it matches the intended record behavior.
Include in Chartsinclude_in_chartsCheck
Optional		If enabled, this row's values will be displayed on financial charts
Advanced Filteringadvanced_filteringCheck
Optional		Use Python filters to get Accounts
Formula or Account Filtercalculation_formulaCode
Optional		Administrator/integration field. Use a validated configuration or supported script and test its impact before deployment.

Troubleshooting

  • Not permitted: verify the account, role and source-document permission. Do not share an administrator login.
  • Missing record or address: inspect the relevant Link or Dynamic Link fields; a matching title alone does not establish a relationship.
  • Cannot save or change status: review required fields, read-only values, document status and the configured approval transition.
  • Unexpected report or portal result: review company/date filters, source-document submission and the approved party or Employee link.
Was this useful?