AP0301 Accounts Payable Recurring Voucher Processing

Recurring Voucher Processing

Application Overview

 

In addition to normal A/P activity, most companies have several payables that are due on a regular basis and for which there is no invoice and often not even a statement or any kind of reminder of when payment is due.  Such things include rent, loan payments, mortgage payments, lease payments and notes payable.  These payables can be handled in the Accounts Payable package using Recurring Vouchers.

 

Recurring Vouchers can recur in two different ways.  Either they are due on a specific day of the month (possibly every two or every three months) or they are due every so many days (possibly every 14 days or every 30 days).  These two types of recurrence are type M for monthly and type N for number of days.

 

Each recurring voucher has a starting date and an ending date.  The starting date is the date the first payment is due.  The ending date is the date of the last payment.  On some loans, there will be a certain number of payments at one rate and then more payments at another rate.  Two recurring vouchers could be set up with consecutive date ranges to handle the change in payment amount automatically.

 

Once the Recurring Voucher File is set up, all that remains to be done is to post the recurring vouchers to the A/P Transaction File on a regular basis.  These transactions are, in turn, posted to the A/P Open Item File, the same as the transactions entered through A/P Transaction Processing.  The vouchers can then be selected for payment and computer checks will be printed to pay them.

 

Even if Recurring Vouchers are not posted to the A/P Transaction File frequently enough, payments will not be skipped by the application.  The Post Recurring Transactions posting application will auto­matically create as many A/P transactions as needed to bring the payments up-to-date.

Run Instructions

 

Select Recurring Voucher Processing from the pull-down A/P Processing window.  The following screen will then be displayed:




Recurring Voucher Processing

 

 

The following options are available:

  • Select the desired mode from the Recurring Voucher Processing menu bar
  • Enter the data requested on the screen 

To exit press the ESC or F10 key when the cursor is positioned for entry of the first field on the screen.

 

To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

 

Entry Field Descriptions

 

Name

Type and Description

1.   Vendor No

6 alphanumeric characters.

 

Enter the vendor number of the vendor to whom payment will be due.  The vendor's name will be displayed automatically.

 

If you do not know the vendor number of the vendor you want, press the F7 key and a search for the vendor by number can be done or press the F8 key and a search by vendor name can be done.

2.   Recurring Id

4 alphanumeric characters.

 

This field defines the recurring vouchers for a vendor.

 

It is used to define one of several recurring vouchers for a vendor.

 

The default recurring ID is 1, so if you only have one recurring voucher for a vendor, use this default.

 

Pressing the F1 key will bring up the next recurring voucher for this vendor, in change and delete mode.

3.   Description

30 alphanumeric characters.

 

Enter a description of the recurring voucher.

 

For example, a recurring voucher might have a description Rent ‑ 2441 Honolulu Building.

4.   Type of Recurrence

1 alphanumeric character.

 

The valid values for this field are:

 

M  =  Monthly payment

N   =  Number of days between payments

 

If payment will always be due on a certain day of the month, even if there will be more than one month between payments, enter M.

     Type of Recurrence

If the payments are due every specified number of days (such as once every 30 days), then enter N.

 

There is no default for this field.  Once entered this field may not be changed.

5.   Interval

3 numeric digits (999).

 

If M was entered above, enter the number of months between each payment. If payment is due every month, enter 1. If payment is due every other month, enter 2. If N was entered above, enter the number of days between payments. If payment is due every week, enter 7. If payment is due every other week, enter 14. 

 

There is no default for this field.

6.   Starting Date

Enter a date in the standard date format.

 

Enter the date that the first payment is to be made.  If this is a type M recurring voucher, payments will always be due on the same day of the month as this date.

 

When this field has been entered, a description of when the payment is due will be displayed on the screen.  Take a look at this description to ensure that the data entered is correct.

 

This field defaults to the system date.

 

If this date is changed, the last voucher date will be set to zero.

Due

Automatically displays.

 

If field #4 Type Of Recurrence is defined as M (Monthly) and the Interval in field #5, is set at 1 (month), the system displays a starting date and automatically calculates the due date for every subsequent month thereafter.

 

If field #4 Type Of Recurrence is defined as N (Number Of Days Between Payments), and the Interval in field #5 is set at 1 (day), the system displays the starting date, and automatically calculates the due date for every day thereafter.

7.   Ending Date

Enter a date in the standard date format.

 

Enter the date that the last pay­ment is to be made or the date after which no payments should be made.  This date need not fall exactly on a payment date.

8.   Amount

9 numeric digits with 2 decimal places and an optional minus sign (9,999,999.99).

 

Enter the payable amount.

9.   Last Voucher Date

A date in the standard date format.

 

This field will be used by the package to keep track of the last voucher that was posted from this recurring voucher.

 

This field should be left blank when a new recurring voucher is entered in add mode.

 

If, for some reason, you wish to have the recurring voucher posting program skip a voucher or two, this can be done by setting this date to the date of the last voucher which should be skipped.  This would cause the system to think that vouchers had already been created up to this date, so it would skip them.

 

If this date is changed, the starting date will be updated to a date one interval following this date.

10.  A/P Account No

An account number in the standard account number format.

 

This field will only be entered if multiple A/P accounts are being used.  (See A/P Setup.)

 

Enter the A/P account (or any other liability account), which will be affected by the trans­action.

 

Pressing the F7 key will allow you to search for the account by number or pressing the F8 key will allow you to search for the account by name.

 

Defaults to the default Accounts Payable account number.

  
Distribution Screen

 

The vendor name and number and the description of the recurring voucher being entered or changed is displayed on this screen automatically.

 

Name

Type and Description

Account-No

An account number in the standard account number format.

 

Enter the account to which the expense distribution will be made when the recurring voucher is posted to the A/P Transaction File. The description of the account will be displayed.

 

Pressing the F7 key will allow you to search for the account by number or pressing the F8 key will allow you to search for the account by name. 

Amount

9 numeric digits with 2 decimal places and an optional minus sign (9,999,999.99‑).

 

Enter the amount, which is to be distributed to the account.

 

The total of all distribution amounts must be exactly the amount of the recurring voucher.

 

The amount remaining to distribute is displayed at the bottom of the screen and will be automatically updated after each distribution is entered.  You will not be allowed to leave this screen until the amount remaining to distribute is zero.

 

List

 

Name

Type and Description

Starting Vendor No

6 alphanumeric characters.

 

Enter the beginning of the vendor number range, which you wish to print on the report.

 

This field defaults to All.

Ending Vendor No

6 alphanumeric characters.

 

This field is not entered if All was selected above.

 

Enter the end of the vendor number range, which you wish to print on the report.

 

This field defaults to the starting vendor number to facili­tate printing the recurring vouchers for a single vendor.








Accounts Payable

  1. AP0000 Accounts Payable Overview
  2. What Is The Difference Between Payment Date and Check Date during Print AP Check?
  3. How to Purge AP Distribution to GL Report
  4. DYO (Design Your Own) AP Laser Check Design
  5. How Can I Get a List of New Vendors Set Up Since a Certain Date?
  6. Why Doesn't the System Print the Bottom Stub on My Design-Your-Own AP Laser Check?
  7. System Period Control Does Not Apply to Recurring Transactions
  8. AP Check History Report That Includes Voided Check
  9. ERROR 035 on AP TEMP CHK File
  10. Feature - Voucher Criteria On Vendor Account Summary
  11. Feature - Voucher Reference on A/P Distribution to G/L Report
  12. Feature - A/P Simple Trx Processing
  13. AP01S4 Accounts Payable Vendor Audit Trail Report
  14. AP05S1 Accounts Payable A/P Open Item Report
  15. AP07S1 Accounts Payable Cash Requirements Report
  16. AP08S1 Accounts Payable Pre-Check Writing Report
  17. AP08S2 Accounts Payable Post A/P Checks
  18. AP08S4 Accounts Payable Void Checks After Posting
  19. AP10S1 Accounts Payable Check Reconciliation Report
  20. AP11S1 Accounts Payable Check History Report
  21. AP13S1 Accounts Payable Vendor History Report
  22. AP22S1 Accounts Payable Purge AP Open Item File
  23. AP0200 Accounts Payable Post AP Transactions
  24. AP0301 Accounts Payable Recurring Voucher Processing
  25. AP0302 Accounts Payable Post Recurring AP Transactions
  26. AP0400M Accounts Payable Vendor Account Inquiry
  27. AP0601 Accounts Payable Open Item Adjustment
  28. AP0800 Accounts Payable Payment Preparation
  29. AP0900 Accounts Payable AP Distribution to GL Report
  30. AP1001 Accounts Payable Check Reconciliation
  31. AP1200 Accounts Payable Vendor Analysis Report
  32. AP1400 Accounts Payable Job Distribution Report
  33. AP1500 Accounts Payable Job Analysis Report
  34. AP1600 Accounts Payable A/P Setup
  35. AP1701 Accounts Payable A/P Account File Maintenance
  36. AP1801 Accounts Payable FOB Code File Maintenance
  37. AP1901 Accounts Payable Ship Via Code File Maintenance
  38. AP2001 Accounts Payable Job Code File Maintenance
  39. AP2100 Accounts Payable Print/Create 1099 Forms
  40. AP2300 Accounts Payable Clear Vendor YTD Accumulators
  41. APDISSCN Accounts Payable Distribution History Report
  42. APINVIMS Accounts Payable Invoice Import Utility
  43. AP0100 Accounts Payable Vendor File Maintenance
  44. AP0202 Accounts Payable Transaction Processing
  45. FULLPAY Accounts Payable Reset Fully Paid Status
  46. Feature - Default Value For Create Variance Prompt
  47. Feature - Assign Next Manual Check Number in Computer Check Printing
  48. Feature - Added First Bank Export Format to Checks History Export
  49. I Forgot to Clear the AP Vendor Paid Accumulators at Year End
  50. What If I Do Not Run AP Manual Check Register?
  51. Feature - Add Ability to Include or Exclude by Vendor Type for AP Checks
  52. How to Find a Voided AP Check in Check History Report
  53. What Are the Impacts of Purging Accounts Payable Old Inactive Vendors?
  54. Feature - AP Check History CSV Creation
  55. AP Laser Check Layout
  56. How to Apply AP Credit to Voucher When Credit Is Greater Than Voucher Amount
  57. Feature - Add Amigo Support to Additional Transactional Files

Feedback and Knowledge Base