AR Statement Designer

Navigator > Setup > Accounts Receivable > Statement Designer

Use the Statement Designer to design your own statement or modify an existing statement design. To design a statement quickly, start with an existing layout, save it with a different name, then modify it. Sample reports are installed with the Accredo server install, and are also available on the Accredo website.

Note: If you modify reports that are provided with Accredo it is important to save them with different names, as when Accredo updates are installed, the reports can be overwritten.

The AR Statement Designer is based on the Report Designer and has similar functionality. Full report design facilities including MaxBasic options are available.

Usually a statement consists of:

Header band showing details of the Customer and statement date,
A Repeating Detail band for transactions, and
Footer band for totals.

Iterators are available to create sub-sets of records. Iterators can be applied to Bands to filter records shown in a band. Iterator objects allow setting of the SortBy property in the BeforeReport code.


Name		Iterators filter records that are shown in the report. Available Iterators are: Current - current AR transactions. CurrentInvoiceLine - current IN invoice lines. CurrentInvoiceLineTracking - iterates through the tracking detail for the invoice line. Outstanding - AR Transactions outstanding or overdue. OutstandingInvoiceLine - IN Invoice lines outstanding or overdue. OutstandingInvoiceLineTracking - iterates through the tracking detail for the invoice line. Future - AR transactions entered since last processing. FutureInvoiceLine - IN invoice lines entered since last processing. FutureInvoiceLineTracking - iterates through the tracking detail for the invoice line.
Bands		The Bands in the report to apply the iterator to.
Sort Order		Optionally select fields to sort records in the iterator.
Filter		Optionally select fields to further filter the iterator.
Toolbar
	Move up `(Shift+Up)` Move down `(Shift+Down)`		Move the Iterator group up or down to change the order the Iterators are executed in.

Objects available in the statement designer in addition to the standard objects include:

Object	Contains
BillFrom	Fields from the Customer the transaction was entered against.
Branch	Fields from the Branch the Customer is attached to. (Accredo Saturn Only)
Company	Fields from the Company.
Contact	Fields from the Contact.
Customer	Fields from the Customer for the statement (the "billed to" Customer).
DeliveryAddress	Fields from the delivery address.
InvoiceHead	Fields from the original source Invoice header.
InvoiceLine	Fields from the original source Invoice line.
itCurrent	Properties of the Current iterator.
itCurrentInvoiceLine	Properties of the CurrentInvoiceLine iterator.
itFuture	Properties of the Future iterator.
itFutureInvoiceLine	Properties of the FutureInvoiceLine iterator.
itOutstanding	Properties of the Outstanding iterator.
itOutstandingInvoiceLine	Properties of the OutstandingInvoiceLine iterator.
SalesPerson	Fields from the Sales Person.
Transaction	Fields from the transaction.
User	Fields from the User.

Report Properties specific to AR Statements are:

StatementAging

Values are:

saPeriod - This is the default. The statement is aged per period.
saDays - The statement does days ageing and enables the AgingDays property. This allows you to design weekly or other days based ageing statements. Days ageing statements work from the Statement Date and Aging Days to calculate statement iterators.
saMonthly - The statement is aged by calendar months, regardless of the company period structure. Monthly aging statements work from the month for Statement Date and calendar months to create statement iterators.

Report.AgingDays and Report.StatementAging can be set in BeforeReport code for AR Statement designs allowing a single statement design to be used by customers with different aging terms.

AgingDays

The number of aging days, when StatementAging is set to Days. Defaults to 7.

Sample AR Statements are provided with the Accredo Server Install, and are also available on the Accredo website.

Sample AR Statements include:

ARStatement.pfd - standard AR Statement, handles customers with different Statement Aging. Shows Current transactions followed by Over Due transactions.
ARStatementOutstanding.pfd - AR Statement showing all outstanding items sorted by due date. Recommended if Due Dates are changed from those calculated from Customer Payment Terms.

To use documents downloaded from the website, ensure your document designer is the latest version.

In This Section

AR Statement Designer Objects

AR Report Period