Home

MFG/PRO eB2 User Guide Volume 9: Manager

Contents

1. 84 Setting Up Baseline Data for Items 0 0 0 e ee eee 84 Setting Up Baseline Data for Purchase Orders 85 Setting Up Other Baseline Data 00 000 e eee eee 85 Setting Up Database Connections 0 000 naeran 85 Designing a Network 0 0 00 0 nees 86 Defining Databases in MFG PRO 00200 cee eee ee eee 86 Assign Each Site to a Database 00 0 c eee eee eee 88 Set Up Database Security 0 0 0 cee ees 88 Copying and Connecting Databases 00 00 c cece cece eens 88 Setting Up Other Databases 2 0 cece cee eee 89 Maintaining System Accounting Data 00002 eee 89 Maintaining Locations 0 cece eee eee eee 89 Maintaining Inventory Status Codes 0 00 cece eee eee 89 Maintaining Sales Orders 2 00 cece eee eee 89 Maintaining Items and Sites 00 cee eee 90 Maintaining Item Planning and Cost Data 90 Maintaining Purchase Order Sites 00 cee eee eee eee 90 Maintaining Prefixes 0 e eee eee eee eee 90 Maintaining Security 2 0 cece eee eee 90 Maintaining Printers 20 0 cece eee eee nee 90 Modifying Startup Connections 00 02 e eee eee 91 Modifying DRP and MRP 00 00 cece eee eee 91 Managing Multiple Databases 0 0 0 c cece eee ee nes 92 Login and Connection Metho
2. 2 0 0005 119 Example of CIM Delete 00 0 ccc cece 120 Running Multiple CIM Sessions 000 cece eee eee eee 120 Killing CIM Sessions 0 0 ccc ett e eee nees 121 Chapter8 Database Management 0 00000ee 123 Managing Database Size 1 2 ee eects 124 Determining Disk Usage 0 0 cc cece eee eens 124 Freeing Disk Space siden ond leek adda kbd gee ha ea es 124 Dumping and Loading Data 00 ec eenes 125 Dump Load Procedures 0000 c cece eee 126 Deleting and Archiving Data 2 0 cee cece eee eee 127 Audit Detail Delete Archive 2 0 0 cece eee eee 128 Restoring Archive Files 0 00 c cece eee eee ene 129 vii viii MFG PRO eB2 User Guide Manager Functions Managing Database Sequences 1 2 0 0 cece eee eee eee ene 130 Initializing Sequences 02 0 0 cee cece eee eee eee 131 Maintaining Sequences Manually 0 002 e eee eee 131 Maintaining Sequences Using CIM 2 02 e eee eee 133 Maintaining Audit Trails 02 0 ce eee eee 135 Maintaining Sequences in Oracle 00 0 eee ee eee eee 135 Registering Licenses 0 cece cee enn eens 136 Licensing Overview 00 0 cect teen ees 136 License Registration senape resape raa eect ene nes 142 License Reporting 0 c cece cece enn ees 145 Setting Up Multiple Time Zones 0 0 2 0 0 c cece eens 149 MTZ
3. 2 0 02 eee 174 Chapter 12 User Interface Management 006 177 IMOMUCHON 545 badd sete bbe dS ere E el elser hate Aad E ee ac 178 Maintaining Drill Downs and Lookups 0 2 0 c eee eee ee 178 Wildcards in Drill Down Lookup Maintenance 181 Drilling Down on Drill Downs 0 0 0 eee eee eee 182 Planning for Upgrades annuun ccc eee 182 Creating Access to Other Programs 00 0 cece cece eee 183 Setting Up Menu Substitutions 0 0 0 185 Creating BFOWSES tiotsianat a ea Sea db Mere e ahbwadw nels 186 Creating Views cosa cick ore are ag Oe Gow Boag GY acs he ERES 190 Using Progress Syntax 0 cette ees 191 Using Jom Types xo acta nk eka Mod av ae ee be eee 192 Using View Maintenance 0 0 nunnorna 193 INGER S 6564 basens sne 620 dG aap ODDER Reeds aodekos eee ds 197 FA QAD x MFG PRO eB2 User Guide Manager Functions FAQAD About This ocumentati 2 MFG PRO eB2 User Guide Manager Functions FAQAD This guide covers the system administration programs within MFG PRO Most of these programs are on the Manager Functions menu 36 Other MFG PRO Documentation For an overview of new features and software updates see the Release Bulletin For software installation instructions refer to the appropriate installation guide for your system For conversion information refer to the Conversion Guide For instr
4. 2 00002 eee eee 12 Calendar Maintenance 0 c eee eee eee nes 13 Holiday Maintenance 0 0 eect eens 14 iv MFG PRO eB2 User Guide Manager Functions Defining Rounding Methods 0 0 0 cece nen 15 Establishing Generalized Codes 0 ccc cece cece ene 16 Field Validation 2 0 0 c eects 17 Using Reason Codes 0 ccc ccc cect tenn en eens 19 Managing Number Ranges 00 0 cece eee eect en eens 20 NRM OVERVIEW ser ecreeier teut eni een eae eae da ah 20 Sequence Life Cycle 1 0 0 ccc cece teen ees 23 NRM Sequences in MFG PRO 0 00 23 Setting Up Sequences f 00 0 64 due via dane dddaed E AE anaes 24 Setting Sequence Values 0 cee eee eens 28 Viewing Sequence Number History 00 cece eens 29 Deleting and Archiving Sequences 00 00 e eee eee eens 29 Tracking Changes rer wie hes echo bisa bbd ae betbdedwnte khiatels 29 Change Tracking Implementation Overview 30 Defining Change Tracking Reason Codes 00 0 eee 30 Activating Change Tracking 0 0 cece eee eee eee 31 Specifying Fields to Track 0 0 eee eens 31 Chapter 3 Users and Security 0 00 e eee eee eee 35 Security OVErvIew aeree eed ee ea dad ade RESA E A dees a ee dda one 36 Setting Up Security Control 00 00 c ccc eet eenenenes 38 Basic Login Security soccer nce ea Fee ee kd wee adhe a COM eee
5. FA QAD 84 MFG PRO eB2 User Guide Manager Functions FAQAD Setting Up Baseline Data for Sites and Locations Site codes must be identical across databases Set up sites and locations so that inventory tables in a database not belonging to a site cannot have inventory information associated with that site Each site must be assigned to just one database and be unique across all databases When the system looks for information on a site it should find that information in a single database For each site assign an address to the site code in Company Address Maintenance 2 12 The site address can be used as a ship to address when items in a purchase order go to different sites and by freight lists when computing freight charges Set default sites and the costing methods in Inventory Control You can change these settings later for individual databases Locations must be identical across databases Individual locations can be added later and attached to sites You can disable automatic locations for some or all sites by setting up default locations If you know your transportation mode set up locations with names identical to the transportation mode in each DRP site Setting Up Baseline Data for Product Lines Product lines to which purchased or finished products are assigned must have identical account codes across databases Other product lines can be added after the baseline database is copied Setting Up Baseline Dat
6. See License Types on page 137 FAQAD Note To change an existing password to blank press the spacebar in the Password field and then press the backspace key This action lets the system know that you want to change the password value Passwords expire based on the value of Password Expiration Days in Security Control If you want users to change their own passwords give them access to User Password Maintenance 36 3 20 Access Location Enter a code that associates the user with a major business facility or major business location If you have more than one facility or location or if users work remotely or in small offices associate the user with the major business facility or location that is most appropriate The system uses the access location when verifying user access to applications with the location license type Location licenses specify a predefined number of locations for specific applications The system validates location count when you change the access location of a user or when you assign applications to users in User Maintenance or License Registration 36 16 10 1 A message displays if the number of locations exceeds the amount specified in the license agreement Access location codes must be defined in Generalized Codes Maintenance 36 2 13 for field usr_access_loc MFG PRO ships with a Primary location code that is used as the default for new user records You can use this location as your company home of
7. 0 00 0 e cece ene 61 Chapter4 System Interface 00 cee eee eee 63 Using Multiple Languages 0 0 0 0 ccc cece tenes 64 Setting up Multiple Languages 0 0 0 cece eee eens 65 Language Detail Maintenance 2 0 00 c eee eee eee eee 65 Customizing Menus and Function Keys 0 000 cece eee een nee 66 Menu System 0 e eens 67 User Menu and Function Keys 0 0 e cece een ene 68 Modifying Labels 0 ccc cece teen ene nee 71 Modifying Messages 0 0 0 cece cc eee eneret 72 Using Field and Procedure Help 0 0 cece eee nee 73 Adding User Help 0 ccc cece cece eee n ene 73 Printing Help lt si 6 s0 o8a0 cdew kw douse adore od cals E E 74 Building an E Mail System Interface 0 00 cece eee eee 74 E Mail Definition Maintenance 00 00 75 User Maintenance 5 23 areas hane kedede hede ad a 71 Chapter5 Multiple Databases 000 cece eee 79 Introduction 2 0 0 0 ccc kreere E ene eens 80 Establishing a Baseline Database 0000s 81 Vv vi MFG PRO eB2 User Guide Manager Functions Setting Up a Baseline Chart of Accounts 0 00 00s 81 Setting Up Baseline Data for Entities 00 0 2 0 000 0 83 Setting Up Baseline Inventory Status Codes 0 83 Setting Up Baseline Data for Sites and Locations 84 Setting Up Baseline Data for Product Lines
8. Database Management 151 Multiple Time Zones Maintenance Use Multiple Time Zones Maintenance 36 16 22 1 to define and modify time zones Note The Multiple Time Zones Load Utility creates sample data upon which you can base your own time zones This program supports two ways of setting up a time zone In the simplest format you can base a time zone on an offset from GMT The system can also track daylight savings time adjustments from a baseline you set If you choose the second approach you must specify when the change in time occurs You can also use effective dates with time zone information if the start and end points for daylight savings time only apply for a range of years After you define the time zones you can generate reports with Multiple Time Zones Report 36 16 22 3 Figure 8 16 illustrates Multiple Time Zones Maintenance Fig 8 16 Multiple Time Zones Maintenance Time Zone AKST AKC 36 16 22 1 Description Alaska Time Auto Period Adjust Time Zone Detail Time Period 88 P Standard Time Start Year End Year GMT Offset Start Period Weekday 1984 9999 09 00 10 25 ES Time Zone Enter an eight character label identifying a time zone Description Enter up to 40 characters describing this time zone The description appears in the time zone lookup FAQAD 152 MFG PRO eB2 User Guide Manager Functions Tip Set up values for time period as language details to reflect the terms
9. The license code for this application expires in the number days on of days indicated Contact your QAD sales representative or distributor to obtain a new license code register correct code in License Registration Concurrent session limit The application you are attempting to access has a exceeded concurrent session license type and the maximum number of active sessions for this application has been reached If this error displays during MFG PRO log in you cannot log in unless another currently logged in user logs out Interaction with MFG PRO The license registration programs use data from other MFG PRO programs to process maintain and report license data System administrators maintain defined named users a list of registered software applications that users are authorized to access and the access locations in User Maintenance 36 3 18 License registration software uses this information to prevent more active users or locations than the license allows User Maintenance also includes information that more clearly defines the user The system ships with a default set of user types predefined in Language Detail Maintenance 36 4 3 The set includes the employee customer and QAD user type It is important for user count and system monitoring purposes that users are correctly identified in User Maintenance before complete license registration functionality can be used Multiple Time Zones Maintenance 36 16 22 1 lets
10. Use the Activated Field Security Report 36 3 5 to see which fields have security activated It also lists privileged user IDs Dictionary Field Security Report The Dictionary Field Security Report 36 3 6 lists the fields containing the association to the validation file as part of their definition Protect any of these fields from update by creating a record of privileged user IDs or groups This association can be made to any field and is one of the only database definition changes you can make that does not constitute a schema change Adding Security to an Eligible Field 1 Add the field name and the list of user IDs that can access the field in Field Security Maintenance 36 3 4 2 Verify that the field is secured by running the Activated Field Security Report 36 3 5 Adding Field Security Eligibility You can make most fields eligible for field security by adding the validation expression to the field in the data dictionary You then recompile the programs that use the field using the modified data dictionary It is not always possible to add field security Some fields have preexisting data dictionary validation expressions that prevent the addition of gppswd v Users and Security 55 Warning Once you have made a field eligible for field security you cannot make it ineligible You can deactivate the security by removing all user IDs for the field in Field Security Maintenance 36 3 4 For multiple databases make
11. 36 2 10 Rounding Method Browse adbr016 p 36 2 11 Rounding Method Report mgrndrp p 36 2 13 Generalized Codes Maintenance mgcodemt p 36 2 14 Generalized Codes Browse mgbr004 p 36 2 17 Reason Codes Maintenance mgrnmt p 36 2 18 Reason Codes Browse mgbr007 p 36 2 19 Reason Codes Report mgrnrp p 36 2 21 Number Ranges Ment 36 2 21 1 Number Range Maintenance nrsqmt p 36 2 21 2 Sequence Browse nrbr001 p 36 2 21 5 Sequence Number Maintenance nrnxmt p 36 2 21 13 Sequence Number History Report nrsqrp p 36 2 21 23 Sequence Delete Archive nrsqup p 36 2 22 Change Tracking Maintenance mgtblcmt p 36 2 23 Change Tracking Browse mgbr223 p Maintaining Holiday and Shop Calendars The shop calendar is required for planning manufacturing and distribution modules The calendar indicates what days the plant is open and how many hours are worked each day This information is used To schedule start and due dates for MRP planned orders master schedule orders and work orders To schedule operations for work orders and repetitive schedules System Constants 13 e To schedule the procurement or shipment of materials through association with suppliers and customers Use Calendar Maintenance 36 2 5 and Holiday Maintenance 36 2 1 to maintain the calendars Calendar Maintenance Use Calendar Maintenance 36 2 5 to specify normal work days and normal work hours for each site and its work centers If shift patterns vary because of overtime increased
12. 6 MFG PRO eB2 User Guide Manager Functions Manager Functions includes tasks typically performed by system administrators within MFG PRO Most functions located on the Manager Functions menu 36 are discussed in this volume Fig 1 1 Manager Functions System tants User Interface Management Application Server System Interface Manager Functions System Cross Reference Multiple Database Reports and Utilities Printers and Batch Processing Database Management A few functions on the Manager Functions menu are discussed in other volumes e System Account Control 36 1 affects processes throughout MFG PRO However it is not typically set up by system administrators but by individuals in your company with financial expertise It is discussed in User Guide Volume 4A Financials e The functions on the Desktop Security Menu 36 3 21 are discussed in the User Guide QAD Desktop e Configured Messaging 36 4 applies only to scheduled orders and is discussed in User Guide Volume 7 Release Management FAQAD Introduction to Manager Functions 7 e External Interfaces 36 5 Q LinQ 36 8 and the Logistics API 36 5 7 are discussed in various External Interface Guides e User interface functions found on the Desktop Menu 36 20 10 are discussed in the User Guide QAD Desktop and Installation Guide QAD Desktop This volume does not cover the vari
13. Field Name fo aroz in qty ch in qty nonet Inventory Master Label Term QUANTITY ON HAND Qty On Hand Qty on Hand Max Length 12 Format gt gt gt gt gt gt gt 9 944 Enter a sequence number to access field data Identify the table and field and change the default field label and format optional To control the display length of a label enter a Max Length value Press End FAQAD 190 MFG PRO eB2 User Guide Manager Functions Fig 12 9 Browse Maintenance Revision History AQAD ALNE Name ic007 lt Preview gt History Procedure Nane history SSS i 16 The program automatically creates a revision history line containing a revision number the user name or logon ID and current date You can modify this as needed The revision history is also saved in the source code 17 Press Go to generate the browse To save the browse data without generating the browse program press End Creating Views A view is a display of some or all of the fields from one or more tables You join two or more tables for a view by specifying the relationships between fields in different tables and choosing the type of join to use Views are used in browses which display the fields gathered using views By choosing which fields to include or exclude in a view you control which fields are available for a browse to display By putting security on the view
14. Leave blank to begin with the first user ID matching the other selection criteria Sort Option Enter the number that corresponds to the way you want to arrange information in the User Monitor Inquiry You can sort by e User ID which sorts the data in alphabetical order by user ID Idle Time which sorts the data by the length of time a user has remained on a menu The user with the longest idle time displays first Program time which sorts the data by the length of time a user has remained in a program The user with the longest program time displays first Setting Up Multiple Time Zones Accommodating variations in local time is a special global business challenge The Multiple Time Zones Setup menu 36 16 22 of Manager Functions helps you create and maintain multiple time zones The main features of time zones include Define and maintain multiple time zones including the changes required by daylight savings time Load sample time zone data Display and report time zone information The optional Service Support Management SSM module provides additional functionality related to time zones If you are using SSM you can activate the Multiple Time Zone MTZ option in Service b See User Guide Volume 8A Service Support Management FAQAD 150 MFG PRO eB2 User Guide Manager Functions b See Defining Users on page 42 Fig 8 15 System Account Control 36 1 FAQAD Management Control
15. Optionally enter any other parameters required when connecting to this application server E mail User ID and E mail Level These fields are not implemented and have no effect on processing Example Using an AppServer to Run MRP This section shows a practical example of how to set up an AppServer to dramatically improve the performance of MRP To use the MRP AppServer you need to perform three main tasks e Modify the ubroker properties file for the AppServer instance e Configure the AppServer Start and stop the AppServer as required Modify the Properties File To set up an AppServer to support MRP processing you must add a set of parameters to the Progress ubroker properties file to identify information about the AppServer instance You can modify ubroker properties in two ways Manually edit the file Use the Progress Explorer tool to change parameters through a graphical user interface Progress Explorer can also be used to start and stop the AppServer and for remote administration 1 Choose Start Programs Progress Progress Explorer Tool 2 Choose File Connect 3 Specify the host name and Admin Server port of the machine you want to administer remotely 4 Enter a valid user ID for the remote machine and a password if required Application Server 171 Configuring the AppServer Improved MRP performance requires a single AppServer with multiple threads which is used to execute the programs that proc
16. See Chapter 3 profile in the initial log in database These values are passed to each Ra a for i subsequent database during log in However the system reads the full discussion of security records in each new database whenever the user attempts to security issues execute a secured function in that database If you do not have the same security setup in each database some users may not be able to execute the same functions in both FAQAD 96 MFG PRO eB2 User Guide Manager Functions b See Registering Licenses on page 136 FAQAD Example User RBT belongs to group AP which has access to all functions on the Accounts Payable 28 menu in Database1 In Database2 group AP can only execute AP reports User RBT logs into Database and can update vouchers After connecting to Database2 RBT can only execute voucher reports In addition to security the system also checks licensing in each database Users must have the proper license access to execute programs Connection Loss Multiple database operation assumes databases are connected continuously When database connections fail consolidated order processing capabilities may be lost In this case users are notified You cannot enter a sales order referencing a site in a disconnected database This is true of both unconfirmed and confirmed orders Since entering a purchase order typically causes a requisition in another database to be erased this action cannot be perfo
17. Summary License Violation Report Use Summary License Violation Report 36 16 10 14 to display Application name version and license type Summary license violation reports let you specify the application and the Violation date Total number of violations Total number of violations by violation type Maximum number of licensed users logged on during a period or the high water mark Total number of licensed users period you want the report to cover If you do not specify an application all violations for all applications display If you specify an application but no dates all violations for that application display If you run either report and there are no violations to report the following message displays No violation observed Database Management 147 Fig 8 12 Detailed License Violation Report 36 16 10 13 Fig 8 13 Summary License Violation Report 36 16 10 14 FAQAD 148 MFG PRO eB2 User Guide Manager Functions Tip This inquiry represents a single point in time not a continuous system record or audit trail Fig 8 14 User Monitor Inquiry 36 16 12 FAQAD Audit Reporting MFG PRO provides programs for QAD auditors to use when the auditors gather statistical information on customer use The programs are not accessible to users The statistical information is for QAD auditing purposes only User Monitor Inquiry User Monitor Inquiry 36 16 12 displays users current
18. and DRP in a multiple database environment Only issues relevant to multi database implementation are addressed For information on e Consolidated order processing see User Guide Volume 2A Distribution e Distribution requirements planning see User Guide Volume 5 Supply Chain Management Each MFG PRO database contains the following A set of tables containing base data for customers items and sites A set of site based inventory tables A security system e A chart of accounts A primary entity In multi database operations some of these elements must be the same across databases others must be different across databases and still others can be either the same or different Moreover in some databases some tables are not used and precautions must be taken to prevent them from being used To accomplish this first set up a baseline database containing information common to all databases you intend to connect After establishing database connections copy the baseline database as many times as necessary and implement each copy separately Finally set up procedures for maintaining data integrity across databases Copy the baseline database and implement each copy separately Establish a baseline database Set up maintenance procedures that ensure data integrity across databases Set up database connections Establishing a Baseline Database To establish a baseline database
19. program FAQAD 106 MFG PRO eB2 User Guide Manager Functions Fig 6 3 Batch Processes Tip Use names that are descriptive and easy to remember such as Paycheck Monthly or After5 FAQAD Example You create two new sales order formats identified with form codes AA and 2 The program name for Sales Order Print is sosorp05 p and the default sales order layout is defined by sorp0501 p Use program file sorp05AA p to store sales order form code AA and program file sorp0502 p to store form code 2 Be sure to include the zero preceding the 2 Then modify sosorp05 p to define the two new formats as valid Running Batch Processes A batch process is a group of processes run simultaneously To set up a batch process first create a batch ID in Batch ID Maintenance 36 14 1 Then select reports or programs that can be run in batch mode and submit those programs using the batch ID You batch a report or process by specifying a batch ID for output rather than a printer ID Report Request 1 Batch Queue Batch Request Detail Batch Request Processor Report Request 2 Table Use Batch Request Processor 36 14 13 to run reports and or programs submitted using a batch ID You can process up to 10 batch IDs in a single run Report Request n When you run a batch process the system executes all items queued for a given batch ID in the requested order You control the batch order by assigni
20. you can allow users to modify browses knowing that they can access only those fields that you have authorized Use View Maintenance 36 20 18 to create or modify views User Interface Management 191 Using Progress Syntax You use some Progress syntax in creating or modifying views You must also understand MFG PRO table and field relationships To create or modify a view 1 Select the table or tables to include in the view 2 For sequences after the first specify the type of join to use inner or outer 3 Join the tables using Progress logic 4 Select fields from the tables 5 Save the view Figure 12 10 illustrates how to create a view of selected fields from two tables Fig 12 10 Fields to Display in View Enpi Creating a View by i ran nae Joining Two Tables pr 4 Payroll Emp ID Total Dept Phone Sal Period i Earnings i a Indexed Join Fields to Display in View Phone List View Emp ID Emp Name Dept Phone Sal N PIQAD 192 MFG PRO eB2 User Guide Manager Functions Figure 12 11 illustrates how to create a view of selected fields from one table Fig 12 11 Creating a View Employee Department List from One Table E E Emp ID Emp Name Dept Salary Table emp_mstr Using Join Types When a view includes data from more than one table you
21. you do not need to enter values for Physical Database name When the primary database starts the system tries to connect to every other database by issuing connect statements for each database with Yes in the Active field of Database Connection Maintenance You can establish the connections directly in the Progress log in script as shown in the following example exec DLC progress qad database2 H database2 S database2 ld database2 qad databasel H databasel S databasel ld databasel p mf p The command tells Progress to run mf p against two databases each of which is located on a different computer Since Database2 is mentioned first it is the primary database The first 1d parameter provides the logical name of the primary database Table 5 1 Sample Login Script Parameters AQAD 94 MFG PRO eB2 User Guide Manager Functions FAQAD You can also specify all connection parameters such as H or S ina parameter file The following command has the same effect as the previous login script exec DLC progress qad database2 pf database2 pf qad databasel pf databasel pf p mf p If you use Database Connection Maintenance 36 6 1 to connect to Databasel you can specify databasel1 pf in the Parameter File field The parameter file substitutes for and overrides individual specifications for each parameter Both methods achieve the same result The user is logged into Database2 which is the primary database for
22. 1 86 36 6 13 94 36 6 15 94 36 6 17 92 94 138 36 13 1 100 36 13 2 102 36 13 4 105 36 14 1 106 36 14 3 106 36 14 13 106 36 15 1 111 36 15 2 111 36 15 4 120 36 16 1 124 36 16 5 129 36 16 10 136 142 36 16 10 1 49 36 16 10 3 145 36 16 10 8 146 36 16 10 13 146 36 16 10 14 147 36 16 11 147 36 16 12 148 36 16 13 131 36 16 17 131 36 16 22 149 36 16 22 1 151 36 16 22 2 153 36 16 22 13 153 36 17 1 157 36 17 2 157 FAQAD 198 MFG PRO eB2 User Guide Manager Functions 36 17 5 157 36 17 6 157 36 19 1 169 36 20 1 178 36 20 2 183 36 20 6 185 36 20 13 186 36 20 18 190 36 23 1 128 157 36 23 2 158 36 24 1 158 36 24 3 158 36 24 4 158 36 24 13 124 158 A access location User Maintenance 44 accounts intercompany 82 multiple databases 81 address e mail specification 46 API type User Maintenance 46 application server 168 Application Usage Profile Report 146 applications assigning in User Maintenance 43 49 applications displaying registered 145 AppServer Service Maintenance 169 Archive File Reload 129 archive delete audit detail 157 GL transactions 158 NRM sequences 29 programs 127 records from database 127 ASCII data 125 assigning applications in User Maintenance 43 Audit Detail Delete Archive 128 157 auditing licenses 148 master table changes 156 B Batch ID Maintenance 106 batch processes 106 batch processes user ID requirements 42 Batch Request Detail Maintenance 106 Batch Request Proce
23. 17 as needed Multiple Databases 89 Setting Up Other Databases Once your database network is running you can make changes to individual databases as needed Maintaining System Accounting Data Change the system entity and base currency as needed in System Account Control 36 1 If needed use Entity Code Maintenance 25 3 1 1 to change the primary entity to the system entity If your inventory database uses a different base currency from the central database use Account Code Maintenance 25 3 13 to set up Sales and Sale Discount accounts with a foreign exchange conversion index of 4 historical Maintaining Locations Normally the sites associated with a particular database should not be accessed in other connected databases You can use the automatic location feature to ensure that new locations are not created inadvertently To do this set Automatic Locations to No in Site Maintenance 1 1 13 for sites not belonging to the current database In most inventory transactions inventory is placed in a site location pair When Automatic Locations is No new pairs cannot be created during transaction processing Since no pairs currently exist in a new database this prevents inventory from being moved to or from a site accidentally Maintaining Inventory Status Codes For sites not associated with the current database assign a fully restricted inventory status code as the default Maintaining Sales Orders Set up Sales O
24. 40 Progress Security 2 2 0 0 ccc tenet nee 41 Saving the UserID 5 sas 0b 036 a elser eres 41 Defining USS a cic de Bh ae eek edie Peale 6 OES has ae Rhee ARA 42 Interaction with Licensing 0 ce cece ee ees 42 Specifying Authorization and Access 0 0 cece eee aes 43 Information Process and Display 00 00 c eee eee eee 44 Identifying Users ecn ceesre er eect e eens 46 Specifying E mail Addresses 00 00 ccc ee eens 46 Setting Interface Preferences 2 0 0 cee eee eee ees 47 Specifying User Groups sausso cece ence nee 48 Specifying Application Use 20 0 0c ccc eee eens 49 Using Menu Security 0 eect n nes 50 FAQAD Contents Specifying Menu Numbers 0eeeeeeeeeeererrnnnee 50 Specifying Groups 0 ens 51 Effect of Menu Security 2 0 0 ccc ccc cent nee 52 User Group Example 0 00 0 52 Using Field Security 2 0 0 0 ccc ene RER 53 Field Security Validation 2 0 0 cece cece ene eens 53 Field Security by Group 2 cc cece 56 Using Site Security at 0h decd ddd dead bedded sed AED done koere 57 Programs Affected i ceed ado Bed dds ek a ae cel eee oats 57 Implementing Site Security 00 0 0 cece ene 58 Ranges of Sites fi or au tues ee Wah debe ae eA a ee 58 Using Entity Security 2 00 0 cee ene n nea 58 Using GL Account Security 0 0 cece cent eens 60 Using Inventory Movement Code Security
25. 71 Label Detail Maintenance 72 Label Master Maintenance 71 Language Code Maintenance 65 FAQAD Language Detail Maintenance 65 Language field User Maintenance 44 languages identifying for users 44 multiple 64 License Registration 49 License Registration Menu 136 142 License Violation Report 147 Licensed Application Report 145 licenses auditing 148 concurrent session 137 displaying recorded license data 146 displaying registered applications 145 enforcing agreement 139 granting access to licensed applications 143 location 137 monitoring in MFG PRO 138 named user 137 removing 143 reporting use 145 tracking violations 39 types 137 upgrading 143 violation reports 146 licensing changing databases 138 interaction with User Maintenance 42 overview 136 recording high water mark 147 warnings versus errors 39 loading data 125 procedure for 126 loading time zones 153 locale dat file 45 location license 42 137 location user 44 log in controlling 94 licensing check 138 required passwords 43 requirements 42 scripts 94 security check 40 Lookup Browse 179 look up browses 178 associating with field 181 creating 186 for generalized codes 18 M Master Comments Report 157 Master Data Audit Detail Report 157 Master Data Audit Report 157 master production scheduling MPS shop calendar 12 material requirements planning MRP performance improvement 19 shop calendar 12 site security 57 Menu Items by Field Report 162 Menu It
26. Desktop In Desktop My Programs lets you organize frequently used programs rather than being a way to access multiple programs This is because you can always run multiple programs simultaneously in detached windows You do not need to be concerned about running two maintenance programs at the same time System Interface 71 User Function Maintenance Set up user menus and function keys in User Function Maintenance Each selection on the user menu should have a different function key reference from 13 to 40 and a zero or blank sequence number The function key reference must be 13 or greater even if your keyboard supports fewer function keys or you plan to access selections through the User Menu Note To set up function keys terminals must be compatible with the Progress protermcap file Fig 4 5 User Function Maintenance aa 86 4 11 selection 18 E oR Inquiry Modifying Labels MFG PRO dynamically reads the label master table to determine the appropriate labels to display on screens and reports For the system to display labels from the label master Translate Frames must be Yes in Label Control 36 4 17 24 Otherwise screens and reports display field labels statically from the source code You can modify how labels display in Label Master Maintenance 36 4 17 1 You may want to modify labels in order to meet specific company needs or to improve definitions of non English labels Fig 4 6 Mas ten Label Master nee Mai
27. Field Security tx2 mstr GTM Tax Rates is mstr Inventory Status usr mstr Users The audit record contains the user ID table name field name and old and new data values Reports and Utilities 157 Review modifications to tracked master tables with either of the following Use Master Data Audit Report 36 17 1 to print changed records in master tables The report includes the database table name current version of the changed record user ID of the person who made the change and date Use Master Data Audit Detail Report 36 17 2 to show details about audited changes when Audit Trail is Yes in System Account Control The report includes current and previous versions of the record with the time and date of any changes The system offers other auditing functions Auditing information for unposted general ledger GL transactions is maintained when GL Transaction Audit Trail is Yes in the General Ledger Control 25 24 This data also displays on the Master Data Audit Detail Report e Use Change Tracking Maintenance 36 2 22 to track changes to sales order detail fields Other Reports Use Master Comments Report 36 17 5 to print the text of master comments selected by a range of references and by type and language Use Control Tables Report 36 17 6 to generate a report listing the current values defined for all control tables in the system This report is especially important during implementation It enables you to ve
28. Name field The program controls and formats incoming data and sends its output back to CIM Data Load See CIM Data Format on page 112 Fig 7 1 CIM Data Load gt See CIM Data Format on page 112 for details FAQAD 112 MFG PRO eB2 User Guide Manager Functions Fig 7 2 Continuous Data Input gt See Determining Data for the Input File on page 114 gt See CIM Data Input File Example on page 115 FAQAD System Formatted Data Raw Data Formatted Data Pre Data Shopikloon processor f Control CIM 7 Database A Data Load Device Program Device Raw Data System Formatted Data Data Snop Floor t Control L CIM m Database avic Program Data Load k e Warning When acquiring external data in real time run CIM Data Load at the highest possible dispatch priority to ensure that data loss does not occur as a result of competition with other system processes CIM Data Format Each program takes in data in groups A group typically consists of input fields within a frame When using a program interactively you must press Go to move from one group to another Data going into the CIM load must use the rules described in this section The BATCHLOAD key word signals the beginning of the data load group consisting of one or more lines Program name is the MFG PRO program that will process
29. SHIPQTY and SHIPTIME with the PRO PLUS i See User Guide Shipment Performance module gg FAQAD 20 MFG PRO eB2 User Guide Manager Functions FAQAD Generate reports on downtime organized by reason code using the Downtime by Reason Report 17 17 Managing Number Ranges Some countries impose sequencing requirements related to tax filings or statutory reporting In many countries companies are legally required to prevent gaps in the numbering of official documents Additionally certain business practices require different business units within the same corporation to maintain separate sequencing for similar documents such as invoices purchase orders sales orders and vouchers Example In Italy the number of an official document is strictly related to the date the document was printed and it is a common practice to have multiple number ranges for shipment and invoice documents In Brazil the number of an official document is related to a specific physical site requiring multiple number ranges with a prefix identifying a site code Number range management NRM supports varied sequencing requirements on a global scale Features include gap control and multiple number ranges for the same document type NRM Overview NRM generates sequence numbers built from one or more segments each with its own set of characteristics and behavior You can add or remove segments during sequence definition but once a sequence has been used
30. See Login and Connection Methods on page 92 fora sample script FAQAD Assign Each Site to a Database During transaction processing the system determines which database to use based on the value associated with the site in Site Maintenance 1 1 13 Your input in Site Maintenance is validated against databases defined in Database Connection Maintenance After assigning databases you can normally complete inventory transactions only for sites associated with the current database Set Up Database Security The system checks the security records in each database when validating user access to menus fields GL accounts entities sites and inventory movement codes When users access data in multiple databases they typically need access to the same programs In this case set up security in the primary database You can then modify security for individual databases after you copy them if needed Copying and Connecting Databases 1 Copy databases to the appropriate locations on your network using prodb or MFG UTIL Use physical database names and directories as defined in Database Connection Maintenance 36 6 1 2 Start the servers for each database using the following command prostart lt dbname gt 3 Check connections by logging into a database using a login script Use Database Connection Inquiry 36 6 2 to review connections You can work in any database during a single session by using Current Database Change 36 6
31. and the Selected Fields list You can use the Move Up and Move Down buttons to arrange the fields in the Selected Fields list If you want to remove a field from the Selected Fields list select it and choose the Remove button When you have arranged the fields in the order you want press Go User Interface Management 189 Enter the column number to take the field values from in Value Returned Column optional The default is the first column of the browse In the Sort Columns field enter the columns you want to have Tip available for sorting Enter the columns as a comma delimited list of ee aad up to seven numbers The first field name in the Selected Fields list is only for look up column 1 the second is column 2 and so on browses The look up browse sorts the records on the first column you enter in the Sort Columns field The remaining columns you enter are listed in the selection list above the browse Select another column in the list and the browse re sorts on that column When it re sorts the browse redisplays beginning at the first record The browse does not redisplay beginning at the record that was selected when the re sort was initiated By default the browse sorts on the first field in the Selected Fields selection list Press Go Fig 12 8 Browse Maintenance ye Browse FG SV OG EN Maintenance GE OOOuE Batts a RER Name ic007 lt Preview gt Sequence 4 Browse Field Data Table Jin
32. appropriately named and located in a convenient directory of your choice PROPATH is the Progress path used to locate code to run This should reference the r code directory where the MFG PRO software was installed e uuid is a global unique identifier value associated with this AppServer instance The Progress tool genuuid should be used to generate a value This tool can be run from the command line and is found in the Progress DLC bin directory Note If you use the Progress Explorer tool to create the AppServer definition the uuid will be generated automatically Application Server 173 appServiceNameList should match the AppServer instance name that you have chosen which is listed in the first line of the properties entry portNumber is the port number for the AppServer broker for this instance Its value can be an arbitrary integer as long as it does not conflict with any port assignments of other applications running on this machine including other AppServer instances srvrMinPort and srvrMaxPort specify a range of port values to use for the 4GL engines spawned by the AppServer instance The range should be large enough to accommodate the maximum number of 4GL engines that can be spawned specified by the maxSrvriInstance parameter and should not have any conflicts with ports used by other applications including other AppServer instances srvrStartupParam specifies the Progress startup parameters to be used by each 4
33. can use User Access by Application Inquiry 36 3 22 to display a list of applications user access status active or inactive access location and access activation date Licensed Application Report Use Licensed Application Report 36 16 10 3 to display a list of software applications registered through the MFG PRO database You can select a range of applications to display Setting Show Only Active Licenses to Yes displays the current license code for an application Setting this field to No displays information on current and expired license codes for applications Records display in descending order of the registration date If there are multiple records for one application the record with the latest registration date displays first The report includes the application description and version license code and type number of licensed users registration and expiration date user ID of the person who registered the application audit date information and any changes to license information Fig 8 10 Licensed Show Only Active Licenses 7 Output Batch ID Application Usage Profile Report After you install and register an application with MFG PRO the software keeps statistics about your application use The statistics include Licensed application name e Menu item s executable program name 145 C Application Report Application O vi 36 16 10 8 FAQAD 146 MFG PRO eB2 User Guide Manager Functions e N
34. code for each user in User Maintenance 36 3 18 This ensures that when the user logs on MFG PRO calls the Progress programs for that person s language If the language is the same for all users but multiple language comments are required for orders you only need to define the separate language codes in Language Code Maintenance A number of codes for supported languages are already defined Language Detail Maintenance Some program options in MFG PRO appear on the screen using alphabetic codes or words Internally these options are controlled by numeric codes Mnemonics and labels provided in English may not be appropriate in other languages Use Language Detail Maintenance 36 4 3 to change add and delete mnemonic codes and labels Fig 4 2 Language Code Maintenance 36 4 1 i See Defining Users on page 42 FA QAD 66 MFG PRO eB2 User Guide Manager Functions Fig 4 3 Language Detail Maintenance 36 4 3 Language ID us english U S Data Set ac_ms Field Name book_type Numeric Code 1 Translatable Text Mnemonic L Label Legal Data Set Enter the program name a database table name or an abbreviation of the functionality for a field Field Enter the field name associated with the data set Numeric Codes These are the values used by the programs A mnemonic code can be assigned for each numeric code Codes cannot be added or edited Mnemonic Mnemonic codes are already assigned
35. databases running you can log in to any database Example To log in to Database2 located on the Database2 CPU a log in script includes the following exec DLC progress qad database2 H database2 S database2 p mf p ld database2 Multiple Databases 93 Table 5 1 shows the login script parameters Parameter Description exec UNIX command that runs Progress DLC progress Version of Progress on your system qad database2 Full path name of Database2 H database2 Host containing qad database2 in etc hosts file S database2 Server connected to in etc services file p mf p Progress program that launches MFG PRO ld database2 Logical name of the database If a 1d parameter is specified the value given for that parameter must also appear in Database Name in the entry for the current database in Database Connection Maintenance Also sites attached to the primary database must include the logical name in the Database field In the script the value of the 1d parameter Database2 sets the logical name of the primary database To determine if a site is in the current database the system checks the database name associated with the site and compares it with the value of the 1d parameter If they are the same the site is in the current database For this reason each database name used in an 1d parameter must be defined in Database Connection Maintenance Since the login script does the actual work of connection
36. description you must use quotation marks Fields used in mathematical operations are numeric values They can contain a decimal point or a negative sign but no other symbols including commas and dollar signs are allowed Do not use quotation marks for numeric values Logical fields use Yes No values and do not require quotation marks Format date fields the way they are formatted in the source field Determining Data for the Input File Each program contains one or more entry groups Each entry group consists of one or more data entry fields in which data can be entered before pressing Go Example In Employee Maintenance 2 7 1 there are three entry groups corresponding to the number of times you must press Go Although direct correspondence between entry groups and frames is normal it is not required The three entry groups are e Key field group employee code e Address group e Employee data group Each entry group corresponds to one line in a CIM file While navigating a program to determine field groupings use the Tab key to move from field to field rather than the Return key The Return key works like the Tab key in all fields except the last field in an entry group where it executes the Go command This can be misleading in determining which fields belong to an entry group CIM Interface 115 CIM Data Input File Example wocimp p Program to create CIM input data file for Work Order
37. do the following 1 Multiple Databases 81 Make a copy of the mfg database that comes with MFG PRO Load your data into this database Use Language Code Maintenance 36 4 1 to set up the language version you plan to use Set up data common to all databases to be implemented as shown in Figure 5 2 Set up a baseline chart of accounts Set up baseline data for entities Set up baseline inventory status codes Set up baseline data for sites and locations Set up baseline data for product lines Set up baseline data for items Set up baseline data for purchase orders Set up additional baseline data Setting Up a Baseline Chart of Accounts Fig 5 2 Multiple Database Data Setup Work Flow As a general rule the more accounts shared across databases the easier the implementation At minimum make common any accounts used with System Account Control 36 1 Intercompany transactions Inventory Product lines Accounts Receivable FAQAD 82 MFG PRO eB2 User Guide Manager Functions Tip Create bank codes in Bank Maintenance 28 9 1 first FAQAD e Accounts Payable Purchase orders Sales orders Note Keep sales order setup information such as customers and price lists in the sales order database only Some countries such as France require a specific chart of accounts in financial statements which may not match the operational datab
38. e Which X and Y are used by this Z X Y and Z can be tables fields menu items or programs Used can mean referenced updated or called e Which database tables are referenced or updated by this menu item e Which menu items call this field e Which program source files use this include file You construct a cross reference in two steps 1 Compile the entire system 2 Build a bill of material from the menu structure The end result is a bill of material for each program in which all programs called by the initial program are components as well as fields called or updated by those programs Cross reference reports provide different ways of organizing the bill of material Background MFG PRO consists of approximately 6200 programs that call some 10 000 fields The programs consist of normal executable Progress programs p files and include files i files which can be called from many different p files System Cross Reference 161 The menu system calls approximately 1400 of those 6200 programs These called programs call numerous other p and i files Progress programs can be nested enabling you to place i files within i files and so on These Progress programs read or change information in database tables such as the item master pt mstr or the printer master pr mstr The database tables consist of records containing entries in a group of fields When Progress is compiled the list of programs called and
39. each database individually FA QAD 58 MFG PRO eB2 User Guide Manager Functions gt See Specifying Groups on page 51 FAQAD Implementing Site Security Because of the complexities of MFG PRO security it is important to plan site security carefully and to follow closely the procedures for creating user and group names and associations Users who are not listed individually or who have no group memberships in Site Security Maintenance 36 3 16 cannot complete transactions at secured sites To implement site security associate groups with users in User Maintenance You can use previously defined groups to implement site security Ranges of Sites Many programs let you access a range of sites at one time Site security controls data updates and processes for ranges of sites If you enter a range of sites you must have access to all of them for the update to occur When you enter a range of sites that includes sites you do not have access to an error message displays for the first site code from which you are restricted You must then adjust the site range to include only sites that you can access Using Entity Security When entity security is in place only authorized users can complete update transactions in the General Ledger module for particular entities Update transactions include Transaction maintenance Posting e Consolidation Export and import Budget maintenance Opening and closing fi
40. field in Field Security by Group displays as the comment for the field and user combination in Field Security Maintenance Users and Security 57 Using Site Security Site security lets administrators control user access to inventory transactions at each site Only authorized users can process transactions at secured sites Access is managed by user and by group A user can access a site only if that user s ID or group name appears in the Groups field in Site Security Maintenance 36 3 16 Fig 3 10 Site Security Maintenance Site 10000 36 3 16 Groups When a user enters a restricted site code in a site controlled program the system checks the value of the Groups field associated with the site in Site Security Maintenance If the user does not belong to an associated group an error message displays and the user cannot complete the transaction Programs Affected Site security works with programs that change inventory data and have a Site field as part of the selection criteria Site security checks ranges of sites on batch update programs that meet the previous criteria they affect inventory and have a Site field This includes programs such as Regenerate Materials Plan 23 2 and Sales Order Auto Allocations 7 1 17 Site security does not affect inquiry and report programs Delete and archive programs Contract Control 11 5 24 and Quality Management Control 19 24 do not use site security You must set up
41. for inquiries is always terminal You can specify devices for a user ID or a combination of user ID and menu selection This can be useful for specialized tasks such as sending checks to a check printer the same user can have different default output devices for different programs The default does not necessarily have to be a physical printer you can also choose to send output to the terminal page a window GUI only or an e mail recipient Defining Document Formats Some programs let you specify alternative formats for printed documents in addition to the system defined default formats For example an Italian customer may require a different sales order layout than a US customer In that case you can specify a predefined alternate format in the Form Code field of Sales Order Print 7 1 3 You do not use a menu level MFG PRO program to define alternate document formats Instead you must create a Progress program to generate them Use the following steps to do this 1 Create a Progress program to format the document as required 2 Name the new program file appropriately so it can be located by the print program The file name is typically created by removing the first two characters of the print program name and appending a two character form code 3 Modify the applicable print function to consider the new form code as valid Tip Remember this is only the default you can change it to any valid device when you run the
42. for each field with several system specified options These codes can be changed added or deleted using this program Label Default labels already exist for the different mnemonic codes These labels can be changed added or deleted using this program Customizing Menus and Function Keys You can execute a program in a number of different ways Type the program name such as mgmemt p at any menu prompt When you exit the program the prompt redisplays Type the full number such as 36 4 4 at any prompt If you are currently on another branch of the menu tree for example the 1 4 menu enter a period before the menu number 36 4 4 Type a partial number from a submenu such as 4 4 while located at menu 36 Press a function key that is assigned to this program Select the program from the User Menu FAQAD System Interface 67 You can control the menu numbers and the names associated with Tip If you make these programs in several ways ee e Move menu items be lost during software updates Change menu names e Create names for menu items e Specify security for menus See Using Menu Security on All menu information is contained in the mnd_det table View its page 50 structure in the MFG PRO Data Dictionary With each release you receive the latest version of this table which you should load into your databases As QAD develops new programs it populates this table with new records and alters ex
43. for maintenance Note Inventory movement security does not affect whether a line item from a given sales order or other originating transaction can be added to a shipper You can delete inventory movement security records at any time Use Inventory Movement Code Security Browse 36 3 12 to display inventory movement code security records Fields associated with a record can be viewed by scrolling the display to the left or right Fields available as filtering parameters in Browse Options are also available on the Sort By selection list FA QAD 62 MFG PRO eB2 User Guide Manager Functions FAQAD 74 64 MFG PRO eB2 User Guide Manager Functions Fig 4 1 Multiple Language Installations FAQAD Using Multiple Languages MFG PRO supports multi language capabilities in two areas e Screens displayed in multiple languages e Data stored and displayed in multiple languages Database with Spanish D Spanish D Compiled r Schema Code Updates E Production c_o Database with Spanish Source Code and French S Menus and Messages Database lt m x French with French A Schema Compiled r Updates Code a The system can display screens in multiple languages because the programs are in multiple languages If you have some users who want to see MFG PRO in Spanish and others who want to see it in French you need a set of Progress programs in each language The Spanish programs are compile
44. s0B Neg Line Feed Reset Printer Type Select your printer type from the list of predefined types If your printer type is not in the list use a similar printer type or define a new one To define a new printer type you specify a series of programming sequences to control printer characteristics and behavior in the following situations e 80 character width print jobs e 132 character width print jobs e Barcode print jobs Hardware initialize and reset Printers and Batch Processing 101 Using control characters you define how your printer performs such tasks Tip as modifying fonts changing page orientations producing multiple anser A copies and so forth Your printer manual is the best resource for control related aspect of code definitions printer control will not work Use normal ASCII characters in the control fields For nonprinting characters also called control characters use a slash and the three digit ASCII number for the character Table 6 1 lists characters frequently used in control sequences Table 6 1 Control Character ASCII Control Characters Backspace 008 Tab 009 Linefeed 010 Form Feed 012 Carriage Return 013 Escape 027 Default system data includes correct control sequences for some commonly used printers Note One of the default printers is terminal Use terminal in a character interface window in a Windows interface and page in QAD Desktop Table 6 2 Code Function Sample P
45. security 36 3 16 limits who can create inventory transactions at secured sites Desktop security 36 3 21 lets you restrict who can log into a database using QAD s Desktop interface It also provides a detailed and focused way of controlling access to data when browses and reports are generated from the Desktop Master table audits 36 17 menu show when and by whom changes were made to key master tables Figure 3 1 illustrates how several different kinds of security can operate at the same time with the same user Users and Security 37 Fig 3 1 Menu security Types of Security prevents access i to Screens GL Reference IC020613000001 Type IC Effective 06 13 02 Period 6 2002 Field security Currency USD Control 50 00 Base Total 0 00 prevents Daybook Entry Number changing a field Primary Entity Correction O Account Information Entity security Acou ma P Sub Account prevents Cost Center ct Enty Description Cur Amount 1000 ISS S0 S501004 USD 0 00 creation of GL Project transactions for an entity Adding new record O Q Account security prevents users from updating an account balance By default only log in security is defined in MFG PRO Once you set up explicit permission for one user for entities fields or menus all other users are excluded For this reason you should have a comprehensive security plan before beginning to set up security records All sec
46. security the use of groups is entirely appropriate In a few cases you might not want to use groups For high risk functions such as Menu Security Maintenance grant access to specific users by ID Using Field Security Field security prevents unauthorized users from updating secured fields It does not prevent them from seeing the value of a field if they have access to the screen where it is updated Neither does it protect a field from program level updates through custom code The system determines whether a user is authorized based on whether the user ID matches the values specified for the field User groups are supported through a two step process Field Security Validation In the standard release of MFG PRO security is not active for any fields and only a few fields are eligible for field security Use the Dictionary Field Security Report 36 3 6 to determine which fields can be given security Table 3 3 Sample User Setup gt See Specifying Groups on page 51 FAQAD 54 MFG PRO eB2 User Guide Manager Functions FAQAD In the character and Windows interfaces you can also access the field on a screen and press Ctrl F For eligible fields the message Password Validation displays An eligible field must have a specific validation expression in the data dictionary The expression must reference gppswd v The syntax is gppswd v amp field lt dictionary field name gt Activated Field Security Report
47. the end of the header and detail record key frames This field can be updated only when the program is accessed through a batch process that is when batchrun true Note When you press Ctrl F in a field of a program with batchdelete enabled a message indicates that you can use batch delete You can do this in the character and Windows interfaces Menu Label Program Name Customer Maintenance adcsmt p Customer Ship To Maintenance adstmt p Customer Item Maintenance ppcepmt p Generalized Codes Maintenance mgcodemt p Site Maintenance icsimt p Entity Code Maintenance glenmt p CIM Interface 119 Menu Label Program Name Account Code Maintenance glacmt p Sub Account Code Maintenance glsbmt p Cost Center Code Maintenance glccmt p Currency Maintenance mecumt p Price List Maintenance pppimt p Price List Maintenance pppcmt p Item Master Maintenance ppptmt p Because the bat chdelete value exists at the end of key frames it does not affect existing CIM input files and can be omitted from these files when not used Since it is only one character unlabeled and hidden the field also does not change the visible MFG PRO interface Creating Input Files to Delete Records Use these guidelines when creating input files that include deletes 1 To determine if batchdelete is enabled in a particular program check the list in Table 7 1 Note In the character and Windows interfaces press Ctrl F to display the informational messa
48. the input data For example if item data is being loaded the program name would be ppptmt04 p Item Data Maintenance 1 4 3 All input data contained between each BATCHLOAD and END is one group regardless of how many transactions are specified in the data section Limit the number of transactions to 50 Each transaction entry can involve the creation of many records The more transactions in a transaction group the more system resources are required for processing and the greater the likelihood of errors An error in one transaction can put all transactions in a group out of sequence and prevent the system from processing that group In cases where maintaining data integrity is vital and re creating data difficult you might limit the number of transactions to one CIM Interface 113 Input File Formatting Rules When creating your CIM input file follow these formatting rules Use a single line of data for each input request To treat two consecutive input lines as a single line place a tilde Tip at the end of the first line Place no characters including spaces after ke me sk not the tilde create the CIM file in an editor Surround character fields with quotation marks At the end of each input group use a line feed The end of an input line performs the same function as the Go key Fields for which there are no data and that come at the end of an input sequence do not require hyphens Type all characte
49. the pull down User Menu This menu has multiple sections e User menu items display in the top section ordered by the value of the Function Key and Sequence fields For example the program assigned to function 13 sequence 2 follows the program assigned function 13 sequence 0 The program assigned to function 15 comes after both of these Programs defined in User Tool Maintenance 36 20 4 display below See User Tool User Menu items They also display as buttons on the toolbar of S ia programs with which they are associated Unlike user menu items eee you can associate user toolbar items with specific programs or groups of programs Note Programs defined with User Tool Maintenance do not display on browses The exact menu items that display depend on whether you have user specific items defined in User Function Maintenance If you have user specific items defined they display on the menu e If no items are associated with your user ID the menu includes only items assigned to a blank user ID Note This is unlike the character interface where users can see both menus Character Interface Access programs associated with a function key by selecting that function key Function keys Fl through F12 are reserved for MFG PRO so the assigned key must be F13 or higher Since many keyboards do not handle that number of function keys this option is used less frequently AQAD 70 MFG PRO eB2 User Guide Manager Function
50. the tables and fields read or potentially updated by those programs can be output This output along with MFG PRO supplied utility information is the source of the cross reference Table Field and Menu Reports The eight cross reference reports answer such questions as What does this table field message menu item or program do The syntax is XYZ For example the Tables Fields by Menu Report tells you what tables X and or fields Y are called by or updated by menu item Z Similarly Menu Item by Message Report tells you which menu items X Y call a particular message Z Table 10 1 Program Name Description Table Field and Menu Reports Tables Fields by Menu Shows what tables or fields are referenced or updated by Report 36 18 1 programs called by a top level menu Limit searches further by execution file database table and field Report includes the type of actions performed by the selected programs on each table or field listed Action types are create search update delete and access Tables Fields by Similar to 36 18 1 but not limited to menu level programs Program Report Shows what tables or fields are referenced or updated by the 36 18 2 named Progress program Before running this report for a top level program first use Program Source File Report 36 18 16 to generate a list of subprograms called by the program Then run Tables Fields by Program Report for each relevant subprogram FAQAD 162 MFG
51. to generate or validate numbers you cannot change its structure Figure 2 8 illustrates a sample sequence with five segments three fixed value segments NY and two dashes one incrementing integer segment 1234 and one date driven segment 06 15 02 NY 1234 System Constants 21 06 15 02 Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Table 2 2 describes the three segment types Segment Type Description Required Incrementing Integer A range of values with a lower bound an upper bound initial and reset value Yes Each sequence number must have one and only one incrementing integer segment Date Driven A value that depends on the transaction effective date or the fiscal period that corresponds to the effective date The format is a compound string that allows the optional display of date components such as year month week day including delimiters between components Delimiters separate the individual components of a segment For example 06 15 02 uses colons as delimiters No Each sequence can have one date driven segment Fixed Value Any printable character except a comma For example NY may be a fixed value segment assigned by a client in New York A fixed value segment is not changed in any way during sequence number generation No Sequence Number Generation To update a sequence number the system examines each segment separatel
52. to load a set of sample data based on a snapshot of time zone information The data assists in the setup process and is a sample only After you load this data verify that the time zones are valid and appropriate for your business practices Use Multiple Time Zones Report 36 16 22 2 or Inquiry 36 16 22 3 to review definitions and ensure they conform to your requirements Each organization is responsible for maintaining and updating time zone data to correspond to changing realities and business requirements If needed you can delete existing time zone data and reload the sample data Figure 8 17 illustrates the Multiple Time Zone Load Utility Fig 8 17 Multiple Time Zone Load Utility 36 16 22 13 This utility will allow user to load sample Time Zone data This utility may be run more than once if sample Time Zone data need to be refreshed at a later date For complete details on the effect of running this utility see the procedure help Load Sample Time Zones O Delete Existing TZ Data O FAQAD 154 MFG PRO eB2 User Guide Manager Functions FAQAD Load Sample Time Zones Yes indicates you want the system to load sample time zone data You can use this data as the basis for your own time zone maintenance After loading verify that the time zones are valid and appropriate for your business Use Multiple Time Zone Report or Inquiry to ensure the definitions conform to your requirements Delete Existing TZ Da
53. to set up a link between two programs so that when users select one from a menu the other program displays This is useful for substituting custom versions of existing programs In the Windows and character interfaces which program is invoked for a particular user depends on whether they have enabled menu substitution Each user can turn menu substitution on or off in User Maintenance 36 3 18 or in the Windows environment from the Options menu In the Desktop interface browses and standard programs are always placed on the menus Users can find the alternate program using the search function Menu substitution affects standard MFG PRO programs in these ways e Replaces browses with inquiry programs Replaces standard programs with custom versions FAQAD 186 MFG PRO eB2 User Guide Manager Functions Fig 12 5 Menu Substitution Maintenance 36 20 6 FAQAD Menu Substitution Maintenance Execution File adbr014 p New Execution File Selection Label Term Supplier Inquiry 1 Enter the program name in Execution File Users selecting this program from a menu will actually be running the one entered into the New Execution File field 2 Enter the substitute program name in New Execution File This is the name of the program to replace the one entered in Execution File Users will run this program when they select the one entered in the Execution File field You can use wildcards For example if you want to
54. up window Wildcards in Drill Down Lookup Maintenance Use wildcards to attach browses to fields in multiple programs For example pp p attaches the drill down to the specified field in all programs starting with pp and ending with a p extension Possible entries to Drill Down Lookup Maintenance Field ad_addr ad_addr ad_addr Calling Procedure so soivmt p Procedure to Execute adbrad p adbrcs p arbrbl p When you drill down on ad_addr in soivmt p a menu shows all three browses adbrad p adbrces p arbrb1 p When you drill down on ad addr in a program other than soivmt p but beginning with the letters so a menu shows two browses adbrad p and adbres p When you drill down on ad_addr anywhere else the browse adbrad p opens Fig 12 2 Wildcards in Drill Down Lookup Drill Down Lookup Drill Down Maintenance Field Name ad_addr Calling Procedure Procedure To Execute adbrad p FA QAD 182 MFG PRO eB2 User Guide Manager Functions Fig 12 3 Nested Drill Downs AQAD Drilling Down on Drill Downs You can nest drill downs In other words one drill down can call another which can call another and so on After creating the first drill down you can assign the others to the same field Enter the name of the first drill down as the calling procedure for the nested drill down First drill down Enter the name of the first Drill Down Lookup Drill Down drill down Field Name ad_addr Cal
55. var05 you name your local variable local var0o6 Use local variables when you want to return a value resulting from an operation on two fields for example the quantity required minus the quantity open Define the operation in Expression If you entered a local variable in Field Name enter its Label Term Format and Data Type User Interface Management 195 12 If Field Name is a local variable you can enter Progress syntax in Expression to define the local variable Valid expressions include e fieldl field2 computation where fieldl and field2 are fields within the record e gt lt gt operands that perform comparisons Progress functions suchas substring field1 1 4 or round field1 1 Note Incorrect syntax terminates your MFG PRO session if you attempt to use the view AQAD 196 MFG PRO eB2 User Guide Manager Functions FAQAD Symbols exclamation point 51 asterisk 51 pf files parameter files 87 Numerics 2 13 13 158 2 14 1 45 7 15 14 33 11 21 22 24 153 11 24 150 17 17 19 36 2 1 14 36 2 5 13 36 2 9 15 36 2 13 17 36 2 17 19 36 2 21 1 22 36 2 21 5 28 36 2 21 13 29 36 2 21 23 29 36 2 22 29 36 3 1 50 36 3 4 54 56 36 3 6 54 36 3 7 56 36 3 8 60 36 3 11 61 36 3 12 61 36 3 16 57 36 3 18 42 36 3 22 49 145 36 3 24 38 36 4 1 65 36 4 3 65 36 4 4 67 36 4 7 72 36 4 11 67 Index 36 4 13 73 36 4 14 74 36 4 15 74 36 4 16 74 36 4 17 1 71 36 4 17 5 72 36 4 17 24 71 36 6
56. you use Tip Use the MM DD formatregardless of the date format you use FAQAD Auto Period Adjust This field indicates whether the system should adjust the time zone you are defining for a given period usually daylight savings time or its equivalent Yes Define the period to be adjusted in the subsequent detail frame No Time Period defaults to STD standard You cannot change it Time Period This field is editable if Auto Period Adjust is Yes Valid choices are STD for standard time Day for daylight saving time and Sum for summer time You can define details for two periods a standard period and a special adjusted period for daylight savings or its equivalent This field determines which of the detail fields are required Start Year Enter the beginning year of the range associated with this time zone definition In some countries the implementation of time zones varies from year to year Using start and end dates you can set up multiple records effective at different periods of time End Year Enter the ending year of the range associated with this time zone definition If you do not know when the current definition ceases to be effective use an end year such as 9999 GMT Offset Enter the actual offset in hours and minutes from Greenwich mean time GMT for this time zone Enter this number with either a plus sign or minus sign indicating the direction of the offset GMT is the base for establishing th
57. your security changes in the database against which you compile The changes are then in effect for any other databases you run the compiled code against 1 Identify and list all fields you want to add security to Since recompiles take time it is more efficient to add all field security at once Make sure all other users are logged out Run Field Eligibility Maintenance mgfldcmt p 36 25 22 which changes the validation expression and message in the data dictionary Set field security for each field on your list The mg 1demt p utility prompts for a table and field name on which to activate field security Once you enter a valid field and table name and you press Go you are prompted for the next entry Press End to exit Field Eligibility Maintenance Recompile either all programs or those programs impacted by the changed field security If you have custom programs that access these fields they also need to be recompiled To compile only the affected programs make a backup copy of utcompil wrk in the gad directory and then delete the program names that you do not want recompiled from the file utcompil wrk contains a complete list of all programs Back up recompiled code You can now add the field name and the list of user IDs that can access each field in Field Security Maintenance 36 3 4 Verify that each field is secured by running the Activated Field Security Report 36 3 5 AQAD 56 MFG PRO eB2 User Gui
58. 2 external 22 internal 22 oO operating system e mail 75 multiple e mail systems 75 Operating System Commands menu 158 Oracle database sequences 135 P parameter files 87 passwords aging 39 changing regularly 39 expiring 43 required for log in 43 planned work orders shop calendar 12 planning change tracking 30 Primary location for user access 44 Printer Default Maintenance 105 Printer Setup Maintenance 102 Printer Type Maintenance 100 printers control codes 101 PIQAD 202 MFG PRO eB2 User Guide Manager Functions default 105 Desktop setup 104 max pages 104 setup 102 terminal 101 type definition 100 procedure help 73 printing 74 Procedure Help Report 74 Program Execute 158 Program Run Report 163 Program Source File Report 163 Program Summary Bill File Create 164 Program Text File Display 158 Programs by Field Report 163 Programs by Table Report 163 Progress application server 168 batch 107 document formats creating with 105 editor security 52 function key limitations 68 log in scripts 93 messages 72 multi language 64 program names 107 root user 40 security 41 protection See security protermcap function keys 71 purchase orders cross database transactions 96 Q QAD type User Maintenance 46 R reason codes for change tracking 30 Sales Order Maintenance 19 32 sales quotes and 19 shipment performance 19 shop floor control 19 Reason Codes Maintenance 19 registered applica
59. 4 16 and Programs with No Menu 36 18 24 18 reports These reports show any errors in menu or program listings Missing Menu Execution File Report for instance shows names of programs called by the menu that do not exist 3 After making corrections add parent component relationships not included in step 1 Missing parent components are supplied by the cross reference 4 Run Menu Item Cross Reference Create 36 18 24 3 to link all cross reference items with the menu 5 Delete obsolete cross reference items FA QAD 166 MFG PRO eB2 User Guide Manager Functions FAQAD 168 MFG PRO eB2 User Guide Manager Functions gt See the Progress documentation for more information on setting up and using AppServers gt See User Guide Volume 3 Manufacturing for information on MRP gt See Example Using an AppServer to Run MRP on page 170 FAQAD Progress AppServer The Progress Open Application Server or AppServer is a brokered collection of 4GL engines that can execute Progress programs on the server in response to remote client requests Each AppServer instance is identified by a unique name and contains a broker that manages a pool of AGL engine processes each of which is available for processing client requests The client connects to an AppServer indirectly through the Progress Name Server This provides for location transparency and also provides the logical basis for load balancing a
60. 6 3 11 Inventory Movement Code Security sosimt p 36 3 11 Inventory Movement Code Browse gpbr502 p 36 3 13 Entity Security Maintenance glsecmt p 36 3 14 Entity Security Inquiry glseciq p 36 3 15 Entity Security Report glsecrp p 36 3 16 Site Security Maintenance clsismt p 36 3 16 Site Security Report clsisrp p 36 3 18 User Maintenance mgurmt p 36 3 19 User Inquiry mguriq p 36 3 20 User Password Maintenance mgurmtp p 36 3 20 User Access by Application Inquiry Ivusriq p 36 3 24 Security Control mgurpmmt p Setting Up Security Control Use Security Control 36 3 24 to establish basic security parameters for a database Session ID Prefix I Timeout Minutes 0 Password Expiration Days 0 Enforce Licensed User Count O Session ID Prefix Enter a prefix for temporary system generated work files These are created in the directory where the user started MFG PRO The default is TMP Modify this field only if you access multiple databases from the same directory If the prefix in both databases is TMP one session s temporary files could overwrite another s Users and Security 39 Timeout Minutes Specify a number of minutes after which the system should automatically log out inactive sessions Set a value in this field to minimize unnecessary overhead on busy systems Password Expiration Days Set a value to require users to change their passwords after this number of days Users who have not changed their passwords within th
61. Discarding Effective Date 07 08 2001 Allow Voiding E Expiration Date 07 08 2002 Segment List Settings Control 0 0 0 0 Segment Editors The segment editor used depends on the type of segment being defined Use the editor to create or modify the segment format definition and assign a new segment number There are four types of segment editors Fixed segment editor for fixed value segments Integer segment editor for incrementing integer segments System Constants 27 Date segment editor for date driven segments Fiscal segment editor for date driven segments relative to fiscal periods Fixed Segment Editor Use the fixed segment editor to establish a fixed string value You can use any printable character except a comma Fixed Segment Editor New Seg Nbri 2 Integer Segment Editor Use the integer segment editor to specify the initial reset minimum and maximum values for a segment Integer Segment Editor New Seg Nbr 1_ Minimum value o Initial value Reset Value 0 O Q Maximum vale 0o Date Segment Editor Use the date segment editor to tell NRM how to display a date component of a sequence number Specify codes representing date components such as year month day You can add components in any order with optional delimiters In the date segment 07 02 a forward slash is the delimiter You can indicate if this segment is a control segment Changing the value of a control segm
62. Ds by separating them with commas 4 Press Go Fig 12 13 View Maintenance Table Selection yw os amp Sequence 2 Table Selection Tabie emanate nein Type iner E Join Phrase O Q 5 The number you enter in Sequence controls the order in which the table defined in Table is joined to the view 6 Entera table name 7 Ifthe sequence is not 1 specify the type of join either inner or outer The Join Type field is only enabled when the sequence number is greater than 1 FA QAD 194 MFG PRO eB2 User Guide Manager Functions Fig 12 14 View Maintenance View Field Data Tip Search for a label term by entering a portion of a label then use Next Previous to display available records FAQAD 10 11 Enter or edit the phrase to join the tables Use proper Progress syntax Do not include a Where verb Join phrases express the field relationships between tables see Figure 12 10 For a faster display of fields use indexed fields in the Join Phrase Press End View Maintenance Name cmhhist01 Table cm_mstr Field Name P View Field Data Label Term Format Data Type Expression In Field Name enter a field from one of the tables in the view or enter a local variable When entering a local variable name it local varnn where nn is a number incremented by one from the last defined variable For example you see from the look up browse that the last local variable was local
63. GL engine that is spawned The specific DB host and service names should match the values that correspond to your MFG PRO database installation Other values should remain as specified in the examples controllingNameServer specifies the Progress Name Server instance with which the AppServer broker will register its name The Progress default is NS1 Since the AppServer broker mt_mrppro is used internally by MFG PRO you must use AppServer Service Maintenance 36 19 1 to define an application server connection master record Additional Oracle Tasks If you have an MFG PRO Oracle installation you must perform two additional tasks Add an Environment entry like the example below to the ubroker properties file Environment MRP ORACLE ORACLE HOME Oracle OracleAppServer ORACLE SID YourSystemIdentifier ORACLE BASE Oracle b See Defining the AppServer on page 169 FAQAD 174 MFG PRO eB2 User Guide Manager Functions gt See the Progress AppServer documentation Tip Click Start Programs Command Prompt to launch a DOS window FAQAD Where e Oracle OracleAppServer is the directory where the Progress AppServer for Oracle has been installed for example dr01 app oracle product 8 1 7 e YourSystemIdenti fier is the Oracle system ID SID for your system e Oracle is the base Oracle directory which contains version specific subdirectories for example dr01 app oracle Starting and S
64. In the Windows interface you generally assign browses and inquiries only to toolbar buttons Running a maintenance program while working in another maintenance program can cause problems and is not recommended Desktop Interface In the Desktop interface you use User Tool Maintenance to assign links that let you access one program from another These links display on the bottom of the program screen Images do not apply to Desktop The link displays the text label specified If no label is specified the standard menu description from Menu System Maintenance is used When you click a link the program opens in a new detached window You can run as many detached windows as the system settings allow b See User Menu and Function Keys on page 68 b See User Guide QAD Desktop for details on adding links FA QAD 184 MFG PRO eB2 User Guide Manager Functions Fig 12 4 User Tool Maintenance 36 20 4 AQAD User Tool Maintenance Figure 12 4 illustrates the User Tool Maintenance screen U U Y w amp User ID Program so Programs Exec Label ladonoonw Cust Maint eustmt adbroosp Custer ouster Bsoiviaonp so Inv inq seinsing ladertmtp Cr Trm Maint ertrmmt_ e pem E e m Oo Er Er es Enter a user ID or leave the field blank to assign the button or link to all users Enter a program name or leave the field blank to assign to all programs You can a
65. Industry specific QAD SOLUTIONS Manufacturing Applications MFG PRO eB2 User Guide Volume 9 Manager Functions System Constants Users and Security System Interface Multiple Databases Printers and Batch Processing CIM Interface Database Management Reports and Utilities System Cross Reference Application Server User Interface Management NQAD 78 0565A MFG PRO eB2 September 2002 This document contains proprietary information that is protected by copyright No part of this document may be reproduced translated or modified without the prior written consent of QAD Inc The information contained in this document is subject to change without notice QAD Inc provides this material as is and makes no warranty of any kind expressed or implied including but not limited to the implied warranties of merchantability and fitness for a particular purpose QAD Inc shall not be liable for errors contained herein or for incidental or consequential damages including lost profits in connection with the furnishing performance or use of this material whether based on warranty contract or other legal theory MFG PRO is a registered trademark of QAD Inc QAD QAD eQ and the QAD logo are trademarks of QAD Inc Designations used by other companies to distinguish their products are often claimed as trademarks In this document the product names appear in initial capital or all capital letters Contact the appropriate companies for mor
66. Item Data Maintenance Item Number 10 10000 Description YST 1 4 3 Unit of Measure EA P Item Data Prod Line 1000 Item Type CONFIG Drawing 10 10000 Added 05 28 1992 Status AC Rev AB Design Group Group DISCRETE Drawing Loc Promo Group Price Break Category Use the following code to load this data batchload ppptmt04 p 10 10000 Ea Oasis TM Cooling System Home Indust Model 1000 5 28 1992 Config AC DISCRETE 10 10000 AB end FA QAD 118 MFG PRO eB2 User Guide Manager Functions Table 7 1 Programs with batchdelete Functionality FAQAD Error Handling When the CIM load is completed CIM Data Load Processor 36 15 2 creates a report showing the groups successfully processed and any processing errors Groups containing an error are not processed Troubleshoot errors using the following guidelines e Are the values appropriate e Is there a line reading batchload e Is there a line reading end e Are the data in the correct order Are there any blank lines e Are there any misplaced spaces Is there an end of line for each data set Does it complete the record e Did the first error cause all the others Deleting Records through CIM You can use CIM to delete records created with any of the MFG PRO programs listed in Table 7 1 In each of these programs an updateable single character field bat chdelete exists at
67. Maintenance 36 2 9 After defining rounding methods apply them to currencies in Currency Maintenance 26 1 Rounding Method 2 Description Round to hundredths Rounding unit a 010 Rounding Threshold 0 0050 Decimal Point O Q Rounding Method Enter an alphanumeric code identifying the new rounding method to be created Rounding Unit Enter the number of decimal places to which monetary values are rounded For example to specify rounding to three decimal places enter 0 001 Rounding Threshold Enter the number at which monetary values are rounded up This number must be less than the number entered for the rounding unit For example if the rounding unit is 0 001 entering 0 0025 for the rounding threshold tells the system that decimal values of 25 ten thousandths and higher are to be rounded up to the nearest one thousandth Amounts are rounded based on their absolute value For example 9 99 is rounded the same as 9 99 Decimal Point Enter the character to be used as the decimal point in monetary values Fig 2 3 Rounding Method Maintenance 36 2 9 PIQAD 16 MFG PRO eB2 User Guide Manager Functions Fig 2 4 Currency Maintenance 26 1 gt See Adding Validation on page 18 FAQAD Use Currency Maintenance 26 1 to apply rounding methods to currencies Currency Maintenance Currency fr Description French Franc Enter a rounding Rounding Method 2 method in t
68. PRO demo databases use printer and terminal for the most commonly used printers However you can use any name You can set up more than one record for the same printer as long as you use different names in Output To For example this lets you access the same printer from both character and Windows clients Destination Type Enter the type of device represented by this printer definition Valid values are e Default This is a server printer a terminal display a Windows display or output to page In Language Detail Maintenance 36 4 3 this mnemonic is assigned to value 0 zero See Building an EMail This printer definition sends the report output to an e mail Mal sil message For this to work properly you must have an e mail page 74 system that accepts a command line interface The e mail system must be set up in E mail Definition Maintenance and the User FAQAD Printers and Batch Processing 103 Maintenance record for each user must include an e mail definition and e mail address In Language Detail Maintenance this mnemonic is assigned to value 1 Winprint Use this type to represent printers selected from the Windows network of a GUI client computer Devices defined with this type are available only from GUI clients When you run a report and specify a Winprint device in the Output field you can select a specific printer from your network and control some printing options through Windows dialog boxes In Lang
69. PRO eB2 User Guide Manager Functions FAQAD Program Name Description Menu Items by Field Report 36 18 4 Menu Items by Table Report 36 18 5 Menu Items by Message Report 36 18 6 Messages by Menu Item Report 36 18 8 Shows which menu items call a field or range of fields Further limit searches by execution file and database table Shows field name and table calling menu item and kind of action performed Action types are create search update delete and access Similar to 36 18 4 but limited to a database table or range of tables rather than fields Shows which menu items call a table or range of tables Further limit searches by execution file and menu item Shows table name menu item execution file and kind of action performed Action types are create search update delete and access Shows which menu items call a particular message or range of messages Further limit searches by menu and execution file Shows message numbers and message text Shows all the messages called by a particular menu item Further limit searches by menu and execution file Shows message numbers and message text For all reports the top level selection is the first one searched To speed up processing enter values in the top level System Cross Reference 163 Using Program Reports Program reports list all programs i files and p files called by a menu item Program Name Table 10 2 Description Pr
70. Receipt Backflush DEFINE DEFINE DEFINE DEFINE DEFINE DEFINE OUTPUT REPEAT END VARIABLE VARIABLE VARIABLE VARIABLE VARIABLE wonbr LIKE wo_nbr wolot LIKE wo_lot wogty LIKE wo_qty_comp woyes AS LOGICAL INITIAL yes wono AS LOGICAL INITIAL no STREAM bf STREAM bf TO batchloa d PROMPT FOR wonbr wolot woqty wonbr wolot woqty INPUT wonbr INPUT wolot INPUT woqty See if work order exists in system FIND FIRST wo_mstr WHERE wo_nbr wonbr AND wo_lot wolot NO LOCK NO ERROR IF AVAILABLE wo_mstr THEN DO Identify beginning of record amp program used PUT STREAM bf batchload wowoisrc p SKIP The work order number and ID EXPORT STREAM bf wonbr wolot qty comp issue alloc yes issue pick yes EXPORT STREAM bf woqty woyes woyes Component issue yes PUT STREAM bf SKIP Display items being issued no PUT STREAM bf Is all information correct yes EXPORT STREAM bf woyes Qty complete EXPORT STREAM bf woqty Remarks no PUT STREAM bf SKIP Display item and lot serial detail no EXPORT STREAM bf wono Is all information correct yes EXPORT STREAM bf woyes Please confirm update yes EXPORT STREAM bf woyes Identify end of record PUT STREAM bf end SKIP END OUTPUT STREAM bf CLOSE FA QAD 116 MFG PRO eB2 User Guide Manager Functions Tip You can als
71. Setup Programs 0 0 eee eee eens 150 Multiple Time Zones Maintenance 0 e eee eee eee 151 Multiple Time Zone Load Utility 00 0200 153 Chapter9 Reports and Utilities 0005 155 Generating Master Data Reports 0 0 0 ce eens 156 Auditing Reports 0 cece cece cnet enna 156 Other Reports creases dae dade a hbo edb Ed enedes 157 Using Delete Archive Utilities 0 0 cee eens 157 Audit Detail Delete Archive 00 0c cece eee 157 GL Transaction Delete Archive 0 00 cece eee eee eee 158 Using Operating System Commands 0 002 cece eee eee 158 Chapter 10 System Cross Reference 222000005 159 Using System Cross References 0 00 cece cect eee eens 160 Background 105 00 cea Koh ee Mion Cee eR ede eh tied eb eS 160 Table Field and Menu Reports 00 0 cece eee ee ene 161 Using Program Reports 0 teens 163 Updating the Cross Reference 0 c ccc cette eee 165 Chapter 11 Application Server 0 cee eee eee 167 Progress AppServer 0 0 eee teen enn eee 168 Defining the AppServer 0 eee eee ene enn enes 169 FAQAD Contents ix Example Using an AppServer to Run MRP 0 0 0 0 eee eee ee 170 Modify the Properties File 0 0 0 cece eee ene 170 Configuring the AppServer 0 000 c cece cece teens 171 Starting and Stopping the AppServers
72. Verify GL Accounts is Yes in System Account Control 36 1 Account security groups are validated against groups assigned to users in User Maintenance 36 3 18 Use GL Account Security Maintenance 36 3 9 to assign security groups to account numbers Use the GL Account Security Report 36 3 10 to list all accounts that have security groups Account 1035 Unreal Exch Gain USD Security Groups When a user attempts to create a transaction affecting an account the system checks the list of groups associated with the user against the list associated with the account If a match is not found a message displays and the user cannot complete the transaction Account security is not applied during Transaction Post Use Menu Security Maintenance 36 3 1 to restrict posting functions Users and Security 61 Using Inventory Movement Code Security Use Inventory Movement Code Security 36 3 11 to grant or deny access to individuals and groups when using a specific inventory movement code at a particular site Fig 3 13 Inventory RRA LANA SRNR Movement Code Site 10000 San Diego Main Plant Security 36 3 1 1 Inventory Movement Code SHIP Shipping Restricted Groups When you create shippers the system determines which inventory See User Guide movement codes are available based on the Ship From site of the shipper eee Access to the inventory movement code also determines if you can select an existing shipper
73. When MTZ is active in SSM time zones can be associated with customers end users and service engineers and affect the processing of service calls The system uses the date and time provided by the Server Time Zone field as the default value in date and time fields This time zone defaults to the Time Zone field in User Maintenance 36 3 18 Verify GL Accounts PJ Set the server time zone if MTZ is not P i activated in gt a SSM Base Currency Entity Bank Acct Validation p 1000 P Default System Language Audit Trail Server Time Zone PST When MTZ is activated through SSM the server time zone is set in both Service Management Control 11 24 and System Account Control 36 1 If you try to change the server time zone when it is set from SSM an error message displays If you are not using SSM set the server time zone in the Server Time Zone field in System Account Control illustrated in Figure 8 15 MTZ Setup Programs Time zone setup programs are under the Multiple Time Zones Setup Menu 36 16 22 and include the following Multiple Time Zones Maintenance 36 16 22 1 e Multiple Time Zones Inquiry 36 16 22 2 e Multiple Time Zones Report 36 16 22 3 Multiple Time Zones Load Utility 36 16 22 13 It is best to use menu level security on these programs with the possible exception of the report and inquiry Do not change time zone information without carefully evaluating the impact
74. When you complete the setup for your e mail system you are prompted to send a test message The default addressee is your log on user ID If you have not yet entered your e mail address in User Maintenance the system prompts you for an address System Interface 77 User Maintenance To use the e mail interface you must also complete two fields in User See page 42 Maintenance 36 3 18 for each user E Mail Address and Definition User ID mmb User Name Madeline M Brightly Fig 4 10 User Maintenance 36 3 18 Language US 1P Country Code USA P variant Password Date Last Changed User Type Employee P Restricted Time Zone PDT IP Access Location calif_ P Use these Access Type CASUAL P fields to Email j i Address immb qualityeorp com rr define e mail Definition MP information Interface Preferences Menu Style fa A Icons B Tear Off C Character WinHelp 4 Menu Substitution 7 Groups E Mail Address Enter the complete e mail address for this user as required by your company s e mail system E Mail Definition Enter a code established in E Mail Definition Maintenance FA QAD 78 MFG PRO eB2 User Guide Manager Functions FAQAD se Connections 85 ng Databases 88 92 80 MFG PRO eB2 User Guide Manager Functions Fig 5 1 Multiple Database Setup FAQAD Introduction This chapter describes how to implement consolidated order processing
75. a for Items Item codes and units of measure must be identical across databases Enter into the baseline database all information pertaining to items sold purchased or transferred between sites using DRP Items can be added to individual databases later An item must be associated with a site but you can change this association after copying the baseline database A default cost set for an item site is located in the database in which it is created Multiple Databases 85 Associate centrally purchased items with the central purchase order site Items purchased locally can be associated with a site at any time Setting Up Baseline Data for Purchase Orders Purchase order setup information such as suppliers supplier items credit terms tax codes and currency must be identical across databases Settings in Purchasing Control 5 24 should be identical except for the next purchase order number Numbers must be unique across databases so you should identify a unique prefix or separate range for each database that creates orders Setting Up Other Baseline Data Make significant base data such as unit of measure conversions site calendars currency and conversions printer types and printers banks product structures and format positions identical across databases DRP setup information including source networks transportation modes and transportation schedules must be identical across databases DRP networks and sourcing relationshi
76. al software applications then set Active to Yes or No for each application The default is Yes The application name you enter under Application Name must be See Registering registered with MFG PRO through License Registration 36 16 10 1 ma on You can also specify which users can access an application after you register the application in License Registration If you deactivate MFG PRO for a user all other registered applications are deactivated too Use User Access by Application Inquiry 36 3 22 to view a list of applications as well as the user s ID and name active or inactive status time zone access location and access date Fig 3 6 User Access by Application Inquiry Application Show Active Users Only Output 36 3 22 PIQAD 50 MFG PRO eB2 User Guide Manager Functions Fig 3 7 Menu Security Maintenance 36 3 1 FAQAD Using Menu Security Menu security controls each user s access to programs Use Menu Security Maintenance 36 3 1 to define the users or groups that have access to a menu function Menu 36 Manager Functions Selection 3 System Security Menu User IDs Groups Specifying Menu Numbers Enter the number identifying the menu where the program you want to restrict is found The system combines menu and selection number to determine the function to be restricted For example Purchase Order Maintenance is selection 7 on menu 5 The main menu is identified by menu
77. ase s chart of accounts In this case it may be useful to run two databases Use an inventory database for operational day to day control and intercompany reporting Use a financial reporting database for general ledger GL data This database contains account cross reference data which permits easy translation from the inventory database Set up the default accounts for Sales and Cost of Goods Sold in Sales Account Maintenance 1 2 17 These can be modified after you copy the baseline database Intercompany Transfer Accounts Establish intercompany debit and credit accounts by entity in Entity Code Maintenance 25 3 1 1 for accounts payable accounts receivable inventory control and fixed assets transactions Each entity can have its own set of intercompany accounts These accounts are used to track amounts for any transaction between entities If you are using DRP you can also set up accounts for transfer clearing transfer variance and goods in transit Specify the default Transfer Clearing account in Inventory Control 3 24 You can specify default intercompany accounts in the System Account Control 36 1 Defining default accounts simplifies the setup of intercompany accounts in Entity Code Maintenance for multiple entities Also create a default bank for accounts payable You may need to change the default bank later for individual databases Multiple Databases 83 Setting Up Baseline Data for Entities An ent
78. ation the documentation uses the following conventions e MFG PRO screen captures show the Desktop interface e References to keyboard commands are generic For example choose Go refers to e The forward arrow in Desktop e F2 in the Windows interface e Fl in the character interface In the character and Windows interfaces the Progress status line at the bottom of a program window lists the main Ul specific keyboard commands used in that program In Desktop alternate commands are listed in the right click context menu For complete keyboard command summaries for each MFG PRO interface refer to the appropriate chapters of User Guide Volume 1 Introduction and User Guide QAD Desktop This document uses the text or typographic conventions listed in the following table If you see It means monospaced text A command or file name italicized monospaced text A variable name for a value you enter as part of an operating system command for example YourCDROMDir indented command line A long command that you enter as one line although it appears in the text as two lines Note Alerts the reader to exceptions or special conditions Important Alerts the reader to critical information Warning Used in situations where you can overwrite or corrupt data unless you follow the instructions FAQAD Database Man a Reports an N Interface Management 9
79. b qcerhp01 disks drive2 d7 users cmb 654480 blocks 1 files users dzn qerhp06 dr4 users dzn 422860 blocks 1 files users svc ohhp04 home u3 svc 1401846 blocks 1 files users fxd ohhp04 home u3 fxd 1401846 blocks 1 files users pzd ohhp04 home u3 pzd 1401846 blocks 1 files users byd qcrhp01 disks drive2 d7 users byd 654480 blocks 1 files users rbe qcerhp01 disks drive2 d7 users rbe 654480 blocks 1 files qad mfgpro 85db etfdb ohhp40 dr01 85db etfdb 9285970 blocks 1 files users svb ohhp04 home u3 svb 1401846 blocks 1 files users ncr ohhp04 home u3 ncr 1401846 blocks 1 files users scq qcerhp06 dr5 users scq 3373932 blocks 1 files Freeing Disk Space There are three ways to reduce the size of a Progress database e Use dump load programs to compact your data Compacting data can increase disk access speeds significantly To do this dump all data from your database and reload it into an empty database You need free disk space amounting to about 70 of the total size of your data d files Progress recommends that you dump load once a year Database Management 125 e Use delete archive programs to create free database space Typically the largest tables in a database contain history sales order and purchase order data The amount of disk space may decrease if you store the archived data on the same disk e Use both dump load and archive delete programs To do thi
80. can choose from two types of joins when creating a view An inner join returns the records selected for the first table combined with related records selected from the second table If a record does not exist in the second table no records are returned Only related records selected from both sides of the relationship display in the view An outer join returns the records found by an inner join However in addition for each value in the first table it returns unknown values from the second table when no related record is found As a result all matching records from the first table are preserved for unmatched records in the second table The default join type is inner Using the outer join can give you more flexibility in displaying information Example An inner join between customers and sales orders displays only customers with sales orders An outer join includes all customers even those who do not have orders FAQAD User Interface Management 193 Using View Maintenance Figure 12 12 illustrates View Maintenance 36 20 18 Fig 12 12 View Maintenance 36 20 18 View Join Data Description Term CUSTOMER YEAR HISTORY VIEW P Customer Year History View User IDs Groups 1 Select or enter a view name 2 Entera label term in Description Term The long label contained in this term is displayed as the view label 3 In User IDs Groups enter a user ID to limit user access to the view optional You can enter multiple user I
81. ce for details FAQAD 8 MFG PRO eB2 User Guide Manager Functions gt See Chapter 5 Multiple Databases for details gt See Chapter 6 Printers and Batch Processing for details b See Chapter 7 CIM Interface for details gt See Chapter 8 Database Management for details gt See Chapter 9 Reports and Utilities for details gt See Chapter 10 System Cross Reference for details FAQAD Multiple Database The Multiple Database menu includes programs for connecting to and setting up multiple databases This chapter also covers the system requirements for operating with multiple databases Printers and Batch Processing The Printer Management menu contains programs for setting up system printers specifying default printers by user or group and creating batch print requests CIM Interface CIM computer integrated manufacturing is one way to load legacy or non Progress data into the MFG PRO database Using CIM data can be added using standard program validation Database Management MFG PRO provides utilities for monitoring database size performing dumps and loads reloading archive files and managing database sequences Delete archive followed by dump load is the standard means of controlling database size and fragmentation in Progress databases User licensing utilities and programs for managing time zones are also included in databas
82. contains the field that is being tracked for changes Currently Change Tracking Maintenance tracks only the sales order detail sod det table Description Enter a brief description 24 characters of the database table Active Specify Yes to track changes for the database table you specified Specify No to deactivate tracking The default is No b See User Guide Volume 2A Distribution Fig 2 19 Sales Order Control 7 1 24 Fig 2 20 Change Tracking Maintenance 36 2 22 FA QAD 32 MFG PRO eB2 User Guide Manager Functions You must set Active to Yes for both the table and the field before change tracking begins Delete Specify Yes to display the reason code pop up in Sales Order Maintenance when the user deletes an entire sales order line Specify No if you do not want the reason code pop up to display The default is No Note You must set Active to Yes and specify a field to track Once you complete these fields and press Go the following frame appears Fig 2 21 Change Tracking Maintenance Field Frame Active Field sod due date ww Field Enter the field to track Currently you can only track fields belonging to the sales order detail sod_det table Note To find the field name in the character or Windows user interface press Ctrl F while your cursor is located in the field In Desktop the field name displays as a field tip when your cursor moves over a field Description Enter a br
83. ctory The operating system OS directory where you want to store the file A second Sequence Maintenance screen displays Sequence Name cmt sq01 Sequence Description cmt_det cmt_indx Maintenance Activity 3 Activity Description Manual Update Dump Load Full Directory Path Directory Sequence Name Specify the sequence or set of sequences to be maintained Leave blank to specify all sequences Maintenance Activity Specify the maintenance activity to be applied to the specified sequence sets Valid values are 1 to dump Outputs the current sequence value to an OS file e 2 to load Reads the sequence value from the OS file e 3 to manually update This activity can only be performed when a single sequence is specified When a set of sequences is to be manually updated the manual update activity is called once for each Activity Directory For a dump or load specify the OS directory where the sequence files are located The direction of the data flow is determined by the activity Files are named using the name of the sequence with the file extension d For example the sequence tr sq01 is dumped to a file named tr_sq01 d Database Management 133 When a manual update is specified an additional frame appears Manual Sequence Update Original Sequence Value 48 Current Sequence Value 48 User Input O ww w Original Sequence Value This field displays the value of the sequence before the user s u
84. cur rarely You can modify MFG PRO messages in Message Maintenance 36 4 7 One reason for changing messages is multiple language requirements Ifa message seems unclear to some end users an administrator can clarify its meaning Message Maintenance Language ID US english U S Message Number 1P Message Not a valid customer System Interface 73 Changing messages can create the same version control problems that occur when menus are changed Be careful to use message numbers not likely to be used by MFG PRO in a later version Using Field and Procedure Help MFG PRO provides two types of online help procedure and field help Procedure help explains what the current function or program you are working within does Field help describes particular fields You can view these help records in either Windows or character format The content of the Windows and character help files is identical However you can add your own information to the character help files Note QAD Desktop displays the character help data in an HTML format Any changes you make to character help are also visible in Desktop In the Windows interface online help uses the standard Windows help format h1p files In addition to receiving context sensitive help on the active field and procedure you can also access other help topics through the help menu hypertext links and keyword searches In the character interface view field help by pressing F2 w
85. d against an empty database with Spanish data definitions labels and validation messages The French programs are compiled against a second database with French data definitions The system can display menus messages and field help in multiple languages The standard menus and messages are in the production database Field help is in the field help database mfghelp db The fact that the Progress programs are in multiple languages does not affect the production database To retrieve data in multiple languages each piece of information in the production database must be stored once in each language Most orders include comments which often must be in multiple languages These can be stored in multiple languages and retrieved by language ID You can also customize menus and messages and assign a language ID so the system knows which entry to display System Interface 65 However not all data in the system can be stored and displayed by language ID For example item descriptions can be stored in only one language Setting up Multiple Languages To work in full multi language mode you must 1 Specify the top level directory for each language s object code in Language Code Maintenance 36 4 1 Language ID bu Language Number 3 This ensures that the system can locate the programs for each language The programs for each language must be stored in separate subdirectories 2 Designate the default language and country
86. de Manager Functions Fig 3 9 Field Security by Group 36 3 7 FAQAD Note For multi language installations you must run mgfldcmt p against your master database Then when you recompile follow the normal procedure for compiling a multi language version including the creation of a translated database to compile against Field Security by Group You can also set up field security for a group of users 1 Assign users to groups in User Maintenance 36 3 18 2 Execute Field Security by Group 36 3 7 This function adds all users who belong to a specified group to the list of authorized users for a validated field Even with this process field security is only available at the user level not the group level Field Security by Group is simply a batch utility that lets you add multiple individuals simultaneously This has the following consequences If you remove a user from a group that was given access to a field that user can still access the field To prevent this use Field Security Maintenance 36 3 4 to remove the individual user e You cannot use Field Security by Group to remove a group of users from the list of authorized users To remove a group you must remove every individual in the group in Field Security Maintenance Once Field Security by Group is executed for a field and group all users who belong to the group display in Field Security Maintenance 36 3 4 as authorized to access the field The Comments
87. ding E Effective Date 07 08 2001 Expiration Date 07 08 2002 Segment List Settings Control 0 0 0 0 Next Sequence Number Editor System Constants 29 Viewing Sequence Number History When a client program uses a sequence to dispense or validate numbers the system creates history records Use Sequence Number History Report 36 2 21 13 to view history data on internal and external sequences You can view the sequence definition which sequence numbers have been used and which sequence numbers have not been used including gaps This report helps you to identify missing documents by reporting numbers that are not recorded in the sequence history Deleting and Archiving Sequences Use Sequence Delete Archive 36 2 21 23 to delete sequences and associated history You can optionally archive information to an external file and later restore it using Archive File Reload 36 16 5 Once sequence history is deleted it no longer appears on the Sequence History Report Fig 2 17 Sequence Delete Sequence 10 1 p a 23 ig Action Date E i wei Specifies Retain Sequence ID whether to Retain Highest Usage delete historical Retain Unprinted Numbers r amp Delete 0 information Archive Yes or review Archive File Output without deleting Batch ID No oo If Yes copies each selected record to the file displayed in Archive File Tracking Changes Use Change Tracking Maintenance 36 2 22 to ma
88. ditional character terminals b See page 47 b See Adding User Help on page 73 gt See Setting Up Menu Substitutions on page 185 b See User Guide Volume I Introduction for more information on menu styles and other elements of the user interface FA QAD 48 MFG PRO eB2 User Guide Manager Functions Fig 3 5 Menu Style Options GUI Interface Only gt For an example refer to User Group Example on page 52 FAQAD Character Menu Quality Products Corp qaddb BEE User Menu Edt Queue Options Help 12 03 33 Tear Off Menu Quality Products Corp gaddb MEE UserMenu Edt Queue Options Help Please select a function ESC or blank to EXIT 1 E ata 3 1 4 2 Item Master Inquiry all 3 hem Data Maintenance 4 Item Data Inguir ea 5 Tem Inventory Data Maintenance a 5 ltem Sie Inventory Dat l pan Enter data or press ESC to end Wi B Mem Site h 3 Item Cost Maintenance 10 Item Site Cost Inquir x enheter raw Icon Menu 12 Item Master 13 Item Number Change 8 oo Quality Products Corp qaddb 15 Tem Element Cost Batch Load TREE A E 16 Item Site Inventory Data Maint 17 Tem Ske Planning Maintenance E Main Menu 18 Item Site Cost Maintenance 19 Code Maintenance 20 Item Burden Cost Update m Master Files fal Item Overhead Cost U Le 22 Current Cost Set Move to GL Set 23 GL Cost Set Move
89. dministrators and QAD auditors can run reports to view the violation data The system responds to license violations with either violation errors or violation warnings With errors messages display and the system prevents additional users sessions or access to certain programs from Database Management 139 additional locations With warnings messages display but additional users sessions or locations can exist and users can still log in to MFG PRO or separately sold MFG PRO modules System administrators can implement enforcement of license agreement See Setting Up by setting the Enforce Licensed User Count field to Yes in Security ie a Control 36 3 24 Setting this field determines whether errors or warnings display and what action the system takes Important The first time a warning displays you can access MFG PRO to complete transactions or other processing If you receive repeated warnings contact your QAD sales representative or distributor to upgrade your license The system prevents users from logging in to MFG PRO if the license registration record does not exist for MFG PRO System administrators register MFG PRO s license code in License Registration 36 16 10 1 Violation Types The system records the violation types listed in Table 8 3 Table 8 3 Violation Type Description License Violation Types Date expiry Displays information about violations that occur when an application s license registrat
90. drawn from the data dictionary In reports the From and To fields are often local variables Usually help for local variables is not as significant as database fields Update Only Set to Yes to limit output to fields that can be changed Where Used Maximum Set Where Used to No to keep the system from printing a where used list after each help item Some database fields are used throughout the database and a complete where used list can be very long If Yes limit the length of the where used list by entering a value in Maximum Building an E Mail System Interface Some functions can be configured to send e mail messages to designated users For example optional e mail messaging is used in Product Change Control Supplier Performance and the Global Requisition System To take advantage of this feature the e mail system must be defined and addresses specified The MFG PRO e mail interface is built around an operating system command that communicates with the user s e mail system This command tells the e mail system how to construct and address messages System Interface 75 Set up a command line in E Mail Definition Maintenance 36 4 20 for each system you want to access from MFG PRO Then in User Maintenance 36 3 18 specify an e mail definition and address for each user E Mail Definition Maintenance Before you implement E Mail Definition Maintenance 36 4 20 refer to the e mail application documentation or consult wi
91. ds 0 2 0 ce eee eee eee 92 Controlling User Logins 0 0 0 0 cece eee eee 94 System Security 00 cece eee ee eee eens 95 Connection LOSS vi swine ob de ba be ee ee Se a 96 Multiple Database Example 0 0 c cece cece teens 96 FAQAD Contents Chapter 6 Printers and Batch Processing 0055 99 Introduction 2 0 0 0 cece etn eee n eee ne eeee 100 Defining Printer Types 2 0 c cece eeeeee nes 100 Setting Up Printers 24 244 ais a adele apea es ue bin eh as he Sot wa S 102 Defining a Printer for Use with QAD Desktop 104 Setting Default Printers 2 0 0 2 eee eee 105 Defining Document Formats 0 cece eee eens 105 Running Batch Processes 00 0 cece cece cee nenene 106 Chapter7 ClMInterface 0 2 cee eee eee 109 Introduction esascs eae eked ds We been Ae awed Gorge Phe bee ea nea 110 Using the CIM Interface 0 cc ne ens 110 CIM Data Format 0 eee eee nee 112 Input File Formatting Rules 2 0 00 cee eee eee 113 Input Data TYPES 2 ck sas Bed ae Mh Rh ae bath wh ee was 113 Determining Data for the Input File 22 114 CIM Data Input File Example 0 0 02 e eee eee ee 115 Creating a CIM Input File 2 0 2 0 eee eee 116 Error Handling es aces end e E hent O E 118 Deleting Records through CIM 0 cece eects 118 Creating Input Files to Delete Records
92. dy connected to the sales order database s CPU set up printers as usual If the printers are on another CPU in the system define the printers in the sales order database and refer to your network guide for information on printing to another CPU Multiple Databases 91 To print Databasel sales orders through the Database2 CPU use Printer Setup Maintenance 36 13 2 to give the Database2 printer a name and description In the Device Pathname field specify the operating system commands used to send printer output to the Database2 printer Example Many UNIX systems on an Ethernet network use remsh to execute a command on a remote system If Database2 is located on a CPU called db2 enter the following command for Device Pathname remsh db2 lp drelp s To simplify printing use Printer Default Maintenance 36 13 4 to set printer defaults by user ID To do this user IDs must be unique across databases Do not set default printers by menu item alone if different picklists may need to be printed at different sites Modifying Startup Connections Use Database Connection Maintenance 36 6 1 to set default connections for each database If you do not want databases connected automatically at startup set Active to No Modifying DRP and MRP Add network codes if necessary Check transportation networks and shipping schedules Create locations with the same name as the transportation modes for each site making status codes non net
93. e Expiration Date System Constants 25 Sequence ID Enter a code uniquely identifying a sequence Create a new sequence or use Next Previous to retrieve an existing sequence Description Enter a description of this sequence up to 40 characters Target Dataset Enter the dataset identifier associated with this sequence The target dataset can indicate who owns the sequence or where its numbers are used A sequence owner can be a process a document or any other entity that the client program can recognize You cannot create a new sequence that intersects an existing sequence with the same target dataset creating two sequences that could generate the same sequence number for the same target field For example if sequences A and B both target field so_nbr they cannot have a common element that could cause conflicts The following three target datasets are used with shippers e abs_id shipper is used for sales order shippers e abs_id preship is used by sales order pre shippers e abs id mbol is used by master bills of lading For Fixed Assets specify dataset fa id For Logistics Accounting specify e la so ship id for sales order shipments e la do ship id for distribution order shipments Internal Specify whether the sequence numbers are supplied by an external source or automatically generated by NRM Enter Yes if numbers are generated by NRM Allow Discarding Using a number causes it to be registered This field determ
94. e 2A Distribution gt See User Guide Volume 11 PRO PLUS Fig 2 10 Number Range Maintenance 36 2 21 1 FAQAD General Ledger Daybooks GL daybooks let you group and report GL transactions Unposted transactions include the daybook code and daybook entry number NRM generates entry numbers based on the ID of the daybook Logistics Accounting If you are using the optional Logistics Accounting module two NRM sequences must be defined in Logistics Accounting Control 2 15 24 for distribution order shipments and sales order shipments Shipping Many countries legally require businesses to maintain strict control when assigning numbers to shipping documents This is also true when multiple number ranges are assigned to the same type of shipping document To meet this need NRM is required for all shipper functionality WIP Lot Trace An optional NRM sequence number can be specified in WIP Lot Trace Control 3 22 13 24 for generating WIP lot and serial numbers in the various functions that trace them Setting Up Sequences Create sequences and define sequence parameters using Number Range Maintenance 36 2 21 1 NRM uses a unique sequence ID to retrieve data and generate new numbers Use Sequence Browse 36 2 21 2 to view the defined structure of a sequence Number Range Maintenance Sequence Master Sequence ID 00000010 Descriptio Target Datase Internal 4 Allow Discarding Allow Voiding 7 Effective Dat
95. e Cycle Figure 2 9 illustrates the life cycle of a sequence Create the sequence p NRM enabled program uses sequence to generate or validate numbers Define sequence parameters Manually maintain sequence numbers if allowed Add segments as needed Delete archive obsolete sequences Save the sequence To set up a sequence create an ID define general parameters and add appropriate segments Once a sequence is defined an MFG PRO program uses it either to obtain a new number or validate user entered numbers If you attempt to discard or void a number the system checks the sequence definition to ensure that this is allowed You can delete and archive unneeded sequences NRM Sequences in MFG PRO Programs must be specifically enabled to use NRM Currently NRM sequences are used in general ledger GL daybooks fixed assets logistics accounting shipping and the PRO PLUS WIP Lot Trace module Fixed Assets An optional NRM sequence number can be specified in Fixed Asset Control 32 24 for automatically generating fixed asset ID numbers Fig 2 9 Sequence Life Cycle Tip Programs must be specially designed to use NRM sequence numbers gt See User Guide Volume 4B Financials PIQAD 24 MFG PRO eB2 User Guide Manager Functions b See User Guide Volume 4A Financials gt See User Guide Volume 6 Master Data gt See User Guide Volum
96. e Repair Orders Shippers Subcontract Shippers Supplier Performance Data Supplier Schedules Transaction History Turnaround Data Uninvoiced Receipts WIP Lots Work Orders Zero Inventory Balances FA QAD 128 MFG PRO eB2 User Guide Manager Functions FAQAD Audit Detail Delete Archive Use Audit Detail Delete Archive 36 23 1 to delete archive audit detail information Unlike other delete archive programs this program does not delete each record specified Instead for each unique combination of user ID table and field it keeps the latest record and deletes archives the rest To delete and or archive tables 1 Back up your database and df files To safeguard against data archived from a previous MFG PRO version that has different schema back up the current database definitions df file with each archive delete run This lets you reconstruct a corresponding database for data retrieval Verify record selection Run the delete archive program without deleting or archiving records This generates a report showing selected records Review the report and if records selected for deletion are correct proceed with the actual archive delete Run appropriate historical reports such as Invoice History Delete Archive 7 13 23 Determine selection criteria for the records being deleted and run the delete archive program setting Delete and Archive to Yes The program creates a xxyymmdd hst file in the default di
97. e for preventive maintenance The system uses exception information only when preparing operation schedules but not when calculating manufacturing order due dates Example On July 14 two hours of overtime are scheduled at site 10000 Enter OVERTIME as the reference code July 14 as both start and end dates and 2 as Daily Hours If an exception occurs on a day that is not part of the standard work week add that exception to an existing day rather than changing the standard work week Many scheduling programs assume that the work week has a certain number of days Adding a day to the standard work week can result in inaccurate schedules Holiday Maintenance Use Holiday Maintenance 36 2 1 to schedule holidays and other nonwork days that apply to the entire site Holiday Maintenance Holiday 07 04 2002 Thursday Holidays are days that no one works the plant is shut down and no production is scheduled Manufacturing orders are never due and operations are not scheduled on a holiday System Constants 15 Defining Rounding Methods MFG PRO lets you round monetary amounts in a manner consistent with a given currency Three rounding methods exist by default e 0 Round to zero decimals using 0 5 as the rounding threshold e 1 Round to one decimal using 0 05 as the rounding threshold e 2 Round to two decimals using 0 005 as the rounding threshold You can set up additional rounding methods as needed in Rounding Method
98. e gt Specifies the set of sequences to be maintained You can specify a single sequence or the entire set The default value is NULL indicating all sequences will be maintained lt action gt Specifies the activity to be performed either 1 dumping or 2 loading lt input output OS directory gt The directory in which the sequence files are maintained The default value is the local directory A time stamp is issued to the log file at the beginning of each session This permits the same log file to accumulate a history of the session logs All log files have the log suffix Database Management 135 Example The following is an example of a working CIM file batchload mgsqmt01 p sq_err log qad 2 qad backup end This file outputs the error log to the directory qad with the name sq err log All sequences are maintained The hyphen indicates that the default value in this case all sequences is accepted Number two 2 indicates that the sequences are loaded The directory in which the sequence files are maintained is qad backup Note Only sequences currently implemented in MFG PRO can be maintained using CIM Maintaining Audit Trails The system maintains audit trail for all updates made to sequences using sequence maintenance routines Each sequence has a separate set of audit entries For each updated sequence the audit trail records original and final values If the current val
99. e information regarding trademarks and registration Copyright 2002 by QAD Inc 78 0565A QAD Inc 6450 Via Real Carpinteria California 93013 Phone 805 684 6614 Fax 805 684 1890 http www qad com Contents About THIS Guide 22 5 arrede bien ise sd 1 Other MFG PRO Documentation 0 0 000 ccc cette eee 2 Online Help 223 oct rer er oot hese etd kao ere oki ete bin cha kein 3 QAD WebSite neeaae es Ar AA ener bls Betis Gah ats Apa Rh a A SAREEN 3 CONVENUONS deaet Hid daa ie deca tna eed Raa a Ra E tae bade REE 4 Chapter1 Introduction to Manager Functions 5 System Constants 0 cece eee etn tent n ene 7 SCULLY o taae ca ddd E E Mad deo do oda babe 7 System Interface re cada troA Sua Ben Lab ae en dda eed deena eaden 7 Multiple Database n n nnana eect ene n teen ens 8 Printers and Batch Processing 0 c eee eee nenen eens 8 CIM Interface onc a ccc ache ena cade aa eed Coa Rae Cee eae a ER ERE CO 8 Database Management 00 c cece cece teen e ene 8 Reports and Utilities eesse ate cas sae oad we HA els Rh RA wae ee aed 8 System Cross Reference 0 ccc cece een teen teen nee 8 Application Server 2423 ou weg baw a eres Regus Oa dwar olden ON 9 User Interface Management 0 0 cc teens 9 Chapter 2 System Constants 0 cece eee eee 11 OVERVIEW it5 ha dadhdaiod Moi ddl doe a ed Dp Mh doe dhadeieebudy 12 Maintaining Holiday and Shop Calendars
100. e management Reports and Utilities A number of system wide reports and utilities are provided on the Manager Functions menu System Cross Reference The system cross reference programs display information about field program and table relationships in your database If you customize MFG PRO this is an essential set of programs Introduction to Manager Functions 9 Application Server MFG PRO can use a Progress application server AppServer to run applications remotely The AppServer must be defined in MFG PRO to make it available User Interface Management The UI Manager Functions menu provides programs used to create browses and associate them with fields and programs You can also define alternate programs to execute when menu items are selected and specify programs to be run from other programs gt See Chapter 11 Application Server for details b See Chapter 12 User Interface Management for details FA QAD 10 MFG PRO eB2 User Guide Manager Functions FAQAD 12 MFG PRO eB2 User Guide Manager Functions Table 2 1 System Constants Menu 36 2 FAQAD Overview System constants provide basic data used throughout MFG PRO Table 2 1 lists available functions Number Menu Label Program 36 2 1 Holiday Maintenance mghdmt p 36 2 2 Holiday Browse mgbr017 p 36 2 5 Calendar Maintenance mgscmt p 36 2 6 Calendar Inquiry mgsciq p 36 2 9 Rounding Method Maintenance mgrndmt p
101. e number of days specified are prompted to enter a new password at the sign on screen First they must enter their correct old password followed by a new password which must be different from the old password and cannot be blank Date Password Last Changed in User Maintenance 36 3 18 displays the date the user last modified the password Enforce Licensed User Count Use this field to implement See Registering enforcement of the total number of users sessions or locations sener rs allowed based on your license agreement retails No the default The system issues license violation warnings if you violate your license agreement but you are not prevented from completing the action that caused the violation Yes The system issues a violation error if you violate your license agreement and you cannot complete your current activity The system tracks all license violations both warnings and errors See Table 8 4 on License violations can occur in the following situations page 140 e In User Maintenance 36 3 18 when you attempt to add users or assign them to applications In User Maintenance when you attempt to change access location In License Registration 36 16 10 1 when you assign users to applications During user log in to the system When users attempt to use separately licensed applications or nonregistered applications Important Violation warnings should not occur often if repeated warnings occur con
102. e reason and comments related to a discrete sales order line change To display the changes set e Summary Detail to Detail e Include Reason Comments to Yes Fig 2 23 Booking Booking Trans ocny Transaction Report Product Line P 7 15 14 Effective E Address P Sales ob JP Region JP Show Revision Detail 7 Set these summary Detail Detail z fields to view l FEE changes Include Reason Comments o Output Batch ID O PIQAD 34 MFG PRO eB2 User Guide Manager Functions FAQAD nent Code Security 61 36 MFG PRO eB2 User Guide Manager Functions b See User Guide QAD Desktop for details See page 156 for details FAQAD Security Overview MFG PRO provides options for security on several levels Database security determines whether a user can log into a database This level of security is always active and requires that users specify a valid user ID and password before they can log in Menu security 36 3 1 limits access to menus and menu functions Field security 36 3 4 limits who can update specific fields General ledger GL account security 36 3 9 restricts access to GL accounts Inventory movement security 36 3 11 enables you to grant or deny group members access to shippers and other transactions using specific movement codes at a site Entity security 36 3 13 limits who can create GL transactions for a particular entity Site
103. e relationships among time zones and is never affected by daylight saving time adjustments Start Period When Auto Period Adjust is Yes enter the first day of the week when the change of time occurs in MM DD format For the United States daylight saving time normally begins on the first Sunday in April identified by a start date of 04 0 1 and ends on the last Sunday in October identified by a start date of 10 25 This field in conjunction with the Weekday and Time fields identifies precisely when the time change occurs Database Management 153 Weekday When Auto Period Adjust is Yes enter a number from 0 to Tip 7 indicating the day of the week identified by the Start Period peer field when the time change occurs occur on Sunday 1 Enter 0 if the change occurs on the date in the Start Date field o regardless of the day of the week on which it falls e Enter a number in the range 1 7 corresponding to Sunday through Saturday if the change occurs on a certain day of the week Time When Auto Period Adjust is Yes enter the exact time of day identified by the Start Period and Weekday fields using a 24 hour clock when the time change occurs Enter this time in standard time In the United States enter 02 00 when switching from standard time to daylight saving time but 01 00 when switching from daylight savings time back to standard Multiple Time Zone Load Utility Use the MTZ Load Utility 36 16 22 13
104. e use regardless of your user interface type character Windows or Desktop database type Progress or Oracle or license type For concurrent session license types the system counts the number of active sessions when you log in and compares the count to the number of licensed sessions stipulated by the license agreement If you use Current Database Change 36 6 17 to switch to a new database this process is repeated This is because changing databases is like exiting your current database and starting a new MFG PRO session Whenever you switch databases the system stores the logout date and time Note If you use the Desktop environment each time you run a program and detach it in a separate window each window counts as an individual session For named user license types the software counts users when system administrators create new users in User Maintenance 36 3 18 or activate user access to applications in License Registration 36 16 10 1 For location license types the system counts the number of user locations and compares the number against the predefined limit for the license type when system administrators assign users to applications in either User Maintenance or License Registration License Violations When the number of MFG PRO users sessions or locations exceeds the amount stipulated by your license agreement license violations occur The system stores all license violation occurrences in MFG PRO System a
105. eft corner of the screen Then place your cursor in the field where you want to attach the browse Press Ctrl F and note the field name In the Desktop interface run the program Click on the information button on the right side of the program title bar The button is identified with the letter i A screen displays program information including the program name To identify the field name place your cursor over the field where you want to attach the browse The field name displays See Adding a Lookup on page 18 b See Creating Browses on page 186 for details on creating browses FAQAD 180 MFG PRO eB2 User Guide Manager Functions Fig 12 1 Drill Down Lookup a Maintenance Drill Down Lookup Maintenance 36 20 1 Drill Down Lookup Drill Down z Field Nam Calling Proceduri Procedure To Execute gpbr360 p Description Term SUPPLIERS Suppliers Description Lookup Starts At Row Lines In Lookup You can assign more than one drill down to the same field A menu of drill downs appears when you request the drill down Only one lookup can be attached to a given combination of field and program name You can attach browses to fields in any program including another browse Drill downs can be nested A field can call a browse that can call another browse that can call another browse and so on Follow these steps to use Drill Down Lookup Maintenance to associate a drill down with a field o
106. eft side of all users in the list To de activate users press Spacebar The asterisk is removed Note Ifthe total number of users exceeds the number allowed by the application s license the system makes the first users in the list active For example if there are 100 user IDs displayed but the license agreement for the application is for 50 users the first 50 users are made active for the application If the total number of locations from which users access the application exceeds the number allowed by the applications license a message displays and a violation is recorded If you need to authorize more users than your license allows system administrators can add users through User Maintenance 36 3 18 however the software records a violation of your license when you add more users Cialis Add Authorized Users User aaa Enter All to select all users Available active users 284 Maximum Users Allowed for Selection 50 User Selector User ID User Name REN ten 2 anarews aab Angela A Brever abl Any Blake aba Alan B Ashlyn abb Anita B Barnes bb Database Management License Reporting MFG PRO provides reports that let you monitor application use the number of logged in users and sessions and the programs they use and license violations You can use the application usage and user count reports to be informed about potential license violations In addition to license reporting you
107. ems by Message Report 162 Menu Items by Table Report 162 menu security 50 Menu Security Maintenance 50 menu styles User Maintenance 47 Menu Substitution Maintenance 185 menu substitution User Maintenance 47 Menu System Maintenance 67 menus assigning execution files 67 changing 67 character based 47 cross reference reports 161 security 50 security for Windows icons 50 setting up styles for users 47 substitutions setting up 185 tear off style 47 Message Maintenance 72 messages modifying 72 Progress 72 translating 72 Messages by Menu Item Report 162 messages license violations 140 MFG PRO field help 73 licensing system 136 system map 160 mnemonic codes changing 65 monitoring licenses 138 monitoring users 148 mpro 107 multiple databases 79 97 baseline 81 connection maintenance 93 controlling user log ins 94 log in methods 92 primary database 94 security 94 95 system administration 92 Index 201 multiple languages 64 comments 65 implementation 65 limitations 65 Multiple Time Zone Load Utility 153 Multiple Time Zone Maintenance 151 Multiple Time Zone Menu 149 Multiple Time Zones Load Utility 153 Multiple Time Zones Maintenance 151 Multiple Time Zones Report 153 N named user license 42 137 Number Range Maintenance 22 number range management NRM 20 29 segment editors 26 segment types 21 sequence definition 24 numbers segment control 22 date driven 21 fixed value 21 incrementing integer 21 sequences 2
108. en when you press Ctrl F with your cursor in the field If the message indicates generalized codes validation the system automatically verifies data entered in the field against the list of generalized codes You can also use Generalized Codes Validation Report 36 2 15 to view a list of all fields in the database that have schema validation assigned This is the preferred method in the Desktop interface Note The system performs validation only when generalized codes have been defined for a field Example You have divided your customers into regions The cm region in the customer master is updated by Customer Maintenance 2 1 1 As part of the implementation process you assign each customer to one of two regions To ensure that only standard region codes are used define them as generalized codes Specify cm_region for the field name the values US and X US for the two regions Adding Generalized Codes Figure 2 5 illustrates Generalized Codes Maintenance 36 2 13 Fig 2 5 Generalized Codes i Maintenance Field Name cm region 36 2 13 Value US Specify a field name and then enter valid values and comments Values cannot exceed the length of the field The comment displays next to the value in the lookup PIQAD 18 MFG PRO eB2 User Guide Manager Functions gt See Maintaining Drill Downs and Lookups on page 178 Fig 2 6 Drill Down Lookup Maintenance 36 20 1 FAQAD Adding a Lookup To set u
109. ences manually or through the CIM interface Maintenance includes e Dumping outputting the current sequence value to a file e Loading reading a sequence value from a file Updating manually updating a single sequence Maintain sequences in Sequence Maintenance 36 16 13 Sequence Maintenance works with Progress Relational Database Management System RDBMS only Oracle dataservers are not currently supported 0 Sequence NOT Updated 64 Sequence NOT Updated 10 Sequence NOT Updated 1 Sequence NOT Updated 1 Sequence NOT Updated 0 Sequence NOT Updated 0 Sequence NOT Updated 0 Sequence NOT Updated 0 Sequence NOT Updated 0 Sequence NOT Updated 1 Sequence Updated 5 Sequence Updated Database Management 131 Tip To avoid accidental update to sequence structures use menu security to protect sequence maintenance functions Fig 8 3 Database Sequence Initialization 36 16 17 gt See Maintaining Sequences in Oracle on page 135 FA QAD 132 MFG PRO eB2 User Guide Manager Functions Fig 8 4 Sequence Maintenance 36 16 13 Establish Log File Name Frame Fig 8 5 Sequence Maintenance Sequence Name Frame Tip A time stamp is added to the log at the beginning of each session so session history can accumulate After a maintenance session check the log for errors FAQAD Log File Output Full Directory Path Diretor TT Log File Name The name of the error log file Dire
110. ent causes the incrementing integer segment to reset to its assigned reset value The new value in the control segment ensures that the sequence numbers generated after resetting are unique within the target dataset Date Segment Editor New Seg nbr Control Segment O Fig 2 12 Fixed Segment Editor Fig 2 13 Integer Segment Editor Tip Use any printable character except a comma or another date component as a delimiter Fig 2 14 Date Segment Editor FAQAD 28 MFG PRO eB2 User Guide Manager Functions Tip You can add fiscal segments only if the sequence has an expiration date Fig 2 15 Fiscal Segment Editor Fig 2 16 Sequence Number Maintenance 36 2 21 5 AQAD Fiscal Segment Editor Use the fiscal segment editor to tell NRM how to display a fiscal date component of a sequence number Codes represent a component of a fiscal period Otherwise this editor is exactly the same as the date segment editor Fiscal Segment Editor New Seg Nbr 2_ Control Segment O Setting Sequence Values Use Sequence Number Maintenance 36 2 21 5 to set the next value for an existing sequence when The sequence is internal e Allow Discarding is Yes The sequence value you enter is validated against the segment order and settings Sequence Master Sequence ID 00000010 Description Sequence for Preshipper Numbers Target Dataset abs_id preship Internal Allow Discarding Allow Voi
111. equently used menu items is another way to execute programs quickly Keys can be established for all users or individually customized Up to 999 function keys can be defined In addition you can change the standard label for a menu item to customize menu labels for each user The effect of the records you define in User Function Maintenance 36 4 11 varies depending on the selected user interface Function keys apply only to the character interface However the programs assigned to function keys also display on the User Menu in the character and Windows interfaces and under the My Programs link in QAD Desktop Example Use of Function Keys A user entering a sales order may need to check on the available to promise ATP quantities for an item before indicating a due date By setting up a function key for the Master Schedule Summary Inquiry 22 18 the order clerk can review an item s ATP quantity without leaving Sales Order Maintenance 7 1 1 Note Do not use function keys or the function menu to access a maintenance screen in the character or Windows environments Progress only completes transactions initiated with function keys after the initial transaction is completed If for example you are in sales orders you start an order then perform an inventory transaction using a function key and then cancel the sales order the inventory transaction is also canceled System Interface 69 Windows Interface Access user functions from
112. er Menu 66 assigning buttons to 183 displaying 70 User Monitor Inquiry 148 User Tool Maintenance 183 User Type field 46 users access location 44 assigning applications 43 counting in MFG PRO 138 deactivating access to applications 144 defining types in User Maintenance 46 deleting 42 e mail address 46 enforcing license agreement 43 function keys 68 granting access to licensed applications 143 groups 48 interface preferences 47 language 65 FAQAD 204 MFG PRO eB2 User Guide Manager Functions locale 45 log in requirements 42 log in to multiple databases 94 menu 66 183 menu styles 47 monitoring 148 root and 40 time zone 46 type 46 violation messages for license agreement 42 utdbfx70 p 18 vV validating user input 18 Variant field User Maintenance 45 View Maintenance 190 FAQAD views 190 violation messages licensing 42 violations of license agreement 138 Ww warning messages license violations 39 140 wildcards use in assigning browses 181 use with security 51 WinHelp setting 74 work centers Calendar Maintenance 14 work days calendar for 13 work orders shop calendars 12
113. es a must be predefined in Multiple Time Zones Maintenance page 149 36 16 22 1 Time zone defaults from the server time zone specified in System Account Control 36 1 Specifying E mail Addresses See Building an Associate a valid e mail address and definition with each user who E Mail System receives messages generated by MFG PRO Interface on page 74 FAQAD Users and Security 47 Setting Interface Preferences Select interface preferences for individual users by specifying values for the following e Menu style This only affects the menu style used in an MFG PRO Windows session Appearance of online help This only affects the display of help in a Windows session Select WinHelp for Windows style help files If your system has been updated with custom help set up in Field Help Maintenance 36 4 15 you can view this additional help only when WinHelp is not selected Whether menu substitution is enabled or disabled This only affects menus in Windows and character sessions This does not affect the Desktop interface where menu substitution is assumed to be always on Selecting a Menu Style The Windows user interface includes three menu styles e The icon menu style has large buttons that lead you into the different parts of the system and show a hierarchy of your location in a submenu The tear off menu style enables you to choose your menu layout The character based menu style emulates tra
114. es several programs that let you customize various aspects of the user interface For example you can use these programs to design a view incorporate it into a browse then attach the new browse to a field Table 12 1 lists the user interface manager functions that are described in this chapter Number Menu Label Program 36 20 1 Drill Down Lookup Maintenance mgdlfhmt p 36 20 4 User Tool Maintenance mgtoolmt p 36 20 6 Menu Substitution Maintenance mgmsmt p 36 20 13 Browse Maintenance mgbwmt p 36 20 18 View Maintenance mgvwmt p This menu also contains programs that are not described in this chapter If you are using QAD Desktop additional programs support customizing this interface 36 20 10 Maintaining Drill Downs and Lookups Browses display selected data in the form of a table Two types of browses are available e Look up browses return the value you select to the active field in the calling program Drill down browses are more complex They include more information and can display filter graph or print data The field values in the browse can come from a table or a view A view is a table that has selected values from one table or several joined tables Use Drill Down Lookup Maintenance 36 20 1 to assign drill downs or lookups to fields that do not have a browse to replace a browse or to delete one User Interface Management 179 One of the most common uses of this program is to display generalized codes ass
115. ess planning data when you run MRP Use the following instructions to configure that AppServer All MFG PRO Installations Use this procedure to configure an AppServer instance for all MFG PRO installations If you have an MFG PRO Oracle installation additional configuration tasks are required In the Progress example shown below the name for the AppServer instance is mt mrppro However you can use any name as long as all references to the name are consistent Add an entry for the required AppServer instance to the ubroker properties file in the DLC properties directory You can copy the following text into the file Be sure to change the parameters to match your environment Note Separate examples are provided for Progress and Oracle environments Progress Example UBroker AS mt mrppro appserviceNameList mt mrppro brokerLogFile SWRKDIR mt mrppro broker log controllingNameServer NS1 initialSrvriInstance 12 maxSrvrinstance 20 minSrvriInstance 12 portNumber 50000 PROPATH dr05 mfgpro pro eb2 dr05 mfgpro pro eb2 us bbi PROPATH WRKDIR srvrConnectProc pxldgbl p srvrLogFile SWRKDIR mt mrppro server log srvrMaxPort 50202 srvrMinPort 50002 srvrStartupParam db dr05 mfgpro pro eb2 db mfgprod ld qaddb zgnotrim trig triggers db dr05 mfgpro pro eb2 db hlpprod l d qadhelp db dr05 mfgpro pro eb2 db admprod ld qadadm d mdy yy 1920 Bt 3500 c 30 D 100 mmax 6000 nb 200 s 63 noshvarfix uuid fdf73fb
116. exclusions first userl gives access to all users including user1 To exclude multiple users enter luserl user2 user3 Table 3 2 lists some examples Session IDs are not case sensitive Table 3 2 String Description Session ID All users have access Examples 1 No users have access admin All users whose session ID begins with admin have access mary manager Only users using the session IDs mary and manager have access jcd Everyone but the person whose session ID is jed has access The inverse of the last example does not work If you put jcd in the field the system grants everyone access first and does not go back to check on jcd Someone using the j cd session ID would not be excluded In general because of this problem avoid using any exclamation point after the first entry FAQAD 52 MFG PRO eB2 User Guide Manager Functions Fig 3 8 Using Groups to Give Access FAQAD Effect of Menu Security The effect of menu security varies according to the interface In the character interface users cannot see restricted menu items In the Windows interface a restricted menu item displays with an X after the menu number Users can choose not to see restricted menus by selecting Hide Menu Items from the Options menu e In QAD Desktop restricted menus display but users cannot execute them In all interfaces users cannot access a restricted menu item by typing the program name However
117. f039907 6ce891fc ec7f530e95 7eed See Additional Oracle Tasks on page 173 Tip Parameter changes are described after the sample text PIQAD 172 MFG PRO eB2 User Guide Manager Functions FAQAD Oracle Example Environment mt mrpora ORACLE BASE dr02 apps oracle ORACLE HOME dr02 apps oracle 8 1 7 ORACLE SID mrp UBroker AS mt mrpora appserviceNameList mt mrpora brokerLogFile SWRKDIR mt mrpora broker log controllingNameServer NS1 environment mt mrpora initialSrvrInstance 12 maxSrvriInstance 20 portNumber 54000 PROPATH dr05 mfgpro eb2 dr05 mfgpro eb2 us bbi PROPATH WRKDIR srvrConnectProc pxldgbl p srvrLogFile SWRKDIR mt mrpora server log srvrMaxPort 54202 srvrMinPort 54002 srvrStartupParam db dr05 mfgpro eb2 db oraprod RO znotrim trig triggers db dr05 mfgpro eb2 db mrp dt ORACLE U gad P gad c 250 d mdy yy 1920 Bt 350 c 30 D 100 mmax 3000 nb 200 s 63 noshvarfix uuid 59fdf 73 fbf039907 6302bfc1 ec513ed2fd 6fd7 The parameters of interest are described below Parameters not listed should generally not be changed from the values given in the example Important The first line of the entry specifies the name of the AppServer instance If this is changed from the name in the example be sure to change all other occurrences of this name in the other parameters e BrokerLogFile and srvrLogFile are the two log files for the AppServer instance They should be
118. fice location or central processing site Information Process and Display You can ensure that MFG PRO data are correctly displayed and processed for a given user regardless of the user s language or location by specifying the following fields Language Enter a two letter code identifying the user s language The system displays menus messages and other interface elements in this language when the user logs in Users and Security 45 Country Code Enter a three character country code to associate with See User Guide the user The country code must be defined in Country Code Volume 6 Master j Data Maintenance 2 14 1 and it must have an associated alternate country code The alternate country code must be a valid International Organization for Standardization ISO country code Variant Optionally enter the locale for the user This field can be used to specify regional variations within a country Information on language country code and variant are maintained in a See the file named locale dat along with other format information Once the es guide system determines a user s language country code and corresponding information ISO country code it gets information from locale dat and uses it to set user specific date and number formats System administrators may need to change information in locale dat or add entries for countries that are not included in the current file Each line in the file foll
119. functions with no security constraints If root is defined as an MFG PRO user anyone with access to the root user ID at the operating system level can get access to any information in the MFG PRO databases Users and Security 41 Progress Security If necessary you can use Progress utilities to place additional control over how a user s ID is set When Progress security is in place errors are generated before the MFG PRO log in screen displays To set Progress security access the Edit User List option on the Admin Security menu of the Progress Data Dictionary Use this function to load valid user ID name and password combinations into the user security _ user table You can use this table in combination with command line security options when the database is started There are several possibilities 1 No Progress users are defined and the U and P options are not specified This is the default The Progress user ID is set to the operating system log in or the network log in ID 2 Progress users are defined but the U and P options are not specified On all systems this results in a blank Progress user ID This can be used to establish basic system security for the majority of users Any users with additional capabilities must specify a U and P at startup 3 Progress users are defined and the U and P options are specified The system verifies that the user ID and password combination is in the user securit
120. ge If you set up a printer to accept a maximum of 6 pages at 72 lines to a page the printer prints only the first 432 lines of output exclusive of the trailer Scroll Output Enter Yes to have the system accept a maximum of 3 000 Otherwise the Max Pages limit applies Initialize Ctri Reset Ctrl A slave printer is one connected to a local PC printer port or the printer port of a dumb terminal To transfer printer output to the proper port you may need to specify control codes for these fields The initialize control string passes output from the terminal to the print device The last section of the Reset control string returns output to terminal Set up control strings for each printer In UNIX the slave printer device path name is device tty Defining a Printer for Use with QAD Desktop If users generate reports from the QAD Desktop interface and want to view them immediately they should choose the Page output device rather than terminal Output to terminal is not formatted to display correctly in a browser The Page output device should be defined with the following settings FAQAD Max pages is 0 Destination type and printer type are blank Lines per page is 66 Scroll output is Yes Spooler is No Printers and Batch Processing 105 Setting Default Printers Use Printer Default Maintenance 36 13 4 to assign default output devices to users Note Default output devices apply only to reports the default device
121. ge Batch delete is enabled This message does not display in Desktop sessions 2 To invoke the batch delete functionality place an x at the end of the header or detail record key frame line in the input file 3 Follow the key frame with a blank line consisting of a single hyphen so that the program executes the code that would be executed if an F5 or Ctrl D has been pressed in the first frame after the key frame 4 Enter a subsequent line containing the string yes as an answer to the Please Confirm Delete prompt displayed for online deletes FA QAD 120 MFG PRO eB2 User Guide Manager Functions FAQAD Example of CIM Delete The first CIM input file creates a GL sub account The next two input files use the delete functionality first to delete one sub account line then to delete the entire sub account record Add or modify a GL sub account record with three lines BATCHLOAD glsbmt p sbtest test sub account A 1040 1041 2 1050 1051 3 1060 1061 END Delete the second sub account line The detail record key frame for the second line ends with x followed by a blank line and yes confirming the deletion BATCHLOAD glsbmt p sbtest 2 x yes END Delete the entire GL sub account record with all of its lines The header record key frame ends with x there is a subsequent blank line and yes to confirm the deletion BATCHLOAD glsbmt p sbtest x yes END Running Multiple CIM Sessio
122. he license codes identify the license type version expiration date and number of days remaining and number of users sessions or locations for which your site is licensed Before you can use MFG PRO you must register the license codes with MFG PRO License registration programs are provided under the License Registration menu 36 16 10 Use the license registration programs to Register newly installed software e Upgrade software to add new users or sessions e Maintain and report historical license data Report detailed and summary license violations e Report license usage and user activity for QAD conducted audits Licensing Overview QAD licenses the MFG PRO software to its customers for use by a predetermined number of users sessions or locations The following sections describe concepts associated with license types user and location counting license violations violation types violation messages and registration interaction with other MFG PRO modules Database Management 137 You can use User Monitor Inquiry 36 16 12 or other license related reports to monitor user activities and application use License Types There are three license types in MFG PRO Named User Each unique user ID defined in User Maintenance 36 3 18 is counted as a user There is no limit on the number of sessions each defined user can run simultaneously Multiple sessions for the same user ID are counted as one user Concurrent Ses
123. he name of an MFG PRO database Database Name displays at the top of each menu This name is usually the same as the physical database name but does not have to be If it is not the 1d parameter should be used in the startup script Enter the value specified here following the 1d parameter For the primary database you do not need to specify a physical database host or server However you must enter a value for Database Name You must specify this name in the Database field for all sites in the current database in Site Maintenance 1 1 13 Multiple Databases 87 Physical Database Name Enter the Progress name of the database such as qaddb This database name is case sensitive since it is passed to UNIX There is no extension Database Directory Enter the full path name of the directory that contains the database specified in Physical Database Name The name should not be followed by a slash Only fields used to locate the database are required If all databases are in the same directory for instance you do not need to supply the directory name Host Name Enter the name of the host exactly as it appears in the etc hosts UNIX file or equivalent on the machine where the current database resides If the host parameter is specified specify a server parameter also If the host is the current host neither host name nor server need be specified except with TLI networks on UNIX V 4 Server Enter the name of the server
124. his field Unrealized Exchange Gain Acct 1035 Unrealized Exchange Loss Acct Realized Exchange Gain Act Realized Exchange Loss Aci Exchange Rounding Account 10 Active 7 Review the rounding methods you define using Rounding Method Browse 36 2 10 or Rounding Method Report 36 2 11 Establishing Generalized Codes When you install a new MFG PRO database a number of system and reference fields accept any kind of data as long as it does not exceed the field length You can customize the user interface by adding generalized codes and lookups Before implementing a module or section of MFG PRO the implementation team should determine which fields should have generalized codes and lookups When using generalized codes you can control three different conditions e What the acceptable values in a field are Define these values in Generalized Codes Maintenance 36 2 13 e Whether a list of acceptable values displays in a look up browse on the field Specify this in Drill Down Lookup Maintenance 36 20 1 e Whether the codes you have created are the only acceptable codes that is whether the list is validated This may require you to add a validation expression to the data dictionary System Constants 17 Field Validation Before entering a list of generalized codes for a field you must know the field s name and size In the Windows and character interfaces the field name displays at the bottom of the scre
125. hive programs remove selected records from the database letting you archive them to tape or other media Each delete archive screen looks similar to a report criteria input screen You choose records based on selection criteria Criteria can include date ranges document numbers employee names and so on Table 8 1 lists data that can be deleted and archived Accounts Payable Accounts Receivable Audit Detail Call Quote History Closed Cumulative Orders Closed Intersite Demand Closed PO Shippers Closed Projects Closed Purchase Requisitions Closed Purchase Orders Closed Purchase Receipts Closed Service Requests Comment Cross References Containers Customer Schedules Deferred Accrued Revenue Expired Sales Quotes Expired Call Quotes Family Hierarchies Flow Schedules Forecast Details GL Report Images GL Transactions Inbound EDI Documents Installed Base History Intersite Requests Intrastat History Invoice History Logistics Charges Lot Masters Master Bills of Lading NRM Sequences Operation History Operation Plans Operation Plan Simulations Outbound EDI Documents Physical Inventory Tags Product Change Orders Product Change Requests Product Structures Q LinQ Documents Quality Orders Table 8 1 Transactions that Can Be Deleted Archived Quality Test Results Repetitive History Retired Fixed Assets RMA History Routings Sales Analysis Sales Order Shippers Self Bills Sequence Service Contracts Servic
126. ief description 24 characters of the field Active Specify Yes to activate tracking for the field you specified Specify No to deactivate tracking The default is No Review the tables and fields you specify and their active or delete status using Change Tracking Browse 36 2 23 Reason Code Pop Up After you activate change tracking and specify a table and field to track when the user changes or deletes the value of the field a reason code pop up displays Currently only the sales order detail table can be tracked therefore the reason code pop up displays in Sales Order Maintenance 7 1 1 FAQAD System Constants 33 Fig 2 22 Reason Code Pop Up in Sales Order S010039 Sold To 10010001 Ln Format S M Single Order Maintenance 7 1 1 Sales Order Line Ln Item Number Qty Ordered UM List Price Discount Net Price 2 44 100 1 0 EA 1 000 00 0 0 1 000 00 Reason Code Reason code EEP Pop Up Desc CONTROL UNIT HOMI O oO Loc 12000 Site 10000 Disc Acct 3900 Select a code that indicates the reason you are changing the value of the field or deleting the line The reason type associated with the code must be ord_chg Even though you can track multiple fields you are only prompted once with the reason code pop up Use the comment screen to explain multiple changes you made to the sales order line Viewing Changes To view changes you tracked use Booking Transaction Report 7 15 14 The report displays th
127. ield Use the look up browse for a list of valid entries Choose non key fields you want to populate and in what sequence Note whether Go or Return is required after each entry Not all fields have labels For example a two line description can consist of two separate fields To determine which lines correspond to which fields place the cursor in each line and press Ctrl F to display their field names You must populate each field with a separate entry in a CIM file Note In QAD Desktop field names display as field tips CIM Interface 117 4 Record a template of the CIM input file entries for the first frame The following is an example template for Item Master Maintenance 1 4 1 BATCHLOAD ppptmt04 p 10 10000 EA Oasis Cooling System Home Indust Model Remember all CIM files start with BATCHLOAD lt Program Name gt The Item Number 10 10000 is a key field and is required It must be on its own line The second line represents the next three fields in the entry group Follow Item Number with Go The next line fills in the UM and Description fields Note that Description is shown as two entries one populating the first line one populating the second Note There are a few cases where CIM load does not work such as costing data in Item Master Maintenance 1 4 1 In this case costing data has to be CIM loaded through Item Element Cost Batch Load 1 4 15 Fig 7 3 Item Data Maintenance gt 4 CIM File for
128. ines whether a registered number can be discarded leaving a gap in the sequence No the default Gaps are not allowed and numbers cannot be discarded from this sequence Yes You can discard previously registered numbers from this sequence by reversing the register operation NRM then erases all record of the sequence number and the discarded number is replaced by a gap Tip The target dataset could be the name of the principal database field where numbers from the sequence are used FAQAD 26 MFG PRO eB2 User Guide Manager Functions Fig 2 11 Number Range Maintenance 36 2 21 1 Segment List Frame FAQAD Allow Voiding Determines whether you can mark a registered number as void No the default Numbers in this sequence cannot be voided Yes You can void numbers and specify a brief description why Voiding is recorded as a separate event in the sequence history Effective Date Indicates the earliest date when this sequence can be used Expiration Date Indicates the latest date when this sequence can be used Segment List After you define the initial parameters for a sequence Segment List and Editor frames display The segment list shows the type and settings for each segment defined in the sequence Segments display in ascending order based on segment number Sequence Master Sequence ID 00000010 Description Sequence for Preshipper Numbers Target Dataset abs_id preship Internal Allow
129. ing initial setup Interaction with Licensing There are three license types for MFG PRO named user concurrent session and location Concurrent session licensing is checked at log in Both named user and location licensing is verified in User Maintenance For a named user license the system counts the number of active users authorized to access the licensed application and compares the number against a predefined limit for the license Location licenses stipulate a predefined number of locations for specific applications System administrators define a user s access location in User Maintenance When system administrators assign users to an application the system counts the number of locations and compares the number against the predefined limit for the license type If the number of active users or locations exceeds the predefined limit specified in the license agreement a violation message displays in User Maintenance Violation messages can be either warnings or errors depending on whether enforcement of the license policy is implemented Errors prohibit actions in User Maintenance when the limit on license agreements is reached warnings allow actions to continue Users and Security 43 System administrators can implement enforcement of license agreement See Setting Up by setting the Enforce Licensed User Count field to Yes in Security ped alae Control 36 3 24 Setting this field determines whether Errors or warning
130. insert the validation directly in the source code Important If you change the data dictionary keep careful records and be prepared to repeat the change when new versions of MFG PRO that update the data dictionary are installed Using Reason Codes Reason codes are used in sales quotes sales order maintenance purchase order returns shop floor reporting repetitive reporting and the Product Change Control PCC module They are also used if you have enabled change tracking and in several optional PRO PLUS modules such as WIP Lot Trace and Shipment Performance Add other custom uses as needed Fig 2 7 Re M men Reason Codes eas aif As Maintenance Reason Type DOWNTIM 36 2 17 Reason Code 3 Description MACHINE FAILURE O amp Use codes of type QUOTE in the Reason Lost field of sales quotations Use codes of type DOWN or DOWNTIME in the Reason field of labor feedback programs 17 1 17 4 19 e Use codes of type ORD_CHG to associate changes made in Sales See Tracking Order Maintenance to order detail such as a change to the order line i on quantity or due date e Use codes of type DOWN DOWNTIME REJECT REWORK ADJUST and SCRAP for reporting in Repetitive and Advanced Repetitive programs Use these same codes with the optional PRO PLUS WIP Lot Trace module e Codes used in the PCC module are user defined They specify severity levels related to approval of change documents e Use codes of type
131. ion expires Only evaluation demo or temporary licenses have expiration dates Application Usage Displays information about violations that occur when users do not have access to an application License Count Displays information about violations that occur when the number of users sessions or locations exceeds the amount stipulated by the license agreement Non Licensed Displays information about violations that occur when users Product attempt to run applications that are not registered with MFG PRO FAQAD 140 MFG PRO eB2 User Guide Manager Functions Table 8 4 License Violation Error Messages FAQAD Violation Messages Message Table 8 4 lists error messages that display when license violations occur Explanation and Solution Expired license code Product registration is not valid Application not available in licensed application master Licensed user limit exceed Licensed location limit exceeded Customer is not licensed to execute this module product The license code expiration date for this application has passed Contact your QAD sales representative or distributor to obtain a new license code Register new code in License Registration 36 16 10 1 The licence code data in your environment has been corrupted or is missing Contact your QAD sales representative or distributor to obtain the correct license code register correct code in License Registration Your environment lice
132. ions are associated with individual sessions some users can connect to one database only while others can connect to more than one Leave the databases in Database Connection Maintenance inactive and allow specified users to connect to other databases using Connect Database 36 6 13 as needed Example An administrator in a plant where Database is located creates two log in scripts one making Database1 the primary database the other making Database2 the primary database Table 5 2 shows the kinds of access personnel are given Table 5 2 Personnel Access Access Examples Salespeople Database1 log in script All sales orders filled in Databasel Inventory Database2 log in script Their work does not require access to other Controllers databases Master Database1 and or Database2 log in script depending on security Schedulers Ability to access Current Database Change Shippers Database1 log in script Shipments are recorded in Databasel Purchasers Either Databasel or Database2 log in script depending on site used Receivers Database2 log in script Receipts are recorded in Database2 In this example users can log onto other computers from their computers then execute log in scripts The log in script for Database 1 is identical in Databasel and Database2 except where the log in ID for a user is different on different computers System Security The ID and groups associated with a user are defined based on the user
133. isting records When loading the latest version of the table data you must delete your existing version along with any modifications you made The new menus are loaded with a utility program mgdload p which provides some control over what gets replaced and prints a listing of what was changed The mnd_det table is modified by two programs Menu System Maintenance 36 4 4 and User Function Maintenance 36 4 11 Menu System Use Menu System Maintenance 36 4 4 to assign menu labels and execution files to menu numbers When users type the number the file executes If you want to move a menu item or have it execute a different program change the record with this program Fig 4 4 mer M t Menu System Maintenance eae ha Language ID us english U S 36 4 4 Menu 1 Items Sites Name Execution File Help File Mm ERR O Q The Name field allows you to call programs using keywords For example for a program buried deep in the menu structure you can add a name and then execute the program by typing that name on any menu command line FAQAD 68 MFG PRO eB2 User Guide Manager Functions gt See Installation Guide QAD Desktop FAQAD Note If you are using QAD Desktop you must use Desktop utilities to rebuild the menus and the search database whenever you add new menu items or change existing ones Otherwise your changes will not be visible to users User Menu and Function Keys Assigning function keys to fr
134. ith the cursor in the field Press F2 a second time and procedure help displays No keyword searches or hypertext links are available in character help Adding User Help Use Field Help Maintenance 36 4 13 to add to the character format help delivered with MFG PRO Fig 4 8 Field Help Maintenance Language us english U S Substitute O 36 4 13 Calling Field cm_region Calling Procedure Link to Field Link to Procedure Text FAQAD 74 MFG PRO eB2 User Guide Manager Functions gt See Setting Interface Preferences on page 47 FAQAD Important Currently you can only update help viewed in character sessions If you are using a Windows environment view character help by turning off the WinHelp setting in User Maintenance 36 3 18 Custom text entered in Field Help Maintenance appears first when you press the Help key Press Help again to display standard QAD help Printing Help You can print out portions of the field and procedure help to supplement your User Guide set Printed field help is available through Field Help Report 36 4 14 The Procedure Help Report 36 4 16 prints procedure help in alphanumeric ranges by program name The Field Help Book Report 36 4 15 enables you to print a book containing all field help Choose units as small as one field and as large as an entire module Local Vars Set to No to exclude local variables These are field names created within a program not
135. ity Security Maintenance 59 error messages 72 error messages license violations 140 errors license violations in User Maintenance 39 Exit to Operating System 158 expired password 43 F field help 73 adding to 73 book function 74 printing 74 Field Help Book Report 74 Field Help Maintenance 73 Field Help Report 74 field security 53 validation 54 Field Security by Group 56 Field Security Maintenance 54 56 field tracking changes 30 Form Code field 105 function keys assigning menu items to 68 calling programs with 66 limitations 68 FA QAD 200 MFG PRO eB2 User Guide Manager Functions G general ledger GL account security 60 daybooks number range management NRM 24 generalized codes displaying list of 16 179 example 17 validation 16 Generalized Codes Maintenance 17 Generalized Codes Validation Report 17 18 GL Account Security Maintenance 60 GL Transaction Delete Archive 158 GMT Offset field 152 GMT See Greenwich Mean Time GMT gpcode v 18 gppswd v 54 Greenwich Mean Time GMT 152 groups user 42 48 H help 73 printing 74 user 73 high water mark licensing 147 Holiday Maintenance 14 l interface preferences 47 International Organization for Standardization ISO codes 45 Inventory Movement Code Security 61 Inventory Movement Code Security Browse 61 Invoice Post site security 57 items multiple databases 84 J join type View Maintenance 192 K killing CIM sessions 121 L Label Control
136. ity is a company or a way of grouping financial reports Entity codes must be identical across databases so that appropriate financial transactions can be posted in each database Define entities with Entity Code Maintenance 25 3 1 1 You can record financial transactions in any currency Transactions in different currencies are reconciled in the same way as in single database operations Note While you can create transactions in multiple currencies all entities within a database share one base currency defined in the System Account Control After copying the baseline database you can change the primary entity and base currency of each copied database They do not need to conform to those of the baseline database Setting Up Baseline Inventory Status Codes Set up inventory status codes with Inventory Status Code Maintenance 1 1 1 so they can be used at any site in the system After copying the baseline database you can change or add codes for each copy Set up the following special codes e One that is fully restricted and does not allow use of any transaction codes Use this as the default inventory status code at sites that do not belong to a database e One for the inter site transportation location if you are using DRP Make the code non nettable since DRP orders are already counting the inter site shipment as supply Tip If you use multiple currencies set up currency codes first in Currency Maintenance 26 1
137. ling Procedure soivmt p as the Procedure To Execute ladbradp calling procedure for the nested drill down Drill Down Lookup Drill Down Field Name ad addr Calling Procedure adbrad p Procedure To Execute adbres p Nested subsequent drill downs Planning for Upgrades When you update MFG PRO with a new version be careful when loading flh_mstr This table contains the records created by Drill Down Lookup Maintenance If you have customized it make sure that the new version does not overwrite your customization User Interface Management 183 Creating Access to Other Programs User Tool Maintenance 36 20 4 lets you specify programs that can be run from other programs This makes it easier for you to run frequently used programs Note The relationships you define in User Tool Maintenance do not apply to any programs in the character interface and they do not apply to browses How you define access to programs and the way you run them varies depending on whether you are using the Windows or Desktop interface Windows Interface In the Windows interface you can assign up to four buttons and four User Menu items to launch programs of your choice You assign programs by user and program You can change buttons for all users or only some By default programs assigned to buttons are also assigned to the User Menu You can assign images to the buttons to make them easy to identify or use a text label only Warning
138. lization 131 database sequences initializing 131 maintaining 131 maintaining with CIM 133 Oracle 135 Database Table Dump Load 126 sequence initialization 130 databases changing current 94 dumping data 125 loading data 125 multi language 64 multiple See multiple databases size management 124 daybooks number range management NRM 24 daylight savings time 151 default printers 105 delete archive audit detail 128 157 GL transactions 158 NRM sequences 29 programs 127 restoring data 129 deleting records through CIM 118 deleting users in User Maintenance 42 Detailed License Violation Report 146 Dictionary Field Security Report 53 54 disk space determining usage 124 freeing 124 Disk Space Inquiry 124 158 distribution requirements planning DRP multiple databases 80 document formats creating 105 Down Time by Reason Report reason codes 19 Index 199 Drill Down Lookup Maintenance 178 generalized codes 16 18 drill down browses 178 associating with field 180 creating 186 drilling down on 182 wildcards with 181 DRP See distribution requirements planning DRP dumping data 125 procedure for 126 E editors segment 26 e mail command line 75 parameters 76 user address 77 e mail address User Maintenance 46 E Mail Definition Maintenance 75 employee type User Maintenance 46 Enforce Licensed User Count 43 Enforce Licensed User Count field 39 139 entities multiple databases 83 security 58 Ent
139. load programs see the Progress user manuals gt See Determining Disk Usage on page 124 FAQAD Note Progress and Oracle each provide dump load and import export programs but these programs do not maintain the integrity of data in the MFG PRO database Dump Load Procedures To dump load data 1 2 Back up the existing database Check available disk space A full dump load requires free space equaling approximately 70 of existing database size Log in to MFG PRO in single user mode You can speed up the dump load by running multiple sessions of Database Table Dump Load from multiple terminals Execute Database Table Dump Load for the correct range of tables If there is enough free space select all tables If there is not archive the dumped files to a tape then erase them from the database Repeat this step as needed When the dump is finished copy the standard empty MFG PRO database mfg onto your old database Load the dumped files back into the database using Database Table Dump Load Data files d files reloaded into databases containing data do not overwrite existing records Files to be loaded must be in a directory specified in your PROPATH A Progress bulk load is usually faster than a dump load but can require an index rebuild The system lists load errors ina e file located in the directory you ran the process from Deleting and Archiving Data Database Management 127 Delete arc
140. lso use wild cards to specify where the options appear Specifying pp places the buttons and links in all programs beginning with pp In the Exec fields enter the program names for example adbr001 for the buttons or links to launch In the Label fields enter the button or link labels which you can write as abbreviated program names for example Cust Maint In the Windows interface optionally enter the bitmap image file names in the Image fields The image files must be in the user s PROPATH User Interface Management 185 Displaying Buttons and Links You can assign programs to all users blank user ID or a specific user You can also assign programs to a specific program or using wild cards However only one set of records displays when a user accesses a program They system searches for the appropriate buttons or links to display in this order 1 Specific user ID and specific program name 2 Specific user ID and program name with wildcards 3 Blank user ID and specific program name 4 Blank user ID and program name with wildcards The system displays buttons or links only for the first available See User Menu combination it finds Use User Tool Maintenance in combination with a User Function Maintenance 36 4 11 to manage global and local access page 68 to programs Specify the additional programs you want to display in one or the other Setting Up Menu Substitutions Use Menu Substitution Maintenance 36 20 6
141. ly logged in along with the License type and count for the application Program names and menu numbers they are currently executing Session ID and user interface type for the session Time since they started the current program or menu e Amount of time they have been idle if no program is selected e Client internet protocol IP address for Desktop user interface By monitoring user and program activity the system administrator can identify users in violation of license agreements and minimize unnecessary overhead during peak system usage You can enter a combination of log in time and users applications or menu selections to view details of a specific log in scenario i or Iry Login Time o0 oo User w i Sort Option 1 1 By User ID Output O Q Application Enter the application name for which you want information to display You can enter a range of applications by specifying the first application to display in this field and the last application to display in the To field Database Management 149 Menu Selection Enter the MFG PRO menu selection for which you want details to display Leave blank to begin with the first menu matching the other selection criteria Login Time Enter the log in time for which you want details to display Enter the time based on a 24 hour clock in HH MM format For example enter 1 30 pm as 13 30 User ID Enter the ID of the user for whom you want details to display
142. nd Program Name Enter the complete path to executable e mail application file for instance F apps shared email blat exe End Effective Enter the last date this system is available for use This is an optional field Command line parameter fields can store parameters or arguments to identify the type of data being passed to the command The parameter is a prefix which is followed by the type of data The UNIX mailx command for instance requires that the subject of the message have a s prefix as in the following example mailx s test message E Mail Definition Maintenance defines four parameters Sender Recipient Subject and Message Text File or Message Text String Use the message parameters required by your e mail system Only one message field can be used in each e mail definition The Sequence fields control the order in which the Sender Recipient Subject and Message Text parameters appear in the command line Some e mail systems require these parameters in a specific order If your system does not use one of the parameters leaving both the Parameter and Sequence fields blank omits that parameter from the command line If you enter a parameter without a sequence the parameter is not included on the command line If you enter a sequence without a parameter the system skips this parameter and creates the command The E Mail Command field displays the system built Path and Program Name Parameters and Sequence
143. nd failover since the clients do not need to know the host and port of the AppServer broker The client only needs to know the unique name of the AppServer broker which is used by the Name Server to determine the broker s host and port Each AppServer instance can be configured to have its own set of parameter values such as the PROPATH database connections startup shutdown procedures and log files These parameter values are specified in the ubroker properties file located in the DLC properties directory where DLC is the Progress installation directory One extremely useful example of the AppServer is to improve the throughput speed of the processing intensive task of running material requirements planning MRP The AppServer can distribute processing load across multiple threads dramatically improving performance As an example of how an AppServer can be used this chapter includes instructions for setting up an AppServer to support enhanced MRP performance Before MFG PRO can run applications using a Progress AppServer the AppServer instance must be defined in AppServer Service Maintenance 36 19 1 Application Server 169 Defining the AppServer Use AppServer Service Maintenance 36 19 1 to define the information needed for MFG PRO to connect to a Progress Application Server You can specify a set of standard connection parameters used to connect to this server Optionally you can also define server specific parameter
144. nd loading are done as part of installing a software upgrade sequence initialization is automatically performed by the installation utilities However if you perform a dump load to consolidate tables or increase database size you must initialize sequences yourself This is true also if you consolidate data from two different databases e Use Database Sequence Initialization 36 16 17 to reset sequences to the highest value plus 1 after loading data This program works with both Progress and Oracle databases e Use Sequence Maintenance 36 16 13 to manually reset a sequence number to a specific value in a Progress database e Use Sequence Inquiry 36 16 14 or Sequence Report 36 16 15 to view sequence information To guarantee database integrity perform sequence maintenance In single user mode sessions only Asa required part of your standard database maintenance Initializing Sequences Database Sequence Initialization reads each table that uses sequences and sets the sequence number value to the highest number plus 1 This ensures that each new record created has a unique number This utility initializes sequences correctly in both Progress and Oracle databases Sequence MFG PRO Sequence Initialization Current Value Last Value Used Action cetr sq01 cmt sq01 encix sq01 cncu sq01 encu_sq02 ensix_sq01 ensu_sqo1 ensu_sq02 elg sq01 elg sq02 edmfs sq01 edxfs sq01 Maintaining Sequences Manually Maintain sequ
145. ng a priority to each batch ID Use Batch Request Detail Maintenance 36 14 3 to view reports and programs submitted to any batch Printers and Batch Processing 107 You can set up batch files that run the batch processor and from UNIX you can execute these jobs automatically To set up a batch file use the Progress commands bpro or mpro The mpro command has the following structure mpro DB name p lt Progress prog name gt startup parameters The lt Progress prog name gt designates a file that includes commands such as the following Input From lt input file name gt Output To lt output file name or dev null gt run mf p Input close Output close The lt input file gt should use the CIM format anticipating all data entry including login and logout password mgbatch p batchid wy The four dots are exits Y confirms the exit from MFG PRO You can run the batch file the mpro program automatically with cron FAQAD 108 MFG PRO eB2 User Guide Manager Functions FAQAD 120 110 MFG PRO eB2 User Guide Manager Functions See page 123 See Deleting Records through CIM on page 118 b See External Interface Guide O LinO FAQAD Introduction Transferring data can save disk space increase disk access speeds by compacting fragmented data and integrate legacy or otherwise noncompatible data with MFG PRO data There are three basic ways to transfer data into and o
146. ng data use User Maintenance 36 3 18 to temporarily change your country code to match that of the user who archived the data Fig 8 2 Archive File Reload 36 16 5 See Defining Users on page 42 FA QAD 130 MFG PRO eB2 User Guide Manager Functions FAQAD Managing Database Sequences When a unique identifier is needed by an MFG PRO program the system often uses a control field to store the last number used The system also supports the use of a special schema element called a sequence A sequence is a database element used to generate a stream of sequential values for assigning unique identifiers to records Sequences allow fast accurate numbering and reduce the amount of time the system spends validating uniqueness Use Sequence Report 36 16 15 to display a list of sequences defined in the database The sequence description indicates the database table and field that is updated by the sequence For example the description of sequence cmt sq0l is cmt_det cmt_indx Sequences have the important advantage of speed and reducing the possibility of record locking and contention However each sequence is a separate database element distinct from the table to which it applies This means that sequences must be initialized correctly whenever you use Database Table Dump Load If sequences are not initialized correctly Duplicate Unique Key errors may occur when users attempt to create transactions If dumping a
147. ns Any number of CIM sessions can be run at one time However two load sessions cannot be opened for a single file To run two sessions divide the file When running multiple sessions use CIM Data Load Process Monitor 36 15 4 The monitor shows the state of all existing CIM sessions Type and Process Session are indexes to the sessions Enter Process in Type CIM Interface 121 and use to first see all the Process sessions followed by the Load sessions If you select Go at the Session field the current status of the processes displays continuously The display shows startup time last transaction time and selection criteria used when the session was started Killing CIM Sessions Although a CIM session runs under the operating system and can be stopped using operating system commands this is not advised When the operating system kills a session MFG PRO is not notified and a record of the session may still display in the CIM Data Load Process Monitor 36 15 4 The best way to kill a CIM session is to use the Process Monitor To kill a session identify the session using the Type and Session fields then press the F5 key in the Session field A prompt asks you to confirm that you want to delete this record If the session was invoked with a low dispatch priority your monitor may still display a session after it has been stopped with a status of Killed To erase the session from the system delete it again by putting the curs
148. nse Use the Tab key to select a license code task Add The Add Product frame displays Enter the license code for MFG PRO or an MFG PRO module then choose OK The application name description version license type and number of licensed users display When you add a license code you are prompted to enter the IDs of users who can access the application A list of users who can access MFG PRO displays once you enter a user ID If you try to add an application that is already registered the following message displays Product already installed Database Management 143 Edit The Edit Product frame displays Use this frame to upgrade your license to increase users sessions or locations You must obtain the new number from your QAD representative or distributor After you enter the code and choose OK you are prompted to enter the IDs of users who can access the application Remove The Remove Product frame displays Enter the license code for the application you want to remove from registration A prompt displays asking you to confirm the license removal If you select Yes the system records the removal date and time The application is no longer registered and users cannot execute any programs that are a part of it If you remove the MFG PRO license code you will be logged out of the system and users cannot log in Granting Users Access to Registered Software You must grant users access to registered software If a use
149. nse data has been corrupted or is missing Contact customer support to reload valid license data This message displays in User Maintenance and License Registration when the number of users exceeds the number specified by the license System administrators can deactive some users otherwise contact your QAD representative or distributor to upgrade your license agreement This message displays in User Maintenance and License Registration when the number of locations from which users access the application exceeds the number of locations specified by your license agreement Review the number and definition of the licensed locations per your contract and ensure that users have the correct location value assigned To support more user locations contact your QAD representative or distributor to upgrade your license agreement You selected a menu item that is not covered by registered license codes Contact your system administrator to determine the correct menu items for you to access System administrators should contact their QAD representative or distributor if the license code is not correct or if they wish to purchase this additional module Database Management 141 Message Explanation and Solution User not authorized to run You have not been authorized to run this product this application System administrators authorize users to use products in User Maintenance or License Registration This product expires in
150. ntenance Language ID us english U S 36 4 1 7 1 Term CALCULATE DUE DATE Long Label Medium Label Short Label Stacked Label Description PIQAD 72 MFG PRO eB2 User Guide Manager Functions Fig 4 7 Message Maintenance 36 4 7 FAQAD The system validates the language code and accesses the term The term is the key that links labels to fields allowing the system to determine which labels to display The term remains the same regardless of the language selected Terms display in all uppercase with underscores for example CALCULATE DUE DATE is the term for Calculate Due Date when the language code is US American English Use Label Detail Maintenance 36 4 17 5 to assign terms and labels defined in Label Master Maintenance to fields generically or to fields in specified programs Warning Because terms can be assigned to fields accessed by many programs label modifications and new term assignments should be made with extreme caution Modifying Messages MFG PRO has two kinds of error messages Validation messages stored in the data dictionary These display when the contents of the field do not match its specifications Program messages stored in the database These display in all other cases Numbered Progress error messages sometimes display when a Progress instruction fails Most of these messages are handled by MFG PRO and an MFG PRO program error message is substituted so this should oc
151. ntroduction and User Guide QAD Desktop QAD Web Site QAD s Web site provides a wide variety of information about the company and its products You can access the Web site at http www qad com For MFG PRO users with a QAD Web account product documentation is available for viewing or downloading at http support qad com documentation You can register fora QAD Web account by accessing the Web site and clicking the Accounts link at the top of the screen Your customer ID number is required Access to certain areas is dependent on the type of agreement you have with QAD Most user documentation is available in two formats e Portable document format PDF PDF files can be downloaded from the QAD Web site to your computer You can view them with the free Adobe Acrobat Reader A link for downloading this program is also available on the QAD Web site HTML You can view user documentation through your Web browser The documents include search tools for easily locating topics of interest Features also include an online solution database to help MFG PRO users answer questions about setting up and using the product Additionally the QAD Web site has information about training classes and other services that can help you learn about MFG PRO FA QAD 4 MFG PRO eB2 User Guide Manager Functions Conventions MFG PRO is available in several interfaces Desktop Web browser Windows and character To standardize present
152. number 0 zero In the character interface restrict access to any of the 36 top level menu items by specifying 0 for menu and the appropriate number for selection In the Windows environment top level menu options are also grouped under seven icons These icons are referenced through the letter A A 1 Distribution A 2 Manufacturing A 3 Financials A 4 Customer Services A 5 Master Data A 6 Custom A 7 Supply Chain To restrict access to top level menu items in the Windows interface define records for menu A and the appropriate selection number as well as menu 0 and the appropriate selection Users and Security 51 For example to restrict access to the Item Sites menu 1 in Windows create the following records 1 Specify Menu 0 Selection 1 2 Specify Menu A 5 Selection 1 Specifying Groups Any number of session IDs separated by commas can be used and both wildcards and exclusions are possible At least one session ID usually an asterisk must appear for each menu item The asterisk and exclamation point are special characters when used in the User IDs Groups field Use the asterisk to give access to all users and groups A blank operates the same way as an asterisk allowing access to all users The exclamation point restricts specific users by user ID not by group For example user1 means all users except userl have access to the program When using the exclamation point you must enter
153. o run Menu System Report 36 4 5 FAQAD Creating a CIM Input File To create a data input file first determine the program to be used and fields to be updated The basic steps are as follows 1 Run the program that is to receive the data and determine the program name a Inthe character interface the name of the program displays in the upper left corner of the screen b Inthe Windows interface display the About screen from the Help menu c Inthe Desktop interface click the i information icon to display program details Determine the program s key fields These are typically the first fields and always let you advance to the next field by pressing Go A good test is to position the cursor in a field and press Go Note where the cursor goes Reposition the cursor in the field and press Return If the cursor moves to the same place as it did when using Go embed Go Carriage Return in your CIM file If the cursor went elsewhere embed a Return You could still embed Go if this new cursor position did not lead to any field you want to populate An input file must contain values for key fields each on a line by itself This allows the Go command to apply to the appropriate field Note which fields are validated or secured Do this by typing any character for example x and pressing Enter If a warning displays the field is validated or otherwise constrained Your input file must conform to valid choices for the f
154. ociated with a field You can also assign look ups to any field that acts as an index to a maintenance screen You may however need to write your own custom browse to find and display the data Most programs attached to a function with Drill Down Lookup Maintenance display values in a database table But this is simply a convention You can attach any Progress function to a field and this program executes when the user selects Help For example you can attach the program calculat p to field pt_avg int to display a calculator Before you can use Drill Down Lookup Maintenance you need to know The name of the field where you want the browse to display The name of the program using the field The program name of the browse to attach If a lookup is missing for a particular field but exists for a similar one use Lookup Browse 36 20 3 to determine the program that displays appropriate field values Then use Drill Down Lookup Maintenance to specify the same program for the similar field Determining the name of the program and field depends on the user interface In the Windows interface run the program Then select About from the Help menu The dialog box gives you the program name Return to the program and place your cursor in the field where you want to attach the browse Press Ctrl F and note the field name that displays in the message In the character interface run the program Note the program name in the upper l
155. ogram Reports Programs by Field Report 36 18 13 Programs by Table Report 36 18 14 Program Source File Report 36 18 16 Program Run Report 36 18 17 Shows all programs that call a particular field or range of fields Further limit searches by table name and program name The report includes the following The name of the database table to which each selected field belongs The names of the programs and subprograms that reference each selected field The types of actions performed on selected fields by each program or subprogram listed Action types are create search update delete and access This program may be useful when a field characteristic has been changed and the programmer wants to know what programs are affected When you generate a report on programs that reference a specific field such as pt_part programs using phrases like where so_part pt_part are not included in the report Similar to 36 18 13 Shows all programs that call a particular database table or range of tables Further limit searches by program name Useful when a table has changed Creates a list of program components or bill of material for a specified program or range of programs Shows all component parts including nested executable files and include i files that are directly called by the specified programs Creates a multilevel list of components or bill of material for a specified program or range of programs Sh
156. ok up Browse No View finmstroz Inventory Master View To create or modify a browse 1 Select or enter a name for the browse To name the browse enter two letters and press Enter The system gives the browse a name that increments by one the number in the file name of the last browse created 2 Press Go To preview an existing browse press Enter Otherwise press Go again Important Previewing a browse can be a time consuming process because the system generates and displays the browse in runtime 3 Enter a label term in Description Term The long label contained in this term is displayed as the title in the browse window 4 Indicate whether this is a power browse look up browse or both 5 In View enter the name of an existing view or a primary table whose data the browse displays You can see only those views you have access to If a view exists for a table and the view name is the same as the table name you have access to only those fields that are available in the view Fig 12 6 Browse Maintenance 36 20 13 Tip Use the existing MFG PRO module mnemonics or make up your own b See Creating Views on page 190 FAQAD 188 MFG PRO eB2 User Guide Manager Functions Fig 12 7 Browse Maintenance Field Select FAQAD Note The view name you enter in View must already be defined in View Maintenance or you must enter a primary table name In the Where field type the selection cri
157. ons The output of programs that run in multiprocessing environments such as UNIX To load a product structure for example construct a file that matches the record structure in the product structure master ps_mstr then load data into that table The CIM interface enables you to construct a file of input values for Product Structure Maintenance 13 5 and then validates all the data Internally the CIM Interface operates in two stages 1 CIM Data Load 36 15 1 places data in CIM database tables CIM Data Load can be executed as a Progress background session 2 CIM Data Load Processor 36 15 2 sends data stored in CIM database tables through the appropriate input screen Database Externally Generated CIM CIM Formatted Data Load ennaa Data Load Data Application Standard Data Program When CIM Data Load reads a data load group it creates a record in the batch data load master table and assigns it a unique group ID This integer record contains the name of the MFG PRO program to receive the data and the date and time when the record was added CIM Data Load then creates a record in the batch load detail table for each line of input data from the data load group Input from a file can be from either a disk file or a device character file such as a serial port If Input File Continuous Process is selected CIM Data Load executes the external program named in the Continuous Process
158. operly the Progress Name Server must be running In turn for the Name Server to run properly the Progress Admin Server must be running Although the Name Server and Admin Server are usually configured by default to start up automatically at boot time it may be necessary to administer them manually On Windows these commands are located in the DLC bin directory and should be run from a DOS window On UNIX these commands are located in the DLC bin directory and the user must have Progress administrative privileges to execute them To start stop or query the Progress Admin Server use the appropriate command proadsv start proadsv stop proadsv query Note Ina Windows environment it is recommended that you use Start Settings Control Panel Services to start and stop the Admin Server The Progress Name Server will be started automatically during the successful startup of the Admin Server If it is necessary to start stop or query the Progress Name Server assuming the default NS1 name is used for the Name Server use the following commands nsman i NS1 start nsman i NS1 stop nsman i NS1 query FAQAD 176 MFG PRO eB2 User Guide Manager Functions FAQAD Creating Brov Creating Views SK ng View 178 MFG PRO eB2 User Guide Manager Functions Table 12 1 UI Manager Functions Programs gt See User Guide QAD Desktop for details FAQAD Introduction The UI Manager Functions menu provid
159. or broker used when starting up the remote databases Must be identical to the server name specified in the etc services file This value is not needed if the database is on the current machine Database Type The default value is Progress Network Enter the type of network you use Only TCP DECNET NETBIOS SPX and TLI are supported Parameter File Enter the exact name of the optional parameter pf file to be used by the primary database to find the named database Parameters specified in parameter files supersede settings made in this program The pf suffix is neither required nor supplied The parameter file must be in the PROPATH Database Connection Maintenance and parameter files overlap The decision whether or not to use parameters files depends on how you choose to handle system security The format of parameter files and the meaning of connection parameters are discussed in the Progress documentation Active Enter Yes to have the primary database attempt connection with this database at startup Otherwise enter No Tip The path name is case sensitive gt For details on using pf files see Managing Multiple Databases on page 92 gt See Startup and Shutdown in the Progress System Administration Guide AQAD 88 MFG PRO eB2 User Guide Manager Functions See Managing Multiple Databases on page 92 for details gt See the installation guide for more information
160. or on the Session field and pressing FS FA QAD 122 MFG PRO eB2 User Guide Manager Functions FAQAD 127 130 149 124 MFG PRO eB2 User Guide Manager Functions Tip The program requires adequate free disk space to run Fig 8 1 Disk Space Inquiry 36 24 13 FAQAD Managing Database Size MFG PRO provides utilities for managing the size of your database Determining Disk Usage Use Database Table Size Inquiry 36 16 1 to dump selected tables and review their sizes Reported table sizes may be understated since indexing overhead is not taken into account Use Disk Space Inquiry 36 24 13 to display free space for each available disk in blocks For most UNIX environments a block is typically 1024 bytes For Windows environments blocks range from 1024 to 8192 bytes Consult your hardware manuals for exact specifications Note These programs must be run from a character user interface dev vx dsk rootvol 956656 blocks 464665 files proc proc 0 blocks 4453 files dev fa fa 0 blocks 0 files tmp swap 7823264 blocks 381700 files opt2 dev vx dsk crsu03 dg vol04 2757000 blocks 948168 files dr0o1 dev vx dsk crsu03_dg vol01 46291736 blocks 12355240 files dr02 dev vx dsk crsu03_dg vol02 48571390 blocks 12427225 files dr03 dev vx dsk crsu03_dg vol05 9841572 blocks 2461436 files opt new dev vx dsk crsu03_dg vol03 8622328 blocks 2448537 files users cm
161. or reduced shifts or plant shutdowns enter exception hours Set up exceptions for a date range by specifying the number of hours that are added to or subtracted from normal work hours Site 10000 San Diego Main Plant Work Center Machine Work Day Sunday Monday Tuesday Wednesday Thursday Friday Saturday O Reference Overtime Start 07 10 2002 In a calendar work days are marked with a Yes and nonwork days with a No Manufacturing order due dates are scheduled only on work days Each work day has a production capacity in hours This should exclude breaks and nonproductive time Manufacturing operations can be scheduled only up to the production capacity of the day Shop calendars are typically defined in this order 1 Create a system calendar by leaving site and work center blank 2 Create a calendar for each site with blank work centers CRP uses this calendar to calculate capacity including holidays Tip At least one calendar must exist Fig 2 1 Calendar Maintenance 36 2 5 PIQAD 14 MFG PRO eB2 User Guide Manager Functions Fig 2 2 Holiday Maintenance 36 2 1 FAQAD 3 Create work center calendars with site and work center filled in The system searches for a calendar from the most specific to the least specific specific site work center and machine combination first and blank site work center and machine last You can specify exceptions such as overtime or machine downtim
162. ord_chg type to implement change tracking Create reason codes that fit your company s most common reasons for changes to sales order details For example you can create a Delete reason code for deleted orders System Constants 31 Activating Change Tracking Activate change tracking by setting Keep Booking History to Yes in Sales Order Control 7 1 24 Sales Order Control Use Which Calc for Qty Available to Allocate 1 Allocate Sales Order Lines Due in Days 10 Limit Allocate to Avail Only 0 for no allocations Detail Allocations ATP Enforcement Enabled ATP Horizon Calculate Promise Date O Pick Only Allocated Lines Sales Order Prefix S0 Are Sales Orders Printed Next Sales Order Keep Booking History Z Invoice Prefi Set to Yes to Next Invoice 300009 activate change Shipping Lead Time 5 Integrate with AR tracking Integrate with SA Integrate with APM Confirmed Orders Fiscal Start Month 1 Company Address 10000000 Sales Order Header Comments 0 Sales Order Line Comments Print Only Lines to Invoice Ln Format s m Single z Specifying Fields to Track Use Change Tracking Maintenance 36 2 22 to e Specify which table contains the fields you want to track e Specify which fields to track Delete any records for fields that no longer require tracking Change Tracking Maintenance Table sod det Active Z Delete Table Enter the database table that
163. ous utilities on the Manager Functions menus numbered above 24 For documentation of these programs see the procedure help or the opening program screen of each utility Areas covered in this guide are described briefly below System Constants The programs on the System Constants menu 36 2 control calendars and codes used throughout the system These include shop and holiday calendars reason and generalized codes and rounding methods In addition you can set up number sequences using number range management NRM functions which support regulatory controlled document numbering NRM includes the content and sequencing of a numeric series as well as preventing gaps in a series Finally you can specify fields in tables for detailed change tracking and reporting Security MFG PRO requires that a user be defined with a valid ID and password before they can log in In addition the system offers several types of security including menu field entity site account and inventory movement code You can implement these levels by user ID or user group System Interface The System Interface menu contains programs that control menus screen labels messages multi language installations and help You can also set up user function keys and define your e mail system gt See Chapter 2 System Constants for details gt See Chapter 3 Users and Security for details gt See Chapter 4 System Interfa
164. ows all component parts including nested executable files and include i files that are either Directly called by the specified parent program Indirectly called by subprograms or include files that are in turn called by the specified parent program Use the Levels field to specify the number of levels to include in the report For example set Levels to 1 to list only the subprograms and include files directly called from the parent program FA QAD 164 MFG PRO eB2 User Guide Manager Functions FAQAD Program Name Description Source File Where Used Summary 36 18 19 Source File Where Used Detail 36 18 20 Run Program Where Used Detail 36 18 21 Program Summary Bill File Create 36 18 23 Shows which executable files use a specified source p or include i file or range of files Useful if you change an include file and want to see the executable files affected This program does not list intermediate include files Use Source File Where Used Detail 36 18 20 to generate a report on intermediate include files as well as top level program files Similar to 36 18 19 Shows which executable files use a specified source or include file also shows intermediate include files Use the Levels field to specify the number of levels to include in the report For example set Levels to 1 to list only the executable files that directly call the specified source or include files Shows which
165. ows the same format For example the line for US English looks like this US en US mdy American Where US is the MFG PRO language code en is the ISO language code US is the ISO country code Optional variant is blank mdy is the date format American is the numeric format period as the decimal separator comma as the thousand separator FAQAD 46 MFG PRO eB2 User Guide Manager Functions Identifying Users Use the following fields to identify this user User Type Enter the type associated with this user Employee identifies internal users who are employees e Customer identifies external customers who are authorized to access the system remotely To assign a customer type to a user you must enter a valid customer ID as the user ID in User Maintenance QAD identifies QAD employees who do customer support or service work API identifies users who access MFG PRO through an application programming interface connection Employee is the default for all newly created users except customers When you enter a customer ID as the user ID the type defaults to customer You may need to define additional types if users do not fit into the four categories for example you may need a contractor or part time type You must predefine the new user type in Language Detail Maintenance 36 4 3 before you can assign it to users here See Setting Up Time Zone Enter a time zone to associate with this user Time zon
166. p a lookup to display generalized codes use Drill Down Lookup Maintenance 36 20 1 Enter the field name where you want the lookup and gp1u072 p as the procedure to execute This program creates the lookup with values from the assigned field If the lookup should only be accessed from a particular screen enter that program name as the calling procedure Drill Down Lookup Lookup Field Name cm region Calling Procedure Procedure To Execute gplu072 p Description Term Lookup Starts At Row 7_ Lines In Lookup 6 The description defaults from the data dictionary but can be changed here If no description exists the field name is a local variable The description displays as the title of the lookup Adding Validation Generalized code validation like field security requires a special validation expression in the database dictionary that references the file gpcode v Some fields already reference gpcode v These display in the Generalized Codes Validation Report If you want to activate generalized code validation for other fields you must change the data dictionary You can do this directly using full Progress or if you have encrypted source you can use the utility utdb x70 p Once you have added a validation expression you must recompile the affected programs For instructions on how to do this refer to the Progress Programming Handbook System Constants To add validation for a local variable you must
167. pdate was applied Current Sequence Value This field displays the current sequence value User Input Enter any sequence value within the valid range The valid range is determined by MFG PRO and is part of the schema An error displays when the value entered is not within the valid range Maintaining Sequences Using CIM Sequences can be maintained using the CIM interface The content of a sequence represents the last value applied to the sequence by a call from an MFG PRO function This value is not available for processing since it was consumed by another process Values used to update a sequence are validated against a range of acceptable values for the sequence as established by MFG PRO The value of the sequence can be within and including the boundary values You receive an error message when the range is exceeded Limitations of CIM Some limitations to maintaining sequences through the CIM interface are Sequence maintenance must be performed in a single user mode Progress session The integrity of the sequence value is not guaranteed if maintenance is done in multiple user mode e Destructive updates are not permitted A CIM update cannot overwrite previously created files Data dumping does not proceed if any elements in the set of sequences conflict with an existing OS file Fig 8 6 Manual Sequence Update Frame Tip Sequence Maintenance generates a report listing current values of all sequences in the da
168. programs can still be executed from the Progress editor unless you add security for it To do this leave Menu blank in Menu Security Maintenance 36 3 1 and specify selection 0 zero which represents the editor User Group Example In this example of menu security for user groups a company has three levels of access to accounts payable one for clerks one for managers and one for the CFO Example Company A creates three groups Clerk Manager and CFO Helen the AP Clerk is added to the Clerk group Don the AP Manager is added to the Manager and Clerk groups Sara the CFO is added to all three groups In this setup Sara s session ID grants her entry to all the levels she is authorized to access Budgets gt _ gt z Maintenance y CFO group has access ft Manager group has access gl Transaction Post i Clerk group has access ti t i Voucher Maintenance Users and Security 53 Table 3 3 shows how you would set up users in User Maintenance User Group Helen Clerk Don Clerk Manager Sara Clerk Manager CFO Grouping users has two advantages It simplifies access for the user and reduces maintenance for the system administrator When a new clerk is hired the system administrator only has to assign the user to the Clerk group The administrator does not have to use Menu Security Maintenance and add the new user as an acceptable session ID for all the protected AP functions For most
169. ps can be defined later but it is important to make these consistent among sites Set up transportation modes and shipping schedules if known and if consistent among sites Setting Up Database Connections Figure 5 3 illustrates the steps to connecting databases Fig 5 3 TT Database Connection Flow Assign each site to a database Design a database network Define databases in MFG PRO Set up database security FAQAD 86 MFG PRO eB2 User Guide Manager Functions See Managing Multiple Databases on page 92 Fig 5 4 Database Connection Maintenance 36 6 1 FAQAD Designing a Network For instructions on setting up networks see Progress System Administration Reference Any network supported by Progress is acceptable but all databases must be on the same type of network Choose a host name server name and path name for each database This information can be changed later Defining Databases in MFG PRO Use Database Connection Maintenance 36 6 1 to specify which databases are to be connected Note The preferred method for maintaining database connections is using features of MFG UTIL These are described in the appropriate installation guide for your system Database Connection Maintenance Database Name gaddb Physical Database Name Database Directory Server Database Type Progri Parameter File qaddb Active Z Database Name Enter t
170. r program 1 Select Drill Down in the Drill Down Lookup field 2 Enter a field name to associate with the browse in Field Name Leave it blank to associate it with all fields 3 Enter the program containing the field in Calling Procedure Leave it blank to attach the browse to all programs using the specified field 4 Enter the browse name in Procedure to Execute See Creating 5 Optionally enter a label term in Description Term The long label oe ae contained in this term is displayed as the title in the browse The i default is the browse description term defined in Browse Maintenance You can access drill downs in four ways Select Drill Down from the Help menu and click on the field e Select the Drill Down icon on the toolbar and click on the field e Double click on the field in the browse e Select the field and press Alt F1 FAQAD User Interface Management 181 Follow these steps to associate a lookup with a field 1 Select Lookup in the Drill Down Lookup field 2 Entera field name to associate with the browse in Field Name 3 Enter the program containing the field in Calling Procedure Leave it blank to attach the browse to all programs using the specified field 4 Enter the browse name in Procedure to Execute 5 Optionally enter a description for the lookup This description is for reference only and is not displayed in the lookup 6 Enter the starting row and the number of lines to display in the browse pop
171. r who does not have access tries to start an application either an error or warning message displays depending on the value of Enforce Licensed User Count in Security Control 36 3 24 Access to applications is granted in one of two ways 1 Assign access to individual users by selecting registered applications in the Application List frame in User Maintenance 36 3 18 Activate users for a newly registered application in License Registration 36 16 10 1 After you successfully enter a license code in the Add Product or Edit Product frames the system displays the Add Authorized Users frame l Ball OlOAgE ata User hz i Enter All to select all users User Use this field to select users to be given application access See Specifying Application Use on page 49 Fig 8 8 License Registration Add Authorized Users Frame FAQAD 144 MFG PRO eB2 User Guide Manager Functions Fig 8 9 License Registration User Selector Frame FAQAD User ID Enter the user ID of the person you want to access the newly registered application The User Selector frame displays a list starting from the user ID you entered to the last user ID In the list select the IDs of users you want to activate An asterisk displays on the left side of the user ID to indicate that the user is active All Enter the word All The User Selector frame displays a list of all users An asterisk displays on the l
172. rders Invoices in the sales order database Enter base data See User Guide Volume 2A such as customers salespersons and freight lists a Bice details FAQAD 90 MFG PRO eB2 User Guide Manager Functions FAQAD Maintaining Items and Sites Use Item Inventory Data Maintenance 1 4 5 to assign sites to inventory items in each local database Maintaining Item Planning and Cost Data Set up planning and cost parameters for items at each site in a database Assign DRP items a purchase manufacture code of D and specify a source network Maintaining Purchase Order Sites Assign a purchase order site to each purchased item This is the site that issues purchase orders for this item Maintaining Prefixes In Purchasing Control 5 24 and Sales Order Control 7 1 24 in each database set unique document prefixes for the database This quickly identifies sales orders created in the wrong databases Maintaining Security Set up security for each database You may want to restrict access to Current Database Change 36 6 17 and Database Connect 36 6 13 In Security Control 36 3 24 create a unique session ID prefix for each database This prevents conflicts when temporary files are written and improves security by uniquely identifying users Maintaining Printers Modify the printers for each database as needed In sales and purchase order databases define printers for shipment information If the printers are alrea
173. rectory where xx is the record identifier such as iv for invoices and yymmdd is the archive date Verify deletion of records from the database Verify the contents of the hst file using the appropriate operating system command Back up the hst file to storage media and delete from system The delete archive program does not reduce database size To reduce database size use a dump load program Database Management 129 Restoring Archive Files Use Archive File Reload 36 16 5 to reload an archive file after restoring the file from backup media to the system disk EHLE ACE Database Name Archive File Name Allow Errors Records Loaded Errors The reload process puts data from the archive file back into the database exactly as it was when you deleted it However if base data has changed you may encounter errors Example You are reloading accounts receivable history for a customer that has been deleted Set Allow Errors to Yes to continue processing when errors occur The system lists load errors in a e file located in the directory you ran the process from Important Date and time in the stored data are formatted based on the country code associated with the user who archived the data If a user with a different date and time format reloads the data load errors and corrupted data can occur To avoid these problems use the same user settings when archiving and reloading the data Before loadi
174. replace all inquiry programs with the browse versions you enter iq in the Execution File field and br here 3 Entera label term in Selection Label Term The long label contained in this term appears in the title bar and menu list of the substituted program Creating Browses Use Browse Maintenance 36 20 13 to create browses which display selected data in the form of a table When you create a browse it is saved in your working directory as a source code file The source code name is the first two characters of the name you entered then the letters br or 1u depending on whether you selected power or look up then any remaining numbers from the name you specified then the extension p Example You create a power browse and name it ap010 the system names the code apbr010 p If you selected both power and look up browses the system generates two source code files apbr010 p and aplu010 p User Interface Management 187 Although you do not need to compile the source code of the browse you should for better performance If other users on your network want to use your browse you must compile it and move it to the network directory Use the Progress editor to compile the browse Note You can access the Progress editor only if your PROPATH is correctly set up to access source files BE x Lene BCE Name ic007 lt Preview gt Browse Data STOCK AVAILABILI1 Stock Availability Power Browse Yes Lo
175. rify that settings are appropriate for your business environment Using Delete Archive Utilities Audit Detail Delete Archive To delete data from an audit log use Audit Detail Delete Archive 36 23 1 This program works differently from other MFG PRO delete archive functions It does not delete each record specified Instead for each unique combination of user ID table and field it keeps the latest record and deletes archives the rest b See Tracking Changes on page 29 gt See Audit Detail Delete Archive on page 128 for an exact procedure FAQAD 158 MFG PRO eB2 User Guide Manager Functions Tip Add this function to the User Menu so that users can generate reports to a file and quickly review the content FAQAD Use this function to produce a report of records before deleting them GL Transaction Delete Archive All general ledger transactions are stored in the unposted transaction table until they are posted Review unposted transactions using Unposted Transaction Inquiry 25 13 13 To review or delete archive transactions created in modules other than the general ledger use GL Transaction Delete Archive 36 23 2 Use this program when 1 You are not using the General Ledger module to delete GL transactions created in other modules 2 You implemented other modules prior to implementing the General Ledger Before implementing General Ledger delete the GL transactions in the unposted
176. rinter X2TE Printer reset aa X27 amp 13A Folio paper format X27 amp 1XO Portrait orientation X27 amp 110 Landscape orientation X27 amp 11S Long edge binding prints on both sides X27 amp 166F Bottom margin is 66 lines from top X27 sXp16 67h8 5vXsXbXT Pitch 16 67 height 8 5 default style thickness font X27 amp 1TX89C Adjusts vertical index in steps of 1 48 inch X27 sXp16 67hXs3b4X99T Pitch 16 67 height default bold courier 4X99 FAQAD 102 MFG PRO eB2 User Guide Manager Functions Setting Up Printers After you have defined printer types use Printer Setup Maintenance 36 13 2 to set up printers and other output devices Fig 6 2 Printer Setup Printer Setup Maintenance Maintenance 36 1 3 2 Output To laser3 P Destination Type Default Defined in Printer Type HP LASER a 36 13 4 Description Development Laserjet 3 Lines page 60 Max Pages 0 Scroll Output O Device Pathname Ip dlaser3 s Spooler l Printer Definition O Q Printer Control Initialize Command Initialize Ctrl 80 Column Start 027E 0278100 027 8U 027 s0p10h12v0s0b3T 027802 2E 027817 8689C 0278166F 132 Column Start 027E 027 amp 100 027 0U 027 s0p16 66h8 5v0s0b0T 027 Codes 66P 027 amp I2E 027 amp l7 8689C 027 amp 166F Reset Ctrl Printer Control Reset Command Output To Assign a unique name to each printer or other output device This name displays in the Output field of reports and inquiries The MFG
177. rk sales order detail fields for change tracking For line detail information in discrete sales orders you can e Specify which field to track e Activate or deactivate tracking Delete any records for fields that no longer require tracking FAQAD 30 MFG PRO eB2 User Guide Manager Functions gt See User Guide Volume 2A Distribution Fig 2 18 Change Tracking Implementation Flow gt See Using Reason Codes on page 19 FAQAD e Allow users to enter a reason code and comments when the value of a marked field changes Print the changes reason codes that explain the changes and any associated comments on a Booking Transaction Report 7 15 14 Change Tracking Implementation Overview When implementing change tracking you work with different programs to set up codes activate change tracking specify what to track then view results Figure 2 18 illustrates the basic change tracking implementation flow Define reason codes for ord_chg reason type Enter reason codes and comments when field values change Activate change tracking View changes reason codes and comments Specify and activate the table and field to track Defining Change Tracking Reason Codes You must define reason codes that explain changes to sales order detail in Reason Code Maintenance 36 2 17 You specify ord_chg as the reason type You must define at least one reason code for the
178. rmed when connections are down For most purchasing transactions both databases must be updated at the same time If the system fails during a transaction corrections must be made manually in both databases Multiple Database Example When implementing multiple databases you must ensure that information is available to databases where and when it is needed and that the information is consistent across databases Assume for instance you create a sales order in a sales order database with a line item to be shipped from an inventory database The sales order uses master data such as customers salespersons items credit terms freight lists and price lists from the sales order database When the site belonging to the inventory database is specified the system looks at the site master determines which database the site belongs to then checks the database connection master dc mstr to see if that database is connected If it is the system processes this and all subsequent Multiple Databases 97 transactions involving the site by accessing the inventory database When the order is created allocations and demand records for the site are created in the inventory database When the item is shipped inventory records item master and demand records in the inventory database are updated The inventory transaction occurs in the inventory database and the associated GL records are created in that database using accounts specified by tha
179. rs in lowercase taking care to spell correctly Use a hyphen to Tab through a field retaining the default or existing value For example to accept default data for fields 1 2 3 5 and 7 and enter Yes 12 and 01 01 02 for fields 4 6 and 8 enter the following yee yes yQ a 01 01 02 Format data as it is entered Use a period on a line by itself to indicate End or End Error For repeated input that is multilevel use the period to go back one level This executes the End command Use slashes where needed These are not required Make sure the date format in the CIM file matches the date format specified in the Progress session startup parameters d parameter Use a caret to indicate a null value Input Data Types Input data is information that you would normally enter from your terminal The manner in which you enter information in an input file depends on the type of information the field is set up to handle There are four types of input data e Character fields can be alphabetic or numeric but have no mathematical operations applied to them Descriptions alphabetic and customer codes numeric are examples of character fields FAQAD 114 MFG PRO eB2 User Guide Manager Functions FAQAD Surround descriptions with double quotation marks The description is accepted without quotation marks but may be interpreted as more than one input If there is a space in the
180. ry License Violation Report 147 suppliers shop calendar 12 system constants calendars 12 change tracking 29 generalized codes 16 holidays 12 number sequences 20 reason codes 19 rounding methods 15 system cross reference 160 161 customizing 160 rebuilding procedure 165 size 160 system map and 160 updating 165 System Account Control Audit Trail field 156 Server Time Zone field 150 T Tables Fields by Menu Report 161 Tables Fields by Program Report 161 time zones activating in SSM 150 based on offset from GMT 151 creating 151 defining 151 deleting 153 loading sample data 153 154 reloading 153 setting server time zone 150 setting up in User Maintenance 46 tracking daylight savings time 151 Timeout Minutes field 39 toolbar assigning buttons to 183 tracking changes 29 type license violations 139 licenses 137 printers 100 Index 203 user 46 U UNIX batch processing 107 Unposted Transaction Inquiry 158 upgrading licenses 143 User Access by Application Inquiry 49 145 user count 138 User Function Maintenance 67 71 user groups defining 42 naming 48 security 42 user ID requirements for log in 42 User Maintenance access location 44 country code 45 deleting users 42 e mail address 77 e mail definition 75 interface preferences 47 language 44 65 locale 45 password 43 password change date 39 time zone 46 user groups 48 user ID for log in 42 user type 46 variant 45 violation messages for license agreement 42 Us
181. s FAQAD User Menu in Character Interface Access the User Menu by pressing F6 A list of menu items set up for your user ID appears Choose the one you want by highlighting it and pressing Enter or Go Press Tab to sort the list by menu number or function name Press End to display the user menu items defined without a user ID Note There is no relationship between the order of items on the User Menu and the function key assigned and the function key is not shown Menus sort lexically so that 13 appears before 2 if you are in the Menu Selection column Different environments have different function key uses and limitations Set up your system according to your environment For example if your system is limited to only 12 function keys do not attempt to use the function keys as a quick method to launch programs Instead use the User Menu Executing Programs in Sequence In the character interface you can make several programs execute in sequence by assigning them to the same function key and giving each a different sequence number When you press that function key the first function in the sequence executes When that function is finished the next one in sequence is called automatically Important All transactions in the sequence must be completed before data is updated in the database QAD Desktop If you are using QAD Desktop the programs you specify with User Function Maintenance display on the My Programs menu under My
182. s remove records from the database dump the remaining data and reload it into an empty database You need plenty of free disk space to do this Dumping and Loading Data Dump load programs move the contents of database tables into or out of ASCII files The dump procedure reads a database table puts quotation marks around the data value of each field and places those values in an ASCII file Example A record in the user master table usr_mstr consists of the following entries usr_lang FR usr_site 1000 usr_userl usr_user2 usr_user ID pxr One line in the dump file would read FR 1000 MAW PORES You can use dump files as input to other programs after converting the files to CIM input file format You can also take output from other programs convert it to CIM input file format and load it into the database This assumes the data has the correct form based on the screen flow and format the CIM input is duplicating The Database Definitions book contains details on specific table formats Dump load procedures are located at 36 16 4 in the Windows interface and at 36 16 3 for UNIX environments Load procedures do not overwrite existing records You must delete the old data first b See Deleting and Archiving Data on page 127 gt See Using the CM Interface on page 110 for details PIQAD 126 MFG PRO eB2 User Guide Manager Functions gt For information on Progress dump load and bulk
183. s required by the AppServer Note The example shown in Figure 11 1 includes the data you would See page 170 enter to define an AppServer used to improve MRP performance Fig 11 1 Maintenance 36 19 1 Description AppServer for MRP Application Service mt mrp IP Address or Host Name localhost Parameters E Mail User w P E mail Level NONE P ees Service Name Enter a name to identify this application server Description Optionally enter a description of the application server Application Service Enter the name of the Application Server defined in the ubroker properties file during configuration of the AppServer IP Address or Host Name Enter the IP address or host name used as the H parameter when connecting to this application server This is the IP address or host name of the machine on which the application server is running If the AppServer is running on the same machine as MFG PRO enter localhost Port Number Enter the port number used when connecting to this application server If you are running a Progress name server enter the name server port number The default value is 5162 e Otherwise enter the port number on which the AppServer is running AppServer Service FA QAD 170 MFG PRO eB2 User Guide Manager Functions gt See User Guide Volume 3 Manufacturing Tip The Explorer tool is available only on Windows FAQAD Parameters
184. s display in User Maintenance e System administrators can create new users when the number of existing users exceeds the licensed number e System administrators can assign applications to users for more locations than assigned in the license agreement Additional users can log in when the number of sessions exceeds the licensed number The applications a user can access must be activated for the user You can activate access to applications here or when you register an application license code in License Registration 36 16 10 1 This includes the base MFG PRO application If a user ID is obsolete you should inactivate access to all registered applications Fig 3 4 User Maintenance 36 3 18 Language Us P Country Code usa P Variant Password i Date Last Changed User Type Employee P Restricted Time Zone emT 8 P Access Location 1P E Mail Definition JP Interface Preferences Menu style A amp Icons B Tear Off C Character WinHelp 7 Menu Substitution O Groups Specifying Authorization and Access Use the following fields to set up authorization and specify access for each user Password Enter the password associated with this user ID The user must enter the password to log in to MFG PRO If you do not want users to enter passwords at log in leave this field blank FA QAD 44 MFG PRO eB2 User Guide Manager Functions gt See Password Expiration Days on page 39
185. scal periods Users and Security 59 Entity security all affects the following programs in other modules Debit Credit Memo Maintenance 27 1 Payment Maintenance 27 6 4 Voucher Maintenance 28 1 Voucher Confirmation Automatic 28 6 Voucher Confirmation Manual 28 7 Cash Book Maintenance 31 13 Fixed Asset Transaction Post 32 13 Fixed Asset Transaction Void 32 14 Fixed Asset Retirement 32 19 All users can still enter maintenance functions or run inquiries and reports To control access to a screen you must use menu security Once you define entity security for one user and one entity it applies to all users and entities Each user must be set up individually To give a user access enter the user ID and list of entities as shown in Figure 3 11 Note Entity security cannot be defined for groups Fig 3 11 Entity Security Maintenance 36 3 13 Authorized Entities for User Description Primary Entity An asterisk in the Entity field indicates that a user can access all entities Important For a user to create a new entity they must have access to all entities FA QAD 60 MFG PRO eB2 User Guide Manager Functions gt See Specifying Groups on page 51 Fig 3 12 GL Account Security 36 3 9 FAQAD Using GL Account Security GL account security lets you restrict who can update GL accounts Account security must be set up by user group Account security is only effective when
186. sion Each concurrent log in is counted as a session If a single user logs into multiple sessions simultaneously each log in is counted Location Each user s access location is counted as a location QAD licenses a predefined number of locations for specific applications Customers must define their locations in Generalized Codes Maintenance 36 2 13 System administrators assign users an access location in User Maintenance 36 3 18 Table 8 2 is an example of the location license scheme In the example Logistics Accounting has a location license with three locations predefined Physical Users Location User License Count John accesses Logistics Accounting from the Seattle accounting center Counts as one location Mary accesses Logistics Accounting from the Los Angeles office Counts as two locations Angela accesses Logistics Accounting from the Pasadena distribution center Counts as three locations Bill accesses Logistics Accounting from the Los Angeles office Still counts as three locations See Violation Types on page 139 See Access Location on page 44 Table 8 2 Location Licensing Schemes FAQAD 138 MFG PRO eB2 User Guide Manager Functions gt See User Guide QAD Desktop See Violation Messages on page 140 gt See License Reporting on page 145 FAQAD User Counts MFG PRO software monitors licens
187. source p and include files i reference a specified subprogram Lists both top level source files and intermediate include files Useful if a called program has changed and you want to check the behavior of the calling programs Use the Levels field to specify the number of levels to include in the report For example set Levels to 1 to list only the files that directly call the specified subprograms Creates a list of components or bill of material for a specified program or subprogram showing all files in the order in which they are called List includes all subprograms called by the specified parent program as well as fields updated by those subprograms Can include multiple calls of the same file Report output is placed in an ASCII file where you can manage it using operating system tools For example if you change the name of a called program use Program Summary Bill File Create to make sure you change each instance of it in the source code System Cross Reference 165 Updating the Cross Reference The cross reference is built by compiling programs then checking the compiled programs against the menu If you change menus or change programs rebuild the cross reference using Cross Reference Update Menu 36 18 24 Rebuild cross references as follows 1 Ifthe source has changed run Cross Reference Update from Source 36 18 24 1 2 Run Missing Component Program 36 18 24 15 Missing Menu Execution File 36 18 2
188. ssor 106 batchdelete field 118 Booking Transaction Report 33 bpro 107 Browse Maintenance 186 browses FAQAD associating with field 178 creating 186 creating views for 190 drill downs 178 lookups 178 buttons toolbar creating 183 Cc calculat p 179 Calendar Maintenance 13 calendars shop 12 change tracking activating 31 specifying fields to track 31 Change Tracking Maintenance 29 character based menu 47 CIM Data Load 111 CIM Data Load Process Monitor 120 CIM Data Load Processor 111 CIM interface 109 121 creating input file 116 database sequences 133 deleting records 118 error handling 118 input data format 112 killing sessions of 121 multiple sessions 120 sample input 115 comments multiple languages 65 reporting master 157 concurrent session license 137 control programs Label Control 71 Control Tables Report 157 counting MFG PRO users 138 country information in locale dat file 45 setting country code for user 45 Country Code Maintenance 45 County Code field 45 cross reference system 160 Currency Maintenance rounding method 16 Current Database Change 92 94 138 Customer type User Maintenance 46 customers shop calendar 12 customizing field help 73 function keys 68 menus 66 D data dictionary changing 19 field security 54 generalized codes 18 Database Connect 94 Database Connection Maintenance 86 Database Disconnect 94 Database File Size Inquiry 124 Database Sequence Initia
189. t item s product line Item costs are obtained from item site cost records in the inventory database When the invoice is posted tables such as customer master and credit terms in the sales order database are used and accounts associated with those tables are used for GL transactions These GL transactions appear in the sales database Purchase orders follow a similar sequence again driven by the fact that each site is assigned to a single database AQAD 98 MFG PRO eB2 User Guide Manager Functions FAQAD 100 MFG PRO eB2 User Guide Manager Functions Fig 6 1 Printer Type Maintenance 36 13 1 FAQAD Introduction You can send reports inquiries and browses to a variety of printers both local and network The Printer Management menu contains programs for setting up system printers and default printers by user or group The Batch Processing menu includes programs for creating batch print requests Defining Printer Types Before setting up printers define printer types using Printer Type Maintenance 36 13 1 Printer Type Maintenance Printer Type SER p Description Lines page 60 Initialize 80 Col Start 027E 0278100 027 8U 027 s0p10h12v0s0b3T 027816 027 amp 12E 027 amp 17 8689C 0278 amp l66F 027 amp k2G 132 Col Start 027E 027 amp 100 027 0U 027 s0p16 66h8 5vOsOb0T 027 66P 027 amp 12ZE 027 amp l7 8689C 027 amp l66F 027 amp k26 Bar Code Start 027 0V 027 s4 69h0T Bar Code End 027 3 027
190. ta The system checks this field only when Load Sample Time Zones is Yes If you are loading time zone data you can also delete current time zone definitions Use this feature if you want to reinitialize the sample data 156 MFG PRO eB2 User Guide Manager Functions b See User Guide Volume 4A Financials Table 9 1 Audited Tables FAQAD Generating Master Data Reports Use the Master Data Reports 36 17 menu to generate audit trail reports showing modifications to master tables as well as reports showing master comments and control program settings Auditing Reports Use audit trails to track and log which users have made changes to fields in master tables The system tracks high level information for changes to all master tables To maintain detailed information for a critical subset of master tables set Audit Trail to Yes in System Account Control 36 1 Table 9 1 lists the database tables that the system tracks Table Description Table Description ac_mstr Accounts pac_mstr Purchase Approval Codes ad_mstr Addresses pc mstr Price Lists bk mstr Banks pld det Product Line Detail Accounts bom mstr Bill of Material plsd det Sales Accounts cm mstr Customers pl mstr Product Lines cp mstr Customer Items ps mstr Product Structures ct mstr Credit Terms ptp mstr Item Planning Data cu mstr Currency pt mstr Item Data dpt mstr Department spd det Account Validation exr rate Exchange Rate tax mstr Tax Data flpw_mstr
191. tabase It can be run at any time and does not impact the content of sequence structures gt For more information on CIM see Using the CIM Interface on page 110 FAQAD 134 MFG PRO eB2 User Guide Manager Functions Tip The default activity is dumping 1 FAQAD You cannot manually update from CIM CIM is an automatic process Any error causes the sequence maintenance to fail When you suspect a sequence maintenance activity failed while processing you must repeat the entire process This guarantees that the sequence values are valid Sample CIM File Format A typical CIM file might look like the following illustration Line 1 lt log file gt lt log directory gt Line 2 lt sequence name gt Line 3 lt action gt Line 4 lt input output OS directory gt lt log file gt The name of the file receiving the output log When an existing log file is specified the current CIM output is appended to the end of the existing log The default value is the value of the mfguser variable This has the format of TMP9999 where 9999 isa four digit number that uniquely identifies the CIM s MFG PRO session If the mfguser value is NULL the log file is named mgsqmt03 lt log directory gt The location where the log file is stored The blank value NULL is specified as the default When a lt log directory gt Is not specified the lt log file gt is placed in the PROPATH lt sequence nam
192. table Check settings in the DRP and MRP control programs For each database involved in intersite requests create subdirectories under the database directory using the names of the databases you connect to Give them write permission Intersite request records are written to these subdirectories when a connection is broken FA QAD 92 MFG PRO eB2 User Guide Manager Functions FAQAD Managing Multiple Databases Multi database administration involves ensuring that connections are maintained between databases and that users have proper access to data and functions The administrator determines the following e Database locations on CPUs Progress must be installed on each CPU and each must be connected by a network supported by Progress Server locations and how servers are started A server must be running for each database e Which MFG PRO modules are activated in each database User access to databases Do this by assigning user IDs and login IDs for database CPUs specifying a primary database for each user and controlling user activities in the database Login and Connection Methods Initial logins to the primary database and connections to other databases can be managed in two ways 1 Log in to the primary database with a shell script then use Current Database Change 36 6 17 to switch databases 2 Log in to each database using a different login script On continuously connected networks with servers for all
193. tact your QAD representative or distributor for a license upgrade AQAD 40 MFG PRO eB2 User Guide Manager Functions Fig 3 3 Log In Validation FAQAD Basic Login Security A user must enter both a user ID and a password to log in to the database If the user enters an invalid combination the system prompts for input two more times After three failures the user is returned to the operating system Figure 3 3 illustrates how this process occurs during log in After three tries User ID user is returned from sign on to operating system screen User ID and Add groups to Check menu password user ID to security list match active make list of against list of user record session IDs session IDs Password J from sign on screen If match is found run program A This type of log in security lets you Effectively separate MFG PRO security from the operating system security The user ID in MFG PRO does not have to be the same as the user ID referenced by UNIX or NT Provide an extra level of security from unauthorized users An individual can gain access to an operating system user ID by breaking into the system or stealing a password Requiring a different password to access MFG PRO presents an additional barrier to an unauthorized user Important You should not ordinarily set up root as a user in this system In Progress the root ID has access to all
194. teria optional to limit the browse s search to records that meet a certain condition The criteria in Figure 12 6 would display only inventory balances of bolts greater than 100 Do not put a period at the end of the criteria because the system adds ano lock no error statement to the criteria Press Go Name ic007 lt Preview gt Field Select Available Fields Selected Fields in_mstr in_abe I in nstr in assay lt Add gt in nstr in site lt Remove gt in mstr in avg date pt mstr pt um in ustr in avg int lt Fld Help gt local var02 lt Move Up gt in_ustr in_avg_iss in_mstr in_qty_avail in nstr in avg sls lt Done gt in mstr in qty req lt Move Dn gt in_mstr in_ent_date in mstr in qty all in mstr in cur set in mstr in qty ord in mstr in cyc int in mstr in qty nonet v 8 Fields from the view or primary table entered in the Browse Data frame display in Available Fields Include up to 20 fields in your new browse e In the Windows interface select fields to include in your browse by clicking on them and choosing the Add button To view help on an available field click on the field and choose the Field Help button e In character mode select a field to include in your browse by using the Up and Down keys to locate it and then press Enter Multiple fields can be selected Use the Tab key to choose the Add Field Help or Done buttons or to navigate between the Available Fields list
195. th your e mail system administrator to determine if the application you are using provides an operating system command interface If it does not various shareware products provide e mail command line interfaces Fig 4 9 z E Mail Definition E mail Definition 500 Maintenance Operating System msdos 36 4 20 Start Effective 07 07 2000 End Effective Description Path and Program Name Command Line Parameters Sender Sequence Recipient Sequence 3 Subject s Sequence Message Text File t Sequence 2 Message Text String Sequence Start Effective End Effective E Mail Command E Mail Definition Enter an alphanumeric code for an e mail system your company uses This can be a number or a shortened version of the application name You can use the same code for more than one record to give users access to multiple systems For example you can define both a UNIX system and a Windows system with the same code so that a user can log on to either system with the same user ID Operating System Enter the name of the operating system on the user s computer This is not necessarily the same operating system as the computer where the MFG PRO databases reside Valid values are UNIX MSDOS and WIN32 Start Effective Optionally enter the first date this system is available for use FA QAD 76 MFG PRO eB2 User Guide Manager Functions FAQAD Description Enter a brief description of this system Path a
196. that user Actions taken in the primary database affect data in that database only except where MFG PRO accesses other databases to retrieve or record information To alter data in another database directly use Current Database Change 36 6 17 Data in that database is affected by user activity Data in other databases is affected only by consolidated order processing or DRP actions When users change databases the security records defined in the current database are checked to determine access Database connections can also be managed using Database Connect 36 6 13 and Database Disconnect 36 6 15 Databases must exist in Database Connection Maintenance but can have Active set to No These programs are most useful for resource intensive operations like DRP To keep DRP from overloading a connection between sites you can disconnect the sites before running DRP DRP then writes all records to a subdirectory where you can access them later Controlling User Logins Combinations of Progress and MFG PRO connection methods let you control how users log in In each database use Database Connection Maintenance 36 6 1 to list all other databases Control the use of databases with login scripts Permit users who need to change databases to change the current database with Current Database Change Multiple Databases 95 Leave Database Connection Maintenance empty or inactive and control connections with log in scripts Since connect
197. tions assigning to users 43 registration license codes 136 product 142 removing licenses 143 renewing licenses 143 reporting licensing data 146 FAQAD reports violations of license agreement 146 requirements for log in 42 restoring archived files 129 restricting access See security Rounding Method Maintenance 15 Run Program Where Used Detail 164 S sales quotes reason lost 19 sample data time zones 154 security 35 61 Dictionary Field Security Report 53 entity 58 field 53 field limitations 54 GL accounts 60 inventory movement code 61 menu 50 multiple databases 94 95 password aging 39 Progress editor 52 session ID 37 site 57 special characters 51 types of 37 wild cards 51 Windows clients 50 Security Control 38 segment editors 26 Sequence Delete Archive 29 Sequence Maintenance 131 Sequence Number History Report 29 Sequence Number Maintenance 28 sequences database initializing 131 maintaining 131 maintaining with CIM 133 Oracle 135 number range management NRM 20 Server Time Zone field 150 Service Management Control time zone settings 150 session ID 37 Session ID Prefix field 38 shipping number range management NRM 24 shop calendar 12 shop floor control reason codes 19 site security 57 excluded functions 57 ranges of sites 58 setting up 58 Site Security Maintenance 57 sites multiple databases 84 Source File Where Used Detail 164 Source File Where Used Summary 164 substitution menu 185 Summa
198. to Curent Set t 1 Items Sites 2 a Enter data or press ESC to end VE 1 1 4 item Data Menu Enter data or press ESC to end Specifying User Groups The groups a user belongs to can determine whether a user is given access to menus fields and sites The system always passes the user s ID and any group names associated with the user to each program Assigning users to groups makes setting up security much easier e Group names can contain letters numbers and some special characters They cannot contain an asterisk exclamation point or comma You can add multiple groups at one time Separate group names with commas Spaces are not necessary and are eliminated upon entry e You can specify a user ID when adding groups to allow access to individual users e You can add as many groups as needed to a user Group names should be based on your company s structure Some examples follow Users and Security 49 e sitel00 site105 site110 e prod plan sales e admin supvsr clrk The system does not validate group names when they are entered Be careful to enter group names correctly for each user and ensure they match the groups specified in security functions Specifying Application Use The Application List frame in User Maintenance lets you define the software applications that a user can access MFG PRO is listed as the default application You can list addition
199. topping the AppServers The AppServer instance configured in the example on page 170 can be administered using the asbman command located in DLC bin which can be invoked from the command line of a DOS window The DLC bin directory must be in your PATH environment variable in order to run these commands alternatively you can change directories to the DLC bin directory to run them On UNIX these commands are located in the DLC bin directory and the user must have Progress administrative privileges to execute them Important Make sure that all databases to be connected to the AppServer are running before you start the AppServer The command usage is as follows To start an AppServer instance asbman i appServerInstanceName start e To stop an AppServer instance asbman i appServerInstanceName stop e To check the status of an AppServer instance asbman i appServerInstanceName query Example To start the agents for the AppServer name used in the sample ubroker properties file shown on page 171 type the command asbman i mt mrppro start After starting an AppServer use the query option to check its status and do not proceed until all of the AppServers are in the available state Application Server 175 For troubleshooting verify that the databases that the AppServer connects to are running Do this by running a Progress client session and trying to connect to the same database servers Note For the AppServer instance to run pr
200. transaction table These are reflected in the beginning balances you enter Using Operating System Commands The Operating System Commands menu provides four ways to access the operating system and execute commands directly from MFG PRO Use them as a convenient way of viewing and manipulating information e Use Exit to Operating System 36 24 1 to invoke a UNIX or NT session To return to MFG PRO enter Exit Use Program Execute 36 24 3 to run a Progress program If the program is not in the current directory specify the path e Use Program Text File Display 36 24 4 to display the content of an ASCII file such as a program or print file If the file is not in the current directory specify the path e Use Disk Space Inquiry 36 24 13 to execute an operating system command to display statistics regarding the current database file size 160 MFG PRO eB2 User Guide Manager Functions FAQAD Using System Cross References The System Cross Reference menu 36 18 contains programs that identify how and where fields and tables are used within the system System cross reference activities can be customized to reflect your system setup This lets you update cross references when you add or change menu items If you do not customize MFG PRO you can use the cross reference as it is The cross reference database requires about 50 MB of disk space and consists of a set of reports summarizing database relationships such as
201. uage Detail Maintenance this mnemonic is assigned to value 2 Printer Type Optionally enter a printer type defined in Printer Type Maintenance If you specify a type the characteristics assigned to that type are copied into this printer setup record You can modify them as required Description Enter a description of the output device Describing the physical location of a printer can be helpful Device Pathname Specify the operating system command or path name that enables you to output to this printer A device path name is normally not required for a terminal However if you are setting up a slave printer or a terminal window under X windows you may need to enter a path name Table 6 3 lists examples of device path names Table 6 3 Device Operating Sample Device Path Name System Effect Path Names arnt01 supjet1 Windows Prints to network printer shared as supjet1 off the arnt 01 print server printer Windows Prints to Windows captured default printer Ip d supjet1 UNIX Passes UNIX 1p command to operating system causing printing at destination supjet1 Spooler must be Yes FAQAD 104 MFG PRO eB2 User Guide Manager Functions Tip If you try to print checks forms and similar items on a device with a maximum page limit an error message displays Max Pages Enter the number of pages a device can accept If zero no page limit applies Lines Page Enter the maximum number of lines to appear on a pa
202. uctions on navigating and using the QAD Desktop interface see User Guide QAD Desktop For instructions on navigating the MFG PRO Windows and character environments refer to User Guide Volume 1 Introduction For information on using MFG PRO refer to the User Guides For technical details refer to Entity Diagrams and Database Definitions For information on using features that let MFG PRO work with external applications see the External Interface Guides Each book in this set describes a separate interface such as the Warehousing application program interface API and Q LinQ the tool set for building and using data exchange tools To view documents online in PDF format see the Documents on CD and Supplemental Documents on CD The CD ROM media includes complete instructions for loading the documents on a Windows network server and making them accessible to client computers Note MFG PRO installation guides are not included on a CD Printed copies are packaged with your software Electronic copies of the latest versions are available on the QAD Web site About This Guide 3 Online Help MFG PRO has an extensive online help system Help is available for most fields found on a screen Procedure help is available for most programs that update the database Most inquiries reports and browses do not have procedure help For information on using the help system in the different MFG PRO environments refer to User Guide Volume 1 I
203. ue is the same as the original value the system creates only one record Maintaining Sequences in Oracle Normally you use Database Sequence Initialization to set the starting sequence values in an Oracle database The following information is provided if you need to manually maintain sequence values in Oracle which cannot be done using Sequence Maintenance The standard sequence definition in Oracle is CREATE SEQUENCE lt sequence name gt START WITH lt initial value gt INCREMENT BY 1 CACHE 75 Where lt sequence name gt is the same as defined in the Progress df and lt initial value is the starting value specified by the customer FA QAD 136 MFG PRO eB2 User Guide Manager Functions gt See Maintaining Sequences Manually on page 131 FAQAD The initial value of a sequence is set to the highest value found in the field related to the sequence The content of a sequence is the last value applied by an MFG PRO function Example In a database with no user transaction processing the maximum value of tr_hist tr_trnbr is 1010 This value is used as the starting value of the sequence As user qad you would enter the following SQL DROP SEQUENCE tr sq01 CREATE SEQUENCE tr sq01 START WITH 1010 INCREMENT BY 1 CACHE 75 Registering Licenses When you receive MFG PRO software you also receive license codes This includes license codes for the MFG PRO foundation and other separately licensed applications T
204. umber of times the menu item is accessed Percentage of the application in use at the time of reporting You can use Application Usage Profile Report 36 16 10 8 to display the recorded information for each licensed application Fig 8 11 Application Usage Profile Report 36 16 10 8 Application Dete E Summary Detail Detail Output Batch ID O Q You can generate the report in summary or detail format Summary reports display only the module access count and percentage of application use Detail reports display all recorded information about application usage Detailed License Violation Report Use Detailed License Violation Report 36 16 10 13 to display information about license violations including gt See Violation e Types on page 139 Violation date time and error message User ID and name of the person who is in violation Violation type for example application usage or license count exceeded The total number of sessions and users logged in at the time of violation Session ID at the time of violation Percentage of the application in use at the time of violation Detailed license violation reports let you select a range of applications registered with MFG PRO dates user IDs or violation types on which to report FAQAD Application Type of Violation 1 To E wl wE Date Expiry 2 Application Usage 3 4 License Count Non Licensed Product
205. urity functions use the same internal strategy The security maintenance function creates a record which pairs a field or function and user IDs or user groups For entity and field security specify user IDs e For menu security site security inventory movement code security and GL account security specify any combination of user IDs or user group names When a user tries to do something that is controlled by security the system compares the security records with the ID and groups associated with the current user If there is a match the system limits the user s actions accordingly Since the strings passed to a security function vary the term session ID refers to any string passed to a security function that identifies the user The session ID can be a user ID a user group or a combination of these Table 3 1 lists the programs used for system security Table 3 1 Number Description Program System Security Menu 36 3 36 3 1 Menu Security Maintenance mgpwmt p 36 3 2 Menu Security Change mgpwcg p 36 3 4 Field Security Maintenance mgflpwmt p PIQAD 38 MFG PRO eB2 User Guide Manager Functions Fig 3 2 Security Control 36 3 24 FAQAD Number Description Program 36 3 5 Activated Field Security Report mgflpwrp p 36 3 6 Dictionary Field Security Report mgflderp p 36 3 7 Field Security by Group mgflgpmt p 36 3 9 GL Account Security Maintenance mgacsmt p 36 3 10 GL Account Security Report mgacsrp p 3
206. ut of your MFG PRO database Dump or load data files e Archive and delete or reload data files CIM load data files The first two options are discussed in Chapter 8 This chapter discusses CIM data load which lets you load data into MFG PRO from any source as long as the data is formatted to match the MFG PRO schema CIM is typically used to add or modify records in a database In certain cases it can also be used to delete records Only some functions support this feature Unlike direct data loads CIM checks load data for errors and saves unloaded records in an error file for correction and reloading CIM loads can be run in either batch or continuous mode Note Q LinQ offers more advanced features for data transfer including methods similar to CIM Using the CIM Interface The CIM interface loads data through online maintenance programs All data validation used in these programs during normal data entry is available during a CIM load Imported data is then made available to other programs In UNIX use an external load program to load data continuously These programs can accept input from devices such as barcode readers If data is loaded directly into tables using dump load programs or Progress loads some tables may not be updated correctly CIM Interface 111 Load data into MFG PRO using functions on the CIM Interface Menu 36 15 Imported data can come from e Any ASCII file that follows the correct conventi
207. y Only date driven or incrementing integer segment types are modified A fixed value segment is never changed Fig 2 8 Example Sequence Number Table 2 2 Segment Types FAQAD 22 MFG PRO eB2 User Guide Manager Functions FAQAD Control Segments You can set up a date driven segment as a control segment In this case changing its value causes the incrementing integer segment to reset to its assigned reset value When a control segment does not exist or does not change the incrementing integer segment is incremented Sequence Parameters Create sequence numbers and define sequence parameters using Number Range Maintenance 36 2 21 1 A distinct segment editor defines the format and parameters of each segment type Internal and External Sequences There are two types of sequence number internal and external Internal sequences automatically generate numbers in ascending order as needed NRM examines each segment in the sequence to determine whether to update its value A fixed value segment remains unchanged during sequence number generation External sequences accept a sequence number entered externally and validate it against a sequence definition NRM verifies that the number belongs to the set defined by the sequence and that it has not yet been used The system parses the number into segments and validates each segment against the corresponding segment in the sequence definition System Constants 23 Sequence Lif
208. y _user table If not an error displays and the session is not started Note If no Progress users are defined the U and P options cannot be specified Saving the User ID For users of the Windows interface MFG PRO provides an option to save the user ID for the next login If you need to log in to MFG PRO under a different user ID uncheck the Save User ID for next login setting to prevent the system from resetting your default login FAQAD 42 MFG PRO eB2 User Guide Manager Functions gt See Registering Licenses on page 136 FAQAD Defining Users You define users by assigning a unique user ID in User Maintenance 36 3 18 Each program is always passed the user s ID any group names associated with the user and access information associated with the user After you create the ID for a user you specify other identifying information and preferences To log in to MFG PRO each user must specify a unique user ID and a password that matches the user ID and password that you define here Other user data is referenced throughout MFG PRO and may be required for reasons other than security Note Batch processes must be assigned a valid user ID Once a user has accessed the system the ID cannot be deleted Instead you can make users inactive Inactive users can be archived during a QAD audit If an ID has never been used for log in you can delete it if necessary This lets you correct any errors made dur
209. you define valid time zone codes The server time zone is defined in System Account Control 36 1 System administrators associate users with a time zone in User Maintenance The time zone information is useful when detecting problems with users in location license types b See Defining Users on page 42 gt See Language Detail Maintenance on page 65 gt See Setting Up Multiple Time Zones on page 149 FAQAD 142 MFG PRO eB2 User Guide Manager Functions Fig 8 7 Licensed Registration 36 16 10 1 gt See Granting Users Access to Registered Software on page 143 FAQAD License Registration Use License Registration 36 16 10 1 to Add a new license code for MFG PRO software or separately licensed MFG PRO modules e Upgrade license codes to add sessions users or locations e Remove license codes on BEM OSTEN SY Registered Products Application Description COMPLIANCE Compliance Version eBZ CONSIGNMENT Consignment Inventory Version eB2 ECOMMERCE EDI ECommerce Version eBZ Fixed Assets Version eB KanBan Management Version BZ Logistics Accounting Version eBZ MFG PRO NFG PRO Foundation Version eB PRY Project Realization Version eB2 Add gt lt Edit gt lt Remove gt lt OK The system requests licensing information after you install MFG PRO or separately sold modules and when you attempt to log in with an expired lice

Download Pdf Manuals

Related Search

Related Contents

TV Operating instructions  Énu-réveil sans fil “CHARCO” avec émetteur gris, rouge ou noir  2013年11月版（pdfファイル形式）  Fujitsu ESPRIMO E400  Philips SoHo 105E 15" CRT Monitor  Télécharger - Fédération Française de Parachutisme  FT_ez_DAQ User`s Manual - Jmida Technology, LLC.  Samsung 206B User Manual  Sequel – Benutzerhandbuch  1005 KB  

Copyright © All rights reserved. Failed to retrieve file