Parts: Part Maintenance

Revert to Saved

To revert any changes to the previously saved version.

Save as Shown

To save the changes you have made to the data file.

Cancel

Aborts the process currently in session. The keyboard equivalent is the Esc key for Windows computers and Command-.(full stop or period) for the Mac.

OK

The OK button updates the data you have entered, or confirms the selection and/or processes the function you have called.

Primary Supplier Code

Parts Master. Preferred supplier code (must be in SUPFILE). {PTMFILE.PTMSUPC char 6}

This is the preferred source for a purchased component. MRP uses the Primary Supplier in reports to facilitate purchasing administration. It can also be edited to any Purchase part relationship within the Purchase parts maintenance window. It may also be set as part of the Global Purchase Parts Performance Update process. There is a “System Manager” “System Preferences” flag that can be used to have the part primary supplier always reset to the supplier of the last receipt of the part.

Primary Supplier Name

Suppliers. Supplier company name. {SUPFILE.SUPNAME char 40}

Lead Time

Parts Master. Lead time in active (buy or make) days. {PTMFILE.PTMLEAD number 0dpShortnum}

The number of working days between ordering the Part and receiving it into stock. This should include all the time necessary to process the order and receipt on the system. Days are working days, that are active in the Buy or Make calendar. If the Part has a process route, the Lead time is calculated from the sum of the Operation Lead Times but it can also be edited in Parts master maintenance. For Parts that have no Process Route there are extensive facilities within the Global Changes for selective mass-changes of Part lead times. The facility auto-calculates lead time from process route times, works and/or purchase history.

Minimum Order Quantity

Parts Master. Re-order quantity. {PTMFILE.PTMREQT number 3dp}

This is the standard order quantity that MRP will suggest, rounded-up by the Lot Size. MRP may suggest more, if, at the time in question, the resultant stock quantity will be below the Re-Order Level. However, MRP will never suggest an order quantity of less then the Minimum Order Quantity. A Minimum Order Level of zero will result in MRP suggesting orders that exactly meet demand on a Just-In-Time basis. Within Product Costing (see later) the Minimum Order Quantity is used in the calculation of the component of cost attributable to Work Centre Setup Time. If the Minimum Order Quantity is less than 2 the Setup Time cost is applied in full to the Part cost.

Re-Order Level

Parts Master. Re-Order level. {PTMFILE.PTMROLE number 3dp}

The quantity below which MRP will recommend re-ordering. It is, in effect, a trigger quantity which will cause an order recommendation. As a consequence, MRP, given a sufficient period of forecasting and reasonable other planning values, will seek to finish the forecast period with the inventory quantity at the Re-Order Level. It is important to choose this value with care. Excessively high Re-Order Levels will have significant stock value implications. The Re-Order Level must be greater than or equal to the Minimum Stock Level. See the MRP Menu topic for a discussion on the significance of this planning value.

TIP: When operating on MRP recommendations, think of Re-Order Level as a Typical Stock Level.

Lot Size

Parts Master. Lot size when ordered. {PTMFILE.PTMLOT number 3dp}

The value entered here, if greater than zero, is used to round the recommended order quantity. When entering the quantity in a Work Order any Lot Size will be used to round the order quantity, unless, when you leave the quantity entry field, you hold the Option key down. For example, with a Minimum order quantity of 100 and a Lot Size of 25, MRP will recommend orders of either 100, 125, 150, 175, . . . , depending on demand.

Minimum Level

Parts Master. Minimum stock level. {PTMFILE.PTMMINS number 3dp}

The quantity of the Part that should always remain in stock at any time. MRP plans to receive stock from orders in sufficient time to prevent the predicted stock quantity falling below Minimum Stock. The Minimum Stock quantity must be less than, or equal to, the Re-Order Level. See the MRP Menu topic for a discussion on the significance of this planning value.

TIP: When operating on MRP recommendations, think of Minimum Stock as a Safety Stock Level.

Yield

Parts Master. Yield percent (default 100.00). If system preference MCDYIEU set Yield unit loss (default 0.00)). {PTMFILE.PTMYIEL number 2dpShortnum}

The units are either percent rate or units of loss which is controlled by the system preference MCDYIEU. See also the System Preferences window.

Yield as percent rate

Yield rate is a value in percent to 2 places of decimal that can optionally have an effect on costing and MRP recommended demand. It is the percentage of an ordered quantity that will be, on average, received into stock. It does not effect Purchase or Work Order processing in any way. The normal rate is 100.00% and with this rate it has no effect on costing or planning.

For a non-normal yield to have an effect on costing the appropriate System Preferences must be set.

For a purchased part, the cost of the part will be calculated as the actual cost divided by the yield rate. This has the effect of uplifting the cost and can be seen as taking into account losses in the transport, quality inspection or other receiving processes.

For parts with a BoM that are manufactured or outwork assemblies, the yield will similarly uplift the cost in assuming that only the yield rate of finished part will be subsequent useful inventory, even though the full kit quantity and process cost was consumed.

For a non-normal yield to have an effect on MRP Scheduling the appropriate setting must be set on the MRP Processing window.

MRP will use the Yield Rate of less than 100% to recommend ordering more of the part than is subsequently received into inventory. For a purchased item this is straight forward. For an item with a BoM, the ordered quantity of components will be assumed to be consumed.

WARNING: Care should be taken in the use of Yield Rates as they can accumulate excess quantities rapidly, especially where multiple sub-assemblies contain yield rates.

TIP: You can enter a Yield Rate greater than 100%. This will have the reverse effect to that described above, in both costing and MRP planning. However, this may be what you want.

Yield as units of loss per batch

Yield units of lost to 2 places of decimal that can optionally have an effect on costing and MRP recommended demand. It is the number of stock units that will be, on average, lost when a batch of any size is received into stock. It does not effect Purchase or Work Order processing in any way. The normal is 0.00 and with this value there is no effect on costing or planning.

For a non-normal yield to have an effect on costing the appropriate System Preferences must be set.

For a purchased part, the cost of the part will be calculated as the actual cost of a re-order quantity batch distributed across the re-order quantity less the number of yields loss units. This has the effect of uplifting the cost and can be seen as taking into account losses in the transport, quality inspection or other receiving processes.

For parts with a BoM that are manufactured or outwork assemblies, the yield will similarly uplift the cost in assuming that re-order quantity less yield loss units of finished part will be subsequently useful inventory, even though the full kit quantity and process cost was consumed.

For a non-normal yield to have an effect on MRP Scheduling the appropriate setting must be set on the MRP Processing window. For example, with yield units of loss set to 1, tea for 2 would be 3 cups, tea for 10 would be 11 and tea for 100 would be 101.

MRP will use the Yield loss of more than 0.00 to recommend ordering more of the part than is subsequently received into inventory. For a purchased item this is straight forward. For an item with a BoM, the ordered quantity of components will be assumed to be consumed.

TIP: Generally yield units of loss should never be greater than the re-order quantity. When processing in MRP, the maximum a yield loss can be is 1.00 less than the batch quantity.

WARNING: Care should be taken in the use of Yield as they can accumulate excess quantities rapidly, especially where multiple sub-assemblies contain yield rates.

TIP: You can set the default scraped quantity for a Work Order Backflush to be the yield loss with the option optWOBackYieldScrap. When this is set to 1, during the backflush of a WO the system defaults any yeild loss as scrapped so that the kit quantity accommodates yield. This is NOT suitable for MRP scheduled orders because MRP will schedule the yield into the WO quantity and therefore using this option will duplicate the yield losses.

Planning Alias Part Number

Parts Master. Planning Alias part number. {PTMFILE.PTMALIA char 18}

You can enter here another pre-defined Part number as an Alias for planning and forecasting purposes. You must enter the exact part number, not just the initial few characters. Planning Aliases are used in the program as follows:

1. When you enter a Sales Order line item quantity (with the appropriate “System Manager” “System Preferences” control checked), a review of inventory will be made for the Alias rather than the actual part, if one exists. This is particularly useful when the item being sold is not the inventory-critical item. For example, you may sell a custom tested and packaged assembly. The testing and packaging is customer specific and only carried out after receiving a confirmed Sales Order. However, the assembly is normally stocked, so this part is the one of interest at order time and therefore should be an Alias.
2. When you use the “Sales Order” “Part Available-to-Sell” analysis function, and you choose a part for analysis that has an Alias, the available-to-sell includes the availability of the Part and its Alias and any other demand from other parts that also have the same Alias. This enables you to review sales for a part that belongs to a family of similar parts. See Sales Orders for a more detailed explanation.
3. In “Production Plan” forecasting, you can generate a netted production plan for a forecast of sales. In a similar manner to 2 above, you can forecast for an Alias part (i.e. one that is called by several other parts as an Planning Alias). In this case, the direct demand, against which the forecast is compared, will be drawn from the Part, and all parts that have the part as an Alias. This enables you to forecast by product family, rather than specific product. See Production Plan for a more detailed explanation.

TIP: You can devise a part with a purely imaginary average BoM that describes a typical member of a product family. This can then be called up as an Alias by all the actual products in this family. If you then forecast on this average product, the whole process of planning becomes simplified and the need to be specific in the forecast about product or variant is removed. The down side is that the results of MRP may be less accurate than otherwise. Sales staff can view, with Available-to-Sell, the available production slots for the family that have not yet been committed to other customers.

Planning Alias Description

Parts Master. Planning Alias part number. {PTMFILE.PTMALIA char 18}

Byproduct Part Number

Parts Master. Byproduct part number. {PTMFILE.PTMSWAR char 18} – See below.

Byproduct Description

Parts Master. Byproduct part number. {PTMFILE.PTMSWAR char 18}

Shelf Life

Parts Master. Shelf life in days before expiry. {PTMFILE.PTMSHEL integer}

Stock Rotations

Parts Master. Stock rotation turns per year. {PTMFILE.PTMROTA number 3dp}

Purchase users

Parts Master. Comma separated list of user ids permitted to add this part to a purchase order. {PTMFILE.PTMPOUS char 1000}

NOTE: You can not edit this field unless you are an administrator. However, if you have access to Parts Global Changes you can change this field within that function.

TIP: Control can also be applied to purchasing non-part, work order and job operation items using the system options optPOJobOpUsers, optPONonPartUsers and optPOWoOpUsers.

Product Serial Numbering Options

Serial Numbers Required

Parts Master. Serial number required (sum of: 1=dispatch and job issue, 2=WO receipt, 4=WO kit issue, 8=Goods receipt). {PTMFILE.PTMSNO integer shortint}

You can control when the user is able to assign a serial number to a part. Check one or more options if the part is to be serial numbered on Goods Receipt, WO kit issue, WO receipt and/or Dispatch or Job issue. If the “System Preference” is set and the Dispatch or Job issue is checked, it will be mandatory for the part to be assigned serial numbers. See the topic Product Serial Numbering for details.

Tracking on dispatch

Parts Master. Create SN Tracking record on dispatch or job issue. {PTMFILE.PTMSNT boolean}

If set, a Serial Number Tracking record will be automatically created for each serial number assigned to the dispatch or job issue. It has no value if set when the Required on Dispatch and Job issue option is not set. See the Serial Number Tracking Maintenance window for details of serial number tracking.

Default SO items to be ignored in MRP demand

Parts Master. Default to ignore sales as demand in MRP. {PTMFILE.PTMSMRP boolean}

If set, the part will, by default, be marked on a Sales Order item to be ignored in MRP demand. This characteristic can then be changed in Sales Order line item maintenance. You can use this attribute to eliminate certain products or product groups from control by Materials Requirement Planning. However, you should bear in mind that if the part is an assembly, MRP will not schedule any requirements for it. The consequences of this must be understood in advance as they could be somewhat damaging to your supply situation.

For supplies of the part MRP will order PO Kits

Parts Master. When a component of a PO Kit, MRP will plan to purchase the parent kit. {PTMFILE.PTMPOKL boolean}

This attribute of a part is only useful when the part is a component in a BoM where the parent is a phantom type and has a purchase part record. If this attribute is then checked, any demand for the part will be assumed to be met from purchasing it’s parent kit. For the full implications to MRP see the Treatment of Purchase Order Kits section in the MRP Menu topic.

Single or Preferred Location

Parts Master. Stores single or preferred location. {PTMFILE.PTMSLOC char 8}

This is an optional field for providing a location code to define where the Part is stored. Kitting and dispatch Picking Lists are provided in Location sequence and many reports can be optionally sorted by Location. If the Multi-location flag is set, the data in Location will be the default for any multi-location created and it is then known as a Preferred Location. Otherwise it is a Single Location.

CUSTOM CAPABILITY: oCustom1.$PtmslocAfter() provides a hook that could be used to provide post-entry location code format or other verification. It also operates on all entry points for multi-locations.

Multi-Location

Parts Master. Multi stock location indicator. {PTMFILE.PTMMLOC boolean}

This is a flag that determines whether the part is permitted to have, and processed for, multiple stores locations. If checked, the part will be permitted to have multiple locations including quarantined locations. If, it is also Tracked, it will have to have these multiple location records to identify batch numbers. During processing, the system will assume that a Multi-location flagged part requires location selection for each inventory movement. See the Inventory section for more details.

NOTE: The System Preference “Do not auto-delete empty multi-stock locations”, if set, will prevent any deletion of multi-location records when they reach zero quantity, which is the normal situation. When you turn this preference OFF you will be given the option of deleting all zero (and negative) quantity location records.

Batch-Tracked

Parts Master. Tracked (this part traced with batch tracking). {PTMFILE.PTMTRAC boolean}

This is a flag that determines whether the part will be subject to batch tracking. If you check it, you will also force the part to have the Multi-location flag to be turned on. This, in effect, tells the system to record tracking information every time an inventory movement takes place. For full traceability all higher assemblies of a part need also to have their Batch-Tracked Flag turned on. You are left to set which parts you want tracked. See the Inventory section for more details.

NOTE: The System Preference “Part batch numbers generated as Year-Day-Serial” controls the style of batch numbers the system automatically assigns to receipts of batch tracked parts.

NOTE: If you set Batch Tracking on for an existing part with a positive physical quantity any existing stock locations without batch identifiers, will be automatically assigned batch identifiers. And, after this, if there is positive float stock, a location will be created for this with it’s own batch identifiers. Where these actions take place a comment is added to the stock location records.

On Assembly Kit Issue

Bulk Issue When Kitting

Parts Master. Bulk issue flag. {PTMFILE.PTMBULK boolean}

A flag that identifies, if checked, that this Part is never kitted to a Work Order. Bulk Issue Parts are only issued directly to production as a float of bulk unaccounted production stock. However, MRP does calculate demand for the Part. This enables manufactured parts to be Bulk Issue at a later stage in production. Care should be taken in placing orders for Bulk Issue parts on the basis of MRP recommendations as MRP has no knowledge of the stock being held in the production area. If this flag is un-checked, the Part is kitted to Work Orders. You have the option with Backflushed Work Orders to account for Bulk Issue parts (Take care not to account for them twice!).

Allow auto-selection of location

Parts Master. Allow auto-selection of location on kit issue. {PTMFILE.PTMASTO boolean}

During assembly kit issue this controls whether the system automatically assigns multi-locations for the component issues. If the part has no locations, auto-selection will not be possible. The system’s selection can be amended and must subsequently be confirmed by the user. See also the Assembly auto-selection preferred location prefix field. Auto selection only applies during Work Order kit issue functions.

Preferred Auto-Selection Location Prefix

Parts Master. Assembly auto-selection preferred location. {PTMFILE.PTMASLO char 8}

This value is only used by the system if the part is an assembly with some components which are multi-location and have the Allow auto-selection of location attribute set. When auto-selection takes place the process will only choose from those locations that start with the code characters entered here for the assembly part.

TIP: Assembly auto-selection preferred location prefix is provided particularly for cellular manufacturing operations where stock is distributed around the factory and generally used in particular working areas associated with the particular Work Order assembly part.

Draw from several locations

Parts Master. Draw from several locations (always No for tracked parts). {PTMFILE.PTMMSTO boolean}

For multi-location or tracked parts, this control determines whether you are able to draw any issue quantity from more than one location. If set, it enables you to split an issue between several locations. Tracking is maintained if the part is set for Batch-Tracking. The control only has a value when the part is also set for Multi-location and/or Batch Tracked. If it is also set for auto-selection the system will create split batches if appropriate.

TIP: If Draw from several locations is NOT set batch tracking will force only single batch issues which enforces lot-for-lot batch tracking.

Last Stocktake

Parts Master. Last stocktake freeze date. {PTMFILE.PTMSTTL date date1980}

Cycle Days

Parts Master. Stocktake cycle in days (set to zero for not cycled). {PTMFILE.PTMSTTD integer}

Physical Quantity

Parts Master. Inventory physical quantity. {PTMFILE.PTMPHYQ number 3dp}

Float Quantity

Float stock is the difference between physical stock and non-quarantined multi-location stock and should always be zero for tracked parts.

Quarantine Quantity

The total quantity of quarantined stock.

Multi-Location List

A list of all store locations for the part. Drag and drop to set preferred location. Double-click to view Non-Conformance Reports for part and/or batch.

Button

Action

Open Extended List

To view extended multi-stock information. It will open the Stock Location Listing window.

This button is only available if you have checked the Maintain multi-stock locations extended information in the File — System Manager System Preferences window.

Current Costs

Both Current and Standard Part costs are recorded within the system for each part in five elements (actually 6 if you include this-level). Current Costs for assemblies can be calculated for an individual part with the Update Costs button option in Parts, BoM or Process Route maintenance or the “Log WO Performance” function. In the “Product Costing” you can “Roll-up current costs” for a range of parts. Costs can be entered in the Parts master window but will be overridden during automatic updating unless flagged (see later).

Standard Costs

Standard Costs are held in Material, Labour, Outwork, Overhead, Receiving Overhead and This-level fields. Standard Costs are taken from the Current Cost fields during the “Roll-Over Current-to-Standard Costs” routine within the Product Costing functions (see later), typically at a financial year-end. Costs can be entered in the Parts master maintenance window but will be overridden during Roll-Over. A column of Variance to Standard Costs is provided for review purposes. This is calculated as follows: (Cur. Cost – Std. Cost) divided by Std. Cost, expressed as a percent. If there is no standard cost, the variance will be zero.

Current Material Cost

Parts Master. Current material cost. {PTMFILE.PTMCMC number 3dp}

Material cost is the purchase cost of a purchased Part (calculated from purchase history), or the accumulated purchased costs of components that make up an assembly down to the lowest level.

Standard Material Cost

Parts Master. Standard material cost. {PTMFILE.PTMSMC number 3dp}

Variance on Standard

The % variance between the current cost and standard costs for the part.

Current Labour Cost

Parts Master. Current labour cost. {PTMFILE.PTMCLC number 3dp}

Labour cost is the accumulated Labour costs of an assembly and any sub-assemblies calculated from their Process Routes and Work Centres.

Standard Labour Cost

Parts Master. Standard labour cost. {PTMFILE.PTMSLC number 3dp}

Variance on Standard

The actual mark-up that the selling price represents to the total standard cost for the part.

Current Outwork Cost

Parts Master. Current outwork cost. {PTMFILE.PTMCOC number 3dp}

Outwork cost is the accumulated Outwork costs of an assembly and any sub-assemblies. That is, the charges made by a supplier for both Outwork Assemblies and for any process route Outwork Operations.

Standard Outwork Cost

Parts Master. Standard outwork cost. {PTMFILE.PTMSOC number 3dp}

Variance on Standard

The actual mark-up that the selling price represents to the total standard cost for the part.

Current This-Level Outwork

Parts Master. Current this-level outwork cost. {PTMFILE.PTMCTOC number 3dp}

Current Receiving Overhead Cost

Parts Master. Current receiving overhead cost. {PTMFILE.PTMCROC number 3dp}

Receiving Overhead cost is either a Goods (PO) receiving overhead (burden) charge or a Work Order receiving (completion) overhead charge, depending on whether the part is subject to purchase or manufacture through a WO. In the case of a purchased part, the amount is calculated from the Goods received overhead rate (set in the “System Manager” “Company Details”) times the cost. In the case of an assembly, the amount is calculated from the WO received overhead rate times the “This-level cost” of the assembly (it is not applied to rolled-up sub-assembly costs). The receiving overhead is rolled up into the material cost element of any higher assemblies. In either case the default receiving rate can be overridden by the an Individual Overhead Rate (see below).

Standard Receiving Overhead Cost

Parts Master. Standard receiving overhead cost. {PTMFILE.PTMSROC number 3dp}

Variance on Standard

The actual mark-up that the selling price represents to the total standard cost for the part.

Individual Receiving Overhead Rate

Parts Master. Individual receiving overhead percent rate (if zero default is applied, if -ve no rate is applied). {PTMFILE.PTMROVR number 2dpShortnum}

If a part’s individual receiving overhead rate is zero then when cost updates are performed the “System Manager” “Company Details” default receiving overhead rates (MCDPOOV and MCDWOOV) will apply. If this individual rate is set negative, a receiving rate of zero will be applied. If the rate is positive, that rate will apply when calculating receiving overhead, regardless of the system manager defaults.

TIP: You can also apply the optPartIndivOheadValue system option. If set to 1, part individual overhead will be a value rather than a percent rate. If zero the system default rate will apply. With this option set you can apply a fixed value overhead to some parts (by setting them greater than zero), zero overhead to others (by setting them less than zero), and apply the default overhead rate to the other (by setting them zero).

Current Work Centre Overhead Cost

Parts Master. Current overhead (burden) cost. {PTMFILE.PTMCOVC number 3dp}

Labour Overhead cost is the accumulated Overhead costs of an assembly and any sub-assemblies calculated from their Process Routes and Work Centre Overhead rates.

Standard Work Centre Overhead Cost

Parts Master. Standard overhead (burden) cost. {PTMFILE.PTMSOVC number 3dp}

Variance on Standard

The actual mark-up that the selling price represents to the total standard cost for the part.

Total Current Costs

The total current cost for the part, being the sum of the constituent components of current cost.

Total Standard Costs

The total standard cost for the part, being made up from the sum of the constituent standard costs.

Variance on Standard

The % variance between the current cost total and the standard cost total for the part.

Current This-Level Cost

Parts Master. Current this-level cost. {PTMFILE.PTMCTLC number 3dp}

This-level cost is the sum of the Labour, Overhead and Outwork costs incurred in making the assembly plus the material cost of purchased items in the part’s immediate (single-level) BoM. It excludes all accumulated costs of sub-assemblies. This represents the added cost in making the assembly over the cost of its sub-assemblies. It is always the same as the Total cost for purchased parts and assemblies containing no sub-assemblies. It is used in ABC Analysis and to calculate receiving overheads.

Standard This-Level Cost

Parts Master. Standard this-level cost. {PTMFILE.PTMSTLC number 3dp}

Variance on Standard

The actual mark-up that the selling price represents to the total standard cost for the part.

Prohibit auto-cost-update

Parts Master. Cost update prohibited. {PTMFILE.PTMNOCO boolean}

This flag, if set, will prevent any Current Cost update taking place for the part during Product Costing functions. See the Product Costing window for more details.

NOTE: Normally, part current costs are updated if you have the Update part current cost when Purchase Order prices are confirmed File — System Manager — System Preference is set. This is true even when the Part Prohibit auto-cost-update control is on. However, there is a system-level option that can extend this control. If the option optPartCostNoUpdate is set to 1, when a part has the Prohibit auto-cost-update control on, part costs are not updated during Confirm PO Prices or Invoice Verification.

Update Costs

To carry out a single-level roll-up cost analysis for the part. The cost analysis is based upon the current BoM and Process Route with the current Work Centre rates applying. It opens the Part Costs Update window.

Show Costs Log

To view the current costs log (if the system preference makes it available). It opens the Part Costs History Log Listing window.

Sales Unit of Measure

Parts Master. Sales unit of measure. {PTMFILE.PTMSAUM char 6}

This is a unit of measure descriptive field that represents a default alternative Sales Order unit of measure in which the Part is sold. E.G. “Pk 100”, “Box 5” (Box of 5), etc. The default is the Stock UoM. Sales UoM only occur physically when dispatched to a customer, never in the stores or in the production environment.

Actual Gross Markup or Margin – Current Cost

The actual mark-up that the selling price represents above the current cost.

The Selling price mark-up or gross margin (depending on system preference) is shown for Current Cost and Standard Cost. Mark-up is expressed as the percent of Cost over the Cost that the Selling price has been set at. The Selling Mark-up is calculated as (Selling price-Cost) divided by Cost, expressed as a percent. If you are using Gross Margin, the calculation is (Sales Price – Cost) divided Sales Price. See the Product Costing window for more details.

Actual Gross Markup or Margin – Standard Cost

The actual mark-up that the selling price represents to the total standard cost for the part.

Sales UoM Multiplier

Parts Master. Sales order Unit of Measure Multiplier. {PTMFILE.PTMMULTI number 4dp}

A multiplier that when applied to the Stock UoM yields the Sales UoM for the Part. Up to 4 decimal places are provided. For example if the Stock UoM is “Each” and the Sales UoM is “Pk 100” then 100.0000 must be entered in the Conversion Multiplier. The default is 1.0000. If the Stock UoM is identical to the Sales UoM the multiplier is forced to 1.0000.

Auto Gross Margin or Markup

Parts Master. Margin of sales price over cost price. {PTMFILE.PTMARGN number 0dpShortnum}

This field can be used to automatically generate the Selling Price by applying the percent mark-up or gross margin to either the Total Current or Standard Cost for the Part. This is done during the “Generate selling price” routine run from the Product Costing feature (see later). You have a “System Preferences” choice of Mark-up or Gross Margin. For Mark-up, the routine makes the Selling Price = Total Cost * (100 + Auto price mark-up) / 100. For Gross Margin, the routine makes the Selling Price = Total Cost * 100 divided by (100 – Gross Margin) where Gross margin can not be greater than 99%. In Product Costing functions the standard cost is used, while the Update Costs function uses current costs.

Selling Price

Parts Master. Selling price. {PTMFILE.PTMSELL number 2dp}

The Part selling price and customer-specific discounts can, by default, be applied on a Sales Order. The Selling Price value can be entered on the maintenance window or it can be automatically generated from the Standard Cost and the Automatic cost to selling price mark-up or gross margin. This is achieved within the Product Costing feature. See the Product Costing window for more details.

CUSTOM CAPABILITY: It is possible to customise the system to show unit prices to 3 or more decimal places rather than the standard of 2. The process is complex and involves a number of customisation activities.

1. Firstly, you must set the option optSOPrices3Decimals to 1 or more. See Program Options Listing window for details.
2. Within OpenVision you need to change the following table columns to 3dp numbers in the Schema classes:
   scCPTFILE: CPTPR01, CPTPR02, CPTPR03, CPTPR04
   scPTMFILE: PTMSELL, PTMCUX1, PTMCUX2, PTMCUX3, PTMCUX4, PTMCUX5, PTMQPD2, PTMQPD3, PTMQPD4
   scSAHFILE: SAHPSUM
   scSOLFILE: SOLPRIC
3. Copy the classes from OpenVision into Caliach Vision:
   scCPTFILE, scPTMFILE, scSAHFILE, scSOLFILE

WARNING: When upgrading from one Caliach Vision version to another you MUST reset the new version of Caliach Vision with the Schema Class changes BEFORE launching the new version of the program and syncronising the database. Otherwise the 3rd decimal of stored prices will be lost in the existing database.

Selling Price in Sales Units

The selling price of the selling unit of measure of the part.

Commission class

Parts Master. Commission class (for choice of commission agent applicability on Job and SO part items). {PTMFILE.PTMCOML char 1} See the Commissioned Sales Agents Maintenance window for full details of the commission handling system.

WARNING: If a blank commission class is applied, no commission agents will be filtered onto sales order, job and invoice lines.

Discount Class

Parts Master. Discount class. {PTMFILE.PTMDISC integer shortint}

A number from 0 to 20 that defines one of the 21 levels of discount that is, by default, applied to this Part when entered at a Sales Order line item. The description for each of the 20 non-zero classes is maintained in the File — System Manager Company Details Maintenance window Descriptions tab pane. Each customer is assigned a percent discount for each class from 1 to 20. When a Sales Order is prepared for a Part the customer discount rate is applied for the class appropriate to the Part ordered. A 0 class always applies a zero discount rate for the part.

Discount Class Descriptor

The discount class descriptor, as set in the manager company details.

Tax Class

Parts Master. Sales tax class. {PTMFILE.PTMTAXC char 1}

See the Tax Maintenance window for full details of the tax handling system.

Prohibit auto-price-update

Parts Master. Price update prohibited. {PTMFILE.PTMNOPR boolean}

This flag, if set will prevent any Sales Price changes taking place during Product Costing functions. See the Product Costing window for more details.

Quantity and Promotional Pricing

Quantity price rather than additional discount

Parts Master. Quantity Price rather than additional discount. {PTMFILE.PTMQPRI boolean}

You can supplement the normal sales price and customer discount structure with quantity-based additional discounts or prices. This flag controls whether the quantity supplement is a discount or a substitute price. If you check this option, the value you enter for the quantity prices will be applied to SO line items for this part. Otherwise, any values entered will be applied as additional discount rates for the part.

WARNING: If prices apply and the Sales Order is for a foreign currency for which you have a currency price any quantity prices will be ignored. An additional quantity discount structure will apply in all currency conditions on Sales Orders.

Quantity per order rather than line item

Parts Master. Quantity prices per sales order rather than order line item. {PTMFILE.PTMQPPO boolean}

Promotional based on dates rather than quantities

Parts Master. Promotional prices or additional discounts based on dates rather than quantities. {PTMFILE.PTMPDAT boolean}

Promotional pricing or additional discounts are applied when a sales order or job item is entered for dispatch or issue within a date range. The dates are inclusive. If there is no start date then the end date is a limit for the price or additional discount. If there is no end date, the price or additional discount applies from the start date thereafter. If there are no dates for the price or additional discount it will never apply. If two or more date ranges overlap, the lowest price or greatest additional discount will be applied. Customer Parts have similar controls that override part settings.

WARNING: If the checkbox control is not set, any date ranges will be completely ignored.

2nd Price Start Quantity

Parts Master. 2nd price start quantity in Stock UoM. {PTMFILE.PTMQT02 number 3dp}

Use these three fields to designate the quantities at, and above, which quantity discounts or prices will apply. The normal selling price applies for all quantities below the first start quantity, etc.. All quantities entered must be progressive. i.e. the next quantity must be greater. You can terminate the extent of quantity pricing by zeroing the quantity values above which they are applicable.

2nd Quantity Additional Discount or Price

Parts Master. 2nd quantity additional discount or price. {PTMFILE.PTMQPD2 number 2dp}

These fields are available to enter additional discounts or prices applicable for the quantities specified, depending on the Apply price rather than additional discount rate option chosen. Prices must be entered for all start quantities that are non-zero. Prices are entered in normal currency and for a stock units of measure.

TIP: In Masters — Global Changes — Parts you can mass change 1 or more parts to prices based on a percentage reduction of the base selling price for each quantity break.

3rd Price Start Quantity

Parts Master. 3rd price start quantity in Stock UoM. {PTMFILE.PTMQT03 number 3dp}

3rd Quantity Additional Discount or Price

Parts Master. 3rd quantity additional discount or price. {PTMFILE.PTMQPD3 number 2dp}

4th Price Start Quantity

Parts Master. 4th price start quantity in Stock UoM. {PTMFILE.PTMQT04 number 3dp}

4th Quantity Additional Discount or Price

Parts Master. 4th quantity additional discount or price. {PTMFILE.PTMQPD4 number 2dp}

Start date 1st

Parts Master. Promotional price 1 start date. {PTMFILE.PTMPD1S date date1980}

End date 1st

Parts Master. Promotional price 1 end date. {PTMFILE.PTMPD1E date date1980}

Start date 2nd

Parts Master. Promotional price 2 start date. {PTMFILE.PTMPD2S date date1980}

End date 2nd

Parts Master. Promotional price 2 end date. {PTMFILE.PTMPD2E date date1980}

Start date 3rd

Parts Master. Promotional price 3 start date. {PTMFILE.PTMPD3S date date1980}

End date 3rd

Parts Master. Promotional price 3 end date. {PTMFILE.PTMPD3E date date1980}

Currency Prices and Rate

Sales Currency 1 Price

Parts Master. Sales Price in currency 1. {PTMFILE.PTMCUX1 number 2dp}

TIP: In Masters — Global Changes — Parts you can mass change 1 or more parts to currency prices based an entered exchange rate applied to the base selling price.

Sales Currency 2 Price

Parts Master. Sales Price in currency 2. {PTMFILE.PTMCUX2 number 2dp}

Sales Currency 3 Price

Parts Master. Sales Price in currency 3. {PTMFILE.PTMCUX3 number 2dp}

Sales Currency 4 Price

Parts Master. Sales Price in currency 4. {PTMFILE.PTMCUX4 number 2dp}

Sales Currency 5 Price

Parts Master. Sales Price in currency 5. {PTMFILE.PTMCUX5 number 2dp}

Currency 1 Rate

The calculated exchange rate of the Currency Price to the current local currency Sales Price.

Currency 2 Rate

The calculated exchange rate of the Currency Price to the current local currency Sales Price.

Currency 3 Rate

The calculated exchange rate of the Currency Price to the current local currency Sales Price.

Currency 4 Rate

The calculated exchange rate of the Currency Price to the current local currency Sales Price.

Currency 5 Rate

The calculated exchange rate of the Currency Price to the current local currency Sales Price.

A: Local currency
No part quantity prices

Part’s selling price

Customer discount for the part’s discount type

B: Foreign currency
No currency price
No part quantity prices

Part’s selling price times the Sales Order currency exchange rate

As A above

C: Foreign currency
Currency price
No part quantity prices

Part’s currency selling price

As A above

D: Local currency
Quantity additional discounts

Part’s selling price

Customer discount for the part’s discount type plus the part additional discount for the item stock UoM quantity or the promotional dispatch date

E: Foreign currency
No currency price
Quantity additional discounts

Part’s selling price times the Sales Order currency exchange rate

As D above

F: Foreign currency
Currency price
Quantity additional discounts

Part’s currency selling price

As D above

G: Local currency
Part quantity prices

Part’s price for the item stock UoM quantity or the promotional dispatch date

Customer discount for the part’s discount type

H: Foreign currency
No currency price
Part quantity prices

Part’s price for the item stock UoM quantity times the Sales Order currency exchange rate

As G above

I: Foreign currency
Currency price
Part quantity prices

Part’s currency selling price ignoring any quantity prices

As G above

J: SO in local currency
Additional discounts in Cust.-Part record

Part’s selling price

Customer discount for the part’s discount type plus the Cust.-Part additional discount for the item stock UoM quantity or the promotional dispatch date

K: SO in foreign currency
No part record currency price
Additional discounts in Cust.-Part record

Part’s selling price times the Sales Order currency exchange rate

As J above

L: SO in foreign currency
Part record currency price
Additional discounts in Cust.-Part record

Part’s currency selling price

As J above

M: SO equals Cust.-Part currency
Quantity prices in Cust.-Part record

Cust.-Part selling price in SO currency for the item stock UoM quantity or the promotional dispatch date

Customer discount for the part’s discount type

N: SO NOT equals Cust.-Part currency
Quantity prices in Cust.-Part record
(only descriptive data from Cust.-Part record applies)

As A to I above

As A to I above

Sales G/L Account Code

Parts Master. Sales G/L account code. {PTMFILE.PTMACCO char 10}

This field is provided for integration with the Ledgers option of Caliach Vision. It can be used for grouping parts for Stock Valuation purposes. If the application is not licensed with the Ledgers option, any 10 character code can be entered. If the Ledgers menu is installed, only valid sales type General Ledger accounts can be entered in this field. If you hold the shift key down when passing out of the account code box, the system will accept a non-Sales type G/L account, otherwise only a ‘S’ type account will be permitted. A Sales Order line item will be given this code by default.

Purchase G/L Account Code

Parts Master. Purchase G/L account code. {PTMFILE.PTMPACO char 10}

This field is provided for integration with the Ledgers option of Caliach Vision and as a means of grouping stock and purchase items. If the application is not licensed with the Ledgers option, any 10 character code can be entered. If the Ledgers menu is installed, only valid purchase type General Ledger accounts can be entered in this field. It is useful for Supplier Invoice Verification and subsequent account postings. A Purchase Order line item will be given this code by default.

Current Issue

Parts Master. Engineering issue reference. {PTMFILE.PTMISSU char 4}

This field enables you to apply to the part an Engineering Issue reference of up to three upper or lower case characters. It can be used to help control engineering change. When a part is used in the following, the parts master Issue is stored in the record by default (but usually can be changed):

• a Bill of Material component,
• a Job line item,
• a Product Serial Number record,
• a Purchase Order line item,
• a Work Order assembly.

The following history also stores the relevant Issue that applied when the history record was created:

• Job item, as it was when the item was completed,
• Purchase History, from the PO item on receipt,
• Sales History, from the parts master when dispatched,
• Work History, from the WO when the history was created.

The “Update Issue…” function on the “Parts” menu enables you to review and update references to the part to which the Issue is relevant. See the Update Part Issue and References window for details.

Engineering Warning – Change in-progress

Parts Master. Engineering Change in progress flag. {PTMFILE.PTMENGC boolean}

If set, users will be warned that the part is subject to an engineering change when they attempt to use it on a Sales, Purchase or Work Order. The warning message shows any Engineering Notes.

BoM User

Parts Master. BoM assembly maintenance user. {PTMFILE.PTMBOMU char 3}

You can use this field on a BoM parent part to designate a specific individual’s ownership of assembly maintenance. Enter the designated user’s Transaction I.D.. Leaving the field blank will mean that any user with Security Settings permitting them to maintain BoMs will be able to do so. Having confirmed a specific user as the BoM user, no other user will be able to change that designation on the assembly part record. There is a safety exception to this rule, however. If you have Administrator privileges in the security settings, you can amend any BoM user.

Commodity Code

Parts Master. Commodity code. {PTMFILE.PTMCOMC char 12}

This field can contain up to 12 characters of any type. It can be used for any coding purposes and is available for report/function parts selection and sort. It has particular significance if you are wanting to use the “Sales History” or “Purchase History” “Trade Statistics” analysis feature. In this case you should apply your Customs export/import classification codes.

Country button

Commodity Codes can can vary depending on international trade agreements. For example, the US requires one set of commodity codes for customs, whereas the EU requires a different set. If you need to use country group commodity codes, you must designate each country with a group code in the Country Maintenance window. This button opens the Country Group Commodity Codes window which allows you to maintain non-standard commodity codes for country groups.

Supplementary Units

Parts Master. Supplementary units flag. {PTMFILE.PTMSPLU boolean}

A special yes/no flag (S.U.) used exclusively for “Trade Statistics” reports. If set, the report applies dispatch quantity rather than mass to the report.

Mass

Parts Master. Mass weight for the part. {PTMFILE.PTMMASS number 3dp}

The mass, or weight, of the part. The units of mass you want to use, that will apply throughout the system, is set in the “System Manager” “Company Details” section, normally, “Kgs.” or “Lbs.”. The mass has a resolution of 3 decimal places. You should enter here the mass of a stock unit of measure of purchased parts and raw materials (lowest level BoM items). The Roll-up button is used to have the program calculate the mass of assemblies (see later). Mass is used in “Sales Orders” to indicate the total weight of a SO. It is also used in “Trade Statistics” analysis for purchases and sales history.

Incidentally, for those not scientifically pedantic, Mass is a fundamental measure of the solidity of an object. Weight is the effect of an object’s mass under the influence of earth’s gravity, which can, of course, vary. Mass is also a shorter word!

Mass Units

Company and System Settings. Mass units for window/report display. {MCDFILE.MCDMASU char 4}

Specific Gravity

Parts Master. Specific Gravity. {PTMFILE.PTMSG number 3dp}

Specific Gravity value for the part. This is useful for chemical products, however it is not used explicitly within the system so can be used for any value that is needed in custom reports or documents.

BoM Lowest Level

Parts Master. Lowest level number within the BoM. {PTMFILE.PTMLLNO number 0dpShortnum}

This is a system-generated number that indicates the lowest level that the Part exists in the Bills of material structures. If 0 then the Part never exists as a component to an assembly. On the maintenance window, this field is for review only. The automatic calculation of this number can be switched off in File — System Manager — System Preferences but that leads to restrictions. File — Advanced — Reset Data Files Re-organise Bills of Material function is used to re-calculate BoM Lowest Level Numbers.

Notes

Parts Master. Engineering issue notes. {PTMFILE.PTMNOTE char 10000000}

A long text field that is primarily designed for notes relating to Issue history. It can contain any text up to 10,000,000 characters. There are only two places where Notes are used in the system: They are included in the Parts Engineering report. And, in building a ScratchPad list, you can search for all parts containing a text string in the Notes field.

Quality assurance tested

Parts Master. Quality assurance tested (requires entries in QA system). {PTMFILE.PTMQATS boolean}

Quality Assurance Default Comments

Parts Master. Quality assurance test default comments std. engineering text code. {PTMFILE.PTMQACO char 4}

Variant master assembly or component

Parts Master. Variant master assembly or component. {PTMFILE.PTMVART boolean}

Extra Unit of Measure

Parts Master. Extra unit of measurement. {PTMFILE.PTMXUOM char 6}

Mass Roll-Up

All Parts

If unchecked only the selected part will have its mass calculated. If checked all parts will be calculated.

Multi-Level

Only relevant for a single part roll-up. If checked, the mass will be calculated from the lowest level of the BoM structure. Otherwise, the parts immediate BoM is used.

Roll-up

Click to calculate the Mass from the Bill of Material and Process Route of this or all parts.

The parts master mass of components is added to the Mass-Change of each Process Route operation. Operation mass-change can be either positive, adds mass, or negative, removes it from the sum of the component kit’s mass. The Roll-up button is only active if you have privileges to use the “Update” function on the “Parts” menu.

When you click on the Roll-up button you will be given the choice of rolling-up the currently selected part, or all parts in the system that have components in the BoM file.

WARNING: Role-up All Parts uses the BoM Lowest Level Number to calculate the lowest assemblies first. This function will not operate if the “BoM Lowest Level Numbers automatically adjusted” control is NOT checked in the “System Manager” “System Preferences”. To get it checked, you must run the “System Manager” “Re-set Data Files” Re-organize BoM file function.

If you choose only to roll-up for the currently selected part, you will be offered a further option to either roll up multi-level or just for the immediate single-level.

With a multi-level roll-up, the entire BoM structure below the currently selected part is analysed. However, unlike the All Parts option earlier, the results for each lower assembly are not saved. At the end of the analysis, and if the calculated mass differs from the currently stored mass for the selected part, you will be offered the opportunity to change it.

Country

Click to open the Country Group Commodity Codes window. You must have designated countries with a group code in the Country Maintenance window.

QA Tests

Click to open the Quality Assurance testing regime for the part.

View Engineering Data

Click to directly launch engineering data maintenance for the selected part.

Sales Individual Text

Parts Master. Special sales text. {PTMFILE.PTMSATX char 10000000}

Sales Standard Text Code

Parts Master. Sales std. text code. {PTMFILE.PTMTXS char 4}

Show

Click this button to display a list of alternatives for the field alongside the button. Double-clicking on a list line will enter the value from the list.

Sales Standard Text

Standard Texts (E,P,S,W). Text. {TXTFILE.TXTTEXT char 10000000}

Text List

A list of all available Sales standard texts. Double-click on a text line to assign this text for the part.

Purchase Individual Text

Parts Master. Special purchase text. {PTMFILE.PTMPUTX char 10000000}

Purchase Standard Text Code

Parts Master. Purchasing std. text code. {PTMFILE.PTMTXP char 4}

Show

Click this button to display a list of alternatives for the field alongside the button. Double-clicking on a list line will enter the value from the list.

Purchase Standard Text

Standard Texts (E,P,S,W). Text. {TXTFILE.TXTTEXT char 10000000}

Text List

A list of all available Purchase standard texts. Double-click on a text line to assign this text for the part.

Works Individual Text

Parts Master. Special works text. {PTMFILE.PTMWOTX char 10000000}

Works Standard Text Code

Parts Master. Works std. text code. {PTMFILE.PTMTXW char 4}

Show

Click this button to display a list of alternatives for the field alongside the button. Double-clicking on a list line will enter the value from the list.

Works Standard Text

Standard Texts (E,P,S,W). Text. {TXTFILE.TXTTEXT char 10000000}

Text List

A list of all available Works standard texts. Double-click on a text line to assign this text for the part.

User Defined Fields

These fields are available for any use you wish to put them. They are not used or reported by the system and are provided for use with custom searches or reports or Ad Hoc reports. There are 4 character fields that are limited to 1, 4, 18, and 30 characters respectively. These fields can be set in Global Changes. The field descriptions are set in File — System Manager — Company Details Maintenance window Descriptions tab pane.

TIP: You can selectively get the system to inherit part record user defined field data onto Work Orders. This is done by setting the following system option:

• optWOInheritsUserFields

The option value is set to 1234, or any combination of those numbers. It will cause those WO user defined fields to be inherited from the assembly part fields.

User 1

Parts Master. User character field 1 (single character). {PTMFILE.PTMUSE1 char 1}

User 2

Parts Master. User character field 2 (4 characters). {PTMFILE.PTMUSE2 char 4}

User 3

Parts Master. User character field 3 (18 characters). {PTMFILE.PTMUSE3 char 18}

User 4

Parts Master. User character field 4 (30 characters). {PTMFILE.PTMUSE4 char 30}

TIP: There is a system level option optCommissionRoyalty that, if set to 1, when applying agents on a SO, Job or Invoice, agents entered in the User character field 4 (PTMUSE4) parts field are added to the agent list. This provides for circumstances where you want to use the commission system to account for royalties that need to be applied for parts regardless of commission class or customer agents.

Export or Import Part

Opens the PartMaster and Related Export and Import window in which you can export a part and it’s related master records or import from an export file from another datafile.

• Parts Usage
• Parts Current Quantity