MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Design Engineering > Screens > Design Engineering System > DE150S11 - Data Base Audit Report Request

DE150S11 - Data Base Audit Report Request

 

 

WILLIAMS   PLT MFG            DESIGN ENGINEERING                       3/02/95

 DSP01                        DATA BASE AUDIT CONTROL                    DETAIL

                                                                               

        Submit Report Request          X                                       

                                                                               

        Part Print Option              A                                       

                                                                               

                        Enter  X  For Requested Options                         

                                                                               

                                                                               

      Part No Descp Only  X   System Fields           User Fields              

                                                                               

      Inventory Fields        Cost Fields             Sales Fields             

                                                                               

      Productivity Fields     Purchasing Fields                                

                                                                               

                                                                               

      Bill Of Matl - Mfg      Routing - Mfg           Cost - Pur Or Raw        

                                                                               

      Planning Pol Code       Leadtime Code           Productivity Info        

                                                                                

 F2=Command          F3=Exit             F4=Prompt           F16=Change Printer

 F17=New Plant                                                                 

                                                                               

This screen is used to request a listing of parts and to select the information that you wish to see printed on the listing.  The report may be printed for all parts or for only those parts missing critical data.

PLANT

Required.  Used to identify the plant where the workcenters exist.  The plant must be valid (not blanks or nines) and the user must be authorized to the manufacturing company/warehouse associated with the plant (Reference File category 409).  Defaults to the plant are assigned to the user ID, but may be changed by pressing F17.

SUBMIT REPORT REQUEST

Optional.  Enter 'X' to request the report.

PART PRINT OPTION

Required.  Valid values are:

A - Print all parts. Place an 'X' by each menu option.  Used if you want to select all parts with errors.

P - Print only those parts for which necessary parameters have not been defined.  You may further limit the parts that print by selecting one or more of the six error conditions listed on the screen. Thus, if Part Print Option is 'P' and an 'X' is placed next to Bill of Matl - Mfg, only manufactured parts that have no bill of material will print on the report.  If Part Print Option is 'P', at least one of the six error conditions must be selected.  If all six conditions are left blank, an “Invalid Audit Request” error message will appear on the screen.

At least one of the eight line print options must be selected: Part Number/Description Only, System Fields, User Fields, Inventory Fields, Cost Fields, Sales Fields, Productivity Fields, Purchasing Fields.

PART NUMBER/DESCRIPTION ONLY

Optional.  If an 'X' is entered, only the part number and its description will appear on the report.

SYSTEM FIELDS

Optional.  If an 'X' is entered, fields that are associated with the part, but not maintained by the user, will appear on the report.  These fields are typically used by data processing personnel.

USER FIELDS

Optional.  If an 'X' is entered, user-maintained fields are printed, with the exception of distribution, cost and inventory control fields.

INVENTORY FIELDS

Optional.  If an 'X' is entered, inventory control-related fields will print on the report.

COST FIELDS

Optional.  If an 'X' is entered, current and standard costs will appear on the report.

SALES FIELDS

Optional.  If an 'X' is entered, sales-related information will appear on the report.

PRODUCTIVITY FIELDS

Optional.  If an 'X' is entered, productivity-related information, such as container code, number of BON cards, number of CON cards and group technology number, will be printed on the report.

PURCHASING FIELDS

Optional.  If an 'X' is entered, purchasing-related information will appear on the report.

999999

One or more of the six audit options may be selected if you wish to review only those parts for which required data must be entered: Bill of Material - Manufacturing, Routing  Manufacturing, Cost - Purchased or Raw Material, Planning Policy Code, Leadtime Code, Productivity Info.

BILL OF MATERIAL - MANUFACTURING

Optional.  If an 'X' is entered, any manufactured, planning or build-thru part without a product structure will be printed on the report.

ROUTING - MANUFACTURING

Optional.  If an 'X' is entered, any manufactured part without a routing will be printed on the report.

COST-PURCHASED OR RAW MATERIAL

Optional.  If an 'X' is entered, any purchased or raw material part with a current material cost of zero will be printed on the report.

PLANNING POLICY CODE

Optional.  If an 'X' is entered, any part for which Planning Policy Code has not been defined will appear on the report.

LEADTIME CODE

Optional.  If an 'X' is entered, a part will appear on the report if it meets any of the following conditions:

- Leadtime Code is 'F' and Fixed Leadtime Days is zero.

- Leadtime Code is 'V' and Setup Days, Run Days per Piece, Transit Days and Fixed Leadtime Days are all equal zero.

- Leadtime Code is neither 'F' nor 'V'.

PRODUCTIVITY INFO

Optional.  If an 'X' is entered, any part whose production type is JIT, and meets the following conditions, will be printed:

- the part type is MFG and no production center exists.

- the part type is B/T and no production center exists.

- the part has a relief type or primary producing location that is blank.

- the part's CONBON control code is 1 or 2 and the container code is blank.

COMMAND KEYS

Enter - Process the report request.

F2    - Display a window where a fast path option or mnemonic can be entered.  Fast path allows the next menu selection to be made directly from this screen.  When the window is displayed, pressing F3 will remove it.

F3    - Exit program and return to menu.

F4    - Display a list of values for the field where the cursor is positioned.  If you select one of the items from the list, it will be returned to the application screen.

F16   - Allows the user to change the output location.

F17   - Used to change the plant in which the user is currently working.