Def - Insert excerpt
This page displays warehouse lots for the selected Item, Site and Lot Owner(s). Insert excerpt Def - Warehouse Lot Def - Warehouse Lot nopanel true
The purpose of this page is allow users to select specific warehouse lot(s) to allocated from. Insert excerpt Def - Sales Allocation Def - Sales Allocation nopanel true
This record view contains columns for each Lot Certification. Because these are user defined, they are not included in the default view, but can be added a saved column layout. Lot Certifications are not included in the help documentation.
Software Version: 2021.xx.xx and newer
...
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Grid Layout |
| ||||||||||||||||
Help |
| ||||||||||||||||
Save & Refresh Save & Close Insert excerpt | | Save/Save & Close - RV Header | Save/Save & Close - RV Header | ||||||||||||||
nopanel | true | Either saves your changes and closes the page or saves your changes and refreshes the contents of the grid based on the selected criteria. The Save button is only activated when a change is detected on the page. When the Save button is active, a ‘ + ‘ character is displayed in the page border. | |||||||||||||||
Fields | Description | ||||||||||||||||
Allocate By | Identifies how the allocation will be assigned. This is a single-select standard lookup that is required to return results. It defaults from the selected option on the Sales Transaction Record View. Else, if the "Allocate Item" option is selected from the Sales Transaction Record View and the selected item (or first item, if there is no selected item) is associated with a Warehouse Lot tracked site, then this field will default to "Allocate by Warehouse Lot". This field is always editable. When this field is updated, the page is saved and the contents of the grid are refreshed based on the selected criteria. This lookup contains the values in the AllocateBy Enumeration Class. Database Field: ERPx_MFAllocateSession.AllocateByEN | ||||||||||||||||
Allocate From | Identifies the name of the Site the item will be allocated from. This is a single-select standard lookup that This is required to return results. It defaults from the 'Ship To' field in the 'Home' tab of the Sales Transaction Record View. This field is always editable while the transaction is in a Status less than 'Approved'. When this field is updated, the page is saved and the contents of the grid are refreshed based on the selected criteria. This lookup contains the value "Transaction Sites", as well as a list of all active Sites where the 'Visible to Sales' property is set to "Yes". If "Transaction Sites"are selected, then lots for all sites on the transaction will be displayed in the grid. Database Fields: ERPx_MFSite.SiteName, ERPx_MFAllocateSession.SiteSK | ||||||||||||||||
Allocated | Displays the total allocated quantity and/or weight of the item. This is a These are non-editable text box boxes that is are sometimes required. It defaults from the 'Alloc. Units' or 'Alloc. Weight' field on the Items grid of the Sales Transaction Record View. This field is never editable. This field is The Allocated Units are required when when the item is managed by "Units Only" or "Units and Weight". The Allocated Weight is required when when the item is managed by "Weight Only" or "Units and Weight". They default from the 'Alloc. Units' and 'Alloc. Weight' field on the Items grid of the Sales Transaction Record View. These fields are for information only and are never editable. These fields are updated when 'Units' or 'Weight' field is fields are changed on the page and the user clicks or tabs out of the field. If "Transaction Items" are selected for the 'Item' field, then these fields will display as blank. Database Field: ERPx_SOOrderItemLot.AllocatedUnits, ERPx_SOOrderItemLot.AllocatedWeight | ||||||||||||||||
Item | Displays the item being allocated, displayed as Item ID: Item Description [Sequence] - [Site ID]. This is a single-select standard lookup that is required to return results. This defaults from the selected item in the Items grid of the Sales Transaction Record View. Else if no item was selected, then it defaults from the first item ([Seq. 1]) in the Items grid if of the Sales Transaction Record View. This field is always editable. This When this field is for information only. This lookup contains the value "Transaction Items", as well as a list of all items entered on the transaction. If "Transaction Items" is selected, then lots for all items on the transaction will be displayed in the grid. Database Fields: ERPx_IMItem.ItemID:ItemDescription, ERPx_SOOrderItem.ItemSort, ERPx_MFSite.SiteID, ERPx_SOOrderItem.OrderItemSK | ||||||||||||||||
Lot Owners |
The lookup contains a list of all Lot Owners. Database Fields: ERPx_IMLotOwner.OwnerName, ERPx_MFAllocateSession.LotOwners | ||||||||||||||||
Ordered | Displays the total ordered quantity and/or weight of the item . This isand the associated units of measure. These are a non-editable text boxboxes that isare sometimes required. It defaults from the 'Ord. Units' or 'Ord. Weight' field on theThe Ordered Units are required when when the item is managed by "Units Only" or "Units and Weight". The Ordered Weight is required when when the item is managed by "Weight Only" or "Units and Weight". The quantity/weight defaults from the 'Ord. Units' and 'Ord. Weight' field on the Items grid of the Sales Transaction Record View. This field is never editableThe UOMs default from the 'Units UOM' and 'Weight UOM' fields on the Items grid of the Sales Transaction Record View. These fields are for information only and are never editable. If "Transaction Items" are selected for the 'Item' field, then these fields will display as blank. Database Fields: ERPx_SOOrderItem.OrderedUnits, ERPx_SOOrderItem.OrderedWeight , ERPx_IMUOM.UOMName, ERPx_SOOrderItem.WeightUOMSK | ||||||||||||||||
Show Lots | Identifies the type of lots to be displayed in the grid on the page. This is a multi-select standard lookup that is required to return results. The Save & Refresh toolbar icon must be clicked to update the grid section when this field has been changed. If the transaction Status is less than 'Approved', then this field defaults with "Allocated" and "Available" options selected. Else if the transaction Status of 'Approved' or greater, then this field defaults with the "Allocated" option selected. This field is always editable while the transaction is in a Status less than 'Approved'. This lookup contains the values in the MFAllocateShowLots Enumeration Class. Database Field: ERPx_MFAllocateSession.MFAllocateShowLotsEN | ||||||||||||||||
Unallocated | Displays the quantity and/or weight of the item which has been ordered, but not allocated. This is a These are non-editable text box that is required. It is calculated as [Ordered] - [Allocated]. It defaults boxes that are sometimes required. The Unallocated Units are required when when the item is managed by "Units Only" or "Units and Weight". The Unallocated Weight is required when when the item is managed by "Weight Only" or "Units and Weight". These fields default from the 'Ord. Units' or 'Ord. Weight' field on the Items grid of the Sales Transaction Record View if there are no allocated units/weight for the item. This field is never editable. This field is Else, they are calculated as [Ordered Units] - [Allocated Units] and [Ordered Weight] - [Allocated Weight]. These fields are never editable. These fields are updated when 'Units' or 'Weight' field is changed on the page and the user clicks or tabs out of the field. This field is These fields are for information only and not stored in the database. If "Transaction Items" are selected for the 'Item' field, then these fields will display as blank. |
Page Details
Allocate by Warehouse Lot Tab
Toolbar Icons | Description | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||||||||||||||
View Open Transactions View Posted Transactions View All Transactions | Displays a single-select standard lookup of related drill-through inquiries. The list of options includes:
There was a dev item was pulled from the release several weeks ago that addressed these options. Per JS, this will be addressed when the work is done on sales orders. | ||||||||||||||||||||
Fields | Description | ||||||||||||||||||||
Allocate | Checking this check box auto-populates the 'Unallocated' Unit Units and/or Weight quantities from the header to the 'Units' and/or 'Weight' fields in the selected row. Unchecking the check box removes any 'Units' and 'Weight' quantities previously entered. This field is not required and is always editable while the transaction is in a Status less than 'Approved'. This field is for information only and not stored in the database. Checking the check box will not over allocate the lot. Additionally, the maximum quantities populated in the 'Units' and/or 'Weight' fields will not exceed the 'Available Units' and/or 'Available Weight' quantities. | ||||||||||||||||||||
Available Units | Displays the total available units of the item at the corresponding Warehouse Lot. This is a non-editable text box that is sometimes required. It is required when the item is managed by "Units Only" or "Units and Weight". It is a calculated field that is never editable. This field is for information only and not stored in the database. | ||||||||||||||||||||
Available Weight | Displays the total available weight of the item at the corresponding Warehouse Lot. This is a non-editable text box that is sometimes required. It is required when the item is managed by "Weight Only" or "Units and Weight". It is a calculated field that is never editable. This field is for information only and not stored in the database. | ||||||||||||||||||||
Item: Description |
Item ID & Item Description | nopanel | true |
Database Fields: ERPx_IMItem.ItemID:ItemDescription, ERPxERPx_SOOrderItem.ItemSort, ERPx_MFSite.SiteID, ERPx_SOOrderItem.OrderItemSK | |||||||||||||||||
Lot Exceptions | Identifies the reason lot certification do not match the item's requested certification , to provide more additional information as to why allocations cannot be made. This is a non-editable text box that is not required. It defaults as blank. If a lot exception exists, the warehouse lot row in the grid will be disabled. This field is never editable. This field is for information only and not stored in the database. This field may display the following:
| ||||||||||||||||||||
On Hand Units | Displays the total on hand units of the item at the corresponding Warehouse Lot. This is a non-editable text box that is sometimes required. It is required when the item is managed by "Units Only" or "Units and Weight". It is a calculated field that is never editable. This field is for information only and not stored in the database. | ||||||||||||||||||||
On Hand Weight | Displays the total on hand weight of the item at the corresponding Warehouse Lot. This is a non-editable text box that is sometimes required. It is required when the item is managed by "Weight Only" or "Units and Weight". It is a calculated field that is never editable. This field is for information only and not stored in the database. | ||||||||||||||||||||
Owner | Identifies a the Lot Owner of the item at the corresponding Warehouse Lot. This is a non-editable text box that is required. It defaults from the Lot Owner selected when the Warehouse Lot was created. This field is never editable.
Database Fields: ERPx_IMLotOwner.OwnerName, ERPx_MFAllocateSession.LotOwnersIMLotBalance.LotOwnerSK, ERPx_SOOrderItem.ItemSK | ||||||||||||||||||||
Site | Identifies the Site ID of the item at the corresponding Warehouse Lot. This is a non-editable text box that is required. It defaults from the Site selected when the Warehouse Lot was created. This field is never editable.
Database Fields: ERPx_MFSite.SiteID, ERPx_MFAllocateSessionIMLotBalance.SiteSK, ERPx_SOOrderItem.ItemSK | ||||||||||||||||||||
Site Name | Identifies the name of the Site of the item at the corresponding Warehouse Lot. This is a non-editable text box that is required. It defaults from the Site selected when the Warehouse Lot was created. This field is never editable.
Database Fields: ERPx_MFSite.SiteName, ERPx_MFAllocateSessionIMLotBalance.SiteSK, ERPx_SOOrderItem.ItemSK | ||||||||||||||||||||
Units | Identifies the number of units of the item to allocate to the corresponding Warehouse Lot. This is a numeric text box that is required to make an allocation if it is editable. It defaults as "0.00". This field is only editable if the item is managed by units and weight or units only and the transaction is in a Status less than 'Approved'. It defaults as "0.00". The value entered in this field must be greater than or equal to 0. If the item is managed by units and weight, then when a value is entered in this field, the 'Weight' field will automatically be populated. Database Field: ERPx_SOOrderItem.AllocatedUnits | Units UOM | excerpt-include If the 'Stop over allocating for [lot tracked] or [non lot tracked] items based on' sales preference is set to "Available Only" or "Available and On Hand" and the 'Units' quantity is greater than the 'Available Units' field or the 'Weight' is greater than the 'Available Weight' field, then the message "Based upon the available quantities for the Warehouse Lot, auto allocation was unable to be completed and has resulted in an under allocation of product. Please change the Allocate By to Inventory Lot to complete the allocations." will be displayed on Save. Database Field: ERPx_SOOrderItem.AllocatedUnits | ||||||||||||||||||
Units UOM |
Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.UnitUOMSK | ||||||||||||||||||||
Warehouse Lot |
Database Fields: ERPx_IMWarehouseLot.WarehouseLotID, ERPx_IMLotBalance.WarehouseLotSK | ||||||||||||||||||||
Weight | Identifies the weight quantity of the item to allocate to the corresponding Warehouse Lot. This is a numeric text box that is required to make an allocation if it is editable. it is editable. This field is only editable if the item is managed by units and weight or weight only and the transaction is in a Status less than 'Approved'. It defaults as "0.00". This field is only editable if The value entered in this field must be greater than or equal to 0. If the item is managed by units and weight or weight only and the transaction is in a Status less than 'Approved'. The value entered in this field must be greater than or equal to 0. If the item is managed by units and weight, then when a value is entered in this field, the 'Units' field will automatically be populated, then when a value is entered in this field, the 'Units' field will automatically be populated. If the 'Stop over allocating for [lot tracked] or [non lot tracked] items based on' sales preference is set to "Available Only" or "Available and On Hand" and the 'Units' quantity is greater than the 'Available Units' field or the 'Weight' is greater than the 'Available Weight' field, then the message "Based upon the available quantities for the Warehouse Lot, auto allocation was unable to be completed and has resulted in an under allocation of product. Please change the Allocate By to Inventory Lot to complete the allocations." will be displayed on Save. Database Field: ERPx_SOOrderItem.AllocatedWeight | ||||||||||||||||||||
Weight UOM |
Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.WeightUOMSK |
...