Stock Enquiry Transaction

You can use the Stock Enquiry transaction to:

  • View the listed balance IDs
  • View the balance ID details
  • Print putaway label
  • Print item label Print package in stock label
  • Reclassify status, lot, item and allocatable status

This transaction is comprises of these screens:

The Balance ID Options has five available options:

To open the stock enquiry transaction, select a transaction profile associated with the transaction, from the main menu.

Search Balance ID screen

Use this screen to search balance IDs.

Search Balance ID screen parameters

Parameter Name Values Example Default Value
Auto trigger Next when all fields confirmed

0: No

1: Yes

1 0
Search field search sequence

1: Location

2: Item

3: Lot

4: Container

5

6: Outer Package

7: Sublot : Receiving No : Receiving No nullnull

Option 7 (Sublot) is only available for M3 v16 and higher.

 2;3;4 1;2;3;4;5;6
Sequence of filter fields

1: Search

2: Location

3: Item

4: Lot

5: Container

6: Receiving No

7: Outer Package

8: Sublot

Option 8 (Sublot) is only available for M3 v16 and higher.

 1;3;4 1;2;3;4;5;6;7
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.

List Balance ID screen

This screen lists balance IDs based on the search performed in the Search Balance ID screen.

List Balance ID screen parameters

Parameter Name Values Example Default Value
Action when pressing Select

0: List options

1: Print item label

2: Print put-away label

3: Print package in stock label

4: Balance ID Details

5: Reclassify

6: Sublots

7: Attributes

Option 6 (Sublots) is available only for M3 v16 and higher.

 1 0
Auto select first record

0: No

1: Yes, Always

2: Yes - if only one record is listed

3: Yes. If one record in the list after filtering.

  • If set to 2: Auto select is triggered if there is only one record in the list, either when the list is first displayed or after a filter scan.
  • If set to 3: Auto select is triggered if there is one record in the list after a filter scan. Auto select is not triggered if there is one record in the list that is initially displayed.
 1 0
Balance ID status to include:

Any status (multi)

1;2;3

 1;3 Blank (all statuses are included)
Column order

Set columns to display, column order and column width in the format “N=X;N=X;N=X”

N= Column number

X= Fixed width in no of characters or “A” for auto adjust or “D” for default width

This parameter applies only when list is displayed in grid format (not tile format)

  1. Location “Loc”
  2. Item ”Item”
  3. Item name “Item Name”
  4. Quantity ”Quantity”
  5. Unit “U/M”
  6. Lot “Lot”
  7. Container “Cont”
  8. Receiving number “Rec No”
  9. Status “Sts”
  10. Extra info field 1 Parm “Extra info - Labels”
  11. Extra info field 2 Parm “Extra info - Labels”
  12. Extra info field 3 Parm “Extra info - Labels”
  13. Item description "Item Desc"

Default width:

1=10;2=15;3=30;4=12;5=6;6=20;7=20;8=12;9=8;10=20;11=20;12=20; 13=30

1=10;6=A;2=D;4=5;5=3

1=D;2=D;3=D;4=D;5=D;6=D;7=D;8=D;9=D;10=D;11=D;12=D; 13=D
Date display format

Format

0. Relative (+/- no of days from today)

1. YYYYMMDD

2. YYYYDDMM

3. MMYYYYDD

4. MMDDYYYY

5. DDYYYYMM

6. DDMMYYYY

7. YYMMDD

8. YYDDMM

9. MMYYDD

10. MMDDYY

11. DDYYMM

12. DDMMYY

Separator

A. None (Example: “YYMMDD”)

B. Period (Example: “YY.MM.DD”)

C. Dash (Example: “YY-MM-DD”)

D. Slash (Example: “YY/MM/DD”)

E. Space (Example: “YY MM DD”)

 7=B 0
Display item description

0 = No

1 = Yes

If set to 1:

* An extra line with item description is displayed below the item name

* Extra spaces in the item description are removed leaving only single spaces.

This parameter is only available for M3 16+

 1 0
Extra info - Alt unit 1

Options:

Any unit

*WHS (from item/whs MMS002)

No of decimals:

Any number of decimals

*UNIT (alt unit no of decimals in MMS015)

Set parameter in format “Option; No of decimals”

Trailing zeroes in decimals are always removed regardless of setting for no of decimals

Option to display field with quantity in alt unit is activated using “Extra info - Line 1” parameter.

 *WHS;*UNIT or PAL;2 Blank
Extra info - Alt unit 2

Options:

Any unit

*WHS (from item/whs MMS002)

No of decimals:

Any number of decimals

*UNIT (alt unit no of decimals in MMS015)

Set parameter in format “Option; No of decimals”

Trailing zeroes in decimals are always removed regardless of setting for no of decimals

Option to display field with quantity in alt unit is activated using “Extra info - Line 1” parameter.

 *WHS;*UNIT or PAL;2 Blank
Extra info - Alt unit 3

Options:

Any unit

*WHS (from item/whs MMS002)

No of decimals:

Any number of decimals

*UNIT (alt unit no of decimals in MMS015)

Set parameter in format “Option; No of decimals”

Trailing zeroes in decimals are always removed regardless of setting for no of decimals

Option to display field with quantity in alt unit is activated using “Extra info - Line 1” parameter.

 *WHS;*UNIT or PAL;2 Blank
Extra info - Labels

Set alternative label for extra field

Format: N=X;N=X;N=X

N = field number

X = new label, set to *BLANK to display info without label

Label (X) is in upper case by default. Use prefix “^” to use lower case with first character in each word in upper case.

Example: “N=ABC DE” displays as “ABC DE” in the device. “N=^ABC DE” displays as “Abc De”

Fields:

MMS060MI.LstBalID

  1. Lot reference 1 “Ref 1”
  2. Lot reference 2 “Ref 2”
  3. Remark “Remk”
  4. Allocatable “Abl”
  5. Location type “Loc Tp”
  6. Movable net 1 “Allocbl”
  7. Movable net 2 “Movbl”
  8. Allocated quantity “Alloctd”
  9. Catch weight ”CW”
  10. Priority date ”Prio”
  11. Last receipt date ”Rec Dt”
  12. Last issue date ”Is Dt”
  13. Latest phys inv date “Inv Dt”
  14. Phys inv in progress ”Inv Pr”
  15. Reclass date ”Rcl Dt”
  16. Status item ”Itm Sts”
  17. Stock zone “Zone”
  18. ABC class freq “ABC”
  19. Phys Inv no “Inv No”
  20. Outer package no “Out Pkg”
  21. Qty in alt unit 1 “Qty”
  22. Qty in alt unit 2 “Qty”
  23. Qty in alt unit 3 “Qty”

Supported characters in label: "A-Z","a-z", "0-9" and "_" (underscore)

1=BATCH NO;

2=*BLANK;

21=^PKG QTY
Note: “^PKG QTY” displays as “Pkg Qty” in the device

Blank (default labels are used)
Extra info - Line 1

Set maximum of 3 fields to display in the N=X;N=X;N=X format where N is the field number and X=character length (including unit, where applicable).

Tile format: Info is displayed in an extra line

Grid format: Info is displayed as an extra column that is added after existing columns.

Fields:

MMS060MI.LstBalID

  1. Lot reference 1 (BREF) “Ref 1”
  2. Lot reference 2 (BRE2) “Ref 2”
  3. Remark (BREM) “Remk”
  4. Allocatable (ALOC) “Abl”
  5. Location type (WHLT) “Loc Tp”
  6. Movable net 1 (MVB1) “Allocbl” + Unit
  7. Movable net 2 (MVB2) “Movbl” + Unit
  8. Allocated quantity (ALQT) “Alloctd” + Unit
  9. Catch weight (CAW2) ”CW” + CW Unit
  10. Priority date (PRDT) ”Prio”
  11. Last receipt date (IDDT) ”Rec Dt”
  12. Last issue date (ODDT) ”Is Dt”
  13. Latest phys inv date (INDT) “Inv Dt”
  14. Phys inv in progress (INON) ”Inv Pr”
  15. Reclass date (RCLS) ”Rcl Dt”
  16. Status item (STAT) ”Itm Sts”
  17. Stock zone (SLTP) “Zone”
  18. ABC class freq (ABFC) “ABC”
  19. Phys Inv no (STNB) “Inv No”
  20. Outer package no (OPAN) “Out Pkg”
  21. Qty in alt unit 1 (N/A) “Qty”
  22. Qty in alt unit 2 (N/A) “Qty”
  23. Qty in alt unit 3 (N/A) “Qty”

Fields Qty in alt unit N (21/22/23): Displays quantity set in “Quantity to display” parameter re-calculated into alternate unit set in “Extra info - Alt unit N” parameter. Quantity in three different alternate units can be displayed. Quantity in alternate unit is only displayed if all records in the List Balance ID screen is for the same item.

Date fields (10-15): Date format is controlled by “Date display format” parameter.

 10=12;9=12;1=15 or 10=23;1=12 or 3=105 Blank
Hide non-allocatable balance identities

0: No

1: Yes

Note: If set to 1; Balance ID is hidden if ID is not allocatable or if allocatable net is 0.
0 1
Potency - Quantity display

0: Normal potency quantity

1: Physical quantity

If set to 1: For potency managed items the quantity is displayed as physical quantity instead of normal quantity.

 1 0
Quantity to display

0: Total on-hand balance

1: Allocatable (On-hand balance - Allocated qty)

2: Movable (On-hand balance - Pick list qty - Pending putaway qty)

1 0
Sorting Order

Set maximum of 10 fields to sort by N=X;N=X format where N is the field number and X=A for ascending or X=D for descending.

Logic:

  • A: Ascending
  • D: Descending

Fields:

MMS060MI.LstBalID

  1. Item number (ITNO)
  2. Item name (ITDS)
  3. Location (WHSL)
  4. Lot number (BANO)
  5. Container (CAMU)
  6. Lot reference 1 (BREF)
  7. Lot reference 2 (BRE2)
  8. Remark (BREM)
  9. Status - balance ID (STAS)
  10. Allocatable (ALOC)
  11. Stock zone (SLTP)
  12. Location type (WHLT)
  13. On-hand balance approved (STQT)
  14. Movable net 1 (MVB1)
  15. Movable net 2 (MVB2)
  16. Allocated quantity - basic U/M (ALQT)
  17. Basic unit of measure (UNMS)
  18. Catch weight (CAW2)
  19. Priority date (PRDT)
  20. Last receipt date (IDDT)
  21. Last issue date (ODDT)
  22. Latest physical inventory date (INDT)
  23. Physical inventory in progress (INON)
  24. Reclassification date (RCLS)
  25. Status item (STAT)
  26. Receiving number (REPN)
 19=A;3=D;4=A;5=A 1=A;3=A;4=A;5=A

(Item/Location/Lot/Container)
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.

Balance ID Details screen

Use this screen to display detailed information of the balance ID selected in the List Balance ID screen.

Balance ID Details screen parameters

Parameter Name Values Example Default Value
Date display format

Format

0. Relative (+/- no of days from today)

1. YYYYMMDD

2. YYYYDDMM

3. MMYYYYDD

4. MMDDYYYY

5. DDYYYYMM

6. DDMMYYYY

7. YYMMDD

8. YYDDMM

9. MMYYDD

10. MMDDYY

11. DDYYMM

12. DDMMYY

Separator

A. None (Example: “YYMMDD”)

B. Period (Example: “YY.MM.DD”)

C. Dash (Example: “YY-MM-DD”)

D. Slash (Example: “YY/MM/DD”)

E. Space (Example: “YY MM DD”)

 7=B 0
Display item description

0 = No

1 = Yes

If set to 1:

* An extra line with item description is displayed below the item name

* If item description is blank the extra line will not display

* Extra spaces in the item description are removed leaving only single spaces.

This parameter is only available for M3 16+

 1 0
Potency - Quantity display

0: Normal potency quantity

1: Physical quantity

If set to 1: For potency managed items quantities are displayed as physical quantity instead of normal quantity. Applies to the following fields:

  • On-hand quantity
  • Allocated quantity
  • Allocatable quantity
  • Movable quantity
 1 0
Sequence of input fields

1: Item number

2: Location

3: Lot

4: Container

5On-hand quantity

6: Allocated quantity

7: Allocatable quantity

8: Movable quantity

9

10: Stock Zone

11: Status - balance ID

12: Allocatable

13: ABC class - frequency

14: Physical inventory in progress

15: Physical inventory number

16: Latest physical inventory date

17: Last receipt date

18: Last issue date

19: Priority date

20: Lot reference 1

21: Lot reference 2

22: Remark

23: Catch weight

24: Outer Package

1;2;3;4;7 1;2;3;4;6;7; 8;9;10;11;12;13; 14;15;16;17;18; 19;20;21;22;23;24
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.

Balance ID Options screen

This screen lists the options that can be used for the selected balance ID in the List Balance ID screen.

Balance ID Options screen parameters

Parameter Name Values Example Default Value
Sequence of options

1: Print item label

2: Print put-away label

3: Print package in stock label

4: Balance ID details

5: Reclassify

6: Sublots

7: Attributes

Option 6 (Sublots) is available only for M3 v16 and higher.

 1;4;5 1;2;3;4;5
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.

Print Putaway Label/Print Label screen

Use this screen to print a putaway label for the selected balance ID.

Print Putaway Label/Print Label screen parameters

Parameter Name Values Example Default Value
Auto confirm input field data

1: Quantity

2: Printer

3: No. of Copies

4: Layout

A: No. Requires confirmation by scanning or by entering the data

B: Yes. The value is confirmed automatically.

C: Yes. The value is confirmed automatically, if the suggested data is not Blank

D: Yes. The value is confirmed automatically, if the suggested data is Blank

Note:  If no value is suggested for a mandatory field, the user must scan a value regardless of how this parameter is configured.

1=B;2=B

1=A;2=A;3=A;4=A

:Auto trigger Next when all fields confirmed

0: No

1: Yes

1 0
Display item description

0 = No

1 = Yes

If set to 1:

* An extra line with item description is displayed below the item name

* If item description is blank the extra line will not display

* Extra spaces in the item description are removed leaving only single spaces.

This parameter is only available for M3 16+

 1 0
Layout browse - Layouts to include Any layout

Format: Number=Description;Number Description etc.

The selected layout (number only) is sent as input in the MMS060MI.PrtPutAwayLbl USD1 field when printing a label.

 1=Small box label; 2=Pallet label; 5=Big box label Blank
Mandatory input fields

1: Printer

2: No of Copies

3: Layout

 1;2;3 Blank
Numeric keypad - Activate negative sign

1: Quantity

2: No. of Copies

A: No

B: Yes

 1=A 1=A;2=A
Numeric keypad– Enable

1: Quantity

2: No. of Copies

A: No

B: Yes

C: Yes, auto display

 1=A 1=B;2=B
Populate scan field with suggested data

1: Quantity

2: Printer

3: No. of Copies

4: Layout

 1;2 Blank
Printer browse - Printers to include

Any printer (multiple and/or range)

or

Printer group (format *GRP=X where X=Modification field in CRS290

or

*All (include all, overrides any printer group set in FT admin Users form)

Note: There is no specific M3 field for Printer group. The Modification field in CRS290 is used as printer group.

If this parameter is selected, the printers defined in this parameter are only allowed.

If this parameter is cleared (blank), the Printer group defined in the Printer group - Label Printer field of the User parameters tab displayed in the FTUsersMaint screen for the Factory Track admin is used. If the group is not defined for the current user, all the printers are available for printing.

 PRT01;PRT13-PRT26;PRT87

or

*GRP=PG1

or

*ALL

Blank (all warehouses are included)
Screen to display after report

1: Search balance identity

2: List balance identity

3: Balance ID options

4: Print putaway label (same record)

Note: 
  • If this parameter is set to 3 and the Action when pressing Selectparameter is set to 0 (List options), the Balance ID options screen is displayed. If this setting is not updated, the List balance ID screen is displayed.
  • If this parameter is set to 4, the same screen (Print item label) is displayed with the same record.
  • If set to 1 and Stock Enquiry was opened through BAL ID function of Flex Move transaction, Report Move screen of Flex Move transaction is displayed as it was when function was triggered.
 1 2
Sequence of input fields
  1. Location
  2. Item
  3. Lot
  4. Container
  5. Receiving No
  6. Qty
  7. Printer
  8. No. of Copies
  9. Layout
 1;2;3;6;7 1;2;3;4;5;6;7;8
Suggest data for input field Layout

Any layout

Note: Layout must be set in Layout browse - Layouts to include parameter.
 2 Blank
Suggest data for input field Printer Any Printer
Note: If no printer is set, the printer from User Settings is suggested.
 PRINTER01 Blank
Suggest data for input field No of Copies Numeric 2 Blank
Verify input field suggested data

1: Quantity

2: Printer

3: No. of Copies

4: Layout

A: No. The scanned value is not verified against the suggested value.

B: Yes. A warning message is displayed if the scanned value does not match the suggested value.

C: Yes. A warning message is displayed if the scanned value is greater. If this parameter is selected, the printers defined in this parameter are only allowed.: Yes. A warning message is displayed if the scanned value is greater.

Dnull: Yes. A warning message is displayed if the scanned value is less than the suggested value.

E: Yes. The scanned value must match the suggested value.

F: Yes. The scanned value cannot be greater than the suggested value.

G: Yes. The scanned value cannot be less than the suggested value.

H: Yes. The scanned value cannot be less than the suggested value. A warning message is displayed if the scanned value is greater than the suggested value.

I: Yes. The scanned value cannot be greater than the suggested value. A warning message is displayed if the scanned value is less than the suggested value.

Note: Values C, D, F, G, H and I are only applicable for numeric input fields.

1=A;2=B

1=C;2=A;3=A;4=A

Note: 

Print Item Label Screen

Use this screen to print an item label for the selected balance ID.

Print Item Label screen parameters

Parameter Name Values Example Default Value
Auto confirm input field data

1: Printer

2: No of Copies

3: Layout

A: No. Requires confirmation by scanning or by entering the data

B: Yes. The value is confirmed automatically.

C: Yes. The value is confirmed automatically, if the suggested data is not Blank

D: Yes. The value is confirmed automatically, if the suggested data is Blank

Note:  If no value is suggested for a mandatory field, the user must scan a value regardless of how this parameter is configured.
1=B;2=B 1=A;2=A;3=A
Auto trigger Next when all fields confirmed

0: No

1: Yes

1 0
Display item description

0 = No

1 = Yes

If set to 1:

* An extra line with item description is displayed below the item name

* If item description is blank the extra line will not display

* Extra spaces in the item description are removed leaving only single spaces.

This parameter is only available for M3 16+

 1 0
Layout browse - Layouts to include

Any layout

Format: Number=Description;Number Description etc.

The selected layout (number only) is sent as an input in the MMS200MI.PrtItemLabel USD1 field when printing a label.

 1=Small box label; 2=Pallet label; 3=Big box label Blank
Mandatory input fields

1: Printer

2: No of Copies

3: Layout

 1;2;3 Blank
Numeric keypad - Activate negative sign

1: No of Copies

A: No

B: Yes

 1=B 1=A
Numeric keypad - Enable

1: No of Copies

A: No

B: Yes

C: Yes and displayed automatically when the field is selected.

 1=C 1=B
Populate scan field with suggested data

1: Printer

2: No of Copies

3: Layout

 1 Blank
Printer browse - Printers to include

Any printer (multiple and/or range)

or

Printer group (format *GRP=X where X=Modification field in CRS290

or

*All (include all, overrides any printer group set in FT admin Users form)

Note: There is no specific M3 field for Printer group. The Modification field in CRS290 is used as printer group.

If this parameter is cleared (blank), the Printer group defined in the Printer group - Label Printer field of the User parameters tab displayed in the FTUsersMaint screen for the Factory Track admin is used. If the group is not defined for the current user, all the printers are available for printing.

 PRT01;PRT13-PRT26;PRT87

or

*GRP=PG1

or

*ALL

Blank (all warehouses are included)
Screen to display after report

1: Search balance identity

2: List balance identity

3: Balance ID options

4: Print item label (same record)

Note: 
  • If this parameter is set to 3 and the Action when pressing Selectparameter is set to 0 (List options), the Balance ID options screen is displayed. If this setting is not updated, the List balance ID screen is displayed.
  • If this parameter is set to 4, the same screen (Print item label) is displayed with the same record.
  • If set to 1 and Stock Enquiry was opened through BAL ID function of Flex Move transaction, Report Move screen of Flex Move transaction is displayed as it was when function was triggered.
 1 2
Sequence of input fields

1: Item

2: Printer

3: No of Copies

4: Layout

 1;3;2 1;2;3
Suggest data for input field Layout

Any layout

Note: Layout must be set in the Layout browse - Layouts to include parameter.
 2 Blank
Suggest data for input field No of Copies Numeric 2 1
Suggest data for input field Printer Any Printer PRINTER01 Blank (nothing defaulted)
Verify input field suggested data

1: Printer

2: No of Copies

3: Layout

A: No. The scanned value is not verified against the suggested value.

B: Yes. A warning message is displayed if the scanned value does not match the suggested value.

C: Yes. A warning message is displayed if the scanned value is greater than the suggested value.

D: Yes. A warning message is displayed if the scanned value is less than the suggested value.

E: Yes. The scanned value must match the suggested value.

F: Yes. The scanned value cannot be greater than the suggested value.

G: Yes. The scanned value cannot be less than the suggested value.

H: Yes. The scanned value cannot be less than the suggested value. A warning message is displayed if the scanned value is greater than the suggested value.

I: Yes. The scanned value cannot be greater than the suggested value. A warning message is displayed if the scanned value is less than the suggested value.

Note: If data is not specified, the values are defaulted as A.
 1=A; 2=B 1=A;2=A;3=A
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.

Print Package In Stock Label Screen

This screen prints the package in stock label for the selected balance identity.

Print Package In Stock Label screen parameters

Parameter Name Values Example Default Value
Auto confirm input field data

1: Printer

2: No. of Copies

A: No. Requires confirmation by scanning or by entering the data

B: Yes. The value is confirmed automatically.

C: Yes. The value is confirmed automatically, if the suggested data is not Blank

D: Yes. The value is confirmed automatically, if the suggested data is Blank

Note:  If no value is suggested for a mandatory field, the user must scan a value regardless of how this parameter is configured.
1=C 1=A;2=A
Auto trigger Next when all fields confirmed

0: No

1: Yes

1 0
Mandatory input fields

1: Printer

2: No pf Copies

 1;2 Blank
Numeric keypad - Activate negative sign

1: No of Copies

A: No

B: Yes

 1=B 1=A
Numeric keypad - Enable

1: No of Copies

A: No

B: Yes

C: Yes and displayed automatically when the field is selected.

 1=C;2=A 1=B
Populate scan field with suggested data

1: Printer

2: No. of Copies

 1 Blank
Printer browse - Printers to include

Any printer (multiple and/or range)

or

Printer group (format *GRP=X where X=Modification field in CRS290

or

*All (include all, overrides any printer group set in FT admin Users form)

Note: There is no specific M3 field for Printer group. The Modification field in CRS290 is used as printer group.

If this parameter is selected, the printers defined in this parameter are only allowed.

If this parameter is cleared (blank), the Printer group defined in the Printer group - Label Printer field of the User parameters tab displayed in the FTUsersMaint screen for the Factory Track admin is used. If the group is not defined for the current user, all the printers are available for printing.

 PRT01;PRT13-PRT26;PRT87

or

*GRP=PG1

or

*ALL

Blank (all printers are included)
Screen to display after report

1: Search balance identity

2: List balance identity

3: Balance ID options

4: Print package in stock label (same record)

Note: 
  • If this parameter is set to 3 and the Action when pressing Selectparameter is set to 0 (List options), the Balance ID options screen is displayed. If this setting is not updated, the List balance ID screen is displayed.
  • If this parameter is set to 4, the same screen (Print item label) is displayed with the same record.
  • If set to 1 and Stock Enquiry was opened through BAL ID function of Flex Move transaction, Report Move screen of Flex Move transaction is displayed as it was when function was triggered.
 1 2
Sequence of input fields

1: Package

2: Printer

3: No. of Copies

 1;3;2 1;2;3
Suggest data for input field No of Copies Numeric 2 1
Suggest data for input field Printer Any Printer
Note: 
 PRINTER01 If no printer is set, the printer specified inBlank (nothing defaulted)
Verify input field suggested data

1: Printer

2. No. of Copies

A: No. The scanned value is not verified against the suggested value.

B: Yes. A warning message is displayed if the scanned value does not match the suggested value.

C: Yes. A warning message is displayed if the scanned value is greater than the suggested value.

D: Yes. A warning message is displayed if the scanned value is less than the suggested value.

E: Yes. The scanned value must match the suggested value.

F: Yes. The scanned value cannot be greater than the suggested value.

G: Yes. The scanned value cannot be less than the suggested value.

H: Yes. The scanned value cannot be less than the suggested value. A warning message is displayed if the scanned value is greater than the suggested value.

I: Yes. The scanned value cannot be greater than the suggested value. A warning message is displayed if the scanned value is less than the suggested value.

Note: 
  • If data is not specified, the value A is defaulted.
  • Values C, D, F, G, H and I are only applicable for numeric input fields.
 1=B 1=A;2=A
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.

Reclassify Screen

Use this screen to reclassify(reset) the selected balance identity to a new status, lot, item or allocatable status.

Reclassify screen parameters

Parameter Name Values Example Default Value
Auto confirm input field data

1. New Item

2: New Qty

3: New Lot

4: Reason

5: Lot Ref 1

6: Lot Ref 2

7: Remark

8: Exp Date

9: Sales Date

10: Unit

11: Qty per Pkg

12: No of Pkgs

A: No. Require confirm by scan/enter data.

B: Yes – Always auto confirm field.

C: Yes – Auto confirm field if suggested data = NOT blank.

D: Yes – Auto confirm field if suggested data = blank.
Note: Mandatory field with blank suggested data cannot be auto confirmed. This will require input regardless of this setting. New item number or lot number is mandatory if there’s confirmed value in New qty / “Total Qty”.

1=B;2=C;3=A;

4=A;5=B;6=B;

7=C;8=A;9=D

 1=A;2=A;3=A; 4=A;5=A;6=A; 7=A;8=A;9=A;10=A;11=A;12=A
Auto trigger browse

1. Status

2. Unit

Controls for what fields browse is auto triggered when non-confirmed input field is selected/highlighted.

 1;2

Blank
Auto trigger Next when all fields confirmed

0: No

1: Yes

1 0
Date format Exp/Sales Date

1= YYYYMMDD

2= YYYYDDMM

3= MMYYYYDD

4= MMDDYYYY

5= DDYYYYMM

6= DDMMYYYY

7= YYMMDD

8= YYDDMM

9= MMYYDD

10= MMDDYY

11= DDYYMM

12= DDMMYY

13= YYYYMM

14= MMYYYY

15= YYMM

16= MMYY

Note: 13-16 DD=last day of the month.

Separator:

A: None (e.g. “YYMMDD”)

B: Period (e.g. “YY.MM.DD”)

C: Dash (e.g. “YY-MM-DD”)

D: Slash (e.g. “YY/MM/DD”)

E: Space (e.g. “YY MM DD”)

Note: Separator only applies to the display of current/entered date. Input is always without separator.
 1=C 7=A
Default data for input field Allocatable

0: Not allocatable

1: Allocatable

0 Blank
Default data for input field Status

1: Under Inspection

2: Approved

3: Rejected

 1 Blank
Display item description

0 = No

1 = Yes

If set to 1:

* An extra line with item description is displayed below the item name

* If item description is blank the extra line will not display

* Extra spaces in the item description are removed leaving only single spaces.

This parameter is only available for M3 16+

 1 0
Enable option to print balance ID label

1: Manual print (function option)

2: Print From balance ID

3: Print To balance ID (full quantity)

4: Print To balance ID (reported quantity)

If the value in this parameter is 1, the Print option is displayed to access the Print Label screen. The values for the fields, Confirmed Item, Location, Lot, Container and Quantity from current balance ID are defaulted.

If the value in this parameter is 2, the Print Label screen displays the data defaulted from the From balance ID after reclassify is reported.

If value in this parameter is 3/4, the Print Label screen displays the data defaulted from the To balance ID, after reclassify is reported. The value in the Quantity field is specified as the full quantity (3) or the reported quantity (4).

If this parameter is set to multiple options,the order set in this parameter controls the order sequence for displaying the screens.

The putaway label (MWS450PF) is printed.

If set to 3: The Print Label screen is displayed with data defaulted from the To balance ID, after reporting reclassification for the items. Quantity is set to the full.

 1;2;4 Blank
Item alias - Default data for input field Unit/Qty Per Pkg

*ALS (alias unit/quantity)

If set to *ALS:

If Unit input field is displayed:

If New Item is confirmed by scanning an item alias the unit from the alias in MMS025 is confirmed in the Unit input field.

If Qty per Pkg input field is displayed (but not Unit)

If New Item is confirmed by scanning an item alias the quantity from the alias in MMS025 is confirmed in the Qty per Pkg input field

*ALS

Blank
Mandatory input fields

1: Allocatable

2: Status

3: New Item

4: New Lot

5: New Quantity

6: Reason

7: Lot Ref 1

8: Lot Ref 2

9: Remark

10: Unit

11: Qty per Pkg

12: No of Pkgs

If New Qty is included then input field New Qty is optional if fields Qty per Pkg, No of Pkgs and Total Qty are displayed, else it is mandatory.

 1;2;5 Blank
Numeric keypad - Activate negative sign

1: New Quantity

2: Allocatable

3: Exp Date

4: Sales Date

5: Qty per Pkg

6: No of Pkgs

A: No

B: Yes

 1=B;2=A;3=A;4=A 1=A;2=A;3=A;4=A;5=A;6=A
Numeric keypad– Enable

1: New Quantity

2: Allocatable

3: Exp Date

4: Sales Date

5: Qty per Pkg

6: No of Pkgs

A: No

B: Yes

B: Yes, auto display

 1=B;2=B;3=A;4=A 1=B;2=B;3=B;4=B;5=B;6=B
Populate scan field with suggested data

1: Allocatable

2: Status

3: New Item

4: New Lot

5: New Qty

6: Reason

7: Lot Reference 1

8: Lot Reference 2

9: Remark

10: Expiration Date

11: Sales Date

12: Unit

13: Qty per Pkg

14: No of Pkgs

 1;2;3;4;6 Blank
Potency - Quantity input

0:Normal potency quantity

1:Physical quantity

This setting is only applicable for potency managed items

If set to 1:

  • New Qty input field input is physical quantity
  • New Qty input field suggested data is displayed as physical quantity
  • Info fields Quantity and Allocatable quantity are displayed in physical quantity.
  • Fields “Unit”, “No of Pkgs”, “Qty / Pkg” and “Total Qty” are not displayed
 1 0
Reason browse - Reasons to include

Any reason (multiple or range).

If this parameter is active: Only values set in this parameter are allowed.

 BAD;DIS;H02-H07;Z43 Blank (all reasons are included)
Reason browse - Sorting order

Set max 10 fields to sort by in the format N=X;N=X etc. where N = field number and X = either A for ascending or D for descending.

Logic:

  • A. Ascending
  • D. Descending

Fields:

CRS175MI.LstGeneralCode

  1. Reason (STKY)
  2. Description (TX40)
 2=A;1=D 1=A;2=A (Reason/Description)
Screen to display after report

1=Search balance identity

2=List balance identity

3=Balance ID options

4=Reclassify (same record)

Note: 

If set to 3:

Balance ID options screen is displayed if parameter “Action when pressing Select” is set to 0 (List options), else List balance ID screen is displayed.

If set to 4:

Same screen (Reclassify) is displayed with the same record.

If set to 1 and Stock Enquiry was opened through BAL ID function of Flex Move transaction, Report Move screen of Flex Move transaction is displayed as it was when function was triggered.

 1 2
Sequence of input fields For details about the values of this parameter, see Sequence of input fields. 1;2;3;4;5;6;7 1;2;3;4;5;6; 7;8;9;10;11;12; 13;14;15;16;17
Status browse - Statuses to include

1: Under Inspection

2: Approved

3: Rejected

 1;3 Blank (all statuses are included)
Suggest data for input field New Item

0: Blank

1: Same as current item (applicable for lot-controlled items only)

1 0
Suggest data for input field New Lot

Any lot

*CUR (Same as current lot number)

*AUTO* (Auto generate)

If set to “*AUTO*”:

A new lot number is retrieved and used when reclassification is triggered. The lot number is not displayed on the screen.

Setting “*AUTO*” is only applicable for the items with lot numbering methods = 1, 2, 3, 6 or 7 (auto generate). For items with lot numbering method 0, 4 or 5 (manual lot), suggested value is not specified. Input is mandatory if this parameter is set to “*AUTO*”.

 LOTABC

or

*AUTO* 		Blank
Suggest data for input field New Qty

Any quantity

A: Total on-hand balance

B: Allocatable (On-hand balance - Allocated qty)

A B
Suggest data for input field No of Pkgs

Any numeric value

A=Suggested quantity

If set to A:

* After ”Qty / Pkg” is confirmed: Suggested value for ”No of Pkgs” is calculated as integer of suggested Total Qty / ”Qty / Pkg”.

* After ”Qty / Pkg” is confirmed: Suggested value for ”New Qty” is calculated as suggested Total Qty -–suggested ”No of Pkgs” * ”Qty / Pkg”.

* After ”No of Pkgs” is confirmed: Suggested value for ”New Qty” is re-calculated as suggested Total Qty -–confirmed ”No of Pkgs” * ”Qty / Pkg”.

* If New Qty is confirmed with value <> suggested before No of Pkgs is confirmed: Suggest blank ”No of Pkgs” (since calculated value is no longer valid)

* Suggested quantity is based on parameter ”Suggest data for input field New Qty” and is displayed as suggested data for info field ”Total Qty”

 1

Blank
Suggest data for input field Qty per Pkg

Any numeric value

A=Suggested quantity

If set to A:

* If ”No of Pkgs” is confirmed with value >1 or if ”New Qty” is confirmed with value > 0 then suggested data is blank

* Qty per Pkg is suggested based on parameter ”Suggest data for input field New Qty”

 A

Blank
Suggest data for input field Reason

Any Reason

 DIS Blank
Suggest data for input field Unit

Any unit

*WHS (from item/whs MMS002)

*LOG (logistic unit in MMS015)

*BAS (basic unit MMS001)

If set to any unit or *WHS: The unit must be set up as a logistic unit for the item in M3 (MMS015) else it defaults to blank unit.

If set to *LOG: If multiple units are set up as logistic unit in MMS015 it uses the first one it finds (sorted in alphanumeric order).

If set to *WHS, *LOG or *BAS: Unit based on item of selected balance ID is suggested.

*WHS

Blank
Verify input field suggested data For details about this parameter, see Verify input field suggested data. 1=B;2=C;3=E;4=B;5=A;6=E 1=A;2=A;3=A;4=A;5=A;6=A;7=A;8=A;9=A;10=A
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.

Attributes Screen

Use this screen allows to update balance ID/lot attributes.

Attributes screen parameters

Parameter Name Values Example Default Value
Action to report

0: None (screen is for info only)

1: Update attributes

0

 1
Attribute validation

0: No validation. Any value is allowed.

1: Validation. Any value is allowed. A warning is displayed if a non-valid value is specified.

2: Validation. Only valid values are allowed.

Note: For alphanumeric attributes (type 1), the M3 setting ”Allow blank” controls if blank is a valid value. For other attribute types, blank is not a valid value.
 2 0
Attributes to include - Sequence numbers

Any numeric (multi or range).

 10-30;50;90 Blank (include all)
Attributes to include - Main attributes

0, 1, 2, 3, 4 and/or 5

 1;3;5 Blank (include all)
Attributes to include - Type

1: Alpha numeric

2: Numeric

3: Date

 1;3 1;2;3
Attributes to include - Control object

1: Balance ID

2: Lot

 2 Blank (include all)
Auto confirm input field data

1: Attributes

A: No. Require confirm by scan/enter data.

B: Yes. Always auto confirm field.

C: Yes. Auto confirm field if suggested data is not blank.

D: Yes. Auto confirm field if suggested data is blank.

Note: Mandatory field with blank suggested data cannot be auto confirmed. This requires input regardless of the setting.

The setting for 1 (Attributes) is applicable to all attributes.

 1=C 1=A
Auto trigger next when all fields confirmed

0: No

1: Yes

 1 0
Date format Attributes

1: YYYYMMDD

2: YYYYDDMM

3: MMYYYYDD

4: MMDDYYYY

5: DDYYYYMM

6: DDMMYYYY

7: YYMMDD

8: YYDDMM

9: MMYYDD

10: MMDDYY

11: DDYYMM

12: DDMMYY

13: YYYYMM

14: MMYYYY

15: YYMM

16: MMYY

For 13-16, DD is set as the last day of the month.

Separator

A. None (e.g. “YYMMDD”)

B. Period (e.g. “YY.MM.DD”)

C. Dash (e.g. “YY-MM-DD”)

D. Slash (e.g. “YY/MM/DD”)

E. Space (e.g. “YY MM DD”)

Note: Separator is applicable only to the display of current/entered date. Input of date can be with or without separator.
 1=C 7=A
Display item description

0 = No

1 = Yes

If set to 1:

* An extra line with item description is displayed below the item name

* If item description is blank the extra line will not display

* Extra spaces in the item description are removed leaving only single spaces.

This parameter is only available for M3 16+

 1 0
Enable option to print balance ID label

1: Manual print (function option)

2:Print updated balance ID

When set to 1, the PRINT function is available that displays the Print Label screen.

When set to 2, the Print Label screen is displayed after an update of attributes is reported.

Label to print is the putaway label (MWS450PF).

 1;2 Blank
Mandatory input fields

1: Main attribute 1

2: Main attribute 2

3: Main attribute 3

4: Main attribute 4

5:Main attribute 5

*ALL (all attributes).

 1;2;5 or *ALL Blank
Numeric keypad - Activate negative sign

1: Attribute (numeric/date)

A: No

B: Yes

 1=B 1=A
Numeric keypad– Enable

1: Attribute (numeric/date)

A: No

B: Yes

C: Yes and automatically display when the field is selected.

 1=C 1=B
Populate scan field with suggested data

1: Attributes

 1 Blank
Potency - Quantity input

0:Normal potency quantity

1:Physical quantity

When set to 1, for potency managed items, the quantity is displayed as physical quantity instead of normal quantity.

 1 0
Screen to display after report

1: Search

2: List balance ID

3: Balance ID options

4: Attributes (same screen)

If set to 3, the Balance ID options screen is displayed if the Action when pressing Select parameter is set to “0” (List options), else List balance ID screen is displayed.

If set to 4, same screen (Attributes) is displayed with the same record.

If set to 1 and Stock Enquiry was opened through BAL ID function of Flex Move transaction, Report Move screen of Flex Move transaction is displayed as it was when function was triggered.

 1 2
Sequence of input fields

Info fields:

1: Quantity

Input fields:

2: Attributes

Individual attributes are sorted by attribute sequence number.

 2;1 1;2
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.

Sublots screen

Use this screen to add and remove sublot(s).

Sublots screen parameters

Parameter Name Values Example Default Value
Display item description

0 = No

1 = Yes

If set to 1:

* An extra line with item description is displayed below the item name

* If item description is blank the extra line will not display

* Extra spaces in the item description are removed leaving only single spaces.

This parameter is only available for M3 16+

 1 0
Note:  If you do not specify a value for the parameter, or you specify an invalid value, the default value is used.