Walkthrough: Item weight integration
Overview
Use this walkthrough to verify that changes to weight fields on the Item Card page update the correct values and that the Calculate Weights action correctly updates the corresponding Unit of Measure (UOM) lines in all four supported scenarios. The following two setup options control this behavior:
| Flag | Page | Values |
|---|---|---|
| Automatic Gross Weight | Standard Measurement Setup | ON / OFF |
| Sync Weight to Item UOM | Foundation Setup (Drink-IT) | Net / Gross |
These two flags combine into four scenarios:
| Scenario | Auto Gross | Sync Weight | Expected result |
|---|---|---|---|
| 1a | OFF | Net | Net Weight |
| 1b | OFF | Gross | Gross Weight |
| 2a | ON | Net | Net + auto-computed Gross + Tare |
| 2b | ON | Gross | Gross + recalculated Tare |
Prerequisites
Before you start any scenario, ensure the following:
- Extensions installed: Standard Measurements (MEA), Foundation Management (FND), Drink-IT base.
- Test item: An item with at least one base UOM and one alternate UOM configured (e.g., PCS as base, BOX as alternate with conversion factor = 6).
- Item card weight values pre-set:
- Net Weight = e.g.,
1.000 - Gross Weight = e.g.,
1.200 - Tare = Gross - Net =
0.200(derived, not manually entered)
- Net Weight = e.g.,
- The flag
UpdateItemUOMWithItemChangeis FALSE (default in all DIT deployments - no action needed).
Setup Steps
Step 1 - Configure Standard Measurement Setup
- Select the Search icon
, enter Standard Measurement Setup, and then choose the related link. - In the Automatic Gross Weight field, select OFF (for Scenarios 1a and 1b) or ON (for Scenarios 2a and 2b).
- Close the page.
Step 2 - Configure Foundation Setup (Drink-IT)
- Select the Search icon
, enter Foundation Setup, and then choose the related link. - In the Sync Weight to Item UOM field, select Net (for Scenarios 1a and 2a) or Gross (for Scenarios 1b and 2b).
- Close the page.
Scenario 1a - Auto Gross OFF, Sync Weight = Net
Setup: Automatic Gross Weight = OFF | Sync Weight to Item UOM = Net
Part A: Update Net Weight on Item Card
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Net Weight field, enter
1.000, and then press Tab to confirm. - In the Gross Weight field, enter
1.200, and then press Tab to confirm. - Choose the Units of Measure action.
-
Verify the Net Weight and Gross Weight fields on the base UOM line (e.g., PCS):
-
Net Weight =
1.000 - Gross Weight =
1.200
Part B: Calculate Weights Reads Tare from Item Card
- Choose the Units of Measure action.
- On the Items Units of Measure page, choose the Calculate Weights action.
- Verify the values on the base UOM line (PCS):
| Field | Expected Value | Derivation |
|---|---|---|
| Net | 1.000 | Item card Net Weight |
| Tare | 0.200 | Item card Gross (1.200) - Item card Net (1.000) |
| Gross | 1.200 | Item card Gross Weight |
Part C: Calculate Weights Scales Alternate UOM Lines
Prerequisite: Alternate UOM line BOX exists with conversion factor = 6.
Continuing from Part B, verify the values on the alternate UOM line (BOX):
| Field | Expected Value | Derivation |
|---|---|---|
| Net | 6.000 | Base Net (1.000) x 6 |
| Tare | 1.200 | Base Tare (0.200) x 6 |
| Gross | 7.200 | Base Gross (1.200) x 6 |
Scenario 1b - Auto Gross OFF, Sync Weight = Gross
Setup: Automatic Gross Weight = OFF | Sync Weight to Item UOM = Gross
Part A: Update Gross Weight on Item Card
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Gross Weight field, enter
1.200, and then press Tab to confirm. - In the Net Weight field, enter
1.000, and then press Tab to confirm. - Choose the Units of Measure action.
-
Verify the Net Weight and Gross Weight fields on the base UOM line (e.g., PCS):
-
Net Weight =
1.000 - Gross Weight =
1.200
Part B: Calculate Weights - Correct Net, Tare, Gross
- Choose the Units of Measure action.
- On the Items Units of Measure page, choose the Calculate Weights action.
- Verify the values on the base UOM line (PCS):
| Field | Expected Value |
|---|---|
| Gross | 1.200 |
| Net | 1.000 |
| Tare | 0.200 |
- Verify the values on the alternate UOM line (BOX, conversion = 6):
| Field | Expected Value |
|---|---|
| Gross | 7.200 |
| Net | 6.000 |
| Tare | 1.200 |
Scenario 2a - Auto Gross ON, Sync Weight = Net
Setup: Automatic Gross Weight = ON | Sync Weight to Item UOM = Net
Part A: Update Net Weight on Item Card - Auto Gross Computed
Prerequisite: Item card has an existing Tare Weight, e.g., 0.200 (= stored Gross 1.200 - Net 1.000).
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Net Weight field, enter
1.500, and then press Tab to confirm. - Verify the values on the Item card:
| Field | Expected Value | Derivation |
|---|---|---|
| Net Weight | 1.500 | Entered value |
| Gross Weight | 1.700 | Net (1.500) + Tare (0.200) - auto-computed |
| Tare | 0.200 | Unchanged |
- Choose the Units of Measure action.
-
Verify the Net Weight and Gross Weight fields on the base UOM line (e.g., PCS):
-
Net Weight =
1.500 - Gross Weight =
1.700
Part B: Calculate Weights Scales UOM Lines Correctly
- Choose the Units of Measure action.
- Choose the Calculate Weights action.
- Verify the values on the base UOM line (PCS):
| Field | Expected Value |
|---|---|
| Net | 1.500 |
| Tare | 0.200 |
| Gross | 1.700 |
- Verify the values on the alternate UOM line (BOX, factor = 6):
| Field | Expected Value |
|---|---|
| Net | 9.000 |
| Tare | 1.200 |
| Gross | 10.200 |
Scenario 2b - Auto Gross ON, Sync Weight = Gross
Setup: Automatic Gross Weight = ON | Sync Weight to Item UOM = Gross
Part A: Update Gross Weight on Item Card - Tare Recalculated
Prerequisite: Item card Net Weight = 1.000, Gross Weight = 1.200.
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Gross Weight field, enter
1.300, and then press Tab to confirm. - Verify the values on the Item card:
| Field | Expected Value | Derivation |
|---|---|---|
| Gross Weight | 1.300 | Entered value |
| Net Weight | 1.000 | Unchanged |
| Tare | 0.300 | Gross (1.300) - Net (1.000) - recalculated |
-
When the fix is applied, Tare =
0.300(recalculated). Without the fix, Tare =0.200(stale value). -
Choose the Units of Measure action.
-
Verify the Net Weight and Gross Weight fields on the base UOM line (e.g., PCS):
-
Net Weight =
1.000 - Gross Weight =
1.300
Part B: Calculate Weights - No Tare = 0 Regression
- Choose the Units of Measure action.
- Choose the Calculate Weights action.
- Verify the values on the base UOM line (PCS):
| Field | Expected Value |
|---|---|
| Gross | 1.300 |
| Net | 1.000 |
| Tare | 0.300 |
- Verify the values on the alternate UOM line (BOX, factor = 6):
| Field | Expected Value | Derivation |
|---|---|---|
| Net | 6.000 | 1.000 x 6 |
| Tare | 1.800 | 0.300 x 6 |
| Gross | 7.800 | 1.300 x 6 |
- When the fix is applied, Tare =
1.800. Without the fix, Tare =0.000on alternate lines.
Non-Base UOM Weight Edit - All Scenarios
This behaviour applies in all four scenarios.
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- Choose the Units of Measure action.
- On the Items Units of Measure page, locate an alternate UOM line (e.g., BOX - not the base UOM).
- In the Weight field, enter any value, and then press Tab to confirm.
-
Verify the result:
-
A notification appears (e.g., "Item card update applies to the base UOM only.").
- The Net Weight and Gross Weight on the item card are unchanged.
- Only the UOM line's local Weight value is stored - no item card writeback occurs.
Summary of Fixes Verified
| Scenario | Defect Fixed | Verification Step |
|---|---|---|
| 1a / 1b | P2 - Calculate Weights reads Tare from item card | Scenario 1a Part B, 1b Part B |
| 2a | Auto Gross correctly computes Gross on Net Weight update | Scenario 2a Part A |
| 2b | P3 - Tare recalculated on Gross Weight update | Scenario 2b Part A |
| All | Non-base UOM: no item card writeback, notification shown | Non-base UOM section |
| All | Alternate UOM lines scale Net, Tare, Gross proportionally | Part B in each scenario |
Quick Reference: Setup Combinations
| Scenario | Standard Measurement Setup | Foundation Setup |
|---|---|---|
| 1a | Automatic Gross Weight = OFF | Sync Weight to Item UOM = Net |
| 1b | Automatic Gross Weight = OFF | Sync Weight to Item UOM = Gross |
| 2a | Automatic Gross Weight = ON | Sync Weight to Item UOM = Net |
| 2b | Automatic Gross Weight = ON | Sync Weight to Item UOM = Gross |
Existing Item Walkthrough
This section covers the same four scenarios using an item that already exists in the system - no pre-set values required. Record the item's current weights first, then use those recorded values as your reference throughout.
Step 1 - Find a Suitable Existing Item
An item is suitable if it meets all of the following:
- Has at least one base UOM and one alternate UOM (e.g., PCS base + BOX alternate).
- Has Net Weight and Gross Weight already filled on the item card (both > 0).
-
Is not a production-critical item - weight edits will be made and should be reverted after testing.
-
Select the Search icon
, enter Items, and then choose the related link. - Filter or browse to an item with UOM lines configured.
- Select the item to open the item card.
- Verify that Net Weight > 0 and Gross Weight > 0 on the item card.
Step 2 - Record Baseline Values
Before making any changes, record the item's current values:
| Field | Recorded Value |
|---|---|
| Item No. | _______________ |
| Base UOM | _______________ |
| Alternate UOM | _______________ |
| Alternate UOM conversion factor | _______________ |
| Item card - Net Weight | _______________ |
| Item card - Gross Weight | _______________ |
| Item card - Tare (= Gross - Net) | _______________ |
Choose the Units of Measure action and record the current Net Weight and Gross Weight values on each UOM line before making any edits.
These recorded values replace the hardcoded example values (1.000 / 1.200 / 0.200) used in the new-item scenarios above. Substitute your recorded values wherever those appear in the steps below.
Step 3 - Configure Setup Flags
Follow the same Setup Steps defined earlier in the main walkthrough to set the two flags per the scenario you are testing.
Existing Item - Scenario 1a (Auto Gross OFF, Sync = Net)
Setup: Automatic Gross Weight = OFF | Sync Weight to Item UOM = Net
Part A: Update Net Weight on Item Card
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Net Weight field, enter a new value (e.g., your recorded Net Weight + 0.500), and then press Tab to confirm.
- Choose the Units of Measure action.
- Verify the Net Weight and Gross Weight fields on the base UOM line reflect the updated item card values.
Part B: Calculate Weights Uses Recorded Tare
- Choose the Calculate Weights action.
- Verify the values on the base UOM line:
| Field | Expected Value |
|---|---|
| Net | your recorded Net Weight |
| Tare | your recorded Gross Weight - your recorded Net Weight |
| Gross | your recorded Gross Weight |
- Verify the values on the alternate UOM line:
| Field | Expected Value |
|---|---|
| Net | recorded Net x conversion factor |
| Tare | recorded Tare x conversion factor |
| Gross | recorded Gross x conversion factor |
Existing Item - Scenario 1b (Auto Gross OFF, Sync = Gross)
Setup: Automatic Gross Weight = OFF | Sync Weight to Item UOM = Gross
Part A: Update Gross Weight on Item Card
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Gross Weight field, enter a new value (e.g., your recorded Gross Weight + 0.200), and then press Tab to confirm.
- Choose the Units of Measure action.
- Verify the Net Weight and Gross Weight fields on the base UOM line reflect the updated item card values.
Part B: Calculate Weights - Correct Net, Tare, Gross
- Choose the Calculate Weights action.
- Verify the values on the base UOM line:
| Field | Expected Value |
|---|---|
| Gross | your recorded Gross Weight |
| Net | your recorded Net Weight |
| Tare | your recorded Gross Weight - your recorded Net Weight |
- Verify the values on the alternate UOM line: all three fields scaled by the conversion factor.
Existing Item - Scenario 2a (Auto Gross ON, Sync = Net)
Setup: Automatic Gross Weight = ON | Sync Weight to Item UOM = Net
Part A: Update Net Weight on Item Card - Auto Gross Computed from Existing Tare
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Net Weight field, enter a new value (e.g., your recorded Net Weight + 0.500). Note this as NewNet, and then press Tab to confirm.
- Verify the values on the Item card:
| Field | Expected Value |
|---|---|
| Net Weight | NewNet |
| Gross Weight | NewNet + recorded Tare |
| Tare | recorded Tare (unchanged) |
- Choose the Units of Measure action.
-
Verify the Net Weight and Gross Weight fields on the base UOM line:
-
Net Weight = NewNet
- Gross Weight = NewNet + recorded Tare
Part B: Calculate Weights Scales Correctly
- Choose the Calculate Weights action.
- Verify the values on the alternate UOM line are scaled by the conversion factor using the updated base values.
Existing Item - Scenario 2b (Auto Gross ON, Sync = Gross)
Setup: Automatic Gross Weight = ON | Sync Weight to Item UOM = Gross
Part A: Update Gross Weight on Item Card - Tare Recalculated from Existing Net
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Gross Weight field, enter a new value (e.g., your recorded Gross Weight + 0.100). Note this as NewGross, and then press Tab to confirm.
- Verify the values on the Item card:
| Field | Expected Value |
|---|---|
| Gross Weight | NewGross |
| Net Weight | recorded Net Weight (unchanged) |
| Tare | NewGross - recorded Net Weight |
-
When the fix is applied, Tare is recalculated. Without the fix, Tare remains unchanged from the recorded value.
-
Choose the Units of Measure action.
-
Verify the Net Weight and Gross Weight fields on the base UOM line:
-
Net Weight = recorded Net Weight
- Gross Weight = NewGross
Part B: Calculate Weights - No Tare = 0 Regression
- Choose the Calculate Weights action.
- Verify the values on the alternate UOM lines show Tare > 0 and correctly scaled by the conversion factor.
Existing Item - Non-Base UOM Weight Edit
This behaviour applies in all four scenarios.
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- Choose the Units of Measure action.
- On the Items Units of Measure page, locate an alternate UOM line (e.g., BOX - not the base UOM).
- In the Weight field, enter any value, and then press Tab to confirm.
-
Verify the result:
-
A notification appears (e.g., "Item card update applies to the base UOM only.").
- The Net Weight and Gross Weight on the item card are unchanged.
Restore After Testing
After completing the scenarios, restore the item to its original state:
- Select the Search icon
, enter Items, and then choose the related link. - Select the test item to open the item card.
- In the Net Weight field, enter your recorded Net Weight value, and then press Tab to confirm.
- In the Gross Weight field, enter your recorded Gross Weight value, and then press Tab to confirm.
- Choose the Units of Measure action.
- Choose the Calculate Weights action to propagate the restored values to all UOM lines.
- Choose Back to return to the Item card and verify that Net Weight, Gross Weight, and Tare match your Step 2 baseline.