Behavior of RPM_Future_Retail table when retails of transaction level item vary
When I create a new Level 1 item in RMS where the Level 2 (transaction) level items have different retails, what is expected to show in RPM_Future_Retail table after the NewItemLocation batch runs?
Consider the following high-level scenarios (assume locations are ranged during creation):
Scenario 1:
Create Level 1 (Style) item having $60.00 Retail
Create 3 Level 2 (SKU) transaction items underneath that Style
SKU A has $60.00 retail
SKU B has $50.00 retail
SKU C has $40.00 retail
Approve both Style and SKU.
Scenario 2:
Create Level 1 (Style) item having $0.00 Retail
Create 3 Level 2 (SKU) transaction items underneath that Style
SKU A has $60.00 retail
SKU B has $50.00 retail
SKU C has $40.00 retail
Consider the following high-level scenarios (assume locations are ranged during creation):
Scenario 1:
Create Level 1 (Style) item having $60.00 Retail
Create 3 Level 2 (SKU) transaction items underneath that Style
SKU A has $60.00 retail
SKU B has $50.00 retail
SKU C has $40.00 retail
Approve both Style and SKU.
Scenario 2:
Create Level 1 (Style) item having $0.00 Retail
Create 3 Level 2 (SKU) transaction items underneath that Style
SKU A has $60.00 retail
SKU B has $50.00 retail
SKU C has $40.00 retail
0