APPX Software Library

1Transaction Processing

Option 3Adjustments Entry

Use this function to enter and edit Accounts Payable Adjustments. Adjustments are entered to modify a previously posted invoice.

Each group of adjustments includes a control group record and a series of one or more adjustments.

The normal process of posting adjustments includes:

  1. Entering the adjustments.
  2. Printing the Adjustments Journal.
  3. Posting the adjustments.

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

The screen shown below presents information about Adjustments Control Groups.

When you enter adjustments, you see only one of the two possible screens for Adjustments 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 adjustments. 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?”, you see the second screen, which displays only the operator ID and the Control Number.

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

Adjustments Control Groups screen

The Accounts Payable Adjustments Control Groups Screen
Figure 13

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 adjustments. This number is printed on the journal, tracked on the Transaction control file, and if General Ledger is part of your system it is posted to General Ledger for detailed 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 adjustments.

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 adjustments. 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 adjustment entries are made. Enter the adding machine total of all adjustment amounts to be entered. The system displays the running total of amounts entered in the “Current” field, and the balance remaining is shown in the “Remaining” field.

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 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

The initial default is ‘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

This filed is 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 Adjustments Posting
  • EThis Operator’s Data May Not Be Edited - Posting Was Started
  • EYou May Not Change Data Entered By the Original Operator

Press ENTER to continue to the next screen.

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

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

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

Adjustments Operator ID screen

The Accounts Payable Adjustments Operator ID Screen
Figure 14

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 adjustments. This number is printed on the journal, tracked on the Transaction control file, 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 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 Adjustments Control Groups record.

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

The screen shown below presents information about Adjustments.

This file contains adjustments to an invoice balance. The GL distribution is always to the liability account in the amount of the adjustment, with an offsetting distribution to the account entered.

Adjustments screen

The Accounts Payable Adjustments Screen
Figure 15

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 form 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 doesn’t display additional name and address fields. Since you are applying the adjustment to a posted invoice, the system uses the miscellaneous vendor information entered for that invoice.

Apply To

Upper case, up to 8 characters

Supply the number of the invoice (or the Apply To if it is different than the invoice number) affected by this adjustment.

Invoice Type

Upper case, 1 character Numbers only Valid: 1, 2 Default 1 Required

Identify the type of invoice using one of the following codes:

1
Invoice
2
Retention Invoice
Amount

Number, up to 7 digits and 2 decimals

Enter the amount of the adjustment. This entry can be either negative or positive. A positive amount increases the liability, and a negative amount decreases the liability.

Adjust Date

Date (YMD) Required Carries forward in ADD mode

Today’s date is provided automatically. You may change this date.

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 transactions 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, enter the fiscal period. Your options are:

1
13: Calendar month, or fiscal period 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.

Offset Account

Upper case, up to 12 characters Required Scan available

Supply the offset account to which you want this adjustment posted. If the General Ledger application is part of the system, this account must be on file in the Chart of Accounts file. This system displays the description of this account so you may verify your entry.

If the amount entered is positive, the offset account is debited. If the adjustment amount is negative, the offset account is credited. See Appendix A for examples of the impact of adjustment postings on General Ledger accounts.

Liability Account

Upper case, up to 12 characters Required

You can use Scan to search for an appropriate entry.

The system automatically displays the liability account for the vendor you identified in the Vendor field. you may change this 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 description of this account so you may verify your entry.

If the adjustment amount is positive, the liability account is credited. If the amount is negative, this account is debited. See Appendix A for examples of the impact adjustment postings on General Ledger accounts.

Description

Alphanumeric, up to 30 characters

Describe this adjustment. This description will be printed on various reports throughout Accounts Payable.

PO No

Upper case, up to 8 characters

Designate the number of the purchase order for the adjustment. This field is for your information only; it has no affect on prepayments.

Wh Number

Positive number, up to 2 digits Scan available

If this adjustment is to affect inventory, supply the number of the warehouse where the affected item was delivered.

If this adjustment is to affect inventory, supply the number of the warehouse where the affected item was delivered.

Item Code

Alphanumeric, up to 12 characters Scan available

If this adjustment is to affect inventory, enter the code of the item whose cost are to be adjusted. If the Inventory Control application is part of your system, this code must be a valid item in the Products file.

Subsidiary Type

Upper case, up to 2 characters Letters only

The System displays the subsidiary type for the account as defined General Ledger. This reflects the subsidiary to which this adjustment post.

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

Upper case, up to 16 characters

Supply a subsidiary code if this adjustment 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.

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 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
  • ECannot Post to the 13th Month in a 12 Month Fiscal Year
  • EInvalid Application Type
  • EInventory Product/Warehouse Record Not on File
  • ESubsidiary Code Not on Subsidiary Codes by Account File
  • ESubsidiary Codes by Account File Does Not Exist
  • WAdjustment Amount Has Not Been Entered
  • WPost Month Is Previous to Parameters Calendar Month
  • WPost Year of Zero Will post as the Year 2000
  • WProcessed Invoice Not On File

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 Adjustments Control Groups screen. Select Next Record to go to the next Adjustments record. Select End to go to the next Adjustments Control Groups record.

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