A09 - Account Turnover (Reports & Settings Report Generator variable)

From Catalyst
Jump to: navigation, search

Syntax

A09{D1-D16, F/T}

Description

Can be used to get the account turnover. If you use the optional date range parameters the report generator will dig out the turnover from the transaction archives and therefore is NOT effected by any account cleardowns you may have done.

No parameters will give the current account turnover as given in the Customer/Supplier File Amendments options. Remember this can be reset using Cleardown Period Turnover option in the Customer/Supplier File Amendments options so this may not be the total turnover with the account.


Parameters

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