Part Maintenance

Part Maintenance - Characteristics pane

The Parts master is the name given to the file that contains all the information that is unique to a specific Part in the system. To enter the Parts master maintenance window select a Parts hierarchical menu function in the Masters main menu.

This is a tab pane type window in which all part fields that can be entered or amended. The Parts menu is installed on the menu bar whenever the maintenance window is on top of others and provides all functions. The maintenance window has Revert to Saved and Save as Shown buttons and OK and Cancel buttons provided to confirm a Find.

Button

Action

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.

The window has 9 tab panes.

Characteristics  Planning  Storage  Costs  Selling  Ledgers  Engineering  Texts  Others 

Characteristics

Field

Description

Part Number

Parts Master. Part number unique identifier. {PTMFILE.PTMPTNO char 18}

A unique upper-case alpha-numeric identifier for each Part up to 18 characters long. The Part number, once created cannot be changed except using the Change a Part Number Throughout the System or Change Part Number Characters Throughout the System windows. You cannot use a part number which starts with "JO-" or "WO-" character strings as these are used to identify respectively Job and Work Order outwork operations on Purchase Orders.

Tip TIP: When disabled, double-click on in the field to initiate a Find.

Customisation CUSTOM CAPABILITY: oCustom1.$NewPartRecordInit(), oCustom1.$NewPartRecord() and oCustom1.$NewPartRecordSave() provide hooks for you to build custom methods to change or verify the way Part Numbers and other values are set by users. For instance, a method could be written to prevent the user creating a part record without entering data in particular fields.

Customisation CUSTOM CAPABILITY: oCustom1.$PartNoAfter() provides a hook that could be used to provide part number format verification. After data entry, the procedure would check for a valid format and report deviations and prevent further progress until rectified.

Tip TIP: As so many listings of parts are alphanumeric by part number, it is strongly recommended that you develop a part number system that contains a level of intelligence to the number. This will then help as like parts will be grouped together on lists and reports and using a search restriction by part number will be useful. However, there are some definite does and don'ts when developing a part number system in an integrated environment.

DO: Have only limited grouping prefixes and don't try to be too specific as this can tend to lead to errors in grouping after a while,

DO: Have a fixed number of numeric sequence characters after the grouping prefix (e.g. AHD00080 rather than ADH80). Part numbers are character sorted so always pack numbers with zero characters (watch you don't use the letter 'O'!). "AHD00220" will sort ahead of "AHD080".

TRY: To have a fixed length for both grouping prefix and overall number as this will make reading down columns of part numbers easier.

DO: Group parts with a prefix by what the parts physically are, e.g. Screw, Special Bolt or Transistor.

NEVER: Have any grouping or number reference based on where the part is used on products or higher assemblies, as the BoM structure determines this. You should also avoid building in a supplier or customer into the number. Also, when you add another product to your production (as you inevitably will) which also uses this part, serious confusion will arise. Duplication of the same part usually occurs which leads to gross inefficiency. For example: Screw for 80Mb drive, Special Bolt for Model 24 crane, 60W PSU Transistor.

DON'T: Make part numbers excessively long - it can lead to a good deal of unnecessary typing over the years!

DON'T: Excessively use delimiter marks to separate segments of the part number, such as '-', '/', '.', etc.. It adds to typing and can cause problems if you export parts data to spreadsheets. This also applies to all figure numbers where you have leading zeros.

REMEMBER: You, and all your current and future colleagues, will have to live with your part numbering system indefinitely. Take great care, and involve others, in setting your policy. Once you have set it, stick to it like a limpet!

Description

Parts Master. Part description. {PTMFILE.PTMDESC char 30}

A mandatory 30 character basic description of the Part. This description is the base concise description used throughout the system and needs to be limited so that lists and reports can have useful column space for other data. Additional descriptive text can be entered for use selectively on Order documents (see the Texts pane).

Tip TIP: You should, if possible, adopt standards for the order in which you enter descriptive items of text here because in some reports it is necessary to truncate the description. For example, if you have a group of items and intelligent part numbering, say all Screws, don't start the description with "Screw..." start it with the specifically distinguishing characteristics. "100lg x 2p x M24 Screw". If your part numbering system does not group parts, then this technique is less important. REMEMBER, you cannot search for parts using description or sort them on descriptions in lists or reports, except with Ad Hoc Reports and Keyword Search.

Tip TIP: You can select parts for the ScratchPad based on a text string occurring in the part Description. There is an option to ignore the case of the text. See the Parts ScratchPad Selection window.

Stock Unit of Measure

Parts Master. Standard stock unit of measure. {PTMFILE.PTMSTUM char 6}

This is a unit of measure descriptive field that represents the standard stock unit for the Part. E.G. "Each", "Metre", "Foot", etc.. For a new part, the default is the Stock UoM default entered in the "System Manager" "Company details". Alternative units can be assigned for sales and purchasing. Great care should be taken if you want to change the Stock UoM quantity significance, especially if the part is a BoM Component. See Change All Component Quantities by a Factor window for details of a (rather dangerous) utility function that can help if you do want to do this.

Index Code 1

Parts Master. Index 1 code. {PTMFILE.PTMP1CD char 4}

A mandatory code assigned to the Part that can be used throughout the system to select or sort Parts. For example, it can be used to group Parts into classes such as switches, relays, pcb's, etc.. Index Codes must be pre-defined in the Index and Other Code Maintenance window before being assigned to a Part. A Show button can be used to obtain a list of currently defined codes. When editing a part, double-clicking on a list line will load the code selected.

Index 1 Description

Index and Other Codes. Index code, scrap reason or QA test description (must have at least 1 character). {IDXFILE.IDXDESC char 255}

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.

Index Code 1 List

Lists all available part index 1 codes. Double-click on a code line to select that code for this part.

Index Code 2

Parts Master. Index 2 code. {PTMFILE.PTMP2CD char 4}

Another mandatory code assigned to the Part that can be used throughout the system to select or sort Parts by. It is similar in characteristics to Part Index code 1, although independent from it. A Show button can be used to obtain a list of currently defined codes. When editing a part, double-clicking on a list line will load the code selected.

Index 2 Description

Index and Other Codes. Index code, scrap reason or QA test description (must have at least 1 character). {IDXFILE.IDXDESC char 255}

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.

Index Code 2 List

Lists all available part index 2 codes. Double-click on a code line to select this code for the part.

ABC Class

Parts Master. ABC classification. {PTMFILE.PTMABC char 1}

When Materials Requirement Planning calculates the demand for manufactured or purchased Parts, it can optionally assign a classification to each Part to identify its significance to the business. This significance is determined by the total turnover in value of Parts within MRP identified demand. This-Level Current Cost value is used for ABC calculations, which enables the ABC Analysis to relate to added value of assemblies which is more useful that straight cost value. This can be useful in helping concentrate management time to the most significant Parts. "A" class Parts are the most significant and "E" class parts are the least significant. The break points in terms of % of total MRP demand value can be set in the "System Manager" "Company Details". An "E" ABC class indicates that MRP found no demand for the Part. The ABC class can be edited to any upper case character in the maintenance window.

Tip TIP: You could use the ABC Classification field as a temporary ad hoc flag to identify a group of parts which are otherwise random. One value of this is that after using it the system will return ABC values when you next run MRP with ABC analysis.

Part Type

Parts Master. Part type (A,B,M,N,O,P). {PTMFILE.PTMTYPE char 1}. Only A, B, M, N, O or P can be entered here, with a meaning as follows:

A: The Part sourcing will be automatically deduced when running MRP: If the Part has a Bill of Materials and there are no open Purchase Orders for the Part then it will be considered a manufactured part. If this condition is not met the Part will be considered to be a purchased part.

B: The Part is a purchased part regardless of it having a Bill of Materials.

M: The Part is a manufactured part regardless of it not having a bill of material. This is useful when the part is manufactured from free-issue material that is not included of the inventory system. Costing will calculate any process route for the part.

N: A non-stock part such as a drawing, fixture, casting pattern etc. The part can have all the attributes of a normal Part but it can not be processed as a stock item or have a Bill of Materials or Process Route. However, it can be used on a Sales Order, although with no effect on stock. This is useful for standard delivery charges, services and the like. Once you create a Non-stock part you can not change it to another part type.

O: The Part is an Outwork assembly that is manufactured by a sub-contractor, the components of which are supplied from stock and must be accounted for. i.e. for "O" items MRP will plan to obtain the components as though the Part is to be manufactured under a Work Order, however, it will recommend an Outwork Purchase Order. Costing will take the Purchase Price on the Outwork Purchase Order. The Part, when ordered, is treated in the same way as a Purchase Part but flagged as Outwork. If you duplicate a type "O" part, the new part record will default to a type "A". An Outwork assembly can contain Phantom assemblies within them which will be blown-through and this will operate on a multi-level basis.

P: The Part which is a Phantom assembly only exists in production (or in Outwork kits) as an intermediate stage in the manufacture of a higher assembly. Phantom Assemblies can be end products in the form of kits of their components. They can also be Purchase Kits where kit components are received rather than the parent. Phantom Assemblies are never stocked themselves, only their components. Nor should they have a process route as they are never made as such. If you duplicate a type "P" part, the new part record will default to a type "A".

If a Work Order is prepared for a Parent whose assembly contains a component that is a Phantom type, the Phantom assembly components will be consolidated with the WO parent's other components for kitting purposes. This is a very valuable feature that enables the design of a product's structure to be very much more efficient, intuitive and convenient in production than otherwise. A Phantom Parent never physically exists in the production process and does not have a Process route. This also applies to Outwork Assemblies.

For example, a circuit board may have a number of integrated circuits along with other components. For convenience the business may desire to maintain the integrated circuits as an independent BoM. However, the ic's are always used with the other components, and at the same time, to make the circuit board and never physically exist in the stock room as a set of ic's. In this case the Parent of the bill of ic's is given a Phantom part type. As far as the computer database is concerned the bill of ic's is like any other bill. As far as production is concerned the bill of ic's does not exist as a separate entity and the ic's are consolidated into the bill of the Parent that calls the ic Phantom assembly.

A Phantom assembly can also be used for collections of parts that are kitted at sales delivery time. A business may sell repair kits or spare part kits that are not stocked in the store room as a separate collection of components. If this is the case, the parent of the spare part kit BoM should be given a Phantom part type. When a sales order is prepared for a Phantom parent the paperwork blows-through the bill and lists the components separately. The dispatch process would involve the stockman collecting together the individual parts of the Phantom for the dispatch. If kit items are shortages on dispatch, Caliach Vision will support control of the shortage.

A Phantom assembly can also be ordered on a purchase order in which case you will receive a collection of parts that is the kit. There is no concept of shortages in this use of a phantom. For costing to correctly distribute purchase costs amongst it's kit components, the phantom part must have a purchase part record. For correct operation in MRP the parent needs to have a purchase part record and at least one component needs to have the For supplies of the part MRP will order PO Kits checkbox checked. For the full implications to MRP see the Treatment of Purchase Order Kits section in the MRP Menu topic.

Phantoms can be multi-level. i.e. A Phantom assembly can itself contain other Phantom assemblies. In the case of a SO Kit, the store person is provided with a consolidated component list.

Note NOTE: O and P can not be entered in the parts maintenance window. You can only set a part to these types after the Part has been given components using the "Change Parent Part Type..." command in the "BoM" menu.

Stock Unit of Measure

Parts Master. Standard stock unit of measure. {PTMFILE.PTMSTUM char 6}

Last Modified Date and Time

Parts Master. Last modified date and time of master settings. {PTMFILE.PTMMODM date datetime 8}

Last Modified User Id

Parts Master. Last modification of master settings user id. {PTMFILE.PTMMODU char 3}

Current Quantities

For details see the Parts Current Quantity subwindow.

Period Usage

For details see the Parts Usage subwindow.

Back to top

Planning

Part Maintenance - Planning pane

Field

Description

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 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 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 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 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 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 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 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 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 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 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.

Assembly Byproduct Treatment

The program has the ability to handle single byproducts in assembly manufacture. The byproduct is identified in the parent's part record and the quantity produced and cost implications are calculated from the parent and BoM mass values. The system is most useful in instances such as accounting for swarf.

For an assembly to produce a byproduct during Work Order receipt, the following settings need to be made:

  1. The "Use automatic byproduct recording and costing" System Preference must be checked.
  2. The Byproduct must be defined as a part. Its mass must be set to its correct mass for the stock unit of measure you give it. Its cost needs to be set to its stock unit value you can achieve if you re-use or sell the byproduct.
  3. The Assembly part record must have the byproduct part number entered into Byproduct field.
  4. The Assembly part record must have its mass entered so that the correct quantity of byproduct can be calculated (see below).
  5. All component parts in the bill of material for the assembly must have their masses entered so that the correct quantity of byproduct can be calculated (see below).

Calculating byproduct quantity

The quantity of byproduct produced is calculated from the difference in mass between the parent part and the sum of components used in the BoM, as follows:

BoM Mass = Sum (Component BoM quantity * Component Mass)
Byproduct Quantity in stock UoM = (BoM Mass - Parent Mass) / Byproduct Mass

This will be the byproduct quantity per stock unit of measure of the assembly part.

How the byproduct effects assembly cost

The cost saving to the assembly of production of the byproduct will be the value of the quantity of byproduct produced. This cost will be a negative element of cost and is posted to the Receiving Overhead cost element of the assembly part as a negative number.

If you are using Receiving Overhead (I.E Have a non-zero receiving overhead rate for manufactured items set in the Company Details.) the receiving overhead element will show the receiving overhead less the byproduct value.

How the byproduct inventory is effected

If you have set up an assembly correctly for a by-product, the quantity of byproduct produced will be automatically accounted for at the time of Work Order completion. A stock movement history record for the byproduct part will be made of type F = General Return to Stores.

Back to top

Storage

Part Maintenance - Storage pane

Field

Description

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.

Customisation 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 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 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 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 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 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.

Back to top

Costs

Part Maintenance - Costs pane

Field

Description

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 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 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.

Button

Action

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.

Back to top

Selling

Part Maintenance - Selling pane

Field

Description

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.

Customisation 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 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 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 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 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 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 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.

Sales Pricing Logic

Sales Order Item prices and discounts applied under different conditions are as follows:

When there is NO Customer-Part record matching the SO customer and line item part:

Condition

SO Item Price

SO Item Discount

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

When there IS a Customer-Part record matching the SO customer and line item part:

Condition

SO item Price

SO item Discount

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

Back to top

Ledgers

Part Maintenance - Ledgers pane

Field

Description

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.

Back to top

Engineering

Part Maintenance - Engineering pane

Field

Description

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 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.

Button

Action

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.

Back to top

Texts

Part Maintenance - Texts pane

Parts can have Individual and Standard text applied separately to them for Sales Orders, Purchase Orders and Work Orders. Any standard text applied to a part must be pre-defined. Show buttons are available to give you lists of available alternatives for the standard texts. During edit, you can double-click on a list line to apply that text to the part.

Note NOTE: You can apply individual texts to Purchase, Sales and Work Orders in an alternative manner. If you respectively set options optPODefaultIndivText, optSODefaultIndivText and optWODefaultIndivText to '1', 'Y', 'Yes' or 'YES', the Individual Text will form a default description for the part rather than an additional text. I.E. In a Purchase Order, when optPODefaultIndivText is set to '1', line item description will default to the individual purchase text for the part when there is no relevant Purchase Part record description. In a Sales Order, when optSODefaultIndivText is set to '1', the line item description will default to the individual sales text for the part (as long as there is no relevant Customer Part record). In a Work Order, when optWODefaultIndivText is set to '1', the WO Comment will default to the individual works text for the part. Whenever any of these options are set the Individual Texts will NOT be printed on the respective documents, as they are when not set.

Field

Description

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.

Warning WARNING: Don't unnecessarily fill text into the Individual Tests fields, when it can be usefully put into Standard Texts. Every time parts are accessed across the network all the fields for each record are transferred. As parts are intensively accessed, large amount of unnecessary individual text will reduce the performance of the network. If the text is put in Standard Texts, the data is only transmitted over the network when it is needed.

Use of Engineering data records on Purchase, Sales and Work Orders and Jobs

You can use Engineering Data records to add additional detailed information for a particular Part to line items in Purchase and Sales Orders and to the header of Work Orders. This is a special feature that is instigated for each Part by adding a special text string to the beginning of the Part's Individual Purchase, Sales and/or Work Texts respectively.

The string must be in the form EDX-NNN.....N! and is case-sensitive. ED stands for Engineering Data and is mandatory, X can be T for Engineering Texts only, G for Engineering Graphic only or A for All engineering data. The - is mandatory. NNN.....N is the Document Number for the engineering data record you wish to have added to the Order. The trailing ! is mandatory.

Note NOTE: The Document Number record must be for the relevant Part and if there are more than one with this document/part combination the first created record, chronologically, will be used.

The Individual Text for the part will still print as normal on the Order, but without the special code string above, if an appropriate Engineering data record is found for it.

Warning WARNING: When printing graphic images, Caliach Vision does not wrap the image across pages. This can be a problem when you use Engineering Data graphics on Purchase or Sales Orders as it depends on the position of the line item and where the graphic falls on the page. If the bottom of the graphic falls off the bottom of the page, it will be truncated.

Back to top

Others

Part Maintenance - Others pane

Field

Description

 

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 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 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.

Button

Action

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.

Back to top

See also: -

Compiled in Program Version 5.04. Help data last modified 6 Dec 2016 11:00. Class wPtmEdit last modified 12 May 2016 13:25:57.