/
Warehouse Lots List View

Warehouse Lots List View

Apr 26, 2022

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. 

 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.04.22 and newer

[ 1 Page Header ] [ 1.1 Search ] [ 2 Page Detail ] [ 2.1 Related Topics ] [ 2.1.1 Page Definitions ] [ 2.1.2 Technical Details ]

Page Header

Search

Search Options

Description

Search Options

Description

Auto Hide Filters

Auto Refresh on Open

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

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. 

Saved Searches

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. 

Page Detail

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Delete

Excel

Favorites

Group By Show/Hide

Help

New

Notes

Quick Column Filter

Refresh

Save

Saved Layouts

 

Search Options

Fields

Description

Checkbox

Created By

Database Field: ERPx_IMWarehouseLot.CreatedBy

Created Date

Database Field: ERPx_IMWarehouseLot.CreatedDate

Item: Description

 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

Database Field: ERPx_IMWarehouseLot.LastUpdated

Last Updated By

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. 

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

Storage Begin Date

 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

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

 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. 

Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMTransaction.WarehouseLotSK