IBASE — Inventory
Item master, lots and bins, inventory transactions, the nightly INVAUDIT post, physical inventory, valuation and history.
79 programs documented. Source: S:\Dept\Computer\Documents\PTIS2\AFTEC\IBASE.wpd, IBASEOVER.wpd, ibaseover1.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 |
|---|---|---|
0001 | PRODUCT MASTER FILE ENTRY AND MAINTENANCE | This program will allow the user to enter the PRODUCT MASTER information, as well as the COMMERCIAL AND GOVERNMENT ENTITY MASTER (CAGE), and Product Notes. |
0002 | ITEM ORDER POLICIES ENTRY AND MAINTENANCE | This program allows the entry and maintenance of the Item Order Policies master file (ITEMORD). The part must have been previously established on the Product Master file (PRODUCT). |
0004 | PHYSICAL TYPE CODE FILE ENTRY AND MAINTENANCE | This is the control program for entering and maintain- ing a valid physical inventory type master code. |
0005 | PHYSICAL TYPE CODE LISTING | This listing prints out data from the Physical Inventory Type Code Master File (TYCODE). The report will print out the type code and its description. |
0006 | PRIMARY VENDORS ENTRY AND MAINTENANCE | This program gives the user the ability to build and maintain a table for up to 999 primary vendors. |
0007 | INVENTORY PRIMARY VENDORS LISTING | This program produces a hard copy printout of the primary vendor table and its detail. |
0008 | SALES CLASS FILE ENTRY AND MAINTENANCE | This control program is used for the entry and maintenance of the Sales Class file (PCLASS). The sales class is used in order entry to sub-total sales information by product line. |
0009 | SALES CLASS FILE LISTING | This program provides a hard copy listing of the sales classes on the Sales Class file (PCLASS), for the purpose of review. Sales classes are sorted in alphabetical order. |
0010 | MANUFACTURING CLASS FILE ENTRY AND MAINTENANCE | This control program is used for the entry and maintenance of the Manufacturing Class file (MANFCLASS). |
0011 | MANUFACTURING CLASS FILE LISTING | This program provides a hard copy listing of the manufacturing classes on the Manufacturing Class file (MANFCLASS), for the purpose of review. Manufacturing classes are sorted in alphabetical order. |
0012 | COST ACCOUNTING CLASS FILE ENTRY AND MAINTENANCE | This program allows the entry and maintenance of the cost accounting class master file (CACLASS). |
0013 | COST ACCOUNTING CLASS FILE LISTING | The purpose of this program is to allow the user to print a hard copy listing of the cost classes on file, along with thier associated data fields for the purpose of review. |
0014 | GENERAL LEDGER CATEGORY FILE ENTRY AND MAINTENANCE | This program allows the user to set up and maintain several general ledger categories, each having a specific set of general ledger accounts. This code is then assigned to each part on the part master. |
0015 | GENERAL LEDGER CATEGORY FILE LISTING | This program provides a hard copy listing of the general ledger categories on the Category file (CATEGORY), for the purpose of review. General ledger categories are sorted in category code order. |
0016 | INVENTORY SUBSTITUTION ENTRY AND MAINTENANCE | This program allows the entry and maintenance of the inventory substitution file (INVSUB). The user may enter substitutions for a single part along with reference notes and quantities. |
0017 | INVENTORY SUBSTITUTION FILE LISTING | This program is a listing of all of the valid inventory substitution parts for a given product. |
0018 | UNIT OF MEASURE ENTRY AND MAINTENANCE | This program allows the user to enter and maintain a valid table for Units of Measure. This is the stocking Unit of Measure for parts. The system comes with several Units of Measure on file. |
0019 | UNIT OF MEASURE FILE LISTING | This program produces a hard copy printout of the Unit of Measure table. |
0021 | PART CROSS-REFERENCE ENTRY AND MAINTENANCE | The product xref entry and maintenance is a master program and can be found on the inventory master file selector. |
0022 | CROSS-REFERENCE PART ENTRY AND MAINTENANCE | The xref product entry and maintenance is a master program and can be found on the inventory master file selector. |
0023 | LOCATION MASTER FILE ENTRY & MAINTENANCE | This control program allows the user to enter and maintain valid inventory locations within the system. |
0025 | LOCATION CODE TABLE LISTING | This is the listing program that outputs all location code information on the system. The user has the option to run this report for one or a range of companies and locations. |
0026 | ON HAND ADJUSTMENTS | S This program allows the user to make an adjustment to the on-hand balance. |
0028 | STOCK/LOCATION TRANSFER | This program allows the user to transfer inventory between locations within the same Company. Please keep in mind that only one transfer can occur per transaction. |
0030 | ISSUE TO SCRAP | This operations program allows the user to scrap material from the stores locations, thus reducing the on-hand inventory balances and increasing the scrap balances for the part. |
0033 | INTER-COMPANY STOCK TRANSFER | This operation program allows the user to transfer inventory between companies. The program allows the user to enter a new location and bin to post the inventory to in the new location. |
0035 | PRODUCT COPY TO ANOTHER COMPANY | This is a program that will copy part number (PRODUCT) data from one company to another company. Only the data from Product Entry and Maintenance will be copied. All other data must be set-up in the new company. |
0037 | INVENTORY INQUIRY BY LOCATION BY LOT WITH BINS AND JOBS | This program presents inventory, on-order data, and requirements data for a part to the user in five separate screens, each screen consisting of multiple pages. |
0038 | INVENTORY INQUIRY BY LOCATION BY LOT | This program presents inventory, on-order data, and requirements data for a part to the user in five separate screens, each screen consisting of multiple pages. |
0039 | INVENTORY BIN INQUIRY BY PART NUMBER | This inquiry program displays inventory available for all products in a specific bin at a requested location. |
0041 | INVENTORY LISTING BY LOCATION BY BIN BY PART | A hard copy report of the inventory for a location(s) detailing bin quantity on-hand quantities. |
0042 | INVENTORY INQUIRY BY BIN NUMBER | This inquiry program displays the inventory of a given part in detail by location by bin. Upon entering the part number and location, the following information is displayed. |
0045 | DEMAND FORECAST LISTING | This report may be printed on demand and shows a comparison of sales and manufacturing usage by prior year, prior 3 months, and year to date. |
0046 | LOT HISTORY PRINT/PURGE | This report is a final printout of lot history information prior to purging. Only those lots with a date closed prior to the selected purge date will print and be available for purging. |
0047 | PART SECURITY CODE ENTRY AND MAINTENANCE | This is the control program for entering the part security codes. |
0048 | XREF PART TYPE FILE ENTRY AND MAINTENANCE | The part xref type file entry and maintenance is a control program and can be found on the inventory control selector. This program allows the user to enter the XREF TYPE to be used on the PART XREF file. |
0050 | PART XREF/LIST AUDIT ENTRY AND MAINTENANCE | This table provides functionality in two areas. First it lets the user set-up which fields on the item master are to be posted to the cross reference file automatically upon part entry. |
1000 | INTERIM PRINT FLAG RESET | This program allows the user to reset all of the interim print flags on the ITEMMANF file to null. |
1018 | UNIT OF MEASURE CONVERSION ENTRY & MAINTENANCE | This is the control program for entering unit of measure conversion factors. These factors are used to convert numbers from one unit of measure to another. |
1020 | PRODUCT MASTER FILE LISTING | This report program is a complete hard copy listing of the Product Master file information. |
1023 | INSPECTION CODE TABLE ENTRY AND MAINTENANCE | This is the control program for entering and maintaining the Inspection Code file (INSPECTION). The inspection codes will be linked to the Product Master record through the Item Order Policies screen. |
1025 | PLANNER MASTER FILE ENTRY AND MAINTENANCE | This program allows entry and maintenance of the PLANNER file. This file will be used to validate planners assigned to parts in the Item Order Policies File Entry and Maintenance program (IBASE 0002). |
1026 | PLANNER MASTER LISTING | A hard copy list of planners on the Planner Master File (PLANNER). |
1274 | KIT ISSUE | This operation program performs a kitting issue. That is, it relieves inventory of several component parts, and increases the on-hand quantity of the kit part, or assembly part. |
1277 | STANDARD BILL OF MATERIAL ISSUE (TO DOCUMENT) | This program allows the user to issue a group of parts at one time using a standard bill of material. |
1278 | BILL OF MATERIAL STOCK LOCATION TRANSFER | This program allows the user to transfer a group of parts from one inventory location to another through the a standard bill of material. |
1280 | MISCELLANEOUS ISSUE | This operation program allows the user to issue one part at a time to a work order. |
1281 | MISCELLANEOUS RETURNS TO STOCK (FROM WIP AND DEPTS) | This programs allows the user to return miscellaneous items to inventory. The items must be charged to a valid General Ledger Account Number, a Valid open Work Order or a Document Number. |
1282 | MISCELLANEOUS ISSUE TO G/L STACK FILE PURGE | This program allows the user to purge all data from the GL.ISSUE file on or before a given date, by using a purge cutoff date . |
1300 | INVENTORY ON-HAND REPORT BY PART BY LOCATION | This program is a listing that shows on-hand inventory information by part with location, lot, and bin information. The user has the option to run this report for a selective range of companies and products. |
1301 | INVENTORY ON-HAND REPORT BY LOT | This program is a listing that shows on-hand inventory information by lot with location and lot information. The user has the option to run this report for a selective range of companies and products. |
1302 | INVENTORY VALUATION REPORT BY CATEGORY | This is a hard copy report of the inventory by category, by by part. The type of cost used in the valuation may be selected by the user. Standard cost, last cost, and weighted average cost are the valid options. |
1303 | INVENTORY ON-HAND REPORT BY LOCATION BY PART | This program is a listing that shows on-hand inventory information by location by part with location, lot, and bin information. |
1304 | INVENTORY REPORT BY JOB | The Inventory Report By Job can be found on the inventory reports selector. This inventory report shows avaiable inventory sorted by job number. |
1500 | PART USAGE HISTORY REPORT | This report shows part usage history from the Item History file (ITEMHIST). History will be showned for the past 13 months along with fiscal year to date and past 12 month totals. |
1510 | INVENTORY MONTHLY ACTIVITY | This report shows inventory monthly activity since the last time the Monthly Part History Update (IBASE 1595) was run. |
1520 | MINIMUM LEVEL STATUS REPORT BY MRP TYPE | This report shows minimum level controlled parts that are at or below their minimum order level. Parts that have a minimum level quantity on the Item Order Policies file (ITEMORD) are called minimum level parts. |
1530 | EXCESS INVENTORY REPORT | This is a paper report of all parts with projected excess inventory. Parts are listed by company by descending dollar. |
1540 | INVENTORY ABC ANALYSIS | This report and update program will value last 12 months (not including current month) usage and sort the parts in descending value order. |
1550 | MINIMUM LEVEL CREATOR REPORT | This report reviews parts with a minimum level quantity on the Item Order Policies file (ITEMORD). These parts are called minimum level parts. They are ignored by MRP. |
1560 | INVENTORY WITH NO USAGE IN PAST 12 MONTHS | This program is a hard copy report showing inventory items with no usage in the last 12 months. It is very useful in identifying inactive or obsolete items in inventory. |
1570 | LAST 12 MONTHS INVENTORY MOVEMENT | This program is a hard copy report that will show the activity of manufacturing inventory for twelve months, (current month and eleven prior). |
1575 | LAST 6 MONTHS INVENTORY MOVEMENT DISPLAY | This program is a on-line screen inquiry that will show the activity of manufacturing inventory for six months, (current month and five prior). |
1583 | INVENTORY DETAIL HISTORY INQUIRY | This inquiry program displays on the screen all inventory transactions in the Inventory History file (INVHIST) for a particular part. Material transactions are listed in detail in descending order (most current first). |
1595 | PERIOD END PART HISTORY ROLLOVER | The monthly part history update is an update program and can be found on the inventory purge selector. |
1601 | JOB INVENTORY TRANSFER | This operations program is used to transfer material between jobs, from general inventory to job related inventory, or from job related inventory to general inventory. |
1602 | GENERAL LEDGER MATERIAL TRANSFER REGISTER AND UPDATE | This is a register listing and update program for the Material Transaction file (INVTRANSREG). |
1602B | GENERAL LEDGER MATERIAL TRANSFER REGISTER AND UPDATE (SUMMARY SECTION) | |
1656 | DAILY INVAUDIT LISTING AND UPDATE | This program lists and updates all those inventory transactions performed since the last time this program was run. |
1660 | INVENTORY HISTORY LISTING BY CRTNO BY TIME - DATE | This is a detailed listing of inventory transaction history generated from the inventory history file (INVHIST). The INVHIST entries are system generated audit trail records which are created for every inventory transaction. |
1670 | INVENTORY HISTORY LISTING BY PART NUMBER | This is a detailed listing of inventory transaction history generated from the inventory history file (INVHIST). The INVHIST entries are system generated audit trail records which are created for every inventory transaction. |
1681 | INVENTORY HISTORY LISTING BY DOCUMENT NUMBER BY TYPE | This is a detailed listing of inventory transaction history generated from the Inventory History file (INVHIST). The INVHIST entries are system generated audit trail records which are created for every inventory transaction. |
1682 | INVENTORY HISTORY LISTING BY GENERAL LEDGER NUMBER BY TYPE | This is a detailed listing of inventory transaction history generated from the Inventory History file (INVHIST). The INVHIST entries are system generated audit trail records which are created for every inventory transaction. |
1689 | TIME SENSITIVE MATERIALS ON HAND REPORT | This hard copy report lists the time sensitive materials in inventory for one company. Because the user may select the order in which the data appears, there are no part or company totals. |
1695 | INVENTORY HISTORY LISTING BY ACD BY PART BY TYPE BY DOC-NO | This is a hard copy listing of a parts inventory audit history detail by activity code, by type of transaction, by document number. |
1760 | PART MASTER COST ENTRY AND MAINTENANCE | This program allows the user to enter and maintain cost against a specific part. It can be automatically updated from several sources. |
1761 | PART MASTER COST LISTING | This is a hard copy report of the part master cost file. It will list all the information associated with standard, last, and weighted average costs. |
1762 | DOCUMENT TYPE CODE MASTER FILE ENTRY AND MAINTENANCE | This program will permit a user to enter and maintain Document Type Codes and Desriptions. |
1763 | DOCUMENT TYPE CODE MASTER LISTING | This program is a hard copy listing of all Document Tyoe Codes on file. The user will have the option to run the report for a selected range of companies and a selected range of document type codes. |
Menu paths for this module are in pro3prog/MENUFILE. For the programs that actually execute and their source items, see Reading AFTEC Source.