Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Site
Def - Site
nopaneltrue
 The purpose of this page is to add new Sites and/or update properties on existing Sites.

Table of Contents
typeflat

Software Version: 2022.03.18 and newer

Page Header

Toolbar IconsDescription
Delete
Insert excerpt
Delete - RV Header
Delete - RV Header
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
New
Insert excerpt
New - RV Header
New - RV Header
nopaneltrue
Notes
Insert excerpt
Notes - RV Grid 3.0
Notes - RV Grid 3.0
nopaneltrue
Save
Insert excerpt
Save - RV Header
Save - RV Header
nopaneltrue
FieldsDescription
Site

Insert excerpt
Site Name - LV
Site Name - LV
nopaneltrue
 This is a single select lookup that is required. The lookup contains the list of all sites. Selecting a different Site, reloads the page with data for the selected Site.

...

Toolbar IconsDescription
Excel
Insert excerpt
Excel - Global (old)
Excel - Global (old)
nopaneltrue
Property NameDescription
Auto Generate Warehouse Lots By

Identifies how Warehouse Lot Numbers are auto generated for this Site when it is assigned as the 'To Site' (the receiving Site) on an inventory Transfer. This is only required and editable for Sites where the following conditions are both true:

  • The Site's 'Warehouse Lot Tracked' property is set to either: "Yes - Allow multiple items in single lots" or "Yes - Limit Warehouse Lots to single items"
  • The Site's 'Auto Generate Warehouse Lots on Transfer Receipts' property is set to Yes

If these conditions are true and the value is missing, the message "[SiteID] has the "Auto Generate Warehouse Lots on Transfer Receipts" option turned on but is missing a selection for "Auto Generate Warehouse Lots by"" will be displayed on Save.

When this feature is enabled for a Site assigned as the 'To Site' (the receiving Site) on an inventory Transfer, the system will automatically populate the Warehouse Lot values in the 'To Warehouse Lot' filed, on Save. The values will be populated as either:

  • INTR:[SiteID]:[Reference Number] - for example INTR:BCS:12345
  • [Item ID]-[Production Batch Date MM][Production Batch Date YY] - for example 10015-0519
  • [Production Batch Date MM][Production Batch Date YY]-[Item ID] - for example 0519-10015

This lookup contains all the values in the WarehouseLotTemplateEN Enumeration Class.

(lightbulb) This should only be used for Sites that allow you to specify the Warehouse Lot numbers you want them to use. If the Warehouse Lot numbers are assigned by the Site, this should not be used.

Database Field: ERPx_MFSite.WarehouseLotTemplate

Auto Generate Warehouse Lots on Transfer Receipts

A Yes/No value to identify whether or not Warehouse Lot Numbers are auto assigned for this Site when it is assigned as the 'To Site' (the receiving Site) on an inventory Transfer. This is only visible for Sites where the 'Warehouse Lot Tracked' property is set to either: "Yes - Allow multiple items in single lots" or "Yes - Limit Warehouse Lots to single items".

When this feature is enabled for the 'To Site' (the receiving Site) on an inventory Transfer transaction, the system will automatically populate the warehouse lot values in the 'To Warehouse Lot', on Save based on the settings in the 'Auto Generate Warehouse Lots by' property. 

(lightbulb) This should only be used for Sites that allow you to specify the Warehouse Lot numbers you want them to use. If the Warehouse Lot numbers are assigned by the Site, this should not be used.

Database Field: ERPx_MFSite.AssignWarehouseLotsOnTransferReceipts

Default Via Site for Integrated Transfers

Used to assign the default 'In Transit' Site that will be used for Transfers that are imported/integrated from a 3rd party Warehouse Management System. This defaults to blank, is not required, and is always editable. This property is only visible and editable if the following conditions are both true:

  1. The Site being edited is NOT an In Transit Site (it's 'In transit' property is set to "No")
  2. The Site being edited is visible to WMS (it's 'Visible to WMS' property is set to "Yes")

The Lookup contains a list of all 'Active' "In Transit" Sites. If there is a Site specified, imported Transfers sent from this Site will create 2-part transfers using the assigned 'In Transit' Site. If there is not a Site specified, imported Transfers sent FROM this Site will create 1-part transfers. 

Database Field: ERPx_MFSite.IntegratedTransferDefaultViaSiteSK

Inactive

Insert excerpt
Def - Inactive
Def - Inactive
nopaneltrue
 This is a Yes/No lookup that is required. It defaults to "No" and is always editable.

Database Field: ERPx_MFSite.IsInactive

In Transit

A Yes/No lookup to identify whether or not the site is an "in transit" site. This defaults to "No", is required, and is always editable.

  • If "Yes', the site can be added as the "Ship Via" site on a two-part transfer and on other transactions.
  • If "No", the site will not be included in the "Ship Via" lookup on Transfer Transactions but can be assigned on other transactions.

Insert excerpt
Def - In Transit Site
Def - In Transit Site
nopaneltrue

Database Field: ERPx_MFSite.IsInTransit

Next Production Batch #

Specifies the next Production Batch number that will be auto assigned in the system. This is a text box that is required, defaults to "1000", and is always editable. It must be a positive whole number, else the message "Next Production Batch Number cannot be negative", "Next Production Batch Number cannot contain commas or decimals.", or "Next Production Batch Number must be a Number." will be displayed on Save. This field will auto increment by 1 for every new Production Batch that is auto created.

The 'Production Batch Prefix' is used in conjunction with the 'Next Production Batch #' to determine the auto assigned Production Batch ID. Production Batch IDs are created by stringing together the [Production Batch Prefix] + [Next Production Batch #].

Database Field: ERPx_MFSite.NextProductionBatchNumber

Production Batch Prefix

Used to set a prefix for Production Batches that are auto assigned in the system. If a prefix exists, it will be used prior to the site's 'Next Production Batch #' to auto create the Production Batch ID. This is a text box that defaults to '[Site ID] -', it must be <= 25 characters, it is not required, does not need to be unique, and is always editable.

The 'Production Batch Prefix' is used in conjunction with the 'Next Production Batch #' to determine the auto assigned Production Batch ID. Production Batch IDs are created by stringing together the [Production Batch Prefix] + [Next Production Batch #].

Database Field: ERPx_MFSite.ProductionBatchPrefix

Registration

Used to enter the Registration # for the Site (typically an FDA Registration #). This is a text box that defaults as blank, is not required, must be <= 50 characters, and is always editable.

Database Field: ERPx_MFSite.Registration

Site ID

Insert excerpt
Site ID
Site ID
nopaneltrue
 This is a text box that defaults as blank, is required, must be unique, and must be <= 20 characters. If missing, the message "Site ID is required." will be displayed on Save. If not unique the message "Duplicate Site ID's are not allowed." will be displayed on Save. This field is always editable.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Field: ERPx_MFSite.SiteID

Site Name

Insert excerpt
Site Name - LV
Site Name - LV
nopaneltrue
 This is a text box that defaults as blank, is required, and must be <= 35 characters. If missing, the message "Site Name is required." will be displayed on Save. This field is always editable.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Field: ERPx_MFSite.SiteName

Vendor

A lookup to identify the Vendor that is linked to the Site displayed as [Vendor Name] ([Vendor ID]). This is informational only and is typically only assigned to 3rd party sites (cold storages, re-packers, etc.). This defaults as blank, is not required, and is always editable.

The lookup contains a blank value, the current assigned value and the list of all 'Active' Vendors with a VendorTypeEN = 1 and is sorted alphabetically.

Database Field: ERPx_MFSite.VendorSK

Visible to Logistics

A Yes/No lookup to identify whether or not the site is visible in the "Load Management" functional Area. This defaults to "No", is required, and is always editable.

  • If "Yes', transactions shipping from the Site (that are also being shipped by a Carrier that is "Visible to Logistics") will be visible to the "Build Loads" process in Load Management.
  • If "No', transactions shipping from the Site the Site will be visible/accessible in Load Management

(lightbulb) The list of Sites also exists in the Load Management functional area, allowing users to determine whether or not a Site is available to them for placement on Loads. Because of this, the Site record view Visible to Logistics field corresponds with the Logistics Sites list view Visible to Logistics checkbox. Therefore, if the Site's visibility to logistics is edited from either location, the site will be updated in both locations.

Database Field: ERPx_MFSite.IsVisibleToLogistics

Visible to Sales

A Yes/No lookup to identify whether or not the site is visible for use on Sales Orders, Price Adjustment, and Return transactions. This defaults to "No", is required, and is always editable.

  • If "Yes', the Site will be included in the Site lookups on Sales Orders, Price Adjustment, and Return transactions.
  • If "No', the Site will not be included in the Site lookups on Sales Orders, Price Adjustment, and Return transactions.

Database Field: ERPx_MFSite.IsVisibleToSales

Visible to WMS

A Yes/No lookup to identify whether or not transactions shipping for the site are visible to a 3rd party Warehouse Management System. This defaults to "No", is required, and is always editable.

  • If "Yes', transactions shipping from the Site (for each Item that is also visible to WMS) will be visible/accessible to the Warehouse Management system.
  • If "No', transactions shipping from the Site will not be visible/accessible to the Warehouse Management system.

(lightbulb) This setting is only applicable for NorthScope installations that are integrated with a Warehouse Management system. 

Database Field: ERPx_MFSite.IsVisibleToWMS

Warehouse Lot Tracked

This is a single select lookup to Identify whether or not the Site manages 'Warehouse Lots' and if so, do you allow multiple Item IDs to be stored within the same 'Warehouse Lot'. This defaults to "No", is required, and is always editable. The lookup contains the following values:

  • No. Used for Sites that do not track/store Warehouse Lots. The Warehouse Lot property is disabled for all Items and/or Lots within the Site.
  • Yes - Allow multiple items in single lots. Used for Sites that track/store Warehouse Lots and that you allow Warehouse Lots to contain multiple Item IDs. 
  • Yes - Limit Warehouse Lots to single items. Used for Sites that track/store Warehouse Lots that are limited to a single Item ID. This is a default for all Warehouse Lots for this Site, but it can be overridden on specific Warehouse Lots in the Warehouse Lots LVList View.

(lightbulb) If this property is changed from 'No' either of the Yes options on a Site that contains Item/Lot history, a new Warehouse Lot will be auto created (as [SiteID]-Default) and assigned to all Inventory Lots for the Site and the message "The Warehouse Lot ID on all existing transactions for this Site has been updated to SITEID-Default" will be displayed on Save

Insert excerpt
Def - Warehouse Lot
Def - Warehouse Lot
nopaneltrue

Database Field: ERPx_MFSite.IsSiteWarehouseLotTracked


Address Tab

Toolbar IconsDescription
Excel

Insert excerpt
Excel - Global (old)
Excel - Global (old)
nopaneltrue

FieldsDescription
Address 1

A text box to assign the street address for the Site. This defaults to blank, is not required, and is always editable.

Insert excerpt
Def - Address - Address Line 1
Def - Address - Address Line 1
nopaneltrue

Database Field: ERPx_MFSite.AddressLine1

Address 2

A text box to assign additional address information for the Site. This defaults to blank, is not required, and is always editable.

Insert excerpt
Def - Address - Address Line 2
Def - Address - Address Line 2
nopaneltrue

Database Field: ERPx_MFSite.AddressLine2

City

A text box to assign the 'City' the Site is located in. This defaults to blank, is not required, and is always editable.

Database Field: ERPx_MFSite.City

Country

A text box to assign the 'Country' the Site is located in. This defaults to blank, is not required, and is always editable.

Database Field: ERPx_MFSite.Country

Email

A text box to assign the default email address used for the Site. This defaults to blank, is not required, and is always editable.

Database Field: ERPx_MFSite.Email

Fax

A text box to assign the default fax number used for the Site. This defaults to blank, is not required, and is always editable.

Database Field: ERPx_MFSite.Fax

Phone

A text box to assign the default phone number used for the Site. This defaults to blank, is not required, and is always editable.

Database Field: ERPx_MFSite.Phone1

State

A text box to assign the 'State' the Site is located in. This defaults to blank, is not required, and is always editable.

Database Field: ERPx_MFSite.State

Zip

A text box to assign the 'Zip' the Site is located in. This defaults to blank, is not required, and is always editable.

Database Field: ERPx_MFSite.Zip

...

Toolbar IconsDescription
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. 

FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Certification

Displays the read-only name of the valid certifications to assign to the Site. Eligible certifications to assign to the site are those marked as Site Only or Item & Site in the Lot Certifications list view. To assign a certification to a site, simply check the certifications select box and save. All assigned certifications will filter to the top of the certifications list.

Related Sites Tab

Insert excerpt
Def - Site - Related
Def - Site - Related
nopaneltrue

...