CABASE — Cost Accounting
Job and WIP cost ledgers, cost roll-ups, overhead, labor posting, financial release/relief/close, MIL-STD labor reporting. The engine behind job costing.
108 programs documented. Source: S:\Dept\Computer\Documents\PTIS2\AFTEC\CABASE.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 |
|---|---|---|
CA1700 | EMPLOYEE RATE ENTRY AND MAINTENANCE | This program is used to set up a table for each employee that can be used to over-ride the employee s regular pay rate, (which is stored on the employee master file in the PAYROLL module). |
CA1702 | EMPLOYEE MASTER ENTRY AND MAINTENANCE | This program is a stripped down version of the standard employee master entry and maintenance found in payroll. |
CA1703 | EMPLOYEE MASTER SUPPLEMENT LISTING | This report shows data from the employee master file and the employee master supplement file that relate to cost accounting functions. |
CA1716 | JOB FILE ENTRY AND MAINTENANCE | This master file allows the user to set up a JOB number and the information associated with a JOB, including JOB notes. |
CA1718 | SOURCE INSPECTION CODE ENTRY AND MAINTENANCE | The source inspection table is a user defined code to be called for on a JOB record. Source inspection should indicate where the inspection is to be performed, ie; factory, customer site, etc. |
CA1719 | ACCEPTANCE POINT CODE ENTRY AND MAINTENANCE | The acceptance point table is a user defined code to be called for on a JOB record. Acceptance point is the point where the goods are accepted by the customer,ie; factory, customer site, shipper, etc. |
CA1720 | WORK CENTER TABLE ENTRY AND MAINTENANCE | The work center table is used to set all work centers for a company. A work center number is used by the PRO-III-PLUS system to schedule and plan production. It may be the same as the cost center number if desired. |
CA1721 | WORK CENTER TABLE LISTING | This program gives a hard copy listing of the work center master file (WOCE). |
CA1722 | SHIFT DIFFERENTIAL MASTER FILE ENTRY AND MAINTENANCE | This program allows the entry and maintenance of the shift differential master file (SHIFT.DEF). COMPANY NUMBER Entered by the operator, it must be a valid entry on the company master file (GL-COMPANY). |
CA1723 | SHIFT DIFFERENTIAL MASTER FILE LISTING | This report shows data from the shift differential master file (SHIFT.DEF). |
CA1724 | OPERATION CODE TABLE ENTRY AND MAINTENANCE | The operation table allows the user to define labor operations to be used in setting up standard and WIP routing records. The operation must exist in this table before those records can be entered. |
CA1725 | OPERATION TABLE LISTING | This program gives a hard copy listing of the operation master file (OPERATION). |
CA1726 | REWORK TYPE MASTER FILE ENTRY AND MAINTENANCE | This program allows the entry and maintenance of the rework type master file (REWORK). COMPANY NUMBER Entered by the operator, it must be a valid entry on the company master file (GL-COMPANY). |
CA1727 | REWORK TYPE MASTER FILE LISTING | This report shows data from the rework type master file (REWORK). |
CA1728 | JOB STATUS TABLE ENTRY AND MAINTENANCE | The JOB status table is a user defined code that is called for on the JOB master record. The code is designed to let the user customize simple english status reporting. |
CA1730 | JOB TYPE TABLE ENTRY AND MAINTENANCE | The job type code is a user defined code which is called out on the job master record. This code is used in two functions, for applying fixed overhead by job, and for sorting job in percentage completion analysis. |
CA1731 | JOB TYPE FILE LISTING | This program produces a hard copy report of all the job types on file. |
CA1732 | NON-LABOR TIME TABLE ENTRY AND MAINTENANCE | The non-labor time table allows the user to identify non-labor time, by cost center for easier labor ticket entry. For instance if cost center 1200 always breaks for coffee at 14:30 to 14:45 this is entered for the cost center. |
CA1734 | MACHINE MASTER ENTRY AND MAINTENANCE | This program allows the user to enter and maintain the machine master file (MACHINE). Machine numbers must be established here for use in the rest of the machine loading, usage, and maintenance history programs. |
CA1735 | MACHINE MASTER FILE LISTING | This report shows data on the machine master file (MACHINE), sorted by machine group. |
CA1736 | MACHINE GROUP ENTRY AND MAINTENANCE | This program allows the user to enter and maintain the machine group master file (MACH.GROUP). Machine group is a required entry on the machine master file (MACHINE). |
CA1738 | METHODS FILE ENTRY AND MAINTENANCE | This is a table program to store methods for use in routing note fields. COMPANY NUMBER Entered by the operator, this must be a valid entry on the company master file (GL-COMPANY). |
CA1739 | METHODS TABLE LISTING | This program gives a hard copy listing of the methods table master file (METHOD). |
CA1740 | STANDARD ROUTING ENTRY AND MAINTENANCE | This program allows the user to develop standard routings for two purposes. |
CA1741 | STANDARD ROUTING LISTING | This report is a hard copy listing of standard routings. Standard cost information is included with the actual routing details. Each routing will go to a new page. |
CA1743 | WORK-IN-PROCESS LABOR ENTRY AND MAINTENANCE | This program allows the entry of labor postings to the system. COMPANY NUMBER This field will be automatically displayed based on entry in the security subroutine. |
CA1744 | WORK-IN-PROCESS LABOR REPORT | This report is a hard copy listing of all labor entered in the batch file since the last labor update has been performed. It should be used as a proof report before the update is run, and saved as an audit trail after the update. |
CA1745.CA | WORK-IN-PROCESS COST ACCOUNTING LABOR UPDATE | This program performs the daily Cost Accounting Labor update. It will post all data in the labor batch file (LABOR) to the appropriate Cost Accounting and General Ledger files. |
CA1745.SF | WORK-IN-PROCESS SHOP FLOOR LABOR UPDATE | This program performs the daily Shop Floor Labor update. It will post all data in the labor batch file (LABOR) to the appropriate fields in the following files: Labor Detail History Job and Work-in-process Ledgers Work-in-process… |
CA1745C | LABOR AUDIT LISTING BY GENERAL LEDGER ACCOUNT | |
CA1746 | WIP ROUTING ENTRY AND MAINTENANCE | This program allows entry and maintenance of the WIPROUTE files. These routing files are the main source of control in the PRO-III-PLUS shop floor system. |
CA1747 | WIP ROUTING LISTING | This report is a hard copy listing of work-in-process routings. Each routing will start on a new page. |
CA1748 | WORK-IN-PROCESS LABOR PROOF LISTING | This report is a hard copy listing of all labor entered in the batch file since the last labor update has been performed. It should be used as a proof report before the update is run, and saved as an audit trail after the update. |
CA1750 | STANDARD ROUTING MACHINE WHERE-USED INQUIRY | This program allows the user to display which standard routing lines use a particular machine. |
CA1751 | STANDARD ROUTING TOOL WHERE-USED INQUIRY | This program allows the user to display which standard routing lines use a particular tool. |
CA1752 | STANDARD ROUTING MACHINE WHERE-USED REPORT | This report shows which standard routing lines use a particular machine. The standard routing part numbers, the line item numbers, operation numbers, work center numbers, and operation descriptions are printed. |
CA1753 | STANDARD ROUTING TOOL WHERE-USED REPORT | This report shows which standard routing lines use a particular tool. The standard routing part numbers, the line item numbers, operation numbers, work center numbers, operation descriptions, and tool quantities are printed. |
CA1762 | AVERAGE COST CHECK REPORT | This is a hard copy report of the part master cost file. It will list all parts that have a last to average cost variance greater than or equal to a percentage entered by the operator. This report may be run upon demand. |
CA1763 | PART SECONDARY COST ENTRY AND MAINTENANCE | The part secondary cost entry and maintenance screen contains the cost elements for the CURRENT STANDARD and UNIT LIFO costs. |
CA1764 | PART SECONDARY COST LISTING | This is a hard copy report of the part secondary cost file. It will list all the information associated with the current standard and lifo costs. |
CA1766 | LOTHIST COST AUDIT REPORT | This report shows all entries made on the LOTHIST.AUDIT file since it was last cleared. These represent cost postings to LOTHIST other than those derived normally by the system. |
CA1768 | OUTSIDE OPERATION RECEIPT REGISTER | This program updates the outside cost section of the cost accounting WIP ledgers and job ledgers. It also calculates the outside overhead and posts it to the general ledger. |
CA1770 | STANDARD ROUTING COST ROLL-UP | This program will calculate labor and overhead standard costs by part based on the standard routing file, and post the amounts to the incremental fields on the cost file. |
CA1771 | BILL-OF-MATERIAL COST ROLL-UP | This program will total costs on a bill-of-material and post them to the cumulative cost fields on the part master cost file (ITEMCA). |
CA1772 | STANDARD TO LAST COST TRANSFER | This program will transfer standard cost fields into their respective last cost fields, or from last to standard, or from standard to current standard, or from current standard to standard. |
CA1773 | MATERIAL OVERHEAD COST CALCULATION | This program will calculate material overhead costs for parts, based on the material overhead percentage for their respective cost classes. |
CA1774 | OPEN PURCHASE ORDER COMMITTED DOLLARS ROLL-UP | This program will select all open purchase order line items, calculate the dollar amount committed on a work order by work order and job by job basis, and post the totals to the open P.O. |
CA1775 | WORK-IN-PROCESS FINANCIAL RELEASE | This program releases work orders financially. It sets the financial status flag on the OPENWO file to 1, and generates standard costs on the WIPBMFCOST and WIPROUTE.COST files. |
CA1776 | WORK-IN-PROCESS FINANCIAL CLOSING UPDATE | This report gives a hard copy listing of work orders that have been financially closed (see CABASE CA1793) but not financially updated. |
CA1776GL | WIP FINANCIAL CLOSE REGISTER & UPDATE - GENERAL LEDGER RECAP | |
CA1777 | WORK-IN-PROCESS LEDGER STANDARD COST ROLL-UP | This program takes the standard costs and hours generated by the financial release program (CA1775) and rolls them up into the various WIPLEDGER files. |
CA1778 | JOB LEDGER COST ROLL-UP | This program takes the standard costs and hours on the various WIPLEDGER files and rolls them up into the corresponding JOBLEDGER files. Option to run for a selected range of companies. |
CA1779 | JOB LEDGER STANDARD COST STREAM ROLL-UP | This program is a combination of the financial release, WIPLEDGER roll-up, and JOBLEDGER roll-up programs (CA1775, CA1777, CA1778). Option to run for a selected range of companies. |
CA1780 | SINGLE LEVEL BILL OF MATERIAL COST LISTING | This is a hard copy listing of a single level bill of material with costs. Each assembly will go to a new page. This report may be run upon request. |
CA1781 | INDENTED BILL OF MATERIAL COST LISTING | This is a hard copy listing of an indented bill of material with costs. It will be indented based on the product structure. This report may be run as required. Each assembly will go to a new page. |
CA1782 | SUMMARY BILL OF MATERIAL COST LISTING | This is a hard copy listing of a summary bill of material with costs. It will search out all lower levels and combine total usage for a part on one line, and extend the cost by usage. |
CA1783 | SINGLE LEVEL WHERE-USED COST LISTING | This is a hard copy listing of a single level where-used, with costs. It will search the file for all assemblies one level up. Each new component will go to a new page. This report may be run as required. |
CA1784 | INDENTED WHERE-USED LISTING | This is a hard copy listing of an indented where-used with costs. It will search the usage of a component on all assemblies, all levels up. Each new component will go to a new page. This report may be run as required. |
CA1786 | ALTERNATE ROUTING COST ROLL UP | This program will calculate labor, outside and overhead costs for routings and alternate routings. These amounts will be posted to the cooresponding fields on the routing cost file (ROUTECOST). |
CA1787 | ROUTING COST ENTRY AND MAINTENANCE | This program allows entry and maintenance of the ROUTECOST file. These costs can be automatically calculated by the routing cost roll up program (CA1786), or entered here. |
CA1788 | ROUTING COST LISTING | This is a hard copy report of the routing cost file (ROUTECOST). It will list the incremental costs for the routing. For alternate routings, the standard routing cost will be listed for comparison. |
CA1790 | WORK ORDER PERCENTAGE COMPLETION TABLE ENTRY AND MAINTENANCE | This program allows the entry and maintenance of the WO.PCT.COMP file. This file is used by the Work Order Percentage Completion report. |
CA1791 | JOB PERCENTAGE COMPLETION TABLE ENTRY AND MAINTENANCE | This program allows the entry and maintenance of the JOB.PCT.COMP file. This file is used by the Job Percentage Completion report. |
CA1792 | WORK IN PROCESS RELIEF ENTRY AND MAINTENANCE | This program allows entry of Work-in-Process Costs Releif, by fiscal period. These relief costs are shown in the Work-in-Process Cost Analysis Report. |
CA1793 | WORK IN PROCESS FINANCIAL CLOSE | This program allows the user to mark a work order as financially closed. After marking the work order, the WIP Financial Closing Update program must be run for the close to take affect. |
CA1794 | WIP LEDGER STANDARD COSTS ENTRY AND MAINTENANCE | This program allows the user to enter and maintain standard costs on the WIPLEDGER files. Either incremental or sub-assembly standards may be maintained. |
CA1795 | CUMMULATIVE JOB LEDGER STANDARD COSTS ENTRY AND MAINTENANCE | This program allows the user to enter and maintain standard costs on the JOBLEDGER files. |
CA1796 | WIP COST SUMMARY DISPLAY | This program displays cost data for a work order, with break-downs within the categories of material, labor, outside, and accounts payable costs, as well as sub-totals and grand-totals. |
CA1797 | CUMMULATIVE JOB COST SUMMARY DISPLAY | This program displays cost data for a job, with break-downs within the categories of material, labor, outside, and accounts payable costs, as well as sub-totals and grand-totals. |
CA1798 | WORK-IN-PROCESS COST SUMMARY | This report shows, for a given fiscal period, a detailed break-down of costs for a work order within the categories of material, labor, outside costs, and accounts payable costs, labor hours, as well as sub-totals and… |
CA1799 | CUMMULATIVE JOB COST SUMMARY | This report shows, for a given fiscal period, a detailed break-down of costs for a job within the categories of material, labor, outside costs, accounts payable costs, labor hours, and inventory costs, as well as sub-totals and… |
CA1800 | INVENTORY VALUATION REPORT BY PART BY LOT | This report shows the inventory valuation based on the part lot cost stack. An option to suppress the lot detail is given. |
CA1801 | INVENTORY VALUATION REPORT BY LOCATION BY PART BY LOT | This report shows the inventory valuation based on the part lot cost stack. An option to suppress the part detail or the lot detail is given. |
CA1802 | INVENTORY VALUATION REPORT BY JOB BY PART BY LOT | This report shows the inventory valuation based on the part lot cost stack. An option to suppress the part detail or the lot detail is given. |
CA1810 | WORK ORDER PERCENTAGE COMPLETION REPORT | This report shows the summary progress to date for work orders, in terms of the percentage of work completed and how this compares to the standard. |
CA1811 | JOB PERCENTAGE CUMMULATIVE COMPLETION REPORT | This report shows the summary progress to date for jobs, in terms of the percentage of work completed and how this compares to the standard. |
CA1812 | PERCENTAGE COMPLETION ROLL-UP | This program rolls the percentage completion figures for work orders into the percentage completion figures for jobs. |
CA1820 | WORK-IN-PROCESS MATERIAL SUMMARY | This report shows the summary activity for material issued to a work order. It compares actual costs to the standard using the lot numbers issued on a cost basis (i.e., the lot numbers found on the WIPBMFCOST file). |
CA1821 | WORK-IN-PROCESS MATERIAL DETAIL | This report shows the detailed inventory transactions associated with a work order. It shows the cost lots (as opposed to the material lot numbers) and the actual unit costs on the LOTHIST file. |
CA1822 | WORK-IN-PROCESS INCREMENTAL LABOR SUMMARY | This report shows a summary of labor costs based on the work-in-process routing. Sub-totals are given based on direct/indirect, rework, and outside labor. Split lots are shown along with the original work order. |
CA1823 | WORK-IN-PROCESS INCREMENTAL LABOR DETAIL | This report shows the detailed labor transactions associated with a work order. It shows the information from the LABORHIST file, including a copy of the labor and overhead rates used. |
CA1825 | WORK-IN-PROCESS OUTSIDE OPERATION DETAIL | This report shows the detailed outside labor transactions associated with a work order. It shows the information from the POHIST file. |
CA1826 | PART COST DISPLAY 1 | This program allows the user to view the cost elements of a part. These costs will be displayed from the ITEMCA file. |
CA1830 | WORK-IN-PROCESS COST ANALYSIS | This report shows, for a given fiscal period, the period-to-date and order-to-date cost analysis of standard versus actual costs for work orders. Totals are given for each product category. |
CA1831 | WORK-IN-PROCESS FINANCIAL RELIEF REGISTER | This report shows the source of the WIP relief posting, either invoicing, journal entry or Work-In-Process Relief entry. The report also shows the costing information for work orders. |
CA1832 | OPEN WORK ORDER REPORT BY G/L NUMBER | This report shows the work-in-process general ledger accounts that have been debited to open work orders, the amount credited for completed units, and the balance. |
CA1834 | JOB PROFIT MARGIN INQUIRY | This program allows the user to display the gross profit margins on a particular job. |
CA1835 | JOB PROFIT MARGIN REPORT | This report shows the price, cost, and gross profit margin data for jobs in the system. |
CA1840 | INCREMENTAL MATERIAL DETAIL BY JOB | A hard copy report showing stock issues, summarized by job. All issues and returns in a specified date range will be included. |
CA1850 | DAILY INVENTORY SCRAP REGISTER | This report shows all scrap transactions that are currently on the Scrap Register file (SCRAPREG). This serves as an audit trail for inventory scrap. |
CA1851 | MONTHLY INVENTORY SCRAP REGISTER | This report shows all scrap transactions that are currently on the Monthly Scrap Register file (MSCRAPREG). Transactions shown are sorted by part number. |
CA1860 | WORK ORDER MATERIAL USAGE VARIANCE | This report shows the material usage variances for a work order. The variance is calculated as the standard cost times the difference between the quantity required and the actual quantity used. |
CA1861 | WORK ORDER INCREMENTAL LABOR RATE VARIANCE | This report shows the set-up and labor rate variances for operations on a work order. The rate variance is calculated as the actual hours times the difference between the standard and actual rates. |
CA1862 | WORK ORDER INCREMENTAL LABOR USAGE (EFFICIENCY) VARIANCE | This report shows the set-up and labor usage variances for operations on a work order. The usage variance is calculated as the actual rate times the difference between the standard and actual hours. |
CA1865 | LABOR HISTORY INQUIRY BY WORK ORDER BY EMPLOYEE | This program is an on-line inquiry of all labor hours posted to a work order sorted by employee number for a specific time period. |
CA1870 | STANDARD ROUTING INQUIRY | This program allows the user to review standard routings without allowing any changes to them. |
CA1871 | WORK-IN-PROCESS ROUTING INQUIRY | This program allows the user to review work-in-process routings without allowing any changes to them. |
CA1881 | WORK ORDER COST VARIANCE DETAIL REPORT | This program is a detail variance report for financially closed work orders. |
CA1882 | WORK ORDER PRODUCTION VARIANCE DETAIL REPORT | This program is a detail production variance report for financially closed work orders. It will show the actual quantity and hours, the standard quantity and hours, and the variance between actual and standard. |
CA1890 | LOT HISTORY GENERAL LEDGER ACCOUNTS DISPLAY | This program displays the general ledger category number and general ledger accounts associated with a specific inventory lot. The user enters the part and lot numbers. |
CA1891 | WORK ORDER GENERAL LEDGER ACCOUNTS DISPLAY | This program displays the general ledger category number and general ledger accounts associated with a specific work order. The user enters the work order number. |
CA1900 | OWNERSHIP CODE MASTER FILE ENTRY AND MAINTENANCE | Ownership codes are used in the Purchasing module. The consignment inventory flag assigned to the code will determine whether purchased inventory will be costed as company owned inventory or consignment inventory. |
CA1901 | TIME SENSITIVE MATERIALS VALUATION REPORT | This hard copy report values the time sensitive materials in inventory for one company, using actual costs. Because the user may select the order in which the data will appear, there are no part totals. |
CA1902 | CONSIGNED INVENTORY VALUATION REPORT BY OWNER BY PART BY LOT | This report shows the consigned inventory valuation based on the consigned value from the Lot History file (LOTHIST). Only consignment inventory will appear on this report. This report offers the option to suppress lot detail. |
CA1903 | CONSIGNED INVENTORY VALUATION REPORT BY JOB BY PART BY LOT | This report shows the consigned inventory valuation based on the consigned value from the Lot History file (LOTHIST). Only consignment invemtory will appear on the report. |
CA1910 | INVENTORY VALUATION REPORT BY G/L ACCOUNT | This report shows the inventory valuation based on the actual lot costs. This report will use the actual G/L accounts that the lots were received against. An option to suppress the lot detail is given. |
CA1914 | INDENTED BILL OF MATERIAL COST INQUIRY | The Indented Bill of Material inquiry screen will have two screens. The first screen will prompt the user for a cost option to be used. |
CA1915 | SINGLE LEVEL BILL OF MATERIAL COST INQUIRY | The Single Level Bill of Material inquiry screen will have two screens. The first screen will prompt the user for a cost option to be used. |
Menu paths for this module are in pro3prog/MENUFILE. For the programs that actually execute and their source items, see Reading AFTEC Source.
Footnotes
-
The manual prints this program number incorrectly; corrected here against
MENUFILEand the source tree. ↩