Microsoft Gold Partner Logo_edited.png
  • LinkedIn Social Icon
  • Twitter Social Icon
  • Facebook Social Icon
  • YouTube Social  Icon

Austin  |  Dallas  |  Houston  |  New Orleans  |  Nashville

NAVigating NAV: Financial Reporting using Account Schedules



This will open the following window:

The fields in the Account Schedule are defined as follows:

  1. Row No. – Add a number to each row in your Account Schedule in order to perform mathematical calculations.

  2. Description – This will be the description on the row.

  3. Totaling Type – In this field, you must select the totaling type for the account schedule line. The type determines which accounts within the totaling interval you specify in the Totaling field will be totaled.

Click the Assist Button to the right of the field to see the options:Posting AccountsThe total will be calculated from amounts in posting accounts in the chart of accounts.Total AccountsThe total will be calculated from amounts in total and end-total accounts in the chart of accountsFormulaThe total will be calculated from amounts in other rows in the account schedule. You enter the formula in the Totaling field.

If you use the Insert G/L Accounts function, accounts that have the Account Type Total or End-Total on the chart of accounts will be assigned the totaling type Total Accounts. All other lines will automatically be assigned the totaling type Posting Accounts.

  1. Totaling – You use this field to indicate which accounts will be totaled on this line.

How you fill out this field depends on the contents of the Totaling Type field. If you assign the Formula totaling type to the account schedule line, you can enter a formula that includes row numbers (or totaling intervals) from the account schedule. If the totaling type is Posting Accounts or Total Accounts, you must enter an account number (or totaling interval) from the chart of accounts.

When you use a totaling interval, all the accounts within the range you define (for example, 1900..2100 inclusive) will be totaled.

You can use a formula to perform calculations on other lines. Other lines are referenced through their row number.

You can use the following symbols:

+ (addition)

– (subtraction)

* (multiplication)

/ (division)

^ (exponentiation)

() (parentheses)

Note: If you wish to include a number in the formula, that number must not be used as a row number in your account schedule.

  1. Row Type (Choose one of the Options)

Net Change – Will display the net change in the account balances during the period being filtered.

Balance at Date – Will display the balance of the accounts at the end of the period being filtered. Beginning Balance – Will display the balance of the accounts at the beginning of the period being filtered.

  1. Amount Type – Choose one of the Options –

Net Amount – Includes both credit and debit entries.

  1. Show – (Choose one of the Options)

Yes – Amounts will always be shown

No – No amounts will be shown (Use this option for performing interim calculations)

If Any Column Not Zero – Row will be shown unless all of the columns are equal to zero

When Positive Balance – Only shown when Amounts are Positive

When Negative Balance – Only shown when Amounts are Negative

  1. Dimension Totaling – This specifies which dimension value amounts will be totaled on this line. (If you use this option, make sure the G/L accounts you are totaling for this row have Code Mandatory for their Dimension Values).  You have the ability to use this for the first four dimensions from the General Ledger Setup. Note! If you assign the Account Schedule Name to an Analysis View, the system will then use those dimensions you in the Analysis view for totaling.

#NAV