Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances. The purpose of this page is to add new Sites and/or update properties on existing Sites.

Page Header

Toolbar IconsDescription
Delete
Deletes the transaction or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

Grid Layout
Error rendering macro 'excerpt-include' : No link could be created for 'Toolbar Icon - Grid'.
New
Allows the user to create a new master file record or transaction by opening a blank record view page. This icon is always enabled. 
Notes
Opens the Notes dialog, filtered for the appropriate Note Type(s), allowing the user to enter Notes for the selected line item. From here, users can add, review, or edit Notes associated with the line item. If no line items are selected, entered Notes will apply to all line items and be appended to any existing Notes. This toolbar icon is always enabled. 
Save
Saves the changes made to the record. 

(lightbulb) It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.

FieldsDescription
Site

Identifies the name of the Site (warehouse) the transaction, shipment, or master file is associated with. 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.

Properties Tab

Toolbar IconsDescription
Excel
 Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. 
Property NameDescription
Auto Generate Warehouse Lots By
Auto Generate Warehouse Lots on Transfer Receipts

Identifies whether or not the Warehouse Lot Numbers are auto-generated for applicable transfer line items. 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". This value is required if the Site is warehouse lot tracked and there is a value in the "Auto Generate Warehouse Lots By" property. 

If these conditions are true and the value is missing, the message "Unable to set "Auto Generate Warehouse Lots By" if "Auto Generate Warehouse Lots on Transfer Receipts" is not enabled on Save.

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

Linked Database Field: ERPx_MFSite.AssignWarehouseLotsOnTransferReceipts

This lookup contains options for either "Yes" or "No". 

Default Via Site for Integrated Transfers
Inactive
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.

In Transit Sites are used to store perpetual Item & Lot balances for product that is moving (in transit). These are most often used for product that being transferred between two physical locations. These can represent trucks, shipping containers, ocean vessels, or any other virtual (non-physical building).

Database Field: ERPx_MFSite.IsInTransit

Next Production Batch #
Production Batch Prefix
Registration
Site ID

Identifies the unique Site ID (warehouse ID) of the Site the transaction, shipment, item, or lot is associated with. This is a text box that defaults as blank, is required, must be unique, and must be <= 25 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.

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain perpetual inventory balances.

Database Field: ERPx_MFSite.SiteID

Site Name

Identifies the name of the Site (warehouse) the transaction, shipment, or master file is associated with. 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.

Database Field: ERPx_MFSite.SiteName

Vendor
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 that 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 LV.

(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

A Warehouse Lot (aka Storage Lot) is used by 3rd party distribution sites to identify a unique quantity of product they are storing. Unlike a Production Batch number that never changes, Warehouse Lots will change as product is transferred to other Sites and/or transferred into exiting Warehouse Lots within the same Site. The 'Warehouse Lot' is one of the 5 components that make up a unique Inventory Lot and it is required when entering a transaction line on a transaction for a Warehouse Lot Tracked Site. This value will be blank and/or disabled for all non-Warehouse Lot Tracked Sites on screens that include a Warehouse Lot field.

Database Field: ERPx_MFSite.IsSiteWarehouseLotTracked

Grid: Properties Tab Properties

Property NameDescription
Auto Generate Warehouse Lots By

Identifies how Warehouse Lot Numbers are auto-generated for applicable transfer line items. This is not visible for new Sites and is only required and editable for Sites where the following conditions are both true:

  • The 'Warehouse Lot Tracked' property is set to either: "Yes - Allow multiple items in single lots" or "Yes - Limit Warehouse Lots to single items"
  • The '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 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. 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

Linked Database Field: ERPx_MFSite.WarehouseLotTemplate

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

Auto Generate Warehouse Lots on Transfer Receipts


Default Via Site for Integrated Transfers
InactiveThis field displays a drop-down menu with the options Yes and No for the user to identify whether or not the site is inactive.If a site is inactive, it will not display in any Site lookups, regardless of which modules it is visible to. Selecting Yes from this field will save the site as inactive. This field defaults to No and is required. This field is always editable.
Next Production Batch #This field displays a text box for users to enter the numeric value that will determine the production batch number of the next production batch created at the corresponding site, if the production batch is set to '(Use Next Number)'. This value will be combined with the Product Batch Prefix, if entered, to create the Production Batch ID. If no value is entered, this field will display 0 and will assume that users must manually enter the production batch ID. For new sites, this field defaults to 1000 but is always editable. After a number is used on a production batch, this field will automatically increment by one to create the next number. This field is not required but must only contain numbers.
Production Batch PrefixThis field displays a text box for users to enter the prefix for the production batch IDs created for production batches at the corresponding site. This prefix will be combined with the site's Next Production Batch number to create the next production batch ID, if both are entered. For new sites, this field defaults to 'Site ID -', which would result in the next production batch ID being 'Site ID - Next Production Batch #'. This field is not required and is always editable.
Registration

This field displays a text box for the user to enter the registration number for the site. This field defaults to blank and is not required. This field is always editable.

Vendor

This field displays a drop-down menu of all active vendors for the user to identify a specific vendor the site belongs to. This field defaults to blank and is not required. This field is always editable.

Address Tab

Toolbar IconsDescription
Excel

 Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. 

FieldsDescription
Address 1

This field displays a text box for the user to enter the first address line for the Site. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.AddressLine1

Address 2

This field displays a text box for the user to enter the second address line for the Site. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.AddressLine2

City

This field displays a text box for the user to enter the city in which the Site is located. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.City

Country


Database Field: ERPx_MFSite.Country

Email


Database Field: ERPx_MFSite.Email

Fax


Database Field: ERPx_MFSite.Fax

Phone

This field displays a text box for the user to enter the phone number of the Site. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.Phone1

State

This field displays a text box for the user to enter the state in which the Site is located. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.State

Zip

This field displays a text box for the user to enter the zip code in which the Site is located. This field defaults to blank and is not required.

Database Field: ERPx_MFSite.Zip

Contacts Tab

Toolbar IconsDescription
Excel

 Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. 

FieldsDescription
Contact Type

This field displays the contact type. The default Contact Type is Shipping and it cannot be edited.

Database Field: ERPx_MFSiteContact.ContactTypeSK

Email

This field displays the email address of the contact. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteContact.Email

Fax

This field displays the fax number of the contact. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteContact.Fax

Name

This field displays the name of the contact. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteContact.Name

Note

This field displays a note added to the contact. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteContact.Note

Phone

This field displays the phone number of the contact. This field defaults to blank and is not required. 

Database Field: ERPx_MFSiteContact.Phone

Lines Tab

Toolbar IconsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
DeleteDeletes the selected line(s) from the transaction or master file. This icon is only enabled for transactions with a Status of 'New'.
Excel

 Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. 

NewInserts blank lines that allow adding multiple new records.
FieldsDescription
Line

This field displays a text box for the user to enter the line name for the site. This field defaults to blank and is not required.

Database Field: ERPx_MFSiteLine.SiteLineName

Shifts Tab

Toolbar IconsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
DeleteDeletes the selected line(s) from the transaction or master file. This icon is only enabled for transactions with a Status of 'New'.
Excel

 Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. 

NewInserts blank lines that allow adding multiple new records.
FieldsDescription
Shift

This field displays a text box for the user to enter the shift name for the Site.

Database Field: ERPx_MFSiteShift.SiteShiftName

Certifications Tab

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
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
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

Toolbar IconsDescription
Excel

 Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. 

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Site Address Line 1


Database Field: ERPx_MFSite.AddressLine1

Site Address Line 2


Database Field: ERPx_MFSite.AddressLine2

Site City


Database Field: ERPx_MFSite.City

Site Country 


Database Field: ERPx_MFSite.Country

Site ID


Database Field: ERPx_MFSite.SiteID

Site Name


Database Field: ERPx_MFSite.SiteName

Site State


Database Field: ERPx_MFSite.State

Site Zip


Database Field: ERPx_MFSite.Zip


Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details


Table Names:
dbo.ERPx_MFSite
dbo.ERPx_MFSiteContact
dbo.ERPx_MFSiteLine
dbo.ERPx_MFSiteShift
Stored Procedures:
dbo.SPx_MFUPD_Site
dbo.SPx_MFSEL_SiteAddress
dbo.SPx_MFSEL_SiteCertificationList
dbo.SPx_MFSEL_SiteContactList
dbo.SPx_MFSEL_SiteLine
dbo.SPx_MFSEL_SiteProperties
  • No labels