Maintain Store Item Definitions {FPMM-23}

The individual stock items to be handled by the stores are defined under this option. This four-Block option allows the user to define the details of the Item, Link the Item to a store and sections, Create Item Creditor Information and Define Item Additional Identification Information. 

The definition of an Item requires the following information: 

The same Stock Item can be linked to multiple Store Codes. In the rest of the ITS system a Stock Code consists of an Item and Store code. 

Field	Type & Length	Description
Item Code	N8	The number of the stock item as defined in block 1. The description and sundry description will be displayed.
Store Code	A2	An item must be linked to a particular Store, and the position in that store must also be defined. An Item code can only be linked to a store code once. The Code that is entered here must be one that has already been defined under option {FPMM-22b1}. The Store name will be displayed when the code is entered. This code cannot be changed. If the SOD (LV/PM) is set to 'Y',  use the <LOV> to select the Store as set up on {FPMM-22b3}.
Section	A2	The section within the above Store must be entered here. The Section is defined under option {FPMM-22b2}. The Section name will be displayed when the code is entered. If the SOD (LV/PM) is set to 'Y',  use the <LOV> to select the Section as set up on {FPMM-22b3}. The layout of a store and the sections within the store may change from time to time or may be created incorrectly. Should it be required to change the section of an item within a store, the section may be changed provided that that the in stock and on order quantities is zero (0).
Active/Non-Active	A1	Is this Store Item Active or Non-active? If this indicator is set to Non-active, the system will not allow processing of this item.
Row, Rack, Shelf, and Bin	A1, A1, A1, A1	The exact location of this item in the Store must be defined here. The "Row" field is mandatory, whilst the other three are optional if the item is not linked to a function. The combination of rack, row, shelf  and bin is unique per store and item and combinations containing null values constitute valid store location that may be linked to item. If Item Location Structure Validation  is Active item may only be linked to locations defined in {FPMM-22b3}. Item Location Structure Validation Active is set in {FCSM-1B2}. The following example illustrates valid combinations for a row A and rack / shelf / bin a  . Row Rack Shelf Bin A null null null A a null null A null null a A null a null A a null a A a a null A null a a A a a a                            If all four location fields are used, users should do careful planning and consider the following: An alternated mix of alpha/numeric values           For example:                Row    = A to Z                Rack   = 1 to 9                Shelf  =  A to Z                Bin     =  1 to 9          This convention offers a less confusing reference for reports and other documentation. The user should further take note of the limitations of each range and the layout of the store, for example:                 Rows Are there are more than 9 rows of racks in the store                 Rack  Refers to the front and back of row, thus < 9                 Shelf Refers to the horizontal sections (Length)                 Bin Refers to the vertical section (Height). Consider numbering from the floor for expansion at the top. Example: Store Layout Numbering
Location Barcode	A20	The Location Barcode number for the Row, Rack, Shelf and Bin. Location barcode is unique in the system. This is a not a mandatory field. Location barcodes should be less that 19 characters. The program validates that the barcode's length.
Cost Price	N15.2	The cost price of this Stock Item can be entered at the time when the item is defined, but never subsequently updated by the user. It will be updated by the system whenever a stock movement takes place.
Cash Mark-up	N4.2	The percentage mark-up over cost price at which items are sold for cash or credit, must be supplied. The system will default the value set in option {FPMM-21} into this field, but can be updated by the user for this specific store item. The following information is displayed on this screen for information purposes only, and cannot be updated or entered here: Present On-order Quantity: The total quantity for this store item on order. Present Stock: Total theoretical quantity on hand for this store item. Last Update: The date on which the last change was made on this Item Store Definition. Last User Code: The User who did the last change. The second part of this screen is called "STORE ITEM STATISTICS". Here the system displays Theoretical Order Quantities. These fields need not be entered. Some of them can be calculated via option {FPMOR5-9} once a sufficient amount of data has been collected on the system. Recommended period is at least 1 Year of operational data.
Issue Price	N15.2	The VAT inclusive issue or sales price of the item in Issue Units. This price will be used when an item is sold on credit or for cash using the option Stock Sales {FPMO4-10}.
Buyer	A8	A buyer as defined on the finance user definition {FCSM-5} can be linked to an item.  The field is used by the "Items Level Status Report" {FPMOR5-1} which allows the user to create an item status report per buyer.
VAT Code	A2	By linking a VAT code to the item / store / section the user sets the VAT attributes, namely VAT Rate and Taxable Supply Indicator, of the item. These default VAT attributes are used to generate VAT transaction on sale of the item although the user can change these defaults on sale of a stock item. The VAT rate linked to the VAT code on the item is used to generate the output VAT transaction on sale of a stock item. The VAT rate linked to the VAT code on the cost centre and the taxable supply indicator is used generate an input VAT transaction on sale of the item. The following fields are displayed for the VAT code: Code Description VAT Rate  Taxable Supply Indicator
Re-Order Quantity	N6	The number of items that is normally ordered when the Minimum Stock Level is reached.
Maximum Stock Level	N6	The maximum quantity of stock to be held in a store for this item.
Minimum Stock Level	N6	The stock level at which an order has to be placed, can be entered here in quantity, for this item.
Safety Stock Level	N6	The stock level which is safe prior to placing an order
Annual Demand	N7	The annual quantity required.
Economic Order Quantity	N6	This value can be calculated by option {FPMOR5-9}
Peak Month	MM	The month of peak demand for this stock item. Allowed values are "01" to "12".
Minimum Lead Time	N3	In days.
Maximum Lead Time	N3	In days.
Last Update	DD-MON-YYYY	The date on which the last change was made on this Item Definition.
Last User Code	A8	The User who did the last change. Report {FPMMR2-22}, "Item Detail", will list all the above information and the "Item Location List".

In this block the system carries the cost price information for each creditor that can supply the item. 

Value of this block will default to an order if the creditor of the order is defined for the stock item. 

The Buyers of the Institution can priorities the creditors from 1 to 99. The value of System Operational Definition Code AU determine the number of priorities that will be linked to a Request (Assign to PO) if the Store Item is used.

E.g. System Operational Definitions AU value is 3 then creditors linked to priority 1, 2 and 3 will be linked to the Request.

The definition of a Store Item Creditor Definition requires the following information:

Examples
	An Order will create the following description from the above information: THE OXFORD PAPERBACK DICTIONARY. .. Compiled By: Joyce M.Harkins. Edition: Third Edition. Publisher: Oxford University Press. Year: 1988. ISBN: 0-19-282117-2

• Procedures:
• None