Get Short Item Number
Description
Efficiently retrieve the Short Item Number given the 2nd Item Number. This negates the need to join the Item Master table to your report.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| 2nd Item Number | Column or Literal | ✔ |
Remarks
This method will retrieve the Short Item Number (ITM) from the Item Master (F4101) using the value of the 2nd Item Number (LITM).
Example
- Input: 2nd Item Number (2001)
- Quick Calculations > JDE > Get Short Item Number
- Output: Returns Primary Short Item Number (60062)