APPX Software Library

1Transaction Processing

Option 1Invoices Entry

Use this function to enter and edit vendor invoices. If the Purchase Orders and Inventory applications are part of your system, invoices entry in Accounts Payable can only be used for non-inventoried purchases. Invoices entered through Invoices Rapid Entry may also be modified using this function. The following processing steps accomplish this job.

  1. Step 1This function identifies the application that created the invoice control group.
  2. Step 2Each group of invoices includes a control group record and a series of one or more invoices, each with any number of line items.

The normal process of posting invoices includes:

  1. Entering the invoices.
  2. Printing the Invoices Journal:.
  3. Posting the invoices.

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.

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

The screen below presents information about Invoices Control Groups.

When you enter invoices, you see only one of the two possible screens for Invoice 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 invoices. 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.

Invoice Control Groups screen

The Accounts Payable Invoice Control Groups Screen
Figure 3

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 invoices. 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. For invoices, enter the adding machine total of all invoice amounts to be entered. The system will display the running total of amounts entered in the “Current” field, and the balance remaining will be shown in the ‘Remaining “ field. This entry is optional.

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 and balance it against this entry. This entry is optional.

Print Journal?

Y or N Default N

The system displays indicates whether or not this group has been verified (the journal printed and no errors are present) and is correct.

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 Invoice Posting
  • EThis Control Group Must Be Edited In Its Original Application
  • 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 Invoices Control Groups record.

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

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

Invoice Operator ID screen

The Accounts Payable Invoice Operator ID Screen
Figure 4

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 Required Carries forward in ADD mode

Only number and letters are acceptable.

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 field, 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 Must Be Edited In Its Original Application
  • 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 Invoices Control Groups record.

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

The screen shown below presents information about Invoices.

This file contains information that applies to the entire invoice, such as vendor, invoice amount, invoice date, and due date.

Invoices screen

The Accounts Payable Invoices Screen
Figure 5

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.

Description

Alphanumeric, up to 30 characters Required

Describe this invoice. This description prints on the stub of machine checks as well as on various reports throughout Accounts Payable.

Transaction Type

Positive number, 1 digit Carries forward in ADD mode

The system defaults the transaction type of accounts payable invoice but you may override the display. Valid choices are:

1
AP Invoice
2
Debit/Credit Memo
Vendor

Upper case, up to 8 characters Scan available

Only number are acceptable.

Supply the number of the vendor responsible for this invoice. The system displays the vendor name so that you can verify your entry. If you enter a miscellaneous vendor number in standard Invoices Entry, additional name and address fields appear on the screen after you have completed the invoice information.

PO No

Upper case, up to 8 characters Scan available

If applicable, furnish the purchase order number. If you have the purchase Orders application and this is a valid PO number, you must enter the invoice through the Purchase Orders application.

If this invoice includes a prepayment, identify the PO number entered on the Hand Check Posted for the prepayment. This is necessary to ensure that the prepayment is tracked properly.

Pay Status

Upper case, 1 character Valid: N, T, H, D Default N Required

The vendor’s pay status is defaulted form the Vendors file. You may change this field if you wish to handle this invoice differently. Valid codes and Standard descriptions are:

N
Normal - Use the payment terms as defined in the terms file.
T
Take Discount - Take the discount regardless of the payment terms.
H
Hold - Place payment on ‘Hold’ until released by changing to ‘N’ or ‘T’.
D
Disputed - Same as ‘Hold’ status but payment is in dispute.
Invoice Number

Upper case, up to 8 characters Required

Supply the number of the invoice, debit memo, or credit memo.

Invoice Amount

Number, up to 7 digits and 2 decimals

Supply the amount of the invoice. The Invoice Amount is calculated as follows:

Amount = Subtotal - Prepayment + Freight + Tax + Other

For a credit memo, enter a negative amount.

Invoice Date

Date (YMD) Required

Supply the date of the invoice. This date is used to determine the due date of the invoice.

Apply To

Upper case, up to 8 characters Required

This field identifies the invoice to which this transaction applies. The system displays the invoice number in this field but you may override the display. In most cases, the invoice number and the Apply To are the same. If this is a debit memo or credit memo, however, the Apply To may refer to the invoice number of the original invoice that is being adjusted.

Prepayment

Number, up to 7 digits and 2 decimals

If applicable, enter the amount that was prepaid on this invoice. If a prepayment amount is entered, a purchase order number must also be entered. This amount is credited to the prepaid account identified in the Parameters file.

See Appendix A for further information about prepayments.

Invoice Due Date

Date (YMD) Required

The due date, based on the invoice date and terms for this vendor, is displayed. You may change this field.

Discount Basis

Number, up to 7 digits and 2 decimals

The amount used to calculate the invoice discount is supplied. Normally, this amount will be equal to the invoice subtotal. If, however, the invoice has a line item not applicable to the discount, for example, a freight charge, change this amount to reflect the total of the line items to which the discount does apply.

Discount

Number, up to 7 digits and 2 decimals

The discount amount is calculated and displayed based on the Discount % and Discount Basis fields. You may, however, change this amount. The Discount Amount is defined as:

Discount Amount = Discount Basis x (Discount % / 100)

Discount Due

Date (YMD)

The date of the last day of the discount period is calculated and displayed, based on the invoice date and terms for this vendor. You may change this field.

Discount %

Positive number, up to 2 digits and 3 decimals

The discount percentage is provided according to the terms set up for this vendor. However, you may change this value.

Freight

Number, up to 7 digits and 2 decimals

Enter any freight charges associated with the invoice. Any amount entered in this field is prorated over all the line items whose “Prorate?” field is set to ‘Y’.

Retention

Number, up to 7 digits and 2 decimals

The retention amount is calculated and displayed based on the Retention % from the Vendor master file and the Invoice Amount field from this entry. You may change this amount. The retention amount will be credited to the account entered in the ‘Retention Account’ field.

Other

Number, up to 7 digits and 2 decimals

If there are any miscellaneous charges that you want to be distributed over the line items, enter the amount in this field. Any amount entered here is prorated over all the line items whose “Prorate?” field is set to ‘Y”.

Tax

Number, up to 7 digits and 2 decimals

Supply the amount of any tax applicable to the invoice. Any amount entered in this field is prorated over all the line items whose “Prorate?” field is set to ‘Y’.

Warehouse

Positive number, up to 2 digits Scan available

Furnish the number of the warehouse to which the purchases were delivered. This number appears as the default when entering line items.

Subtotal

Number, up to 7 digits and 2 decimals Display only

The total of all the line items to be entered is calculated and displayed. The invoice subtotal is defined as:

Subtotal = Invoice Amount + Prepayment - Freight - Tax - Other

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

In ADD mode, this field will automatically be saved form one record to the next.

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.

Liability Account

Upper case, up to 12 characters Required Scan available

The liability account for this vendor is provided from the Vendors file. You may change this account number. If the General Ledger application is part of your system, the account number must be on file in Chart of Accounts file. The system displays the account description so that you may verify your entry.

Retention Account

Upper case, up to 12 characters Scan available

The Retention Account from the Parameters file is provided. You may change the account number. If the General Ledger application is part of your system, the new account number must be on file in the Chart of Accounts file. The system displays the description of this account so that you may 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:

  • ECannot Post to a Heading Account
  • ECannot Post to a Summary Account
  • ECannot Post to the 13th Month in a 12 Month Fiscal Year
  • EDiscount Date Must Be Entered When Discount Amount Is Entered
  • EInvalid Application Type
  • EInvalid Transaction Type; Non-PO Invoices Must Be Entered In AP
  • EInvalid Transaction Type; PO Invoices Must Be Entered In PO
  • EPO Number Must be Entered with a Prepayment Amount
  • EPurchase Invoices Must Be Entered In Purchase Order Application
  • EPurchase Order Detail File Does Not Exist
  • EPurchase Order Header File Does Not Exist
  • EPurchase Order Not on File
  • EVendor Number Does Not Match Vendor Number of Original PO
  • MUse Option 17 to Invoice a Complete Purchase Order
  • WDiscount Basis is Not Equal to Invoice Subtotal
  • WInvoice Date Comes After Discount Date
  • WPost Month is Previous to Parameters Calendar Month
  • WPost Year of Zero Will Post as the Year 2000
  • WProcessed Invoice Already on File (Vendor Invoice)
  • WProcessed Invoice Not on File (Apply To)

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

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

The screen below presents additional information about Invoices. It only appears if the entered vendor number represents a miscellaneous vendor.

Invoice Miscellaneous Vendor screen

The Accounts Payable Invoice Miscellaneous Vendor Screen
Figure 6

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:

Name

Alphanumeric, up to 30 characters

Enter the miscellaneous vendor’s name. This name is stored for printing on checks, reports, and inquiries.

Address - Line 1

Alphanumeric, up to 30 characters

This line is commonly used for the shipping address of the vendor.

Address - Line 2

Alphanumeric, up to 30 characters

This line is commonly used for the vendor’s mailing address.

City

Alphanumeric, up to 20 characters

Provide the city in the miscellaneous vendor’s address. If you want a comma(‘,’) to print after the city name, be sure to enter it here.

State

Upper case, up to 2 characters Letters only

Furnish the two-letter abbreviation for the state in the miscellaneous vendor’s address.

Zip

Upper case, up to 10 characters

Enter the miscellaneous vendor’s zip code.

Country

Alphanumeric, up to 20 characters

Designate the miscellaneous vendor’s country.

Press ENTER to continue to the next screen.

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

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

The screen shown below presents information about Invoices Line Items.

This file identifies and describes the invoice line items.

Invoice Line Items screen

The Accounts Payable Invoice Line Items Screen
Figure 7

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:

Line Item No

Positive number, up to 4 digits

The system automatically numbers line items in sequence beginning with ‘1’. You may change this number.

Quantity

Number, up to 7 digits and 2 decimals

Enter the number of units being purchased. If units don’t apply here, enter ‘1’. For a credit memo, enter a negative quantity.

Price

Positive number, up to 6 digits and 3 decimals

Enter the price per purchasing unit. If price per unit doesn’t apply here, enter the line item amount.

Amount

Number, up to 7 digits and 2 decimals

The system calculates and displays the line item amount based on the quantity and price, assuming that the two items are entered. This number is rounded to 2 decimal positions. Since the Amount, Quantity and Price are interrelated, if you change the Quantity or Price, the amount is recomputed. If you change the Amount field, the Price recomputed.

Item Code

Alphanumeric, up to 12 characters Scan available

Identify the Item associated with this line item. If you have the Inventory Control application, this code must be a valid item in the Products file. This field is not required.

If the item purchased is not inventoried in your Inventory Control application, leave this entry blank and enter the item code or item description in the ‘Description’ field.

Description

Alphanumeric, up to 30 characters

Describe the product. If an Item Code was entered for a valid inventory item, the item description from the Products file is displayed. You may override the display.

If your system does not include Inventory Control, you should provide a description of the purchase.

Offset Account

Upper case, up to 12 characters Required Scan available

Supply the offset account to which this line item is to be posted. For invoices and debit memos, this account is debited; for credit memos, it is credited.

If Inventory Control is part of your system and a valid item code was entered, the inventory account from the Products Class record is defaulted. Otherwise, the offset account entered in the Vendors file for this vendor is defaulted. In either case, you may override the display.

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.

Subsidiary Type

Upper case, up to 2 characters Letters only

The system displays the subsidiary type for the account, as defined in General Ledger. This reflects the subsidiary to which this line item will 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 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 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.

PO Line No

Positive number, up to 5 digits

Supply the purchase order line number for this line item. This field only applies if you are using the Purchase Orders application.

Whse (Warehouse)

Positive number, up to 2 digits Scan available

Designate the number of the warehouse to which the purchases on this line item were delivered. The warehouse entered on the previous invoice screen is defaulted but may be changed.

Prorate?

Y or N Default Y Required

Indicate whether or not freight, tax, and other amounts should be prorated to this line item. If this field is set to ‘N’, no amount is prorated to the line item nor is the line item amount included in determining the amount of proration for other line items. For example, if you wish to enter freight as a line item but do not want any tax, or other amounts prorated to the freight, set this field to ‘N’. If an amount is entered in any of the freight, tax, or other fields on the invoices screen, at least one line item must accept the proration amount. If no freight, tax or other amounts are entered, this field is ignored.

If you are using the Discounts Lost method, discount amounts are also prorated according to the above guidelines.

See Appendix A for a more detailed discussion of prorating.

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:

  • EAll product Invoices Must Be Entered In Purchase Order Control
  • EAmount Must Have The Same Numeric Sign As Quantity
  • 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
  • EInvalid Application Type
  • EInventory Parameter Record Not on File
  • EOffset Account Must Be Entered
  • EProduct Class Not on File
  • EProduct/Vendor Not on File - Use Option 17 to Create a Record
  • EProduct/Warehouse Not on File - Use Option 18 to Create a Record
  • EProducts File Does Not Exist
  • EProducts by Vendor File Does Not Exist
  • EProducts by Warehouse File Does Not Exist
  • EPurchase Order Line Number Not on File
  • EQuantity Times Price Exceeds Maximum Amount
  • ESubsidiary Code Not on Subsidiary Codes by Account File
  • ESubsidiary Codes by Account File Does Not Exist
  • MUse Option 17 to Create Prod/Vendor Records, Option 18 for Prod/Warehouse

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 Invoice screen. Select Next Record to go to the next Invoices Line Items record. Select End to go to the next Invoices record.

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