Versions Compared

Key

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

The NorthScope Warehouse Lots master file allows the user to manage Warehouse Lots records. The purpose of this page is to view lots created from Inventory transactions, manually add new lots and edit and remove existing records. 

(lightbulb) This List View also contains columns for each Attribute that is set up under the 'Warehouse Lots' Master File attribute type. Because these are user defined, they are not included in the default view but can be added to a saved column layout. User configured attributes are not included in the help documentation.

Software Version: 2022.0304.XX 22 and newer

Table of Contents
typeflat

...

Search OptionsDescription
Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
nopaneltrue
Created Since

This is a Date field that allows the user to enter/select a date to search for Warehouse Lot records that were created on or after the chosen date to display in the grid. 

Site

Insert excerpt
Inq - Site
Inq - Site
nopaneltrue
This is a multi-select lookup that contains all the active Warehouse Lot tracked Sites setup in the Sites master file. This defaults to blank. 

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Saved Searches
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
Warehouse Lot ID

This is a textbox that users can enter a Warehouse Lot ID value that has been created in the system to filter the data in the grid. 

Insert excerpt
Def - Warehouse Lot
Def - Warehouse Lot
nopaneltrue

...

Toolbar Icons

Description
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete
Insert excerpt
Delete - RV Header 3.0
Delete - RV Header 3.0
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
New
Insert excerpt
New - Global 3.0
New - Global 3.0
nopaneltrue
Notes
Insert excerpt
Notes - Global 3.0
Notes - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Save
Insert excerpt
Save - RV Header 3.0
Save - RV Header 3.0
nopaneltrue
Saved Layouts

Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
 

Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Created By

Insert excerpt
Created By
Created By
nopaneltrue

Database Field: ERPx_IMWarehouseLot.CreatedBy

Created Date

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_IMWarehouseLot.CreatedDate

Item: Description

Insert excerpt
Item ID & Item Description
Item ID & Item Description
nopaneltrue
 This field displays a drop-down menu of all active items for the user to select the item(s) eligible to be included in the warehouse lot. This field allows the user to select a single item, multiple items, or 'ALL', which include all items. For warehouse lots created at sites set to a warehouse lot tracked value of 'Yes - Allow multiple items in single lots', this field will default to 'ALL' when the warehouse lot is created. For warehouse lots created at sites set to a warehouse lot tracked value of 'Yes - Limit Warehouse Lots to single items', this field will default to the item the warehouse lot was initially created for from the inventory transaction that created it but will allow user to override this singular item.

Database Fields: ERPX_IMItem.ItemID, ERPX_IMItem.ItemDescription, ERPx_IMTransactionDetail.ItemSK

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_IMWarehouseLot.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue

Database Field: ERPx_IMWarehouseLot.LastUpdatedBy

Site

Identifies the unique ID and the name of the Site at which the warehouse lot is located. This is displayed as [Site ID]: [Site Name] and defaults from the 'Site' field on the 'Home' tab of the Inventory transaction associated with the Warehouse Lot. This is never editable. 

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Fields: ERPx_MFSite.SiteID: SiteName, ERPx_IMTransactionHeader.SiteSK

Storage Begin Date

Insert excerpt
Def - Storage Begin Date
Def - Storage Begin Date
nopaneltrue
 This defaults from the Inventory Receipt transaction if one was entered for the associated lot (via mass update).  This is always editable for the user to enter or select a valid date but is not required.  

Database Field: ERPx_IMWarehouseLot.StorageBeginDate

Storage Renewal Day

Insert excerpt
Def - Storage Renewal Day
Def - Storage Renewal Day
nopaneltrue
This defaults from the Inventory Receipt transaction if one was entered for the associated lot (via mass update). This is always editable and must be a number between 1 - 31 that represents the day of the 'Storage Begin Date'. If a Storage Begin Date is provided and the Storage Renewal Day is blank, the value will be automatically calculated and assigned.  For example, if the Storage Begin Date = 02/26/2022, the Storage Renewal Day would be 26.  Users cannot enter 0 as a value, but the field is not required and may be blank.

Database Field: ERPx_IMWarehouseLot.StorageRenewalDay

Warehouse Lot

Insert excerpt
Warehouse Lot
Warehouse Lot
nopaneltrue
 This value defaults from the 'Warehouse Lot' value specified on the Inventory transaction that created the Inventory Lot. This is always editable, however duplicate Site and Warehouse Lot combinations are not allowed. 

Insert excerpt
Def - Warehouse Lot
Def - Warehouse Lot
nopaneltrue

Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMTransaction.WarehouseLotSK

...