N15 - Centre Balance (Reports & Settings Report Generator variable)
From Catalyst
Syntax
N15{+/-, D1-D16, F/T, H/C, Y/N}
Description
Will return the centre balance between two dates. This will search both history and current nominal transactions for the result.
Internal P/L postings made to P/L centre will be excluded as their purpose is to zero the balance of the profit and loss centre which for this variable is meaningless. |
Parameters
- +/-
- A text parameter that can be omitted.
- blank
- All balances.
- +
- Only get transaction balances that are positive.
- -
- Only get transaction balances that are negative.
- D1-D16
- A text parameter that can be omitted (it defaults to "D1").
- Restrict to a given date range.
- D1-D16
- Corresponds to the date range screen.
If you use a '+' or '-' after the D?? along with a number that number will be used as a month offset. e.g. D1+12: The date range 1 with 12 months added to the "From" and "To" dates. '01/01/2004' to '31/12/2004' would become '01/01/2005' to '31/12/2005'. |
- F/T
- A text parameter that can be omitted.
- H/C
- A text parameter that can be omitted.
- blank
- If this omitted the default is to include transactions from both history and current.
- H
- Filter on history items.
- C
- Filter on current items.
- Y/N
- A text parameter that can be omitted.
- Used to calculate the amount that has/has not been audited on the balance sheet in a period. This parameter will have NO effect on profit and loss centres.
- Y
- Transactions must have been through the balance sheet.
- N
- Transactions must be waiting to be listed on the balance sheet.
Returns
A numeric value whose typical size is 6 digits plus 2 decimal places.