Facility Part Cross References

Deacom offers the option to define unique MRP criteria, costs, and prices for specific Facilities by using Facility-specific parts. If Facility-specific parts exist, and the Facility and Part are selected when entering an order, the system will use the information on the Facility part record rather than the Part's Item Master record. Refer to the Designing a Part Number System page to better understand when Facility Cross Reference Parts should be used. Users should also reference the Understanding the Deacom Pricing Hierarchy page to understand how Facility-specific pricing is handled in Deacom. The information configured in this form can be used by purchasing and sales team members to make informed decisions when ordering and selling materials and can influence decisions when using MRP to plan purchases and sales for specific items.

System Navigation

Inventory > Item Master > click "View"
- Click "View Facilities" > click "Add" or "Modify"
- Click "New" or "Modify" > Facilities tab > click "Add" or "Modify"

Edit Item Facility form

Opened via the "Add" or "Modify" buttons on Item Master Facilities tab, this form lists the general, MRP, and costing details of the Facility part attached to the selected Item Master and is used to view or modify those details.

Button/Field	Description
Update Acct. Std.	If clicked, the system will take the "Current" costs listed on the Costs tab (on the left-hand side) and populate the "Acct" costs (on the right-hand side) and populate the "Last Acct Update" field with the current date. If the "Inventory Costing" method is set to "Standard Cost" in Accounting > Options > Costing tab, all new transactions will be posted using the new updated costs. The security setting "Inventory -- update fixed standard costs" controls access to this button.
Part Number	Displays the Part Number as defined on the Item Master header to which this Facility part will be assigned.
Part Description	Displays the Description of the Part as defined on the Item Master header.
Facility	Search field used to select a Facility to which this part should be linked.

General tab

The Facility part General tab allows a company to define different defaults and hazard information associated with handling this item in the selected Facility, if different than the regular defaults of handling the item. This tab contains most of the same fields and flags as the regular Item Master General 1 and Properties tabs and a few unique fields, defined below. Refer to the Item Master Encyclopedia page for field definitions.

Flag/Field	Description
Zone	Only available in web versions of Deacom. Search field used to restrict what inventory can be received to only Locations within the selected Zone. Useful for situations where companies need to restrict items to certain areas of the warehouse. For example, certain materials can only be stored in the Cooler. This field will direct users to the Cooler and not allow users to move this product into a non-Cooler Location.
Use Physical Inventory/Cycle Count Settings	If checked, the system will use the "ABC" setting and "Last Count" date from the cross reference selected in the physical inventory/cycle count process. When this box is not checked, the system will not include the selected Facility Part Cross Reference in the physical inventory/cycle count process. Introduced in version 15.04.042. Previously, the "Use Reorder Points" on the MRP tab (p3_usereorder) had to be checked to perform this logic at the Facility Part Cross Reference (dmprod3) level. Additional information on this process can be found on the Performing Cycle Counts and Completing a Physical Inventory pages.
Prevent Inventory Transaction	If checked, the system will not allow any inventory transactions for this item in the facility. If unchecked, the system will refer to the "Prevent Inventory Transaction" flag on the Properties tab of the Item Master.
Use Scrap and Over Issue	If checked, the system will use the field values in this tab when issuing material to Jobs for this Part in the specified Facility rather than the values on the regular Item Master record.
Use Property Flags	If checked, the system will use the "Saleable", "Purchasable", "Manufactured", and "Hazardous" flag values when using this Part in the specified Facility rather than the values on the regular Item Master record. May be used in conjunction with the "Require Facility Entry" flag on the Item Master Properties tab if Parts should only be saleable, purchasable, and/or manufactured in specific Facilities.
Include Sub-Assemblies in Header & Line Jobs	If checked, and a header or line job is created, the system will evaluate this Part's BOM for any items flagged as "Manufactured," and will check all levels of the BOM and automatically include Subassemblies deeper than the first level to the job. By checking the flag in this Edit Item Facility form, one can ensure this process happens only at specific facilities if desired.
Re-Calc Facility Specific BOM Calcs On Save	If checked, BOM Rollup for all facility specific BOMs will occur.
Require Lot On Relief	Option to determine how lot control will be handled for items in the selected Facility. Options are: Follow Item Master (default setting) - the system will check, and enforce, the setting for the "Require" Lot On Relief" and "Require User Lot On Receipt" fields on the Properties tab of the Edit Item Master form. No - the system will not require lot control when handling lots for this item in the selected Facility. Yes - the system will require lot control when handling lots for this item in the selected Facility, regardless of the setting for the field on the Properties tab of the Edit Item Master form. This field was added in version 17.01.003 and is useful in situations where companies have multiple Facilities and only require strict lot control in certain ones, allowing the other Facilites to assign/backflush lots automatically, and therefore make daily/weekly production easier and potentially faster.
Require Lot On Receipt	Option to determine how lot control will be handled for items in the selected Facility. Options are: Follow Item Master (default setting) - the system will check, and enforce, the setting for the "Require" Lot On Relief" and "Require User Lot On Receipt" fields on the Properties tab of the Edit Item Master form. No - the system will not require lot control when handling lots for this item in the selected Facility. Yes - the system will require lot control when handling lots for this item in the selected Facility, regardless of the setting for the field on the Properties tab of the Edit Item Master form. This field was added in version 17.01.003 and is useful in situations where companies have multiple Facilities and only require strict lot control in certain ones, allowing the other Facilites to assign/backflush lots automatically, and therefore make daily/weekly production easier and potentially faster.

Note: Inventory counts by Facility may be performed via Print Outs > Physical Inventory Forms. Once initiated, the last time inventory has been counted by a selected Facility, the Last Count field on the General tab will update with the appropriate date.

MRP tab

The Facility part MRP tab allows a company to define different MRP specific information such as minimum and maximum quantities, lead times, etc. associated with handling this item in the selected Facility, if different than the regular MRP settings for the item. This tab contains most of the same fields and flags as the regular Item Master MRP tab and a few unique fields, defined below. Refer to the Item Master Encyclopedia page for the field definitions on this tab.

Notes:

The information and settings on this tab will not be used unless the "Use Reorder Points" flag is checked.

Beginning in version 16.03.055, if creating a purchaser order in MRP for an item with no suggestion, the system will check the "PO Quantity" field on any Vendor Part, then any Facility Part, and finally the Item Master when determining the default purchase order quantity. Note: the value in the field must be greater than 0.

Flag/Field	Description
Min. Transferable Qty	Defines the minimum quantity required when creating Inter-Company Transfers for the selected Facility, including transfers created via MRP. Users with the security setting "Sales orders - allow quantities less than min transferable" will be permitted to enter a quantity below the minimum.
Incremental ICT Qty	Defines the increment, in Stock Units, at which Inter-Company Transfers for the selected Sales Orders for this Part must be created, including transfers created in MRP. Users with the security setting "Sales Orders -- allow non-incremental ICT quantities" will be permitted to enter non-incremental quantities on Sales Orders. This field, and the Min. Transferable Qty field, are used in situations where customers transfer and sell the same items from the same Facility in Deacom. In this case, the Minimum Saleable and Incremental SO Quantity fields may be used by customers to determine quantity parameters when items are sold, thus allowing them to specify different quantity parameters for Inter-Company Transfers from the same facility.
Include Sub-Assemblies in MRP Jobs	If checked, when creating Jobs via MRP, the system will evaluate this Part's BOM and any items flagged as "Manufactured" will be added to the same Job(s). Specifically, the system will check all levels of the BOM and include Subassemblies deeper than the first level. By checking the flag in this Edit Item Facility form, one can ensure this process happens only at specific facilities if desired.

Flag/Field

Description

Min. Transferable Qty

Defines the minimum quantity required when creating Inter-Company Transfers for the selected Facility, including transfers created via MRP.

Users with the security setting "Sales orders - allow quantities less than min transferable" will be permitted to enter a quantity below the minimum.

Incremental ICT Qty

Defines the increment, in Stock Units, at which Inter-Company Transfers for the selected Sales Orders for this Part must be created, including transfers created in MRP.

Users with the security setting "Sales Orders -- allow non-incremental ICT quantities" will be permitted to enter non-incremental quantities on Sales Orders.
This field, and the Min. Transferable Qty field, are used in situations where customers transfer and sell the same items from the same Facility in Deacom. In this case, the Minimum Saleable and Incremental SO Quantity fields may be used by customers to determine quantity parameters when items are sold, thus allowing them to specify different quantity parameters for Inter-Company Transfers from the same facility.

Include Sub-Assemblies in MRP Jobs

If checked, when creating Jobs via MRP, the system will evaluate this Part's BOM and any items flagged as "Manufactured" will be added to the same Job(s). Specifically, the system will check all levels of the BOM and include Subassemblies deeper than the first level.

By checking the flag in this Edit Item Facility form, one can ensure this process happens only at specific facilities if desired.

Restrictions tab

The Restrictions tab allows a company to establish item facility specific sales restrictions such as minimum/maximum saleable amounts. The tab works in conjunction with the Restricted Selling feature.

Add/Modify Restriction form

Flag/Field	Description
Restricted Selling Type	Defines the Restricted Selling Type.
Minimum/Maximum	Defines the minimum and maximum amount based on the selected Restricted Selling Type. Example - if the Restricted Selling Group has a minimum of 5 and maximum of 12, then the minimum at the part level cannot be 4 with a maximum of 14, otherwise the part will not be available for use on sales orders
Percent Of

Flag/Field

Description

Restricted Selling Type

Defines the Restricted Selling Type.

Minimum/Maximum

Defines the minimum and maximum amount based on the selected Restricted Selling Type.

Example - if the Restricted Selling Group has a minimum of 5 and maximum of 12, then the minimum at the part level cannot be 4 with a maximum of 14, otherwise the part will not be available for use on sales orders

Percent Of

Costs tab

The Facility part Costs tab allows a company to define current, future, and standard materials, labor, burden, and freight costs associated with handling this item in the selected Facility, if different than the regular costs of handling the item. This tab contains most of the same fields as the regular Item Master Costs tab, a read-only "Currency" field listing the Currency that will be used to post entries for this Facility part, and a "Use Costs" flag which if checked, tells the system to use the costs listed in this tab rather than the costs listed on the regular Item Master Costs tab when updating inventory costs, costing production Jobs, and in any other transactions that require cost information for this item in this Facility.

When calculating the "Current Labor" field on this tab, the default Routing on the default BOM specific to the selected Facility is used. If there is no Facility-specific default BOM revision/routing, the default BOM revision/routing for all Facilities is used. When rolling up the standard costs to parent items, Facility-specific costs are now rolled up as well. For a given Facility, if the Facility part for a Raw Material is flagged to "Use Costs", the Facility costs are used. Otherwise, the Item Master costs are used. If the parent item has a Facility part that the Raw Material does not, the Item Master costs are used to fill it. If there is a default Facility-specific BOM for the parent item, it is used to calculate costs. If not, the system looks for the following, in order:

A default BOM not assigned to any Facility.
A default BOM assigned to the default Facility.
Falls back on the default BOM for the Facility with the lowest ID.

Refer to the Item Master Encyclopedia page for field definitions and, where applicable, calculations.

Costs 2 tab

Like the Facility part Costs tab, the Facility part Costs 2 tab allows a company to define sale prices, purchase prices, transfer costs, loaded costs, etc. associated with handling this item in the selected Facility, if different than the regular costs of handling the item. This tab contains most of the same fields as the regular Item Master Costs 2 tab and a "Use Prices" flag which if checked, tells the system to use the prices listed in this tab rather than the prices listed on the regular Item Master Costs 2 tab when performing pricing updated, adding Parts to Sales Orders, and in any other transactions that require price information for this item in this Facility. Refer to the Item Master Encyclopedia page for field definitions and, where applicable, calculations.

User Fields tab

Deacom allows the creation of user-defined fields that, once created, are available on various master data records such as items, Vendors, and Ship-to Companies. These fields allow companies to enter and store information outside of the fields provided in the system. The user fields on a Facility part record may be used to capture information such as Boiling Point, Special Instructions, Allergen Information, Nutrition Information, etc. User fields may be added via Tools > Maintenance > User Fields. For more information, refer to Configuring User Fields and User Calculations.