GUI Accounts Payable Check Run
Back to GUI Accounts Payable Check Run (feature table).
Back to Enhancement Details (feature list).
Vision GUI Path |
|
Related Vision GUI Path |
||||||||
|
|
Accounts Payable |
—> Cash Disbursement —> A/P Check Batch Inquiry —> A/P Batch History |
|
|
|
Vision Configuration —> Security Maintenance —> User Maintenance —> [Selected User] > Roles |
|||
|
|
|
|
|
|
Related Vision Back Office Functions |
||||
|
|
|
|
|
|
|
|
AUTO |
12.1.1.3 |
Bank Maintenance |
|
|
|
|
|
|
|
|
OP |
12.1.1.3 |
Bank Maintenance |
As of release 10.0, many accounts payable actions you previously performed through the Vision Back Office can be accomplished through the Vision GUI Accounts Payable tab. Note: To have access to the functionality described in this topic, at least one of your user roles must have the A/P CASH DISBURSEMENT job function. This job function is automatically included in the standard Accounts Payable Manager role. This topic contains the following: |
|
You cannot use both the Vision GUI and the Vision Back Office to work with cash disbursements functionality. The the Vision GUI cash disbursements functionality is equivalent to the Vision Back Office operations but the two sets of tools are NOT compatible with each other. Use one or the other but not both. For more information, see |
With release 10.0, these screens were added to the Vision GUI Accounts Payable tab, significantly expanding the accounts payable tasks you can accomplish via the Vision GUI. |
Screen |
Functionality Provided |
Cash Disbursement |
• Add vouchers with an open balance to an A/P check run batch and save it. • Add vouchers by date or discount date, and selected vendors. • Add vouchers by voucher number. • Add rebate vouchers by due date and selected vendors. • Remove selected vouchers from a batch. • Right-click options: • View (opens the selected voucher on the Voucher Inquiry screen). |
A/P Check Batch Inquiry |
• Display a list of vouchers on a specific batch for inquiry purposes. • View batch header information. • View individual voucher information. • Right-click options: • View (opens the selected voucher on the Voucher Inquiry screen). |
A/P Check Batch History |
• Display a list of existing batches for inquiry purposes. • Search for and list all batches meeting search criteria. • View batch header information. • Right-click options: • View (opens the selected batch on the A/P Check Batch Inquiry screen). • Edit (opens the selected batch on the Cash Disbursement screen). • Print Cash Disbursements Journal. • Print Checks. • Print Check Register. • Delete Printed Batch. • Post Batch. • Double-click opens the batch on the A/P Check Batch Inquiry screen. |
Note: Reports and checks print jobs are sent to the user’s spooler.
Back to Top
These topics provide information on how to create and edit an accounts payable check batch.
Because the options for selecting vouchers utilize several dates for filtering vouchers, the various date controls are defined here:
Location |
Control Name |
Control Type |
Definition |
|
Batch (Group Box) |
Payment Date |
Date Selector |
This is the date written on the check. It is also the date posted on the vouchers when you run the check batch. When you select the Payment Date, you will want to be aware of the varous discounts, net due dates, and so on. |
|
Add by Due Date (Panel) |
Date Type |
Group Box |
Groups two radio buttons used for filtering. |
|
|
Discount Date |
Radio Button |
Pay by this date to get a prompt pay discount. This is the date by which you must pay a voucher in order to get the prompt pay discount. Clicking this button will filter for vouchers that have a discount date on or before this date as represented by Date to Pay. |
|
|
Due Date |
Radio Button |
Pay by this date to avoid late fees. This is the date by which you must pay a voucher in order to avoid late fees. Clicking this button will filter for vouchers that have a due date on or before this date as represented by Date to Pay. |
|
Date to Pay |
Date Selector |
Filters vouchers by the Date Type selected. Selects all vouchers with a Discount Date or Due Date less than or equal to the Date to Pay and if they meet the other criteria, adds them to the voucher list when you click Add Vouchers. |
||
Add Rebates (Panel) |
Due Date |
Date Selector |
The date by which the rebate check must be printed. Selects all rebate vouchers with a due date less than or equal to this date and adds them to the voucher list when you click Add Vouchers.. |
2 Click Cash Disbursement. 3 Click New Batch. Note: Clicking New Batch clears all fields and vouchers from the list view and returns the screen to a fresh state with the Add By Due Date panel open. 4 Select the Company from the drop-down box. 5 Select the Bank. 6 Select the Fiscal Period. When you select the company, the system automatically sets this field to the current A/P fiscal period for the selected company. The system also loads the drop-down box with the company’s next three fiscal periods. For example, if the current fiscal period is 201209, the drop-down list also includes 201210, 201211, and 201212. ![]() Please see additonal information at below right. 7 Select the Payment Date using the date selection tool. |
![]()
|
|
Fiscal Period When you bring up an older A/P check batch on the Cash Disbursement screen the fiscal period is read-only. To view a screenshot of the read-only fields, refer to Edit an Existing Batch. |
Also, if the fiscal period of the older A/P check batch is already closed, then Vision displays a validation error when you try to save the batch. In this case, you will have to delete the batch and then recreate it with an open fiscal period. See Delete Batch. |
|
8 Exclude EFT Vendors from the batch. Put a mark in the check box to exclude vendors that are set up for Electronic Funds Transfer. Leaving the check box clear will include vendors set up for EFT if they meet the other voucher criteria you set. Note: Electronic Funds Transfer is a licensed feature. Currently, it supports the Royal Bank of Canada (RBC). Please contact your Epicor Vision sales representative for more information. 9 Multi-Company. Choose to include multiple companies in the batch by setting this check box. Note: All vouchers for a check run must be for the same company unless the consolidated disbursement flag is on for the bank. Regardless, the bank must be the same for all vouchers in the batch.
10 Continue with any combination of the following:
Back to Cash Disbursements Back to Top |
![]()
|
|
Multi-Company This check box is enabled depending on how the bank is set up. If the bank option, Consolidation Ind, is set to Yes, then this GUI option is enabled and it defaults to checked (set). When it is enabled and defaulted to checked (set), this setting allows the system to include vouchers for other companies if the companies are associated with the same bank and if the vouchers meet your other selection criteria. |
When it is enabled, you can choose to turn it off for the current batch by clearing the check box. Please note that if the bank option is set to No, the check box is always disabled and unchecked (cleared). The bank option, Consolidation Ind, is located in the Vision Back Office, here: • Auto & OP, 12.1.1.3, Bank Maintenance
|
To add vouchers by due date, do the following: 1 Perform step 1 through step 9 under 2 Click Add by Due Date 3 Select the Date Type. 4 Select the Date to Pay using the date selection tool. 5 Enter the Minimum Discount %. 6 Choose vendors for this batch. 7 Click Add Vouchers. The Vision system adds vouchers that match the selected criteria and which fit the Restrictions listed below right:
8 Continue with any combination of the following: Or, you can skip to Results to see what you can do with a populated voucher batch. Note: You can also add vouchers from the Accounts Payable —> Invoice History screen by right-clicking the voucher and selecting Back to Cash Disbursements Back to Top |
![]()
|
|
• Company for the voucher must match company for the batch unless Multi-Company is checked. • Bank for the voucher must match bank for the batch. • Fiscal period for the voucher must be less than or equal to fiscal period for the batch. |
• The voucher must have a non-zero balance. • The voucher is not included in another batch. • If Exclude EFT Vendors is checked (set), the vendor on the voucher must not be setup for EFT. For more information, see here. • The voucher must not be a rebate voucher.
|
To add vouchers by voucher number, do the following: 1 Perform step 1 through step 9 under 2 Click Add by Voucher Number. 3 Enter a valid Voucher Number that is not already included in another batch. The Vision system adds vouchers that match the selected criteria and which fit the Restrictions listed below right:
5 Repeat step 3 through step 4 as necessary. 6 Continue with any combination of the following: Or, you can skip to Results to see what you can do with a populated voucher batch.
Note: The image at right shows a voucher being added to an already populated voucher batch.
Back to Cash Disbursements Back to Top |
![]()
|
|
• Company for the voucher must match company for the batch unless Multi-Company is checked. • Bank for the voucher must match bank for the batch. • Fiscal period for the voucher must be less than or equal to fiscal period for the batch. |
• The voucher must have a non-zero balance. • The voucher is not included in another batch. • If Exclude EFT Vendors is checked (set), the vendor on the voucher must not be setup for EFT. For more information, see here. • The voucher must not be a rebate voucher.
|
To add rebate vouchers, do the following: 1 Perform step 1 through step 9 under 2 Click Add Rebates. For more information, see Date Table. 4 Select vendors from the scrolling list. The Vision system adds vouchers that match the selected criteria and which fit the Restrictions listed below right:
6 Repeat step 3 through step 5 as necessary. 7 Continue with any combination of the following: Or, you can skip to Results to see what you can do with a populated voucher batch. Note: The image at right shows rebates being added to an already populated voucher batch.
Back to Cash Disbursements Back to Top |
![]()
|
|
• Company for the voucher must match company for the batch unless Multi-Company is checked. • Bank for the voucher must match bank for the batch. • Fiscal period for the voucher must be less than or equal to fiscal period for the batch. |
• The voucher must have a non-zero balance. • The voucher is not included in another batch. • If Exclude EFT Vendors is checked (set), the vendor on the voucher must not be setup for EFT. For more information, see here. • The voucher must be a rebate voucher.
|
Once you’ve added vouchers to the batch, you can take the following actions Edit Columns The following columns are editable: • Disc Amt — lets you set a different discount. • Amt to be Paid — lets you set a partial payment. • Voucher Description — lets you enter a short description. (Not shown in image at right.) Remove Selected If the system selected vouchers that you don’t want in the batch, you can remove them. Just select them by clicking the check box to the left of the Voucher Number column. Then click Remove Selected. Save the Batch Click Save Batch when you are ready. You can bring the batch up again later to edit it. Start Over If you decide the results are not at all what you wanted, just click New Batch to start over. If you’ve already saved the batch, bring it back up on the screen and then click Delete Batch to remove the batch from the system.
Batch Total The batch total is a live value. It changes if you add or remove vouchers, change the Disc Amt or the
See also:
Back to Cash Disbursements Back to Top |
![]()
|
To edit an existing batch for which the checks have not been printed, do the following: 1 Click Accounts Payable.
Then Either 2 Click Cash Disbursement. 3 Click New Batch. 4 Enter the batch number of the batch you want to edit. 5 Click the Find
Or 2 Click A/R Batch History. 3 Perform a search as described under 4 In the results list view, find the batch you want to edit. 5 Right-Click on the batch and select Edit from the popup menu. The batch opens in the Cash Disbursements screen and is available for editing. Note: When an existing batch is opened for editing, the following fields and options are read-only: • Company • Bank • Fiscal Period • Payment Date • Exclude EFT Vendors • Multi-Company Everything else behaves as described under the following:
Back to Cash Disbursements Back to Top |
![]()
|
|
Delete Batch removes the batch from the system and frees all its vouchers so that they can be added to another batch. |
|
• After you void a check on the Accounts Payable —> Check Register screen, you must run the Vision Back Office check register and update function. This causes the Vision system to update all the vouchers that were to be paid by that check so that the vouchers have an open balance. Those vouchers are then available to be added to another check batch. The function is located here: • Auto menu 14.2.2.8 — Check Register/Hand Check To Voucher Register • OP menu 13.2.8 — Check Register/Handcheck To Existing Vouchers Register • When you delete a batch via the Delete Batch button on the Accounts Payable —> Cash Disbursements screen, all vouchers in the batch are updated so that they are free to be added to another check batch. • You can add open vouchers to a batch from the Accounts Payable —> Invoice History screen via the right-click options in the list view. • When you save a batch via the Save Batch button on the Accounts Payable —> Cash Disbursements screen, all vouchers added to the check batch are updated so that they cannot be added to another batch. This is true whether adding vouchers to a new batch or adding vouchers to an existing batch. • When you add a voucher to a batch and the voucher has a discount amount, the Vision system handles it as follows: If the Payment Date is greater than or equal to the Due Date, or the vendor has the Always Discount flag turned on and if nothing has been paid on the voucher yet, then the system calculates the amount to be paid as the gross amount minus the discount amount. If a partial payment has been made, then the system does not use the discount amount, and the system calculates the amount to be paid as the gross amount minus the amount already paid (including the discount taken). However, if the user changes the discount amount for a voucher in the list view, then the system adjusts the amount to be paid regardless of the Payment Date and the Due Date of the voucher. For additional information, see Date Table. • The Vision system does not display a discount amount in the list view on a partially paid voucher. • The Vision system excludes consignment vendors from the vendor list box on the Add by Due Date and the Add Rebates panels of the Accounts Payable —> Cash Disbursements screen. • You should not use both the Vision GUI and the Vision Back-Office Cash Disbursements functionality to print Accounts Payable checks. Use one or the other but not both. |
Back to Cash Disbursements
Back to Top
To view any existing check batch, do the following: 1 Click Accounts Payable. 2 Click A/P Check Batch Inquiry. 3 Enter a Batch Number. 4 Cliick Search. If the batch number is valid, the Vision system populates the screen with all the pertinent information, including a complete listing of the vouchers included in the batch as shown at right. Note: This view is read-only. |
![]()
|
Back to Top
To view any existing check batch, do the following: 1 Click Accounts Payable. 2 Click A/P Batch History. 3 Select the Batch Type: • All Batches • Unprinted Batches • Printed and Unposted Batches (that is batches that have been printed but not posted) • Posted Batches
4 Select the No. Items Filter. 5 Select the Batch Date Range. This drop-down list is enabled only when you select Max as the value for No. Items Filter. The Vision system presents the following options for date ranges for when the batch was created: • Previous Week • Previous Month • Previous 6 Months • Previous Year • All Dates • Custom Dates
When you select Custom Dates, Vision enables the date pickers for beginning and ending dates. 6 Select a Company Filter. 7 Select a Vendor Filter. 8 Enter a Voucher Filter. 9 Enter a Check Number. 10 Cliick Search. The Vision system populates the bottom part of the screen with a list of the batches that match the search criteria. |
![]()
|
Back to Top
Right-Click Options for Unprinted Batches View Opens the batch on the A/P Check Batch Inquiry screen. Edit Opens the batch on the Cash Disbursements screen. Print Cash Disbursements Journal The report breaks on vendor and totals by vendor, bank, and company. Print Checks Prints the checks in a batch. The process displays the next check number for the selected bank and lets you override by entering a different starting check number. When a vendor is set up for EFT, the system runs the EFT process. For more information about EFT, see here. Note: Reports and checks print jobs are sent to the user’s spooler. Back to A/P Batch History Back to Right-Click Options Back to Top |
![]()
|
Right-Click Options for Printed but Unposted Batches View Opens the batch on the A/P Check Batch Inquiry screen. Delete Printed Batch Deleting a printed batch that has not been posted allows you to recreate your cash disbursement batch and restart the print process in case the printer jams during check print. Print Check Register Prints the check register for a batch that has been printed but not posted. It does not update the batch. Post Batch Updates the batch and then posts it. This marks the vouchers as paid and creates CD (Cash Disbursement) journal entries in the general ledger. It also updates the Accounts Payable records for the vouchers so that the open balance is reduced by what is being paid in the batch. Note: Reports and checks print jobs are sent to the user’s spooler. Back to A/P Batch History Back to Right-Click Options Back to Top |
![]()
|
Equivalent Vision Back Office Functions
This table lists those Back Office functions that are now covered by the Accounts Payable GUI screens discussed in this topic.
Accounts Payable Vision Back Office Functions |
|
You cannot use both Vision GUI and Vision Back Office to work with Accounts Payable checks. You cannot use Vision Back Office functions to work with batches created with the Vision GUI Accounts Payable —> Cash Disbursement screen. As of the 5/19/2013 maintenance release of Vision 10.1, if you try to use any of the yellow-highlighted Vision Back Office functions (at left) on batches you created using the Vision GUI Accounts Payable —> Cash Disbursement screen, the Vision system displays a message telling you that you must use the Vision GUI Accounts Payable features. |
|||
|
AUTO |
14.2.2.3 |
Cash Disbursements (Emergency & Due Date) |
|
|
|
|
14.2.2.4 |
Cash Disbursements (Individual Voucher) |
|
|
|
|
14.2.2.5 |
Rebate Cash Disbursements |
|
|
|
|
14.2.2.6 |
Clear Check Print File (Restart New Run) |
|
|
|
|
14.2.2.7 |
A/P Check Print |
|
|
|
|
14.2.2.8 |
Check Register/Hand Check To Voucher Register |
|
|
|
OP |
13.2.3 13.2.4 13.2.5 |
Cash Disbursements (Emergency & By Due Date) Cash Disbursements (Individual Vouchers) Rebate Cash Disbursements |
|
|
|
|
13.2.6 |
Clear Check Print File - Used To Restart A New Cash Disbursement Run If A Check Register Was Not Printed. |
|
|
|
|
13.2.7 |
A/P Check Print |
|
|
|
|
13.2.8 |
Check Register/Handcheck To Existing Vouchers Register |
|
Note: Reports and checks print jobs are sent to the user’s spooler.
Back to Top