APPX Software Library

1Transaction Processing

Option 2Hand Checks Entry

Use this function to enter and modify hand checks. This function also allows access to check records entered through ‘Void Checks’ entry.

Each group of hand checks includes a control group record and a series of one or more checks, each with any number of line items.

The normal process of posting hand checks includes:

  1. Entering the hand checks.
  2. Printing the Hand Checks Journal.
  3. Posting the hand checks.

If the journal has been printed and some of the data is modified, the journal must be reprinted before the data can be posted.

On the following pages, the five screens displayed by this function are shown.

The screen shown below presents information about Disbursements Control Groups.

When you enter checks, you see only one of the two possible screens for Hand Check or Void Check Control Groups. Which screen you see depends on how you answered two questions on your Parameters file. These are the “Ask Operator ID?” question, and the “Use Transaction Control?” question.

If you answered ‘Y’ to both questions, you see the screen below and can enter control and hash totals for your checks. In addition, a record is written to the Transaction control file for each control group posted.

If you answered ‘Y’ to “Ask Operator ID?” and ‘N’ to “Use Transaction Control?”, the screen displays only the Operator ID and the Control Number.

If you answered ‘N’ to both questions, you are not allowed to edit the Operator ID.

Hand Check Control Groups screen

The Accounts Payable Hand Check Control Groups Screen
Figure 8

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press ENTER; the record will be displayed for editing.

Data items for the preceding screen are described below:

Operator ID

Upper case, up to 3 characters Letters and numbers only Required Carries forward in ADD mode

The operator ID you entered at log-on is displayed. The default may be changed in order to edit transactions for another operator. All control groups are separated by operator.

Control Number

Positive number, up to 4 digits

A sequential number is supplied to identify this group of invoices. This number is printed on the journal, tracked on the Transaction Control file, and if General Ledger is a part of your system it is posted to General Ledger for detail accounts. Although this number need not be exactly sequential, the number itself is important as a part of your audit trail.

Operator Exclusive?

Y or N Default N Required

Indicate whether or not you are reserving exclusive rights to this group of invoices.

Y
Yes, access is restricted to the original operator.
N
No, access is not restricted.
Description

Alphanumeric, up to 30 characters Required

Describe this group of checks. This description will appear on the Transaction Control report and inquiry.

Control Total

Number, up to 9 digits and 2 decimals

This entry is balanced against the running total kept by the system as entries are made. Enter the adding machine total of all check amounts to be entered. The system will display the running total of amounts entered in the “Current” field, and the balance remaining is shown in the “Remaining” field.

Vendor Hash Total

Positive number, up to 12 digits

Enter the sum of all vendor numbers to be entered in this control group. The system will keep a running total of vendor numbers as they are entered and balance it against this entry.

Print Journal?

Y or N Default Y Required

‘Y’ is displayed to indicate that this group is ready for journal printing. If you want to delay journal printing for any reason, enter ‘N’.

Journal OK?

Y or N Display only Default N

The system displays ‘Y’ or ‘N’ to indicate whether or not this group has been verified (the journal printed and no errors are present) and is correct.

Post Now?

Y or N Default Y Required

‘Y’ is displayed to indicate that this group is ready for posting. If you want to delay posting for any reason, enter ‘N’.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

  • EThis Control Group Has Already Been Used For Checks Posting
  • EThis Control Group May Not Be Edited - Posting Was Started
  • EYou May Not Change Data Entered By the Original Operator
  • EYou May Not Edit Machine Generated Checks

Press ENTER to continue to the next screen.

Select Next Record to go to the next Disbursements Control Groups record.

At this screen, the use of the MODE keys - ADD, DEL, CHG, or INQ - pertain to those records in the Disbursements Control Groups file.

This screen may optionally be used to display information about Hand Check Control Groups. You will only see this screen if you entered ‘N’ to “use Transaction Control?” in your Parameters file.

Hand Check Operator ID screen

The Accounts Payable Hand Check Operator ID Screen
Figure 9

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press ENTER; the record will be displayed for editing.

Data items for the preceding screen are described below:

Operator ID

Upper case, up to 3 characters Letters and numbers only Required Carries forward in ADD mode

The operator ID you entered at log-on is displayed. The default may be changed in order to edit transactions for another operator. All control groups are separated by operator.

Control Number

Positive number, up to 4 digits

A sequential number is supplied to identify this group of invoices. This number is printed on the journal, tracked on the Transaction Control file, and if General Ledger is a part of your system it is posted to General Ledger for detail accounts. Although this number need not be exactly sequential, the number itself is important as a part of your audit trail.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

  • EThis operator’s Data May Not Be Edited - Posting Was Started

Press ENTER to continue to the next screen.

Select Next Record to go to the next Disbursements Control Groups record.

At this screen, the use of the MODE keys - ADD, DEL, CHG, or INQ - pertain to those records in the Disbursements Control Groups file.

The screen shown below presents information about Hand Checks.

Based on the ‘Apply Type’ and ‘Apply To’ entries, the system defaults entries from the corresponding unpaid invoices record. The entries that may be defaulted include ‘Dr Liability’, Discount’, ‘Cr Retention’, PO No’, ‘Description’, and ‘Liability Account.’

This file contains information that applies to the entire cash disbursement, such as vendor, date, check number, and amount.

Hand Checks screen

The Accounts Payable Hand Checks Screen
Figure 10

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press ENTER; the record will be displayed for editing.

Data items for the preceding screen are described below:

Transaction No

Positive number, up to 4 digits Display only

A sequential transaction number is supplied for each detail record. This number is printed on the journal and if General Ledger is part of your system it is posted to General Ledger for detail accounts. Although this number need not be exactly sequential, the number itself is important as a part of your audit trail. The transaction number is printed on many reports and inquiries throughout Accounts Payable.

Vendor

Upper case, up to 8 characters Scan available

Only number are acceptable.

Provide a valid vendor number from the Vendors file. The system displays the vendor name so that you can verify your entry.

If you enter a miscellaneous vendor number, the system displays an additional name field on the next screen where you should enter the miscellaneous vendor’s name. The miscellaneous vendor name will appear on the check journal as well as various reports and inquiries.

Check Date

Date (YMD) Required Carries forward in ADD mode

Supply the date of the check.

Check No

Positive number, up to 8 digits Scan by this field (access key)

Furnish the check number.

If you are entering a Void Check, the system uses the system uses the ‘Check No’ to supply the values for ‘Vendor No’, ‘Check Amount’, and ‘Description’.

Check Amount

Number, up to 7 digits and 2 decimals

Enter the amount of the check. For normal hand checks the amount is positive; for void checks enter a negative amount.

Description

Alphanumeric, up to 30 characters

Describe this particular hand or void check. For Void Checks, the system displays the vendor’s name. You may change this default.

Check Status

Positive number, 1 digit

Identify the current status of the check. The system defaults to ‘4’ during hand check entry and ‘8’ during void check entry. Valid choices are”

4
Hand check
8
Void check
Cash Account

Upper case, up to 12 characters Required Scan available

Designate the cash account which the check was written against. The cash account defined in the Parameters file is defaulted but may be changed. This account is credited by the amount of the check. The check amount for a ‘Void’ check is normally negative and thus a debit to the Cash Account.

If the General Ledger application is part of your system, the account number must be on file in the Chart of Accounts file. The system displays the account description so you may verify your entry.

Post Month

Upper case, up to 2 characters Letters and numbers only Valid: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, EY Required Carries forward in ADD mode

Identify the month to which these transaction are to be posted. The current month defined in the Parameters file is supplied. If you want to post to a prior or future month, you may change it . If your system is based on 12 accounting periods, enter the calendar month; if you are using 13-period accounting EY: End-of-Year

Post Year

Positive number, up to 2 digits Carries forward in ADD mode

Enter the year to which these transactions are to be posted. If you are using 12-month accounting, this is the calendar year; if you are using 13-period accounting, this is the fiscal year. The year defined in the Parameters file is supplied; if you want to post to a prior or future period, you may change it.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

  • ECannot Post to a Heading Account
  • ECannot Post to a Summary Account
  • ECannot Post to the 13th Month in a 12 Month Fiscal Year
  • ECheck No must be Entered
  • EInvalid Application Type
  • EStatus Must Be Either 4 (Hand) or 8 (Void)
  • WCheck Amount Has Not Been Entered
  • WHand Check Number Already on File in Outstanding Checks File
  • WMachine Check Number Already on File in Outstanding Checks File
  • WPost Month Is Previous to Parameters Calendar Month
  • WPost Year of Zero Will Post as the Year 2000

Press ENTER to display system-supplied information and then press ENTER again to continue to the next screen.

Select Previous Image to go back to the Disbursements Control Groups screen. Select Next Record to go to the next Disbursements record. Select End to go to the next Disbursements Control Groups record.

At this screen, the use of the MODE keys - ADD, DEL, CHG, or INQ - pertain to those records in the Disbursements file.

The screen below allows you to enter the miscellaneous vendor’s name. This screen appears only if you enter a miscellaneous vendor number on the check record.

Miscellaneous Vendor Name screen

The Accounts Payable Miscellaneous Vendor Name Screen
Figure 11

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press ENTER; the record will be displayed for editing.

Data items for the preceding screen are described below:

Miscellaneous Vendor Name

Alphanumeric, up to 30 characters

If you enter a miscellaneous vendor number, the system displays an additional name field after you complete the Hand Check or void Check information. Enter the miscellaneous vendor name which prints on the checks journal as well as various reports and inquiries.

Press ENTER to continue to the next screen.

Select Previous Image to go back to the Disbursements Control Groups screen. Select Next Record to go to the next Disbursements record. Select End to go to the next Disbursements Control Groups record.

At this screen, the use of the MODE keys ADD, DEL, CHG, or INQ - pertain to those records in the Disbursements file.

The screen shown below presents information about Hand Check Line Items.

This file contains cash disbursements line item information.

Hand Check Line Items screen

The Accounts Payable Hand Check Line Items Screen
Figure 12

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press ENTER; the record will be displayed for editing.

Data items for the preceding screen are described below:

Check Line No

Positive number, up to 4 digits

The system automatically numbers line items in sequence beginning with ‘1’. For machine checks, this number indicates the order in which the invoices will appear on the check stub. You may change this number.

Apply Type

Upper case, 1 character Numbers only Default 3 Required Carries forward in ADD mode

Identify the manner in which this payment is to be applied. The system displays the description so you may verify your entry. Valid codes are:

2
Prepayment - The disbursement is a prepayment.
3
Apply To Invoice - The disbursement applies to an outstanding invoice.
4
Apply To Retention - The disbursement applies to an outstanding retention invoice.
Apply To

Upper case, up to 8 characters Scan by this field (access key)

Supply the number of the invoice that is being paid by this check. If the disbursement is a prepayment (Apply Type 2), leave this field blank and enter the Apply To in the PO Number field. This PO number must also be identified on the invoice to which the prepayment applies, in order to track the prepayment properly. The Apply To should be used for both payments of existing liabilities and direct payments. If possible, this field is supplied for a void check entry.

Direct payments entered with an Apply To create a record of the disbursement and the purchase in various Accounts Payable history files. Thus, supplying an Apply To allows easier tracking and voiding of hand checks.

Dr Liability

Number, up to 7 digits and 2 decimals

If the hand check is written for an invoice which has been or will be entered through Invoice entry, enter the amount to be debited to the liability account. Otherwise, leave this field blank and enter a Direct Amount instead. This amount should be negative for void checks.

Discount

Number, up to 7 digits and 2 decimals

Designate the amount of discount earned or lost. The discount method is set up in your Parameters file.

If you are using the Discount earned (‘E’) method, enter the amount to be credited to the discounts earned income account, if any.

If you are using the Discount Lost (‘L’) method, enter the amount to be debited to the discounts lost expense account, if any.

Cr Retention

Number, up to 7 digits and 2 decimals

If applicable, enter the amount to be credited to the retention account.

PO No

Upper case, up to 8 characters

Provide the purchase order number which applies to the invoice being paid. If the disbursement is a prepayment, this PO number must also be identified on the invoice to which the prepayment applies in order to track the prepayment properly.

Description

Alphanumeric, up to 30 characters

Describe this payment. For payments of invoices previously entered into Accounts Payable, the system supplies the invoice description; you may change it. This description appears on all General Ledger posting detail and related reports.

Liability Account

Upper case, up to 12 characters Scan available Carries forward in ADD mode

For normal hand checks the liability account for the vendor from the unpaid invoices record is displayed. For void checks, the original liability account is displayed if available. You may change this default. If the General Ledger application is part of your system, this number must be on file in the Chart of Accounts file. The system displays the corresponding account description so you may verify your entry.

If you have entered a direct amount, erase the Liability Account field and supply a direct account below.

Retention Account

Upper case, up to 12 characters Scan available

Supply the number of the Retention Liability account to be credited by the Cr Retention amount. The Retention account entered in the Parameters file is defaulted but may be changed. If the General Ledger application is part of your system, this number must be on file in the Chart of accounts file. The system displays the corresponding account description so you may verify your entry.

Direct Amount

Number, up to 7 digits and 2 decimals

If this transaction is to be directly expensed (no liability is to be recorded) indicate the amount of cash to be applied as a direct disbursement or hand check. This field should only be used if there is no Dr Liability entry. The amount should be negative for a void check.

Subsidiary Type

Upper case, up to 2 characters Letters only

If you are entering a direct disbursement, the system displays the subsidiary type for the account, as defined in General Ledger. This reflects the subsidiary to which this line item will be posted.

If General Ledger is not part of your system, you may enter any value in this field. The transactions posted to various subsidiary types and codes can be printed on the Subsidiary Codes GL Distributions report on the Monthly Processing menu.

Subsidiary Code

Scan available

Enter an upper case alphanumeric field up to 16 characters in length.

For a direct disbursement only, supply a subsidiary code if this line item is to be posted to a subsidiary costing application. If the sub type is ‘GL’, it is assumed the transaction will flow through to General Subsidiary. You cannot enter a subsidiary code if the subsidiary type is blank; conversely, if the subsidiary type is not blank you must enter a subsidiary code.

The transactions posted with the various subsidiary types and codes can be viewed on the Subsidiary Code GL Distributions report on the Monthly Processing menu.

Direct Account

Upper case, up to 12 characters

You can use Scan to Search for an appropriate entry.

Supply the number of the offset (expense) account that is to be debited by the Direct Amount field. If the General Ledger application is part of the system, the account number must be on file in the Chart of Accounts file. The system displays the corresponding description so that you can verify your entry.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

E ‘Apply To’ must be blank for ON ACCOUNT Disbursements

  • EA GL Account Must Be Entered
  • ECannot Have Sub Code With Blank Sub Type
  • ECannot Have Sub Type With Blank Sub Code
  • ECannot Post to a Heading Account
  • ECannot Post to a Summary Account
  • EGL Account Has Not Been Entered for Direct Amount
  • EGL Account Has Not Been Entered for Liability Amount
  • EInvalid Application Type
  • ELiability and Direct Amounts Cannot Both Be Entered
  • EOnly One GL Account May Be Entered
  • EPO Number is Required for Prepayment Apply Type
  • ESubsidiary Code Not on Subsidiary Codes by Account File
  • ESubsidiary Code Valid Only With Direct Cash Disbursements
  • ESubsidiary Codes by Account File Does Not Exist
  • WA Payment Has Already Been Made For This Invoice
  • WCurrent Disbursement Already Exists for this Invoice/Vendor
  • WNo Liability or Direct Amount Has Been Entered
  • WProcessed Invoice Not on File
  • WUse PO Number for ‘Apply To’ if Apply Type is ‘Prepayment’
  • MLiability Account Set to Prepaid Account for Prepayments

Press Enter to display system-supplied information and then press ENTER again to save the information on this screen.

Select Previous Image to go back to the Disbursements screen. Select Next Record to go to the next Disbursements Line Items record. Select End to go to the next Disbursements record.

At this screen, the use of the MODE keys - ADD, DEL, CHG, or INQ - pertain to those records in the Disbursements Line Items file.