Atrieve Finance

Statement/Notice Parameters

The preliminary Statement/Notice Parameter screen will be blank on the first entry to it, as seen here:

At the format prompt, enter '1' followed by a <Enter>.

To enter subsequent formats, enter 2, 3, etc. The new format will always be one number greater than the last format number currently displayed on the menu.

The System Will Prompt:

Do You Wish To Add A New Format

A response of 'Y' will allow you to access to the forms parameters module.

A response of 'N' or <Enter> will cause the system to revert to the Forms Parameters Menu.

If you wish to change an existing format, type the number of that format, followed by a <Enter>. The above prompt will only appear if a number is selected which is not already referenced by the system.

Type 'Y', followed by a <Enter>.

The system will prompt:

Enter Name

Enter the name of the statement for which you wish to set parameters (maximum 20 characters). This name will appear subsequently on the Statement Parameters Menu.

The first screen will appear in this manner:

Enter Field # To Change

Enter the number of lines available for printing on your statement. The available lines must be divided between the body and the stub of the statement. The body of the statement refers to the name/address portion, while the stub carries the variable account information. For example, a 10 inch form set to print at 6 lines per inch would have 60 available print lines. The 60 available lines would then be further divided between the body and the stub, depending on the relative size of each. When all fields are correct, enter a <Enter> to display the next screen.

For the next six screens you will define:

  • Statement Header Parameters

  • Statement Subsystem Heading Parameters

  • Statement Stub Document Summary Parameters

  • Statement Stub Document Detail Parameters

  • Statement Sub-system Totals Parameters

  • Statement Totals Parameters

The Examples On The Following Produce A Statement

Statement Parameters

Valid Variable Field Name List

The following is a listing of all the valid field names allowed for input to the Statement Parameters module.

Fields With The Identifying First Letter 'C' Refer To Customer Information

C-NUMBER$

Customer Number

C-NAME$

Customer Name

C-ADDRESS1$

First line of customer address

C-ADDRESS2$       

Second line of customer address

C-ADDRESS3$

Third line of customer address

C-ADDRESS4$

Fourth line of customer address

C-POSTALCODE$

Customer Postal Code

C-SORT$

Customer Sort Code

C-TELE1$

Customer telephone number

C-TELE2$

Customer alternate telephone number

Fields With The Identifying First Letter 'S' Refer To Receivable Group Information

S-SYSNAME$

Receivable group, name

S-AGE1

First aging range total for that sub-system

S-AGE2

Second aging range total for that sub-system

S-AGE3

Third aging range total for that sub-system

S-AGE4

Fourth aging range total for that sub-system

S-CURRENT

Current total due for that sub-system

S-BALDUE

Total balance due for that sub-system

The following represents information referring to the original master documents - 'm'

M-SOURCEDESC$

Master document source code description

M-DATE

Master document due date in the form YY-MM-DD

M-DAYDATE

Day portion of M-DATE field  

M-N_MONTHDATE

Month portion of M-DATE field in the form MM

M-MONTHDATE

Month portion of M-DATE field in the form MMM

M-YEARDATE

Year portion of M-DATE field

M-REFERNO$

Original document number

M-ORGAMOUNT

Original amount due

M-PAYAMOUNT

Payments/adjustments to document

M-BALANCE

Total balance due on document as at statement date

M-BALDUE

Total balance due on document

M-AMTDUE

Total original amount plus interest

M-SOURCE$

Original document source code

M-REFERENCE$

Original document written reference field one

M-REFERENCE1$

Original document written reference field two

M-REFERENCE2$

Original document written reference field three

M-REFERENCE3$

Original document written reference field four

M-BATCHNUMBER$

Original document entry batch number in the form

M-BATCHYPP$

YPP portion of M-BATCHNUMBER$

M-BATCHTYPE$

TTT portion of M-BATCHNUMBER$

M-BATCHSEQ$

SS portion of M-BATCHNUMBER$

The 'I' Fields Refer To Interest Calculation Information

I-INTERTD

Interest calculated to date (compounded)

I-INTERCUR

Interest not compounded

I-INTERTOT

Interest total

I-INTDATE

Date of last interest calculation

I-INTYEARDATE

Year portion of I-INTDATE field

I-INTMONTHDATE

Month portion of I-INTDATE field

I-INTDAYDATE

Day portion of I-INTDATE field

The Following Fields ('D') Refer To Document Detail Information

D-RECEIPT$

Detail receipt number

D-LOCATION$

Detail location code

D-DATE

Detail document date in the form YY-MM-DD

D-MONTHDATE

Month portion of the D-DATE field

D-YEARDATE

Year portion of the D-DATE field

D-DOCREFNO$

Original document reference number

D-REFERNO$

Transaction detail reference number

D-AMOUNT

Detail invoice amount

D-SOURCE$

Detail source code

D-SOURCEDESC$

Detail source code description

D-BATCHNUMBER$

Detail batch number for transactions in the form YPP- TTT-SS

D-BATCHYPP$

YPP portion of D-BATCHNUMBER$ field

D-BATCHTYPE$ TTT

portion of D-BATCHNUMBER$ field

D-BATCHSEQ$ SS

portion of D-BATCHNUMBER$ field

D-BATCHDESC$

Batch code description $L8

Fields Referenced By The Letter 'T' Refer To Account Totals Information

T-AGE1

Total due from first age range

T-AGE2

Total due from second age range

T-AGE3

Total due from third age range

T-AGE4

Total due from fourth age range

T-CURRENT

Total due currently

T-BALDUE

Total balance due

T-OVERDUE

Total overdue

The 'W' Fields Refer To User Defined Print Variable Information

W-LITERAL$

User defined print variable (Maximum 30 characters)

W-REMARK1$

First line of remarks from statement code (maximum 50 characters)

W-REMARK2$

Second line of remarks from statement code (maximum 50 characters)

W-SDATE

Statement date in the form YY-MM-DD

W-SDAYDATE

Day portion of W-SDATE field

W-SMONTHDATE

Month portion of W-SDATE field

W-SYEARDATE

Year portion of W-SDATE field

W-PAGE$

Statement page number