Making Payments and Processing Checks Version

Contents

This topic discusses:

Links to related topics:

Search Online Doc
Current Release Notes

Overview of Payments and Check Processing

You can use the Accounts Payable invoices panels to manually pay approved invoices. However, a simpler method is to let the system handle the payments automatically. This section describes how to direct Accounts Payable to select invoices, generate payments, and process checks. You can create payments and process checks for a single organization, or for multiple organizations assigned to a payment group.

The discussion in this topic is split into two sections: Processing Payments, in which you select invoices to create a payment run, and Processing Checks, in which you generate checks. Several methods are available for check output--you can use the method that most suits your needs, or the vendors' preferences.

If you are using Consolidated Payment Exports, this topic explains how to process payments. However, you should also read the separate discussion Creating Payment Exports for a Bank's Integrated Payments System, because consolidated payment exports has setup steps, independent of payment processing.

Your organization may also use check requests. A check request triggers the creation of an invoice which can then be paid following the processes outlined in this topic. For details on check requests, see Check Request Processing.

Security

The role object that controls access to payment functions is "Payments," minimally set to View. To create payment runs, "Payments" must be set to Create. To delete payment runs, "Payments" must be set to All.

To work with checks, set the role object "Bank" to Modify.
To work with invoice groups, the role object "Invoicing" must be minimally set to View.
To work with custom exports, the role object "Administration" must be minimally set to View.
To view AP transactions for payment, the role object "APTransactions" must be minimally set to View.

Setup

Depending on the check output method that you use, you may need to select options on the Bank Account Edit panel, the Payment Profile panel, and the Vendor AP Location panel. You may also need to create a payment profile to associate with payment runs.

Check Output Methods

To select a check output option on the Bank Account panel:

  1. From the Accounts Payable Contents, select Bank Accounts.
    A list of bank accounts established for your organization appears.
  2. Locate the bank account of interest in the list (or click New if you wish to create a new bank account.)
  3. Click the edit icon next to the bank account.
    The Bank Account edit panel appears (Figure 1).

Figure 1 - Bank Account Edit Panel

  1. On the Bank Account edit panel, click the prompt next to Send AP Check Output To and select a check output method.
    - If you are using Consolidated Payment Exports, read the separate discussion Creating Payment Exports for a Bank's Integrated Payments System,
  2. Click Save.
  3. Click Submit.
    You are returned to the Bank Accounts list.

To specify a check output method on a payment profile:

  1. From the Accounts Payable main Contents, select AP Tables > Payment Profiles.
    A list of payment profiles appears.
  2. Locate the payment profile of interest in the list (or click New if you wish to create a new payment profile).
  3. Click the edit icon next to the payment profile.
    The Payment Profile edit panel appears (Figure 2).

Figure 2 - Payment Profile Edit Panel

  1. On the Payment Profile edit panel, click the prompt next to Send AP Check Output To and select a check output method.
    - For Consolidated Payment Export, see Creating Payment Exports for a Bank's Integrated Payments System,
  2. Click Save.
  3. Click Submit.
    You are returned to the Payment Profiles list.

To flag a vendor AP location for EFT/EDI 820 payments

Figure 3 shows the vendor AP Location edit panel.

Figure 3 - AP Vendor Location Panel

Notice the EFT/820 Location selection field. This field must be selected for EFT or EDI 820 payment processing. Enter the values for the vendor's EFT/820 Bank, Bank Account, and Bank Routing Number.

See Working With Vendor Information for details on editing vendor AP location records. For EDI 820 documents, see Using EDI 820 Payment Documents.

If you are using the consolidated payment exports feature, select the vendor's preferred Payment Method for the payments in the export file. See Creating Payment Exports for a Bank's Integrated Payments System. When an AP vendor location is set up for consolidated payment exports, all payments for the vendor use that method.

Making Payments and Processing Checks - The Big Picture

Below is the broad sequence of steps in creating payment runs and processing checks for the payments.

  1. Match the invoices to be paid
    Before you can make payments, vendors' invoices must be entered into the system and matched with receipts. The invoice must balance, and exceptions must be resolved. Invoice matching is discussed in detail in Matching Purchase Order Receipts with Invoices.
  2. Approve the matched invoices
  3. Build a payment run
    Building a payment run generates payments for selected invoices. You specify the criteria that the system uses to select the invoices. A payment run can contain multiple payments for a set of invoices -- for example, if the invoices are from different vendors -- or only one payment. Note that a payment run can contain as few as one invoice and one payment. Once the payment run is built, you can view and adjust any of the individual payments, or exclude payments.
  4. Commit to the payment run
    Up to the time when you commit to payment, you can make adjustments to the payments in the payment run. (For example, you can instruct the system to take an additional discount on an invoice.) After you commit to the payment run, you cannot edit or delete anything.
  5. Process the checks for exporting or printing locally.
    This step numbers the checks and either prints them locally, or makes them available for export.
    When you reach this point in your payments process, you can follow one of several paths, listed below. (For instructions, click the method that you use.)
  1. Mark the payment run as completed.
  2. Record the numbers of any unused checks.

Payment Run Steps

To approve an invoice group:

  1. From the Accounts Payable main Contents, select Invoicing in AP > Invoice Groups.
    - If you are working in Supply Chain (Materials Management), select Invoicing > Invoice Groups.
    The Quick Click menu appears.
  2. Under "I would like to..." select View the Invoice Groups List.
  3. Enter the Invoice Group ID and click Go. Or, click Show All to view all invoice groups.
    The Invoice Groups list appears (Figure 4). (The system displays No Data if no invoice groups exist.)
    - If you entered an Invoice Group ID, the group with that ID is first in the list.
    - If you clicked Show All, use the Position To box to find your invoice group in the list.

Figure 4 - Invoice Groups List

  1. Click the W to "work with" invoices in the invoice group. The Work With Invoice Group panel appears (Figure 5).

Figure 5 - Work With an Invoice Group

  1. On the Work With Invoice Group panel (Figure 5), select Complete This Group. (Completing an invoice group approves the group and makes the invoices available for payment.)
  2. Click Go. You are asked to confirm that you want to complete the group.
  3. Click Submit.
    You are returned to the Work With Invoice Group panel. The Status of the group changes to Approved. The invoices in the group can now be paid.

To build a payment run:

This section addresses payment runs for a single organization. It will be helpful, even if you are processing payments for multiple organizations, to review this section, since the process is similar in both cases.

  1. From the Accounts Payable main Contents, select Payments > Payment Runs.
    The Quick Click menu appears (Figure 6).

Figure 6 - Payment Run Quick Click Menu

  1. Select New.
    The Payment Run Parameters panel appears (Figure 7). Use this panel to select the invoices that you wish to pay.

Figure 7 - Payment Runs Parameters Panel

Enter information in fields marked with an asterisk (*). Use the other fields to specify your criteria for invoices that the system should select. For example, you may want to pay all invoices with four Discount Days Before the Payment Date. Or, you may wish to select invoices from a certain Vendor Group that have a particular Payment Priority. If you enter no selection criteria, the system includes all approved invoices for the Paying Organization in the payment run. (Click Help for detailed descriptions of fields.)

Payment Profiles

You may specify a Payment Profile for a payment run. Payment profiles are defined in the Accounts Payable Tables. A payment profile contains defaults for values such as check processing method. Payment profiles also define the characteristics of invoices selected for payment, for example:

You can create payment profiles and display existing payment profiles from the Accounts Payable > Tables. Figure 8 is an example of a payment profile.

Figure 8 - The Payment Profile Edit Panel

On the Payment Run Parameters panel, when you select a Payment Profile from the prompt, the system completes several fields with values from the payment profile. If the Vendor Pay-To Location uses EFT (electronic funds transfer) for payments, a payment profile is not required but can be used to provide default values.

Zero Dollar Check Run

The field Zero Dollar Check Run on the Payment Run Parameters panel (Figure 7) (and on the Payment Profile Edit panel - Figure 2) lets you specify how the system should handle payment runs that contain payments with a zero dollar amount. The setting of the Zero Dollar Check Run field takes effect when you Commit to a payment run.

- All payments not equal to zero are dropped (deleted). If, as a result, the payment run has no payments, the system automatically sets the payment run Status to Completed, and writes a system note.

- Payments that equal zero, but where the invoice count equals zero, are deleted.

- Zero dollar invoices are marked as "Paid in Full." No GL transactions are created for these payments.

- Invoices with a hold amount are not eligible for zero dollar check runs.

- Any payments with a zero dollar amount that remain on the payment run are processed as normal checks and can be printed and completed.

- All payments that are equal to or less than zero are dropped (deleted). If, as a result, the payment run has no payments, the system automatically sets the payment run Status to Completed, and writes a system note.

- Any payments with positive dollar amounts that remain on the payment run are processed as normal checks and can be printed and completed.

The Zero Dollar Check Run field appears on the Payment Runs list (Figure 11) and can be used to filter the list. The Zero Dollar Check Run also appears on the Work With Payment Run panel (Figure 9).

Tips for Using the Payment Run Parameters Panel
  1. Click Build.
    The system builds the payments and displays the Work With Payment Run panel (Figure 9). The Work With Payment Run panel shows the message "Build Payment Run Pending." Also, notice that checks from this payment run are destined for a local printer: Send AP Check Output To is set to "Printer." The value in this field could be "EFT Export", "Custom Export", or "Print Image Export" if any of those processing methods had been chosen.

Figure 9 - Payment Run Build Pending

  1. Click Refresh. When the build is complete, the message disappears, and the Payment Count field displays the number of payments (Figure 10) and the Invoice Count displays the number of invoices.

Figure 10 - Payment Run Build for Vendor 383

Notice that two payments were generated for six invoices.

To view a payment run on the Payment Runs List:

  1. From the Accounts Payable main Contents, select Payments > Payment Runs.
    The Quick Click menu appears (Figure 6).
  2. On the Quick Click menu, click Show All or enter the Payment Run ID of the payment run that you wish to view.
    The Payment Runs list appears. Figure 11 is an example.

Figure 11 - Payment Runs List

To modify the check processing output method:

The current check processing output format appears on the Work with Payment Run panel in the box next to Send AP Check Output To. You can change the check processing output method as long as the payment run is in Open, Selected, or Committed Status.

  1. From the Work with Payment Run panel, under "I would like to..." (Figure 12), select Modify Check Output.
    Go appears.

Figure 12 - The Work with Payment Run Panel with Modify Check Output Selected

  1. Click Go. The Modify Check Run Output panel appears (Figure 13).

Figure 13 - Selecting a New Check Processing Output Method

  1. Click the arrow next to Change Check Output To and select the new processing method from the drop list.
  2. Click Submit. The check output format is changed. The change appears on the Work with Payment Run panel in the box next to Send AP Check Output To.

To view invoices in a payment run:

  1. From the Accounts Payable main Contents, select Payments > Payment Runs.
  2. Select "View the Payment Runs List."
  3. Select Payment Run ID under "Ordered by..."
  4. Enter the Payment Run ID under "Starting With..."
  5. Click Go. The Payment Runs list appears with the Payment Run ID at the top.
  6. Click W to "work with" the payment run.
    The Work With Payment Run panel appears.
  7. Select View Invoices (see Figure 10).
    The list of invoices selected for the payment run appears (Figure 14).

Figure 14 - View Payment Run Invoices

Invoices with notes have "Yes" in the Invoice Notes column.

Taking Discounts on Invoices

Your site may have standard discount terms established for each vendor that you use. Discount terms specify the amount and/or percent of discount that you can take if payment meets certain criteria, such as being paid within a few days of the invoice date. Discount profiles are set up in your AP tables and associated with individual vendors. The Discount Amount column in the Invoices Selected list shows the available discount, if any. In Figure 14, no discounts appear.

If the payment run has a Status of Open or Selected, you can change the total payment for the invoice by taking any available discounts. For any particular invoice, an additional discount over and above any standard discount terms (if any) may be available. In this case, you will need to edit the invoice included in a payment run to specify the amount of additional discount that you can take.

To take or remove a discount:

  1. Follow steps 1 through 6 in To view invoices in a payment run.
  2. Review the Discount Amount column in the Invoices Selected list for the amount of discount available. If the amount appears in the Discount Taken Amount column, it is already included, and you do not need to do anything further unless you wish to decline the discount.
    - To decline the discount, click Menu > Remove Discount.
  3. Otherwise, next to the invoice, click Menu > Take Discount.
    You are asked to verify that you wish to take the discount (Figure 15).

Figure 15 - Verify Discount on a Payment Run Invoice

  1. Click Submit to take the discount.

To take an additional discount on an invoice:

  1. Follow steps 1 through 6 in To view invoices in a payment run.
  2. From the Invoices Selected list (Figure 14), click the edit icon next to any invoice or select Menu > Edit.
  3. Change the values in the following fields as needed: Amount to Pay for this Payment, Invoice Paid in Full, and Discount to Take for this Payment. (Essentially, at this point in the payment process, you can only edit the invoice to specify a discount.) Figure 16 shows an invoice from payment run 10283 being edited to include a discount of $7.00, taken from the total of $1188.00.

Figure 16 - Edit a Payment Run Invoice for Discount Information

  1. Click Save. The discount is shown in the Discount Amount Left to Take field.
  2. Click Submit. The Invoices list appears.
  3. Click Refresh. The system updates the Disc Taken Amount column for the invoice to include the discount.

To view payments in a payment run:

  1. Follow steps 1 through 6 in the procedure To view invoices in a payment run.
  2. Select View Payments from the Work With... panel.
    The payment or list of payments for the payment run appears, similar to the invoices list (Figure 14).
    Note that you can use the Menu next to any payment on the Payments list to designate invoices for exclusion/inclusion in the payment.

To exclude an invoice from a payment:

  1. Follow steps 1 and 2 in the procedure To view payments in a payment run.
  2. Next to any payment on the Payments list, click Menu > Select/Omit Invoices for Payment.
    The list of invoices for the payment appears. The first column of the list shows a select box containing a check. All the invoices are selected, by default.
  3. Click to uncheck the select box next to the invoice(s) that you wish to exclude. Rechecking an empty box includes the invoice.
  4. Click Finish Now or Finish Later. You are returned to the Payments list.
  5. If you clicked Finish Now, click Refresh on the Payments list.
    The Payment Amount column's value changes to reflect the excluded or included invoice(s).

When you are finished setting up the payment run to include all discounts and invoices, you can commit to the payment run. Once you commit to the payment run, you can no longer edit any of its invoices or payments.

To commit to a payment run:

  1. Follow steps 1 through 6 in To view invoices in a payment run.
  2. Select Commit Payment Run. Click Go. You are asked if you are sure that you wish to commit to the payment run.
  3. Click Submit. The Work With... panel shows the message "Commit Payment Run Pending" or "Commit Payment Run Running".
  4. Click Refresh. When the commit process is complete, the message disappears and Commit Payment Run is replaced with Print Checks.

At this point in the payment process, you can number and print or export the checks for the payment.

Voiding/Reinstating payments

You can void payments that are Completed (for which checks have been printed), if you need to. Also, you can reinstate a payment that you have voided. You can specify that you wish to reuse a check number when you void the payment, or later, if you wish.

To void payments:

  1. Follow steps 1 through 6 in To view invoices in a payment run.
  2. On the Work With... panel , select Void a Range of Payments..
  3. Click Go. The Void Range of Payments panel appears.
  4. Enter the range of checks that you wish to void in the appropriate fields. If you wish to void only one check, enter the check number in both the From... and To... fields. Note that you can also delete all the invoices associated with the checks (see Note below), and instruct the system to reuse the check numbers.
  5. Click Submit.
    If you have not deleted all the invoices associated with voided checks, the system asks you which invoices to delete, if any.
    Note: If you delete invoices, you will not be able to reinstate payments for those invoices, should you choose to do so.

Note: GL transactions created for void payments now recognize when payment is a Payment Method 3 ( credit card) and use the Credit Card Clearing account defined for the bank.

Did you forget to specify "reuse" the check number for a voided payment?

You can reuse the check number for a voided payment even if you did not check the reuse option when you were voiding the check.

Instruct ERP to reuse the check number as follows:

  1. From the AP main Contents, select Payments > Payments. The list of payments appears.
  2. Locate the voided payment of interest.
  3. Click W to work with the payment.
  4. On the Work With… menu, a new option Reuse Check Number appears (Figure 17).

Figure 17 - Reusing a Voided Check Number in AP Payments

  1. Click Reuse Check Number. The check number is available for reuse.

To reinstate voided payments:

  1. Follow steps 1 through 6 in To view invoices in a payment run.
  2. On the Work With... panel, select View Payments.
    The list of payments appears. Voided payments contain the word Voided in the Payment Status column.
  3. Next to the voided payment that you wish to reinstate, select Menu > Reinstate Payment.
    You are asked to verify that you wish to reinstate the payment, and keep the payment check number as it was.
  4. Click Yes.
    The payment is reinstated, and the Payment Status returns to Completed.

Creating Payments for Multiple Organizations

You can generate payment runs for multiple organizations at the same time. Multiple organizations are assigned to a payment group; then a payment run is created for the payment group. (This payment run is a payment group run.) The process has two steps:

For each organization in a payment group, you will need to assign a bank/bank account. You may wish to review the discussion of Check Output Methods that you can specify for bank accounts.

Note: The check output method Local Print (Print) is not supported for payment groups.

Payment group runs do not accommodate payment profiles. However, you can specify many of the same values that you use in your payment profiles on the payment group run itself.

Define Payment Groups

In creating a payment group, you first identity the group and select parameters for payment runs for the group. For example, you may wish to have a payment group that makes only EDI payments. You next assign organizations to the group. You can create multiple payment groups and you can assign an organization to more than one group.

To create a payment group

  1. From the Accounts Payable main Contents, select Tables > Payment Groups.
    The list of payment groups appears, if any have been created. Otherwise, No Data appears (Figure 18).
  2. Click New.

Figure 18 - Payment Groups List

The Payment Group Parameters edit panel appears (Figure 19).

Figure 19 - Payment Group Parameters Panel

  1. On the Payment Group Parameters panel, complete the fields that identify the payment group -- Payment Group and Description.
  2. Select the optional fields Check Print Order, Vendor Group, and others, as applicable.
    - If you select EFT/820 Only, the application will only let you include organizations in the group that are set up for EDI or EFT check method payments. The group will be exclusive for
    organizations that make EFT/EDI 820 payments.
    - If EFT/820 Only is not selected, you cannot include organizations set up for EDI/EFT check method payments.
    - Click Help for field information.
  3. Set the Status field to Active.

    In Figure 18, note that the user has defined a payment group that will collect invoices for vendors with a payment priority (Priority Test) greater than 2. (Payment Priority is set on the vendor AP Information panel.) You could, conceivably, create another payment group, assign it the same organizations as this group, but set a different Priority Test, or specify other parameters.
  1. Click Submit.
    The header information refreshes, and a list of organizations appears underneath (Figure 20). The list only contains organizations that are defined in the user's Data Profile.

  2. Select the organization(s) to include in the payment group by checking the Select box (Figure 20).
    - When the EFT/EDI 820 Only field is checked on the payment parameters panel, if you select organizations that use non-EFT/EDI Check Outputs, an error appears when you click Save.
    - If the EFT/EDI 820 Only field is not checked, you cannot select organizations with EFT/EDI 820 methods. An error message appears when you Save.
    - Also, organizations/banks/bank accounts whose Send AP Check Output To field is Printer are not available for selection.

Figure 20 - Payment Group Organizations for Selection

  1. Click Save and Submit. The application returns to the Payment Group List panel.
  2. Click Refresh to display the group you created (Figure 21).

    The payment group that you created is available for use in payment runs. You can also click New to create additional payment groups.

Figure 21 - Payment Groups List with New Group Added

Generate Payment Group Runs

Payment group runs are similar to regular, single organization payment runs. The following steps are highlights.

Note that you must have banks, bank accounts, and payment groups set up, and any vendor payment information specified on the vendor record's AP Information tab.

To generate a payment group run

  1. From the Accounts Payable main Contents, select Payments > Payment Group Runs.
    The list of Payment Group Runs appears, if any have been created. Otherwise, No Data appears.
  2. Select New.
    The Payment Group Run Parameters panel appears (Figure 22). Use this panel to select the payment group whose invoices you wish to pay.

Figure 22 - Payment Group Run Parameters Panel

  1. Enter information in fields marked with an asterisk (*). Use the other fields to specify criteria for invoices that the system should select for payment.

    If you have created payment runs for single organizations, this panel should look familiar. Several fields for particular attention are below.
    - Payment Group - Select a payment group from the prompt. The payment group is a group of organizations (with their associated banks and bank accounts) for which invoice payments are generated. Payment groups are defined in the AP tables. Payments are generated for all of the organizations in the selected Payment Group.
    - EFT/820 Only - When this box is selected, the payment run is for electronic funds transmission (EFT) or for EDI 820 payment documents.

    - Notice that payment profiles are not supported. However, you can include many parameters on this panel that you might normally put on a payment profile.
    - You can also specify values such as Priority Test, Due Days..., Discount Days.... and others on the Payment Group Edit panel for a payment group (see Figure 20). When values are specified for a payment group, the application populates the fields on the Payment Group Run Parameters panel with the values.

    -
    Click Help for more information about field values.
  1. Click Submit.

    The application looks for invoices for the payment run, builds the payments, and displays the Work With Payment Group Run panel (Figure 23). Payments are generated for approved invoices that belong to the organizations in the selected Payment Group, and satisfy other criteria specified on the Payment Run Group Parameters panel.
    - If no invoices meet the criteria, none are available for the payment run, the Invoice Count and Payment Count is zero.

Figure 23 - Work with Payment Run Panel

The menu under "I would like to..." lets you view payments, view invoices, take discounts, and exclude invoices from the payment run. These procedures are the same as those for single-organization payment runs, explained previously. Note that you cannot modify the check output format (as you can for single-organization payment runs).

You can also view the individual payment runs for each organization.

Figure 24 - Individual Payment Runs for Each Organization in a Payment Group Run

When you are finished setting up the payment run to include all discounts and invoices, you can commit to the payment run. Once you commit to the payment run, you can no longer edit any of its invoices or payments.

When the Commit routine finishes running, you can process checks for the payment group run.

Figure 25 - Processing Checks Menu Item on the Work with Payment Group Run Panel

The application displays organizations and payment information for check processing (Figure 26).

Details on check processing are in a subsequent topic.

Figure 26 - Processing Checks in a Payment Group Run

Check Processing Steps

Click on a link in the list below for processing instructions for your preferred check output method.

If you are using Consolidated Payment Exports, see the separate discussion Creating Payment Exports for a Bank's Integrated Payments System.

Processing Checks for Local Printing

This section describes how to print checks locally from the system. The Send AP Check Output To value on the Payment Run Parameters panel (Figure 7) is Printer.

To print checks locally for a payment run:

  1. Follow steps 1 through 6 in To view invoices in a payment run.
  2. Commit to the payment run.
    When the payment run commit is finished, the Work With... panel changes and Send AP Check Output To: Printer appears.
  3. Select Process Checks.
  4. Click Go.
    If you have not downloaded the Check Printing utility, you are asked if you would like to download it.

The Print AP Checks - Step 1 panel appears (Figure 27).

Figure 27 - Print AP Checks, Step 1

  1. Enter information on the Step 1 panel fields. A default printer location may appear in the Printer field. You can also select a printer. The printer that you select for the checks must be the printer that you load with the check forms.
  2. Click Submit.
    You may receive a security message asking you if you wish to install and run the Printer Security Control module.
    - Click Yes if you wish to install the module.
    - If you have not aligned the printer for a check run, the system sends you a message (Figure 28) suggesting that you run the printer alignment wizard.

Figure 28 - Printer Alignment Wizard Query Panel

Figure 29 - Printer Alignment Wizard

  1. The Print AP Checks - Step 2 panel appears (Figure 30).

Figure 30 - Print AP Checks, Step 2

A message below the Step 2 panel shows the printer that you have selected, the bank account, and the check numbers. Make sure that your check forms are loaded in the printer.

  1. Click Begin Printing Checks.
    The system sends you a message when printing is complete.
    - Click OK.
    When the checks are finished printing, the Print AP Checks - Step 3 panel appears. A message below the Step 3 panel asks if the checks printed correctly.
  2. Select the appropriate response for whether the checks printed correctly.

Figure 31 - Reset All Check Numbers

Figure 32 - Reset Some Check Numbers

Figure 33 - Print AP Checks, Step 4.

  1. Click Continue.
    You are asked if you want to complete the payment run (Figure 34).

Figure 34 - Complete the Payment Run?

  1. Click Complete.
    You are asked to verify completion of the payment run.
  2. Click Submit.
    The payment run is completed. The Status of the payment run - as shown on the Work With... panel - changes to Completed.
    At this point, you can record unused checks.

Making Quick Payments

If you need to enter an invoice into the system and create a check quickly, you can do so. The steps below outline the process, and refer to parts of earlier discussions. The steps below are useful for situations in which the invoice is not associated with any PO or receipt, such as invoices for small, unforeseen expenses or services.

Note: To use these steps, you must have invoice approval authority.

To pay a single invoice using a locally printed check:

Step 1 - Enter the invoice in the system.

- On the Distribution tab, you must enter a GL Account for the invoice expense.
- When you are finished entering information, click Save.
- Click Finish Now to approve the invoice.

Step 2 - Generate a payment record for the invoice.
Step 3 - Print the check.

Processing Checks for EFT Export

A vendor can request checks to be forwarded to a particular bank account using EFT. In this case, the EFT Location field is selected on the vendor's AP Location record. As discussed previously, a payment profile or a bank account record may also specify "EFT."

To process checks for EFT export:

  1. Build a payment run as described in Payment Run Steps.

Figure 35 - Building a Payment Run for EFT Export

The system builds a payment run (Figure 36). The invoices selected for the payment run are only for EFT vendors.

Figure 36 - An EFT Payment Run

  1. Commit to the payment run.
    The Work With Payment Run panel refreshes when the commit process has finished.
  2. Click Process Checks.
    The AP Checks EFT Export panel appears (Figure 37).

Figure 37 -The AP Checks EFT Export Panel

  1. Enter the starting check number for the payments.
  2. Click Submit.
    The EFT check export file is created.

You can view the EFT export files from the EFT Export List.
- From the AP Main Contents, select Imports / Exports > EFT Export.
- For any export line on the list, click Menu > Download to transmit the file.

Processing EDI 820 Payment Document - Summary

EDI 820 processing requires several setup steps, and is described in detail in Using EDI 820 Payment Documents. Once EDI 820 is set up, you can transmit payments to a vendor's bank account as EDI 820 documents.

If you use EDI 820 payments, you can set up a payment profile specifically for EDI 820. Payment Profiles contains the information.

Processing Checks for Export to Another Application

Hospitals that use external applications or service vendors to print large batches of checks may prefer to create a check image export file. The discussion below explains the process of creating a check image file for export.

To process checks for export:

  1. Build a payment run as described in Payment Run Steps.

Figure 38 - Building a Payment Run for Print Image Export

  1. The system builds a payment run (Figure 39).

Figure 39 - A Payment Run for Print Image Export

  1. Commit to the payment run.
    The Work With Payment Run panel is refreshed when the commit process has finished.
  2. Click Process Checks.
    The AP Checks Print Image Export Panel appears (Figure 40).

Figure 40 - The AP Checks Print Image Export Panel

  1. Enter the starting check number for the payments.
  2. Click Submit.
    The check image export file is created and put it in the export queue.

You can view the check image export files from the Check Export list.
- From the AP Main Contents, select Imports / Exports > Check Export. The list appears..
- Click Menu > Download Check File to transmit the file.

Processing Checks for Custom Export

If you need check files that contain specific information, perhaps tailored to your check output application, you may wish to generate custom export files for processed checks. Custom exports are .csv files that you create using Report Objects. (For checks, you would use the "Check Printing" Report Object.) Normally, you would define a custom export file for checks, and then re-use the custom export definition for checks in each payment run. The Payment Run ID field in the Check Printing Report Object specifies which payment run the system should use in each custom export.

When you process checks for custom export, you must create a payment run that has the Send AP Check Output To field set to Custom Export. You must also process checks for the payment run, even though you are creating an export file, because the processing step assigns check numbers.

To process checks for custom export:

  1. Build a payment run as described in Payment Run Steps.

Figure 41 - Building a Payment Run for Custom Export

The system looks for Approved invoices that have not been assigned to a payment run, and builds a new payment run (Figure 42).

Figure 42 - A Payment Run for a Custom Export

  1. Commit to the payment run.
    The Work With Payment Run panel is refreshed when the commit process has finished.
  2. Click Process Checks.
    The AP Checks Custom Export panel appears (Figure 43).

Figure 43 - AP Checks Custom Export Panel

  1. Enter the starting check number for the payments.
  2. Click Submit.
    The system assigns the check numbers and returns to the Work With Payment Run panel.

Building a Custom Export for Checks

A custom export file definition tool is provided for specifying what you wish to include in your check export files. Defining a custom export is much like defining a report: you identify the fields for the export file, specify their order, identify any that are selection fields, and so on. Once you have created the definition, you can create custom export files for payment runs. The steps below are a brief outline of the custom export definition process. See also: Creating Custom Reports.

To create a custom export definition and check export file:

  1. From the Accounts Payable main Contents, select Imports/Exports > Custom Exports.
    The list of custom exports appears.
  2. Click New.
    The Create New Custom Export panel appears (Figure 44).

Figure 44 - Create New Custom Export Panel

  1. Enter a title for the custom export.
  2. Click the prompt for the Report Object field.
    The Report Objects list appears.
  3. Select the "Check Printing" report object.
    The system enters "Check Printing" in the Report Object field (Figure 45)

Figure 45 - Create New Custom Export for Check Printing

  1. Click Next.
    The Custom Export Fields selection panel appears (Figure 46)

Figure 46 - Fields for Custom Export Definition

  1. Select the fields that you wish to include in the custom export file.

Important: Among the fields that you select, be sure to select the Payment Run ID field.

  1. Click Next.
    The Selection Fields panel appears (Figure 47).

Figure 47 - Custom Export Definition Selection Panel

This panel lets you order fields horizontally in the export file (Column Order), indicate which fields are selection criteria when the export is run, and specify the sort order. Click Help for details on using this panel.

Important: Notice that in Figure 46, Payment Run ID is a selection field. You should select Payment Run ID under Use as Selection Criteria. When you run the custom export definition, the system prompts you for a Payment Run ID. This way, you can generate export files for each custom checks payment run.

  1. Click Save.
  2. Click Submit.
    You are returned to the Custom Exports list.

Generating the Custom Checks Export File

  1. To build the custom checks export file, locate the custom export title on the Custom Exports list (Figure 48).
  2. Click Menu > Build Export. (Figure 48).

Figure 48 - Custom Exports Definitions List: Building the Check File

A prompt for the Payment Run ID appears (Figure 49)

Figure 49 - Print Report Panel for Creating Custom Checks Export File

  1. Enter the Payment Run ID for which you wish to create an export file.
  2. Click Submit.
    The system sends you a message when the file is created, and returns you to the Custom Exports List.
  3. Click Complete Reports to download your file.
    Note: If you have Pulse (the client "gateway") set up, you can also use the job scheduler to download the file automatically at a time you specify.

Auto-Generating Payment Check Numbers

Check numbers for an organization's payments can now be auto-generated. Auto-numbering avoids having to manually input the next check number for every payment run. An auto-numbering scheme can be set up for an organization's different banks, bank accounts, and payment methods. Check numbers can be auto-generated for all payment types; except, the Check Output Method Printer is not supported for payment groups.

With auto check numbering, each organization, bank, bank account, and optionally, payment method has an associated “next available” check number. The application automatically assigns this Next Check Number to payments in the organization's payment runs. In a payment run, as each check number is used, the next available check number is calculated by incrementing with a specified Increment By value. (The most common increment is one.)

The organization record must be flagged for auto-numbering of checks. You must also set up the Start Check Number and the increment for your default payment method for the bank(s) that you use. Additionally, you can set up auto-numbering for other payment methods: check, credit card/ACH, and local print. The Bank Accounts panels (Accounts Payable > Bank Accounts > Menu > Next Check Numbers) provide the setup fields.   

For a payment on a single invoice, the system default is to use an auto-generated check number, except when the Check Output Type is Print.

Users can override auto-generated numbers by entering a check number (on the Process Checks panel) that is greater than the default auto-check number. The entered check number will be incremented, and updated for the next check run.

Restrictions:
On the Work with Payment Run panel, when auto-generated check numbers are used, the menu option Record Unused Checks is not available. Autonumbered check numbers cannot be reused.

Setup for Auto-Numbering Checks

The organization record must be flagged for auto-numbering of checks, and the organization must have -- minimally -- a default starting check number and check number increment assigned. The auto-numbering scheme -- initial check number, increment, payment method, and final check number -- must be set up for the payment bank account.

Organization record
  1. From the Accounts Payable main Contents, select Tables > Organizations.
  2. Locate the organization of interest.
  3. Click the edit icon.
    The Organization Edit panel appears.
  4. Click the tab AP Info (Figure 50).

Figure 50 - Setting Auto Check Numbers on the Organization Record

  1. Select the field Auto Payment Check Numbers.
  2. Click Save and Submit.

Note: If the organization's Auto Payment Check Numbers field is selected, but no default check numbers have been assigned for the paying bank, an error occurs when payments are processed.

Bank Accounts

For each bank account/payment method combination that you use to pay checks, you set up beginning and ending check numbers. Minimally, you must set up default values. You can also set up values for different payment methods.

For example, imagine that you have set up a bank account to auto number checks for the Credit/ACH payment method. A payment run using that payment method is processing checks. The system will begin auto numbering with the Next Check Number available for the Credit/ACH payment method for the bank account. If no auto numbering were set up for the Credit/ACH payment method, the system would use the Next Check Number associated with the Default.

The Bank Account panels contain the auto numbering fields for checks.

To set up check auto numbering for a bank account
  1. From the Accounts Payable main Contents, select Bank Accounts > Bank Accounts.
    The list of bank accounts appears. Figure 51 is an example.

Figure 51 - List of Bank Accounts for an Organization

  1. Click Menu > Next Check Numbers next to the bank account that you wish to use for the payments. The list of Next Check Numbers panel for the bank account appears (Figure 52).

    The Item Key value is a concatenation of identifiers for organization, bank, bank account, and payment method. Values for the payment method -- the last integer after the | delimiter -- can be:
    0 - Default
    1 - Local Print
    2 - Check
    3 - Credit Card/ACH.

    In Figure 51, the final integer in the Item Key is a zero, so the Default value for the Next Check Number has been set up.

    Imagine that the user wishes to set up a value for Credit/ACH payments.

Figure 52 - List of Payment Types Set Up for Auto Check Numbering for a Bank Account

  1. Click New. The Next Check Number edit panel appears (Figure 53).

Figure 53 - Next Check Number Edit Panel

  1. Select a Payment Method. In this case, the user selects Credit Card/ACH.
  2. Enter a Start Check Number.
    The Start Check Number is the numeric value to be used to start auto numbering checks.
    The Start Check Number must be higher than the bank account's current highest check number.
    - If you don't know what the highest number is, enter a small value and click Save. An error message tells you the highest number; e.g., Figure 54.

Figure 54 - Start Check Number Needs to Be Higher

- Re-enter a number higher than the number in the message.

  1. Enter an End Check Value -- the last check number to be calculated via auto-numbering.
  2. Enter an Increment By integer. Typically, checks increment by one, but you can enter a different integer.
  3. Click Save. The system fills in a value for the Next Check Number.
  4. Click Submit.

When a payment run is ready to process checks, the system populates the Beginning Check Number for the payments.

Note for Administrators: System Keys

The values from the Bank Account panels for banks, bank accounts, organizations, payment methods, and check beginning/ending numbers, plus the increment, are stored as System Keys. (System Keys are accessible from the "Work in Administration" panels. The appropriate authorization is needed.) Once a payment run's processing is complete, the System Keys are updated with the correct Next Check Number.

If you change the Default check number in the Bank Account panels, the appropriate Key Value for checks is updated with the new check number.

Using Auto-Numbering when Processing Checks

Check processing with auto-numbering is the same as when you manually number checks, except that you do not need to specify check numbers for the check run. The beginning check number is filled in for you. Figure 55 is an example. The system automatically applies a check number from the parameters that you have set up in the bank accounts panels.

Figure 55 - Processing Auto-Numbered Checks in a Payment Run

How Auto-Numbering Works

When you process checks in a payment run, the system determines if the next check number already exists on a payment for the same organization, bank, bank account, and optionally, payment method. If a duplicate is detected, the check number is incremented according to the Increment By integer. The test is performed again until a unique check number can be assigned. That check number is incremented to create additional checks for the payment run.

When a payment run completes the processing of checks, the stored values for the organization, bank, bank account, and payment method are associated with the next check number available. This value becomes the Beginning Check Number for the next payment run (Figure 55).

Eventually, as you are processing checks in payment runs, you will reach the last check number associated with the End Check Value (Figure 54).
When this situation occurs, you will need to edit the Next Check Number panel and enter a new End Check Value.

Recording Unused Checks

Whether you process checks for export or print them locally, you may have unused checks in a check run, and need to record their numbers.
Note: If you are auto-numbering checks, unused checks do not apply: You cannot record any.

To record unused checks:

  1. Follow steps 1 through 6 in To view invoices in a payment run.
  2. On the Work With... panel, select Record Unused Checks (Figure 56).

Figure 56 - Work With Payment Run Panel: Record Unused Checks and Void a Range of Payments

  1. Click Go. The form for recording unused checks appears (Figure 57).

Figure 57 - Form for Recording Unused Checks

  1. Make corrections as needed to the check date.
  2. In the fields From Check Number and To Check Number, enter the beginning and ending checks in the range of unused checks.
  3. Click Submit.
    The system returns to the Work With... panel and runs the job to record the unused checks. You get a message that "Recording Unused Checks is Pending."
  4. When the job is finished running, clicking Refresh deletes the message.

You can void payments that are Completed, if you need to. Also, you can reinstate a payment that you have voided. For instructions on how to void and reinstate payments, see Voiding/Reinstating Payments.

Entering Handwritten Checks

From time to time, you may need to write checks by hand, and enter them into the system. You can use the Handwritten Checks feature to associate a manual check with an invoice.

To enter handwritten checks:

  1. From the Accounts Payable main Contents, select Bank Accounts.
    A list of bank accounts appears.
  2. Next to the bank account that you wish to use for the handwritten check, select Menu > Enter Handwritten Checks.
    The Create Payment panel appears (Figure 58).

Figure 58 - Create Payment Panel

  1. Enter information for the check.

Figure 59 - Handwritten Check Select/Omit Invoices for Payment Panel

  1. Select the invoice or invoices that you wish to pay with the check by clicking in the box in the first column of the Select Invoices panel. Note that boxes in the column Fully Paid are selected by default. If you wish to make partial payment, select the Fully Paid box for the invoice. (Selecting the box "unchecks" it.)
  2. Click Save.
  3. Click Finish Now to complete the payment. Or, click Finish Later to make the information available for finishing at another time. (See Incomplete Handwritten Checks.)
    To view the payment on the Payments list, from the AP main Contents, select Payments > Payments. The check number appears in the Check Number column and the Payment Status is Completed.

Incomplete Handwritten Checks

You may encounter situations in which you cannot finish a handwritten check immediately, but must come back to it later. The system keeps a record of your incomplete handwritten checks, and makes them available for you to finish or delete.

Note that both the AP Bank Accounts menu and the AP Table for Banks allow you to enter handwritten checks. The discussion below refers to Bank Accounts.

To complete or delete a handwritten check:

  1. From the Accounts Payable main Contents, select Bank Accounts.
    A list of bank accounts appears.
  2. Next to the bank account that you used for the handwritten check, select Menu > Incomplete Handwritten Checks.
    A list of incomplete handwritten checks for the bank account appears.
  3. Locate the check that you wish to complete or delete.
To delete the check

- Select Menu > Delete Incomplete Check.
You are asked to verify that you wish to delete the check.
- Click Submit. The check is deleted and disappears from the list.

To complete the check

- Click the edit icon, or select Menu > Edit.
The Select Invoices for Payment panel appears.
- Select the invoice that you wish to pay by clicking the box next to the Invoice Number.
The total amount of the invoice is entered in the Check Amount field by default.
- If you wish to make partial payment, enter the amount that you wish to pay in the Check Amount field.
- Enter any applicable discount amount in the field Discount Taken This Check.
- Click Save.
- Click Finish Now to complete the check. (When you click Refresh on the list of incomplete handwritten checks, the check disappears.)

Clearing Checks in Reconciling Bank Statements

Clearing checks is a part of bank reconciliation, and is available in the system AP. You can access a list of checks for each of your bank accounts from these areas on the AP Contents.

The discussion below uses the Bank Accounts panels to clear checks manually.

Note: You can also use the Cleared Checks Import function to clear checks automatically on import to the system. See Importing Cleared Checks .

To clear individual checks:

  1. From the AP main Contents, select Bank Accounts.
    The Bank Accounts list appears.
  2. Locate the bank account that you wish to reconcile.
  3. Next to the bank account, select Menu > Clear Individual Checks.
    A list of checks for the bank account appears.
  4. Enter the Cleared Date for the check. Figure 60 shows part of a list of checks to be reconciled, and one check being cleared.

Figure 60 - Clearing Individual Checks

  1. Select the box in the Cleared column next to the check.
  2. Adjust the amount of the check to be cleared by editing the Cleared Amount column.
  3. Click Save. The date appears in the Cleared Date column.
  4. Click Finish Now. You are returned to the Bank Accounts list.

To clear or "unclear" a range of checks:

  1. From the AP main Contents, select Bank Accounts..
    The Bank Accounts list appears.
  2. Locate the bank account that you wish to reconcile.
  3. Next to the bank account, select Menu > Clear/Unclear Range of Checks.
    The selection panel appears (Figure 61). Use this panel to specify the range of checks that you wish to clear or "unclear."

Figure 61 - Selection Panel for Clearing or "Unclearing" a Range of Checks

  1. In the From Check No field, enter the first check number in the range of checks that you wish to clear.
  2. Enter the last check number in the field To Check No.
  3. Select Clear Checks to indicate that the checks have cleared. Select Unclear Checks to designate previously "cleared" checks as "outstanding" again.
  4. Click Submit.
    You are returned to the Bank Accounts list and sends messages while the clear or "unclear" job is running.

Display Outstanding Checks

This utility is an alternative to the "Checks Outstanding" report so that users can generate an accurate list of outstanding checks, as of a particular date.

On the Bank Accounts list, you can access the list of outstanding checks from the menu.

To display a list of outstanding checks:

  1. From the Accounts Payable main Contents, select Bank Accounts.
    Locate the bank account of interest.
  2. Click Menu > Outstanding Checks By Date (Figure 62).

Figure 62 - The Bank Accounts List Menu

The system displays a panel for entering a Checks Outstanding As Of Date. Initially, the field is empty, and the list of outstanding checks is empty (Figure 63).

Figure 63 - The Bank Account Checks Outstanding Panel

  1. To display a list of outstanding checks -- not voided or cleared -- as of a particular date, select a date for Checks Outstanding As Of Date (Figure 64).
  2. Click Enter.
    The list of outstanding checks appears based on the selected date (Figure 64).

Figure 64 - List of Outstanding Checks for a Selected Date

Checks that have been voided or cleared after the selected date appear in the list, along with the outstanding checks. The voided date and year/period is displayed, along with the cleared date when relevant.

Checks that have been voided or cleared before the selected date are not in the list.

View AP Transactions for Payments

  1. From the Accounts Payable main Contents, select Payments > Payments.
    The Payments list appears.
  2. Use the Search function to locate the payment that you are interested in.
  3. Next to the payment, select Menu > View AP Transactions.
    The system displays the AP transactions associated with the payment.

Making payments to a group of OneTime vendors using a Payment Profile

This technique - outlined broadly below - can be used to pay a group of OneTime vendors, such as patient refund invoices (whose vendor is OneTime) that have been imported from another application.

Reports

Several reports are available to assist you in working with checks:

Check Register Summary - Displays check summary information including: check number, check date, payee, vendor number (for the payee), check amount, and the check was later voided, and whether the check was written manually.

Check Register Details - Displays check details including: bank and bank account, check number, date, amount, payee, payee vendor number, whether the check was later voided, whether the check was handwritten and invoice data (if relevant): the invoice number, invoice date, the outstanding amount, held amount, discount amount, and payment amount.

Checks Cleared Report - Lists checks that have cleared.

Checks Outstanding Report - Displays a list of outstanding checks for a period/year, including checks that were voided in a later period for the year.
To use this report, for Check Acct Year Period, enter a year and period in the format YYYYPP. (The field defaults to LE -- less than or equal to -- for the year you specify.)
When you run the report, voided checks are included.
Note: The report does not include payments of $0.00, nor payments where the check year and period are the same as the voided year and period.

Checks Voided Report - Displays voided checks.

To run the reports:

Handle Unclaimed Payments (Escheats)

Escheat refers to the power of a U.S. state to acquire title to property for which there is no owner. Typically a hospital has accounts payable checks that have not been cashed for a number of months. The hospital attempts several times to locate the payee; if unable to do so, the hospital is required to send the money to the appropriate state for the payee.

The escheat process lets you select uncleared checks based on a check date within a range of dates, a bank account, an organization, and a state. You can review the selections, and unselect any that are not relevant. You can then create escheats payments from the selected uncleared checks.

Security: The role object "Escheats" provides security for the feature.

Creating escheats is similar to creating payment runs. The Accounts Payable Payments menu (Figure 65) provides access to escheats processing:

Figure 65 - Accessing Escheats (Unclaimed Property Returns) Processing

To process unclaimed payments (Escheats):

  1. From the Accounts Payable main Contents, select Payments > Escheats. The list of escheat runs appears (Figure 66), if any exist. Otherwise, the Escheat Runs panel is empty, and "No Data" appears.

Figure 66 - List of Escheat Runs

  1. Click New.
    The Escheat Run Parameters panel appears (Figure 67). Enter values in the panel fields to select the uncleared checks for which you wish to create escheat payments.

Figure 67 - Escheat Run Parameters Panel

  1. Enter information in fields marked with an asterisk (*). Use the fields to specify your criteria for uncleared checks that the system should select. For example, in the Check Date fields, you may need to enter dates for uncleared checks of over 180 days, or for whatever timeframe is standard for your organization/state. Figure 68 is an example. (Click Help for detailed descriptions of fields.)

Figure 68 - Escheat Run Parameters Panel: Uncleared Checks Selected for a Six-Month Period

  1. Click Build.
    The system looks for uncleared checks in the timeframe that you specified and builds the escheat run. The Work With Escheat Run panel appears (Figure 69) and displays the message "Build Escheat Run Pending."

Figure 69 - The Work With Escheat Run Panel - Six Escheat Payments Selected

Figure 70 - Displaying a List of Escheats in an Escheat Run

  1. On the Work With Escheat Run panel (Figure 69), click Commit Escheat Run and Go.
    A confirmation panel appears.
    - Click Submit.
    The Work With Escheat Run panel is refreshed when the commit process has finished (Figure 71). The Status displays the value Committed.

Figure 71 - Work with Escheat Run: Committed Status

6. Click Create Invoices and Go (Figure 71) to generate invoices for the US states to which the escheat payment checks for the escheat run are to be sent.

A confirmation panel appears.
- Click Submit.
Click Refresh to refresh the Work With Escheat Run panel (Figure 71). The Status displays the value Completed (Figure 72). Invoices are created as Approved.

Figure 72 - Creating Invoices for Escheats

Figure 73 - Viewing Escheat Invoices

Notice that the Invoice Number for an escheat invoice contains the prefix "EC," that the Invoice Status is Approved, and that the Invoice Due Date is automatically set to one month from the Invoice Date.

Figure 74 - Escheat Run State Totals

At this point, you can proceed to generate payments for the escheats using payment processing and check processing.

For escheats, the payment method is either Local Print or Checks.

Editing Approved Escheat Invoices

Escheat invoices that have been approved can be edited. This feature makes it easier for sites that need to generate escheat payments in different formats; e.g., paper check, electronic transaction, etc. Also, it will allow sites to put approved escheats invoices “on hold” until payment is required.

To edit an approved escheat invoice,
  1. From the Accounts Payable main Contents, select Payments > Escheats. The list of escheat runs appears.
  2. Locate the escheat run of interest and click w to work with the escheats in the run. The Work with Escheat Run panel appears.
  3. Click View Escheat Invoices and Go to display a list of invoices in the run.
  4. Locate the invoice of interest and note its Invoice Number.
  5. Open the Invoice List in Accounts Payable (Accounts Payable main Contents > Invoicing > Invoices).
  6. Locate the approved escheat invoice using the Invoice Number you found in Step 4.
  7. Click Menu > Edit to edit the invoice.

Import and View Payments from an External Application

Payments made in an external system can be imported into ERP for viewing, avoiding the need to access the external system separately for payment information.

Accounts payable staff using ERP need to see invoices and payments that reside in an external system (such as Oracle and others). Normally, this task would require staff to access the external application to display payments. This feature lets you import payments into ERP for viewing, and avoids having to open the external payment application for the information.

A .csv file template is available for the payment imports. You can send the template to the external application's IT staff. Once the .csv file containing external payments is in a location on your network, you can upload the file, and import it into ERP. Payments made in the external system and invoice statuses are then available for inquiry in ERP. The import is the standard ERP import.

Note: Sites that export invoices to an external system for payment have the System Value Export Invoices to External System set to "on."
(Figure 75).

Figure 75 - Setting a System Value to Export Invoices to an External Payment System

Administration > System Values > edit > Other

File format and fields

Figure 76 contains the format and fields for the .csv payment upload file. You must save the file as a .csv. The last line of the file must contain EOF, by itself.

Figure 76 - Fields for the Payment Import .csv Upload File

Figure 77 is an example of a payment import file containing data. (Note: the data are displayed in Excel, but the file must be a .csv file.)

Figure 77 - A Sample Payment Import File Displayed in Excel

Upload process

Payments from an external application are imported using the standard import process.

  1. From the Materials Management main Contents, open Imports/Exports and Financials > Payment Import.
    You can also open the Payment Import list from Accounts Payable > Imports/Exports.
    A list of import appears, if any exist. Otherwise, No Data appears.
  2. Click New. The Import Panel appears (Figure 78).

Figure 78 - The Import Panel for Uploading a Spreadsheet of Payments

Materials Management main Contents (or GL) > Imports/Exports and Financials > Payment Import > New

  1. Enter the file that you wish to import in the File to Upload field.
  2. At this step, you have a choice. You can work through the import process in two stages or in one stage.
    If you have uploaded files to the application before, use the one-stage approach, as follows:

For new users of this feature, we recommend the two-stage import approach. The two-stage approach first loads the file and validates it.
Once the file has successfully loaded, you can process it manually to import it into the application.

Figure 79 is an example of the Payment Import list with several imported files. From the Menu, you can reprocess a file, open a file and view the import details, download a file to a network location, or delete a file.

Figure 79 - Payment Imports List

Materials Management main Contents (or GL) > Imports/Exports and Financials > Payment Import

Invoice and Payment Inquiry

For invoices whose payments are imported from an external system, the Invoice Inquiry panel contains a new tab: Payment Imports. This tab displays data from the import (Figure 80).

Figure 80 - Inquiring on an Imported Payment for an Invoice

Materials Management main Contents > Invoicing > Invoices > i

From the menu, you can review payments for the invoice lines (Figure 81). Notice in Figure 81 under Pay Action that one payment with check 124 was subsequently voided.

Figure 81 - Details of Inquiry on an Invoice with Imported Payment Information

Materials Management main Contents > Invoicing > Invoices > i >

You can display further details (Figure 82) by clicking View Import Details.

 

Figure 82 - Drill Down on Inquiry Details for an Imported Payment

Materials Management main Contents > Invoicing > Invoices > i > Payments tab > View Import Details