16.14.1 Routing Module Overview
pc/MRP's Routing Module allows you to create routing records. You can then move and track work orders and sales orders through the factory floor from work station to work station.
16.14.2 Activating the Routing Module
To activate the module, select Configuration, Module Activation, Routing from the menu, and enter a special configuration number obtained from Software Arts.
When ever a sales or work order is issued to manufacturing using the stockroom's "I" type "Issue to manufacturing" option, a routing record for that sales/work order is created. The quantity at area 1 is the same as the quantity issued and the quantity on the sales order.
16.14.4 Setting up the Routing Module
Selecting "Settings" will open the "Router Module Settings Screen" shown above. This screen allows you to setup your routing module as follows:
o Select each area and enter a long name and a short name for each workstation on your factory floor. For example, you could enter Milling Station as the long name and Mill as the short name for area 06. The short name is used for report headings.
o If you select one of your areas as the finished goods area and you check the "Set as Finished Goods" check box, pc/MRP will automatically initiate the stock rooms "R, Returned completed assemblies from manufacturing back into finished goods stock". Checking this box will disable the stock room module from running an "R" type transaction, as only one module can be responsible for this function.
o One area can be set as "Shipped Goods Area". This area stores the quantity finished and returned to stock but not shipped to the customer yet. Whenever finished goods are shipped, you can decrement the quantity in this area using the router's “Enter Movement" option. The shipped Goods Area allows the user to see how many items are ready for shipment. It does not provide any external functions such as the Finished Goods area which can initiate the stockroom’s R (receive back finished assemblies) transaction.
o Check the "Allow Deletions" checkbox if you wish to allow users to delete router records. Actually, this will zero out the quantities in the router record for that sales/work order. If you check the "Administrator Only" check box, only users with rights to the password module will be allowed to delete (zero out) routing records.
o Checking the "Allow Editing of Fields" will allow users to edit routing record header fields containing sales/work order information. If you check the "Administrator Only" check box, only users with rights to the password module will be allowed to edit the routing record header fields.
16.14.5 Entering a Movement on a Sales/Work Order Routing Record
You can display a routing record for a sales/work order by selecting the "Enter Movement" option on the routing menu. Enter or "Scroll" for the sales/work order you wish to display. The "Enter Movement" screen provides the following options:
o The "Delete" button will zero out all area quantities in that sales/work order routing record.
o The "Edit" button will display additional sales/work order information for that routing record.
o The "From Area" drop down list box, "To Area" drop down list box, "Quantity" spinner, and "Move" button can be used to move a quantity of that sales/work order from one area to another area.
o The "Output" controls can be used to display, print, or send a copy of the routing record to an ASCII, Excel, or DBF file.
o The "OK" button will save your changes.
o The "Cancel" button will not save your changes.
16.14.6 Entering WS Value Percentages
Selecting Optional, Routing, and WS Value Percentages brings up the following screen:
220.127.116.11 Edit WS Value Percentages
Selecting Edit WS Percentages and then choosing an assembly, will allow you to enter the percentage of the cost of the assembly at each routing stage. See Report Type ‘Value’ defined in 16.14.7.
Percentages entered reflect the value of costs and labor of the assembly up to and including a routing stage. The final stage will always be 100%. See screen shot below.
18.104.22.168 List Undefined BOMs
Selecting List Undefined BOMs will generate a listing (genericp.frx) of all BOMs that do not have a WS Percentage record and will use the default percentage record set up via the Default Percentages menu option.
Selecting Index, will re-index the routing percentage database file (wspercnt.dbf).
22.214.171.124 Remove Orphaned Records
This menu option will remove any routing records from the routing database that do not have and BOM records in the partmaster.
126.96.36.199 Default Percentages
Selecting Default percentages allows you to set global percentage defaults if you do not wish to enter specific percentages for a BOM. See Report Type ‘Value’ defined in 16.14.7
16.14.7 Routing Reports
Selecting Optional, Routing, and Reports brings up the following screen:
The following reports are available in the routing module.
o All Records
o All for a Sales Order
o All for a Part Number
o All for a Product Code
o All for a Model Number
o All for a Related Document #
o All for a Customer Account #
o All for a Customer PO #
o All for a Salesman
o Value – the outstanding value of the report is the sum of all the values which is calculated by the station’s quantity * the assembly’s standard cost * % value set in the WS Value Percentage menu option.
The reports can be parsed by a Date Range:
o All records
o Entered On a Date Range
o Required On a Date Range
Reports can also include or be grouped by:
o Open Router Records Only
o Group the Report Results by Work Order
o Work Order Number
o Part Number
o Model Number
o Related Document #
o Customer Account ID
o Customer PO Number
o Start Date
o Date Required
The report output options include:
o Wide carriage print out
o ASCII TXT to disk
o XLS to disk
o DBF to disk
The report utilizes the Routing.DBF and format options include:
o Standard format route.FRX
o Custom format custrtr*.frx and cusrtr*.frx (see custom report section Chapter 15.4.1 for more details)