N15 - Centre Balance (Reports & Settings Report Generator variable)

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.

F

Only use the "From" field in the date given in the D?? parameter.

T

Only use the "To" field in the date given in the D?? parameter.

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.

Feedback

Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'

Keywords AND Misspellings

date, day, month, year