IC50.1 - Transaction History Use transaction history forms to audit transaction history records by update date (IC50.1), in detail (IC50.2) or by transaction date (IC50.3). Transaction history records are created as a result of all transaction types updated to the Inventory Control system. Use IC50.1 to display item transaction history records by update date. This is the date transactions were updated to the Inventory Control system. This form displays the transaction type, update date/time, bin, transaction quantity, after stock-on-hand quantity, and document ID. Transaction records list in descending order beginning with the most recent update date. To display a specific record in a selected form, select the line action X and the Transfer form action. Then, select a form. For example, you could choose IC50.2 to display the record in detail or choose IC50.3 to display history records by transaction date. To display summarized transaction quantities by period, use IC49.1 (Usage History). Updated Files None. Referenced Files ICCOMPANY - Used to validate company numbers. ICLOCATION - Used to validate locations. ICTRANS - Used to retrieve inventory transaction information. ITEMLOC - Used to validate items at a location. ITEMMAST - Used to validate item master records. PORECLINE - Used to retrieve purchase order transaction information. IC50.2 - Detail Transaction History Use this form to display detail item transaction history records. Transaction history records are created as a result of all transaction types updated to the Inventory Control system. The records include adjustments (AJ), bin transfers (BT), cost adjustments (CA), customer returns (CR), issues (IS), issue transfers (IS), physical inventory (PI), purchase order receipts (PO), purchasing receipt adjustments (RA), inventory receipts (RC), rejected PO inspections (RJ), requisition returns (RR), receipt transfers (RT), and shipments (SH.) This form is similar to IC50.1 (Transaction History) but also includes the secondary quantity and unit of measure for catch weight items, operator name, before and after stock-on-hand quantities, general ledger and IC update status, unit cost, reason code, comments, reference notes, and activity. Note: Transaction history records display in this form by update date/time. Typically, a transaction record is transferred to this form from IC50.1 (Transaction History) or IC50.3 (Transaction Date History). Updated Files MMUAVAL - This file defines the user analysis values defined for transactions. Referenced Files CUCONV - Used in a Currency conversion common routine. CURELAT - Used to validate currency relationships. GLSYSTEM - Used to obtain the activity flag. ICCOMPANY - Used to validate the company number. ICLOCATION - Used to validate the location. ICTRANS - Used to retrieve inventory detail transaction information. ITEMLOC - Used to validate items at a location. ITEMMAST - Used to validate items. MMDIST - This record holds an account number and possibly an activity code intended for a general ledger distribution of an inventory item. POCOMPANY - Used to retrieve Purchase Order historical transactions. POLINE - Used to retrieve an activity from the purchase order line. PORECEIVE - This file contains header information for the Purchase Order receiver. PORECLINE - Used to retrieve purchase order detail transaction information. PURCHORDER - Used in a Requisitions common routine. IC50.3 - Transaction Date History Use this form to display transaction history records by transaction date. This is the date transactions were created. Transaction history records are created as a result of all transaction types updated to the Inventory Control system. The types include adjustments (AJ), bin transfers (BT), cost adjustments (CA), customer returns (CR), issues (IS), issue transfers (IT), physical inventory (PI), purchase order receipts (PO), purchasing receipt adjustments (RA), inventory receipts (RC), rejected PO inspections (RJ), requisition returns (RR), receipt transfers (RT), and shipments (SH). This form displays the transaction type, transaction date/time, bin transaction quantity, and document code. This form lists transaction in descending order beginning with the most recent transaction date. Otherwise, you can display transactions on or before a specified transaction date. To display a specific record in a selected form, select the line action X and the Transfer form action. Then, select a form. For example, you could choose IC50.1 to display item transaction history by update date or IC50.2 to display detail transaction history. Updated Files None. Referenced Files ICCOMPANY - Used to validate the company number. ICLOCATION - Used to validate the location. ICTRANS - Used to obtain the needed transactions for display. ITEMLOC - Used to validate the item location. ITEMMAST - Used to obtain the item description. PORECLINE - Used to obtain the Purchase Order receiving records. INVOKED Programs IFCR IFSG |