Inventory Sku Substitution
Module: Inventory
Path: Company Data > Inventory>Inventory Items List
Topic: Inventory Sku Substitution
Version(s): Version 5.1 and up
Editions: Commerce & Call Center
Inventory can be exchanged, one SKU for another, when inventory is allocated to order items. Virtually any criteria related to the order can be used to determine if a SKU substitution is performed. Also, inventory specific criteria such as the depletion of an original SKU or the date of allocation can be taken into consideration.
(Available in Commerce & Call Center Edition)
Internal Code Modification
(SKU Substitution is currently turned off in all editions)
Ticket Title : CJN-745-22253
Description: 5.1 Sku Substitution Feature
Inventory Sku Substitution should appear only in case of Non-Standard edition but not in Standard Edition.
Fixed: Inventory SKU Substitution was throwing error, as it was not loading data properly in case of non-standard edition.
Ticket Title : CJN-745-22253
Description: 5.1 Sku Substitution Feature
Inventory Sku Substitution should appear only in case of Non-Standard edition but not in Standard Edition.
Fixed: Inventory SKU Substitution was throwing error, as it was not loading data properly in case of non-standard edition.
Internal Code Modifications
Ticket Title : None
Internal Code Modifications
Disabled Customer Alerts & SKU substitution features, for review for further review. Note, most of the changes are linked with feature 5.2 as a way to disable them for now, but they may be released earlier.
Internal Code Modifications
Disabled Customer Alerts & SKU substitution features, for review for further review. Note, most of the changes are linked with feature 5.2 as a way to disable them for now, but they may be released earlier.
Internal code modification
[Release notes]
Ticket Title : OVC-851-76181
Description: 5.1 Inventory SKU Substitution improvements
1. On the Inventory Item Screen, Reverse the ordering of the priority numbers
2. On the Inventory Item screen, add detail in a tool tip about what conditions make up a rule.
3. On Inventory SKU Substitution Popup, display a summary of rules (when type other is selected)
4. Add fields to track the original SKU when substitutions take place
5. Order & Customer Detail screen substitution details
6. Inventory SKU Substitution configuration report
7. Bug fix & enhancement. , SKU substitution popup does not work when invoked from Product Offer screen.
Add new field named "origInvItemID" to table named "tblOrderDetailInventoryItem"
Add new field named "subrule" to table named "tblOrderDetailInventoryItem"
Ticket Title : OVC-851-76181
Description: 5.1 Inventory SKU Substitution improvements
1. On the Inventory Item Screen, Reverse the ordering of the priority numbers
2. On the Inventory Item screen, add detail in a tool tip about what conditions make up a rule.
3. On Inventory SKU Substitution Popup, display a summary of rules (when type other is selected)
4. Add fields to track the original SKU when substitutions take place
5. Order & Customer Detail screen substitution details
6. Inventory SKU Substitution configuration report
7. Bug fix & enhancement. , SKU substitution popup does not work when invoked from Product Offer screen.
Add new field named "origInvItemID" to table named "tblOrderDetailInventoryItem"
Add new field named "subrule" to table named "tblOrderDetailInventoryItem"
Additional Notes:
run job every day? set schedule so not having to do manually each time - recommended by Justin
before prepayment processing
spoke with Soty with regard to portal and sku reconciliation
additional feature made to support this with portal
Disabled by default
The Inventory Sku Substitution feature will allow one SKU to be
replaced with another SKU based on various different conditions if
inventory is assigned to base OLX items and is managed in the
Inventory Items List.
Navigate to Inventory>Inventory Items List then click on the inventory item you wish to enable the substitution feature for.
Once you click on the substitution tab you will see the button
that will allow you to then choose what inventory sku should replace
the current one if the desired conditions are met and if you choose to
you can also have multiple sku's that have different conditions of
replacement.
The first criteria you can choose to use is to ""always""
replace the current sku with the chosen as seen below:
You can also establish if there is a certain date range that you wish
to have the substitution occur or enter a far reaching date as you
can see defaulted above which equates to not stopping the replacement.
The choices for the ""based on"" date type are ""inventory commit date""
which is defaulted or you can also choose order date:
The original sku will be in a ""read only"" view and can not be
modified and then you want to select which sku will be the
replacement"" sku from the drop down list of all of the inventory
items that are currently set up.
The next ""criteria"" option that you
have is to replace the sku only when the original sku is depleted and
all of the remaining options stay the same:
The final criteria you can choose is the ""other"" option where you can
customize various reasons to replace the original inventory sku.
(Need to come back to screenshot after bug fix)
Related Articles
5.1.378 - Inventory SKU Substitution
Version: 5.1 Patch: 378 Title: Inventory SKU Substitution Application Category: Other, Inventory Patch Type: Feature Description: Reactivate feature originally described in patch #5.1.16, but not formally introduced now. Original note: Inventory can ...5.1.49 - Inventory SKU Import Fix
Version: 5.1 Patch: 049 Title: Inventory SKU Import Fix Application Category: Import Processing; Order Entry; Other Patch Type: Bug Description: Fixed issue with Inventory SKU Import, where the names of existing SKU's would be erased when importing ...Inventory Items
Module: Inventory Path: Products > Inventory > Inventory Item List Topic: Inventory Items Version(s): Version 5.1 and up Editions: All Editions What Are Inventory Items The core element of the OrderLogix inventory system is the Inventory Item that ...R20.3 p12 - Inventory SKU import new functionality
Version: 5.1 Release Number: R20.3 Patch: 12 Title: Inventory SKU import new functionality Application Category: Other, Import Processing, Inventory Patch Type: Feature Description: Add two new fields to Spec of InventorySKUAssociation import. Client ...Adjust Inventory
Module: Inventory Path: Products>Inventory>Adjust Inventory Topic: Adjust Inventory Version(s): Version 5.1 and up Editions: All Editions What Is Adjust Inventory The adjust inventory screen allows manual adjustments to inventory items according to ...