Inventory Information - SIUPIN

The SI Inventory Information page is used to update information for inventory items by warehouse.

Main Window

Product ID: Enter the Product ID or use the Lookup function. Product IDs are defined on the Person/Entity Database (PE) Product Information (PEUPPR) page.
Description: Read-only field displaying the product ID description as defined in PEUPPR.
Warehouse: Select the warehouse code indicating where this product is being stored. The warehouse codes are defined on the SI Warehouse Information (SIUPWH) page.
Quantity: This field contains the current quantity of the product ordered in Purchasing and is to be added to inventory (expressed in the unit of measure as stocked in inventory). This field is updated whenever a PO (purchase order) containing items tracked in the SI system is printed. When units are received through the PO Receiving Information (POUPRC) page, the value in this field is reduced.
FIFO Cost: This read-only field indicates the per-unit cost of the oldest item remaining in inventory.
Description: This read-only field indicates the description of the product as defined in the PE Product Information page.
Units: This read-only field indicates the unit of measure of this product, as stocked in inventory.
Average: This read-only field indicates the average cost per unit. The average cost is the total value of all items currently in stock divided by the total number of units. This is a weighted average.
Total FIFO Value: This read-only field indicates the total current dollar value of this product in inventory.
LIFO Cost: This read-only field indicates the per-unit cost of the newest item received in inventory.

Inventory Tab

Use the Inventory tab to update inventory details about a product. You must enter location information on this page if the product is a first-time addition to the inventory system.

Committed: This field contains the current quantity of this product that is committed to being withdrawn from inventory (expressed in the unit of measure as stocked in inventory). If "Use interactive committing" is checked on the SI General Information (SIUPGN) page, this quantity is updated when an order is created. Order quantities are deducted when a committed line on an order is filled. If interactive commitments are being used, backorders for committed lines are also reflected in this field as being committed.
Available: This field indicates the current quantity available for this product, expressed in the unit of measure as stocked in inventory.
On Order: This field is system calculated by subtracting the quantity committed from the quantity on hand. This field is not available on reports or selection criteria.
Back Ordered: This field displays the product quantity that is back ordered.
Order Limit: This field displays the maximum number of individual items that can be ordered at one time.
Bundle Amount: This field indicates the bundle quantity (order multiple) that this item will be issued in. This feature will only be used if the customer is flagged to require bundles on the Person/Entity Database (PE) Update (PEUPPE or PEUPPI) page, Customer tab. The quantity can also be used to control the quantity ordered when automatically creating purchase requests during the SI Calculate Reorder Points (SIINOP) process. Reordered items will be rounded to a multiple of the bundle amount.
Bundle Percent: The percentage of the bundle quantity that must be met before the next multiple is assigned. For example, if the bundle quantity is 12 and the percentage is 50%, ordering 1 through 17 will issue 12; ordering 18 through 24 will issue 24, etc. Bundle Percent is not a factor in SIINOP. It is only used when a user is entering a Stores Order in SIOEUB.

Reorder Information

Calculation Code / Class: Select the code that corresponds to the reorder point calculation code to be used for the product being defined from the drop-down list. (If the field is left blank, the system assumes "FX".) To the right of the calculation code is the Class, which indicates the class of this product, as defined in the PE Product Information page. The following calculation codes are valid:

FX FIXED reorder point: Enter a number in the Order Point field and if inventory falls below this number, the system recommends ordering the amount in the Max Supply field when reorder points are calculated using the SI Calculate Reorder Points process. The value in the Max Supply field represents units.
MM MIN/MAX reorder point: Enter a number in the Min Supply and Max Supply fields. When the quantity on hand falls below the Min Supply value, the system recommends ordering an amount which will cause inventory to reach the number in the Max Supply field, when reorder points are calculated using the SI Calculate Reorder Points process. The value in the Min and Max Supply fields represent units.
MT MIN/MAX OVER A PERIOD OF TIME reorder point: Enter a number in the Min Supply, Max Supply, and Expressed In fields. When the quantity on hand falls below the Min Supply over the time-frame in the Expressed In field, the system recommends ordering enough for Max Supply over the time-frame in the Expressed In field, when reorder points are calculated using the SI Calculate Reorder Points process. Demand-type Transactions are used to determine this number.
EO Economic Order Quantity: Enter a fixed order point in the Order Point field, Ordering Cost per order value (on the PE Product Information page), and a Carrying Cost (on the PE Product Information page). When the quantity on hand falls below the value in the Order Point field, the system recommends the number of orders per year and an amount per order based on the average monthly usage history and overall cost considerations, when reorder points are calculated using the SI Calculate Reorder Points process.
FS Fixed Safety Stock: Enter an order quantity in the Max Supply field and a value in the Safety Stock field. The system calculates the forecasted daily usage, adds the lead-time, and safety stock to determine the order quantity. If quantity on hand is below this number, the system recommends ordering the amount in the Max Supply field, when reorder points are calculated using the SI Calculate Reorder Points process. The lead-time for the primary vendor of the product is used. The value in the Safety Stock field represents units.
DS Dated Safety Stock: Enter an order quantity in the Max Supply field and a Safety Stock amount expressed over the unit of time in the Expressed In field. The system calculates the forecasted daily usage, adds the lead-time, and safety stock to determine the order quantity. If quantity on hand is below this number, the system recommends ordering the Max Supply amount when reorder points are calculated using the SI Calculate Reorder Points process. The lead-time for the primary vendor of the product is used. Safety Stock and Max Supply are in units of time as specified in the Expressed In field. Maximum Allowed: For the maintenance of inventory, this user-defined field stores the maximum number of this item allowed in the warehouse. This amount is taken into account when determining the quantity to order when reorder points are calculated using the SI Calculate Reorder Points process.

Order Point: The lowest quantity on hand for this product, before the product needs to be reordered. This field is user-defined and is used by the calculation codes indicated in the next field.
Min Supply: This field indicates either an amount or a time frame. If the Expressed In field, to the right of this field, is left blank, then the value in this field represents the number of units for the minimum supply. If the Expressed In field, to the right of this field, contains a character, then the value in this field represents a five-digit, user-defined time-frame indicating the minimum length of time to use when reorder points are calculated using the SI Calculate Reorder Points process. This time frame can be expressed in days, weeks, months, or years.
Max Supply: This field indicates either an amount or a time frame. If the Expressed In field, to the right of this field, is left blank, then the value in this field represents the number of units for the maximum supply. If the Expressed In field, to the right of this field, contains a character, then the value in this field represents a five-digit, user-defined time-frame indicating the maximum length of time to use when reorder points are calculated using the SI Calculate Reorder Points process. This time frame can be expressed in days, weeks, months, or years.
(Min/Max) Supply Expressed In: The Expressed In field is combo box expressing the time frame associated with the Min Supply and Max Supply amounts. Valid codes are as follows: D=Days, W=Weeks, M=Months, Y=Years. If this field is left blank, the Min Supply and Max Supply are represented in number of units.
Safety Stock: A five-digit, user-defined number signifying the amount of stock desired, in addition to the order point. This value is only used in the "FS" and "DS" calculation methods.
Maximum Allowed: This field displays the Maximum quantity allowed in inventory.
Age Expressed As: Select the way age is to be expressed, from the drop-down list.
Age: This field indicates the age in terms of the time frame specified in the Expressed In field to the right.

Primary Location
Bin: The bin number may be up to 10 characters long and relates to the warehouse where this product is stored. The number is user defined on the Inventory tab and used to sort pick ticket information.
Floor: The number of the floor where the product is stored in the warehouse. The number is used to sort pick ticket information.
Last Activity Date: This field indicates the last date that this product was accessed by receiving or using demand functions.
Row: The number of the row where this product is stored. The number is used to sort pick ticket information.
Last Count Date: This field indicates the last date this product was counted. This field is updated when a count file containing the product is created.
Shelf:The number of the shelf where the product is stored. The number is used to sort pick ticket information.
Oldest Date: This field indicates the date of the receiving of the oldest individual product on hand.

Additional Location Tab

Use the Additional Location tab to describe other locations or further describe the primary location for a product. All defined locations within the warehouse will appear on the pick ticket to assist in pulling stock from the warehouse. However, pick tickets will always be sorted by the primary location number.

Bin: Enter the number of a second or alternate bin where the product is also being stored. This information is used to sort pick ticket information.
Floor: Enter the number of a second or alternate floor where the product is also being stored. This information is used to sort pick ticket information.
Row: Enter the number of a second or alternate row where the product is also being stored. This information is used to sort pick ticket information.
Shelf: Enter the number of a second or alternate shelf where the product is also being stored. This information is used to sort pick ticket information.
Description of Location: This is a large text field where one may use over 300 characters to describe an additional location.

Activity Tab

Use the Activity tab to determine sales projections, ordering demands, and inventory reorder points by warehouse. This read-only page displays products by warehouse.