Prioritizing Inventory

The Lot Priority Maintenance conversation (IC165E) allows you to prioritize multiple location records of lot-controlled and non-lot-controlled parts, thus allowing you to control the order in which inventory is picked for manufacturing orders. When you prioritize the records, you determine which record(s) are selected by the picking programs to fill an order. Neither the sales order picking process nor the Synchro module are impacted by lot prioritizing.

In this conversation, you can:

· Assign the same priority code to all multiple location records for a part within a specific company/warehouse (the priority code defaults from the Function Select screen (IC165S01)) that are currently blank.

· Manually assign priority codes on the Detail screen.

· Change priority codes on the Detail screen.

When the Picking List Maintenance Program (IC210E) and the Shop Paperwork Report Program (IC580E) select parts to fill an order, the programs use the following files: the Multiple Location File by Lot FIFO Date Sequence (IC130ML1) for non-job-controlled parts; the Multiple Location File by Job Number (IC130L13) for job-controlled parts; and the Multiple Location File by Company/Warehouse/Part/Lot/Job/Location (IC130L19) for configured parts. Sorting occurs in each of the logical files as follows:

Multiple Location File by Lot FIFO Date Sequence IC130ML1	Multiple Location File by Job Number IC130L13	Multiple Location File by Company/ Warehouse/Part/Lot/ Job/Location IC130L19

Part Number	Job Number	Company
Company	Part Number	Warehouse
Warehouse	Company	Part Number
Priority Code	Warehouse	Lot Number
Lot FIFO Date	Priority Code	Job Number
Stock Location	Stock Location	Priority Code
Lot Number	Lot Number	Stock Location

The AS/400 uses the EBCDIC collating sequence to determine the value of blanks, symbols, letters, and numbers. These characters are valid in the Priority Code field. The following table lists the EBCDIC symbols, letters, and numbers, in order of value. Note: Although EBCDIC permits lowercased letters, they have not been listed because you may not enter lowercased letters in MAC-PAC fields.

SYMBOL	MEANING	SYMBOL	MEANING

	Space	E
¢	Cent sign	F
.	Period, decimal point	G
<	Less than sign	H
(	Left parenthesis	I
+	Plus sign	}	Right brace
\|	Vertical bar, Logical OR	J
&	Ampersand	K
!	Exclamation point	L
$	Dollar sign	M
*	Asterisk	N
)	Right parenthesis	O
;	Semicolon	P
^	Logical NOT	Q
-	Minus, hyphen	R
/	Slash	\	Left slash
¾	Split vertical bar	S
,	Comma	T
%	Percent sign	U
_	Underscore	V
>	Greater than sign	W
?	Question mark	X
`	Accent grave	Y
:	Colon	Z
#	Number/pound sign	0
@	At sign	1
'	Apostrophe, prime sign	2
=	Equal sign	3
"	Quotation marks	4
~	Tilde	5
{	Left brace	6
A		7
B		8
C		9
D

The EBCDIC Collating Sequence.

As you can see, blanks have the lowest value. This means that any record with a priority code of blanks will always be selected before any other record. If two or more records have identical priority codes, the picking programs will use the next sorting criteria (depending on the part type) to choose among the records.

For example, the following screen sample shows five records for the part Aspirin sequenced by priority code. They are displayed in the order that they would be picked.

WILLIAMS    CO  001            INVENTORY CONTROL                       2/25/93

 DSP01       WHS BEL        LOT PRIORITY MAINTENANCE                     DETAIL

                                                                               

                                                                               

 Part Number     ASPIRIN          ASPIRIN TABLETS                               

                                                                               

                                    ----Balance Quantities----                 

 Pty Lot FIFO Stock                  On-Hand   /    Dist        Job/Grp        

 Cde   Date   Loc     Lot Number      Tran     /   Quality      Number         

      120892  ALOCAT1 LOT00000001         33.000          .000  BELPOTCTL1     

                                            .000          .000                 

      120892  LOC01   LOT001             100.000          .000                 

                                            .000          .000                 

  %   121092  LOC02   LOT003             100.000          .000                 

                                            .000          .000                 

  E   122292  LOC001  LOTPOTCTL1         100.000          .000                 

                                            .000          .000                 

  2   120892  ALOCAT9 LOTPOTCTL1B        100.000          .000                 

                                            .000          .000                +

                                                                               

                                                                               

 F2=Command          F3=Exit             F10=Function Select F15=Rekey Data    

 F19=Potent Units

The Lot Priority Maintenance Detail screen (IC165S02). Multiple location records

for the part Aspirin are displayed in order of priority.

You may prioritize multiple location records for non-lot-controlled parts—for example, if you wanted the picking programs to select inventory from specific locations. For non-lot-controlled parts, the Lot FIFO Date field is protected on the Detail screen.

Multiple Location Priority Code Default

Menu

Prioritizing Inventory

Related