Facility Relationships

The Facility Relationships table allows companies to specify lead times for Inter-Company Transfers that are specific to the designated shipping Facilities. When using Facility Relationships, the Due to Ship date on Inter-Company Transfers created from MRP will be the demand/requirement date less the Facility transfer Lead Time, if one is specified, and the "Use Lead Time" flag is checked. The demand/requirement date refers to the start date of the order driving demand for the item(s). In addition, the Due to Dock date on the Inter-Company Transfer is set as the demand/requirement date. Additional information on the creation of Inter-Company Transfers is available via Using Inter-Company Transfers.

The Elimination Credit and Debit accounts were added to support companies that have two different Facilities or companies that share the same owner but still wish to perform Inter-Company Transfers as opposed to entering Sales and Purchase Orders to each entity. ICTs are typically used in situations where the volume on materials and goods movements is extensive. These elimination accounts allow companies to bypass the Facility elimination accounts and hit the respective AP/AR accounts and sub-ledgers for an Inter-Company Transfer.

System Navigation

Sales > Maintenance > Facility Relationships

Edit Facility Relationship form

Opened via the "New" or "Modify" buttons on the Facility Relationships form.

Field/Flag	Description
Facility	Search field used to select the appropriate shipping Facility.
Facility	Search field used to select the appropriate receiving Facility.
Use Lead Time	If checked, the value specified in the "Lead Time" field below will be used when calculating demand/requirement dates in MRP.
Lead Time	Indicates the value, in days, of time required when shipping items to the designated receiving Facility.
Elimination Credit	Search field used to select an account to which Facility elimination amounts will be credited, different from the "Facility Elimination" account specified in Accounting > Options > Accounts Receivable tab. Both the Elimination Credit and Debit accounts must be populated if using this functionality or left blank if not using. The Facility will not recognize accounts if only one of the accounts on this form are populated.
Elimination Debit	Search field used to select an account to which Facility elimination amounts will be debited, different from the "Facility Elimination" account specified in Accounting > Options > Accounts Receivable tab. Both the Elimination Credit and Debit accounts must be populated if using this functionality or left blank if not using. The Facility will not recognize accounts if only one of the accounts on this form are populated.
Rev On Inter-Co Xfer	Option to determine, at the Facility level, if revenue on inter-company transfers is recognized. Options are: Follow System Options (default), Yes, and No. When receiving an inter-company transfer the system will check for an establish Facility Relationship between the receiving facility and shipping facility, and if one exists, will use the following logic: If this field is set to No, the system will not apply any inventory markup from the receiving facility. If this field is set to Yes, the system will apply inventory markup logic from the receiving facility. If Follow System Options is set, the system will fall back to the setting for the "Recognize Revenue On Inter-Co Xfer" field in Accounting > Options to determine if inventory markup is applied. Added in version 17.02.010 to support scenarios where revenue recognition is established on a Facility level and does not rely on a system wide setting.
For Type	Pick list used to indicate what inventory level this relationship is for. Options are: All Category Sub-Category Part Number
For	Search field used in conjunction with the "For Type" selected to select the desired inventory level.
MRP	Pick list used to determine how this relationship is used when creating Inter-Company Transfers via MRP. Options are: Both - The system will use the First Facility/Transferring Facility (ft_waid1) to create an ICT, if not enough inventory exists there to cover the suggestion in MRP, check the Second Facility/Receiving Facility (ft_waid2). First - The system will only use ft_waid1 to create an ICT, skip ft_waid2 and move on to check the next relationship in sequence. None Second - The system will only use ft_waid2 to create an ICT, skip ft_waid1 and move on to check the next relationship in sequence.
Active	If checked, this record is active. Only active records may be used in the system.