Advanced Lot No. Information List
Advanced Lot No. Information List
The Advanced Lot Information List allows users to analyze inventory lots by item, location, and bin. Within this page, it is possible to apply filters directly on the list in order to display only the most relevant data. The available filters are context‑aware, meaning that once a filter is applied, the remaining filter values are automatically restricted to combinations that exist in the inventory.
To open this page, open the seach page and search for Advanced Lot No. Information List:
Click on action and page will appear:
In this page is possible to filter the lots that are shown on Advanced Lot Information List. For example:
-
Users can filter the list by Item No. and select one or several items. When an item filter is applied, only the lots, locations, and bins that contain the selected items are displayed. All other filter fields are automatically limited to values related to those items.
-
If items are managed with variants, users can also filter by Variant Code. One or multiple variants can be selected, and the list will then show only the lots, locations, and bins where those specific item variants exist. The remaining filters dynamically adjust to reflect valid data combinations.
-
It is also possible to filter the list by Lot No. By selecting one or more lot numbers, the list displays only the items, locations, and bins that contain those lots. This filtering option is particularly useful when tracking or reviewing specific lots across different storage locations.
-
Filtering by Location and Bin is also available and works in the same way as the other filters, ensuring that only existing and relevant combinations are displayed in the list.
-
When working with lot number filters, users can decide whether Promoted Lot No. Attributes should be displayed as columns in the list or hidden from view. This allows the list layout to be adapted to the user’s analysis or reporting needs. Show Lot No. Attributes Toggle button.
-
It’s also possible to filter per Location or Bin Code - only Lots/Items that exist at the selected Locations will be visible for filtering when the remaining fields are filtered.
If no filters are required, click on action Refresh to display the complete list of all existing lots.
If needed, modify filters as required and click on action Refresh to apply the changes.
In this page, it is possible to see these fields:
| Field | Description |
|---|---|
| Lot No. | Specifies the number from the Tracking Specification table when a lot number information record is created. |
| Serial No. | Specifies the number from the Tracking Specification table when a serial number information record is created. |
| Item No. | Specifies the item no. related to the lot no. presented. |
| Variant Code | If the item has variants, it will appear the variant related to the lot. |
| Description | Specifies a description of the item record. |
| Item Category Code | Specifies a description of the category code related to the lot no. information record. |
| Quantity | Quantity of the lot. |
| Available Quantity | Quantity that is available to use. |
| Comments | If the Item lot card has a comment, this field is set to true. |
| Base Unit of Measure Code | Specifies the unit of measure in which the quantity is expressed. |
| Expiration Date | Expiration date of the lot, set in the lot card. In red since the lot is expired |
| Remaining Days for expiration | Specifies the no. of days until the lot is expired (in green), Specifies the no. of days since the lot is expired (in red). |
| Location Code | Location where the lot is in stock. There may be different locations for the same lot. |
| Bin Code | Bin where the lot is in stock. There may be different bins for the same lot. |
| Shelf No. | Shelf where the lot is stored (text field on the Inventory tab, not related to locations/bins). |
| Certificate Number | related to the lot no. presented (Hidden by default) |
| Test Quality | related to the lot no. presented (Hidden by default) |
| Inspection Status 2 | It refers to the status of a lot, which is a collection of material that is subject to inspection. |
| Inspection Status Date 2 | Date when the current inspection status was assigned. |
| Inspection Status Term Date 2 | Date when the current inspection status is due to expire. |
| Next Inspection Status 2 | Defines the next status to apply after the term ends. |
| Sell-by Date3 | Specifies a date marked on a perishable product indicating the recommended time by which it should be sold. In red since the date has passed |
| Remaining Days for sales 3 | Specifies the amount of days until the Sell-By Date.(in green), Specifies the amount of days after the Sell-By Date. (in red). |
| Lot No. Promoted Attributes 3 | Specifies the value of the Promoted Lot No. Attributes. |
| Batch Size Lot4 | If this field refers to a specific quantity of a product manufactured during a single production cycle, it is set to ‘true’. |
| Package No. or Licence Plating No. 5 | Specifies the Package No. from the Tracking Specification table when a lot number information record is created. |
1 Require Advanced Attributs Management Apps from Bricklead
2 Require Inspection Status Apps from Bricklead
3 Require Quality Requirements & Specifications Apps from Bricklead
4 Require Manufacturing Batch Size Apps from Bricklead
5 Require License Plating Apps from Bricklead
Open a record from the Advanced Lot No. Information List
If a record from a lot no. is opened from the Advanced Lot No. Information List, the item ledger entries regarding that lot are filtered for the location code, as well as the Inventory shown. That’s the main difference when compared to Lot No. Information List.
For example, open a Lot Card from the Advance Lot No. Information List:
Click on Inventory (or Expired Inventory):
The entries (and Inventory shown) are filtered for the Location Code associated to the record opened (in this particular case, filtered for Location Code = PAP):
If opened from the the Lot No. Information List, the location is not filtered:
And the Inventory appears not filtered for location:
