A08 - Account Balance (Reports & Settings Report Generator variable)

From Catalyst
Jump to: navigation, search

Syntax

A08{+/-, D1-D16, F/T}

Description

Can be used to get the account balance, using the parameters it is possible to get what balances are outstanding in given periods.

No parameters will given the current account balance as given in the account amendments option.


Parameters

+/-
A text parameter that can be omitted.
blank
Current balance.
+
Only get document balances that are positive.
-
Only get document 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.

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