APBASE — Accounts Payable
Voucher entry and registers, unconfirmed A/P (UCAP) cost confirmation, check processing, vendor history, A/P distribution.
59 programs documented. Source: S:\Dept\Computer\Documents\PTIS2\AFTEC\APBASE.wpd, APBASEOVER.wpd, APBASE_evw.wpd (vendor manual; see Reading AFTEC Source for how to convert and how to tell what actually runs).
This is the vendor's designed behaviour
The manual describes what a program was built to do. PSI does not use all of it — the cost-accounting standards path is the clearest example. Always confirm against live data and the cataloged object before relying on it.
| Program | Title | Purpose |
|---|---|---|
ACHECKP | ACKNOWLEDGED BANK ENTRIES PRINT | A hard copy print of all Checks Acknowledged (Received) back from the Bank. |
APPEA | ACCOUNTS PAYABLE PERIOD ENDING ANALYSIS | A monthly hard copy reconciliation of accounts payable. The operator will be asked if the run is the last run of the month. |
APPURGEP | A/P VENDOR HISTORY PURGE PRINT | This report will print all vouchers that can be purged based on the following criteria: 1. The voucher was deleted prior to the Fiscal Period entered for purging. 2. |
APRESTART | DISBURSEMENTS/CHECK RESTART | This program allows the user to restart the whole payment cycle over again, as long as the Check Register has not been updated. If checks have been printed, they will automatically be recorded as voided checks in the system. |
APSCH | ACCOUNTS PAYABLE PAYMENT SCHEDULE | This report is a Cash Requirements report used to help in estimating and paying bills. |
BANKREC | BANK RECONCILIATION REPORT | Once the Monthly Check Statement is balanced, you can run this report which is your actual Bank Reconciliation. |
CDIN | VOUCHER DISBURSEMENTS ENTRY & MAINTENANCE | This program allows the user to do any of the following: 1. Add any Open Payable to the Disbursements File. 2. Remove any Voucher currently in the Disbursements File. 3. |
CDPRINT | VOUCHER DISBURSEMENTS JOURNAL | This report is a hard copy print of all vouchers now in the Disbursements File (DISBURSE). This report will alert the user if a negative check is going to print for a vendor. |
CDUPD | VOUCHER DISBURSEMENTS BY DUE DATE | This program is made up of 2 parts. The first is an update program which will automatically transfer all those Open Payables with a due date less than or equal to the Due Date entered to the Disbursements File (DISBURSE). |
CHECKACK | CHECK ACKOWLEDGEMENT ENTRY | This program allows the user to acknowlege a check. The following information is automatically displayed, once a valid Check Number is entered: PAYEE CHECK TYPE CHECK DATE BANK ACCT CHECK AMT CHECK STATUS IS THIS THE CHECK YOU… |
CHECKIN | CHECK ENTRY & MAINTENANCE | This program allows the user to enter and maintain checks in the system. They are posted to the accounts payable check reconciliation file (APCKREG). |
CHECKVOID | A/P CHECK VOID PROGRAM | This program allows the user to void a check. Once an existing Check Number has been entered, all information on the screen is displayed. IS THIS THE CHECK YOU WANT TO VOID ? (Y*/N): Y*** = Check will be set up for voiding. |
CKPRT | A/P CHECK PRINT | A forms print of checks of all payables set up for payment in the Disbursements File (DISBURSE). |
CKREG | ACCOUNTS PAYABLE CHECK REGISTER | A hard copy report of all Check Printed since the last time this report was run and updated. After the report has printed satisfactorily (did not jam in printer), the report can be updated. Three updates are involved: 1. |
DAPA | DETAILED ACCOUNTS PAYABLE AGING | This report shows detailed accounts payable aging information. |
DDJ | DAILY PURCHASE DISTRIBUTION JOURNAL | |
DEPIN | DEPOSIT ENTRY & MAINTENANCE | This program allows the user to enter and maintain deposits in the system. They are posted to the accounts payable check reconciliation file (APCKREG). |
DISBURSE.SUPP | VOUCHER DISBURSEMENTS PAYMENT SUPPRESSION BY VENDOR | This program will allow users to suppress payment of a range of vouchers at one time. |
GLPAPERS | G/L WORK PAPERS ENTRY AND MAINTENANCE | Up to 26 fiscal periods can be displayed and available for maintenance. These fiscal periods are whatever is currently defined on the Company Master File. |
GLPAPREP | G/L WORK PAPERS REPORT | This report will print all dollar activity per General Ledger account by Vendor. It will show up to 12 fiscal periods at a time. |
HDCHTRANS | PAYABLE TRANSFER TO HANDCHECK | This prorgram allows the tranfer of vouchers to hand checks. COMPANY This is displayed automatically, based on the company that the account is set up for. CHECK NUMBER The Check Number is a 6 digit entry. |
HDREG | ACCOUNTS PAYABLE HANDCHECK REGISTER | |
IVL | INACTIVE VENDOR LIST | A hard copy print of all Vendors who have a zero value in Invoiced Year to Date, Invoiced Last Year and Open Balance. |
MCKREG | MONTHLY A/P CHECK REGISTER | A Monthly hard copy listing of all Checks recorded during the month. After the report has printed satisfactorily (did not jam in printer), the Monthly Check File (MCKREG) will be cleared in preparation for next month. |
MCSTATE | MONTHLY BANK STATEMENT | Once all the checks have been ackowledged through the system, this hard copy report should exactly match the Check Statement from the Bank. If it doesn t either you are the Bank have made a mistake. |
MDJ | MONTHLY PURCHASE DISTRIBUTION JOURNAL | A Monthly hard copy listing of all General Ledger Distributions entered through the Voucher Preparation program. |
MISCIN | MISC BANK CHARGE ENTRY & MAINTENANCE | This program allows the user to enter and maintain miscellaneous charges in the system. They are posted to the accounts payable check reconciliation file (APCKREG). |
OCHECKP | OUTSTANDING BANK ENTRIES PRINT | A hard copy print of all Checks Outstanding (Open) with the bank. |
OPENPOCOST | OPEN PURCHASE ORDER COST LISTING | This report shows the cost of goods in the Open Purchase Order File (OPEN.PO.LINES), sub-totaled by general ledger category. Each category will start on a new page. |
RECVOUCHEM | RECURRING VOUCHER ENTRY AND MAINTENANCE | This program allows the user to enter recurring voucher master records into the Recurring Voucher Master file (RVOUCHER), where they may be reviewed before running the recurring voucher update. |
RECVOUCHEM.2 | RECURRING VOUCHER ENTRY AND MAINTENANCE | |
RECVOUCHUPD | RECURRING VOUCHER MONTHLY SET-UP UPDATE LISTING | This update is performed only for those recurring vouchers that have an update flag set to Y and have not been already updated for the fiscal period being run. |
RECVOUREG | RECURRING VOUCHER MONTHLY SET-UP PROOF LISTING | A hard copy listing of the Recurring Vouchers created from the RVOUCHER file. This should be used as a proof listing before running the update section. Each batch will go to a new page. |
TRANSACTEM | OTHER DIRECT CHARGE TRANSACTION CODE TABLE ENTRY AND MAINTENANCE | This program allows the user to enter and maintain the other direct charge transaction code table (APTRANSACTION). COMPANY NUMBER Entered by the operator, it must be a valid entry on the company master file (GL-COMPANY). |
TRANSREG | VOUCHER MAINTENANCE TRANSACTION REGISTER | A hard copy audit report of all changed or deleted Vouchers since the last time this report was run and updated. |
TRREG | A/P HANDCHECK TRANSFER REGISTER | A hard copy report of all Transferred Hand Checks entered since the last time this report was run and updated. After the report has printed satisfactorily (did not jam in printer), the report can be updated. |
UCAPADJ | UCAP ADJUSTMENT ENTRY | This program allows the user to adjust the quantity on unconfirmed accounts payable records. COMPANY NO This is entered by the operator and must be an existing Company on the Company Master File (GL-COMPANY). |
UCAPAUD | UNCONFIRMED ACCOUNTS PAYABLE FILE AUDIT LISTING | A hard copy listing of the Unconfirmed Accounts Payable Audit (UCAPAUDIT) file. |
UCAPCOST | UNCONFIRMED ACCOUNTS PAYABLE FILE COST LISTING | This report shows the cost of goods in the unconfirmed accounts payable records from the POHIST file, sub-totaled by general ledger category. Each category will go to a new page. |
UCAPCOST2 | UNCONFIRMED ACCOUNTS PAYABLE FILE COST LISTING BY GENERAL LEDGER NUMBER | This report shows the cost of goods in the unconfirmed accounts payable records from the POHIST file, sub-totaled by general ledger number. |
UNCNFDDJ | DAILY UNCONFIRMED DISTRIBUTION JOURNAL | |
VAR1 | INVENTORY POSTING VARIANCE REPORT | This report shows variances between purchase order material (or outside) costs and the confirmed costs entered during the Voucher Entry program (APBASE VOUCHEM). |
VAR2 | PURCHASE PERFORMANCE VARIANCE REPORT BY PART - STANDARD COST | This report shows cost variance information with respect to the standard cost. It is sorted by part number. |
VAR3 | PURCHASE PERFORMANCE VARIANCE REPORT BY PART - P.O. COST | This report shows cost variance information with respect to the purchase order cost. It is sorted by part number. |
VAR4 | PURCHASE PERFORMANCE VARIANCE REPORT BY VENDOR - STANDARD COST | This report shows cost variance information with respect to the standard cost. It is sorted by vendor number. |
VAR5 | PURCHASE PERFORMANCE VARIANCE REPORT BY VENDOR - P.O. COST | This report shows cost variance information with respect to the purchase order cost. It is sorted by vendor number. |
VAR6 | INVENTORY VARIANCE REPORT BY JOB | This report shows cost variance data sorted by part number. It is sorted by job number. |
VARREGCLR | VARIANCE REGISTER FILE CLEAR | This program will completely clear the Variance Register File (VARREG). This should be done only after all variance reports have been printed, as no other history is kept. All companies will be cleared at once. |
VENDHIST | A/P VENDOR HISTORY REPORT - PRINTER | A hard copy report of all Payable information on file. |
VENDINQ | A/P HISTORY BY VENDOR - SCREEN DISPLAY | This program displays the accounts payable history for an individual vendor. |
VOIDREG | A/P CHECK VOID REGISTER & UPDATE | A hard copy report of all Voided Checks entered since the last time this report was run and updated. After the report has printed satisfactorily (did not jam in printer), the report can be updated. Three updates are involved: 1. |
VOUCHEM | VOUCHER ENTRY AND MAINTENANCE | |
VOUCHEM.2 | VOUCHER ENTRY AND MAINTENANCE | |
VOUCHEM.3 | VOUCHER ENTRY AND MAINTENANCE | |
VOUCHREG | VOUCHER BATCH PROOF LISTING/UPDATE | |
VOUDISPLAY | VOUCHER HISTORY DISPLAY | The user can call up any existing open payable by either entering the correct Voucher Number or by entering a combination of the Vendor s Number and the Vendor s Invoice Number. |
VOUMAINT | VOUCHER MAINTENANCE | This program allows the user to make some changes on existing vouchers. |
VPCTEM | VENDOR PERCENT ALLOCATION TABLE ENTRY AND MAINTENANCE | This program allows the entry and maintenance of the Vendor Percent Allocation Table. This table is used to automatically distribute allocations during voucher entry (see APBASE VOUCHEM). |
VU | MONTH-END/YEAR-END VENDOR UPDATE | This program must be run at Month End and Year End in order to maintain the integrity of the Invoiced MTD, YTD and LYR buckets on the Vendor Master. |
Menu paths for this module are in pro3prog/MENUFILE. For the programs that actually execute and their source items, see Reading AFTEC Source.