Entering stock information for parts

When you enter stock information for parts, you can select the Store, Bin, and Lot for the part in store. The system automatically enters the Price based on the calculated Base Price of the part, and you can modify the Price as necessary.

If you do not enter a Qty. on Hand for the part when entering a stock record, the system creates a new stock record for the part but does not create a stock transaction.

If you are using LIFO/FIFO as your pricing method, the system creates a record for the part in the R5FIFO table and creates a receipt transaction for the stock initialization of the part.

To enter stock information for parts:

Open the Parts form.
Select the part for which to define stock information, and then click the Stock tab.
Click Add Stock Record.
Store—Enter the store for the part. The system automatically populates the store description and the Store Org.
Condition—Enter the condition if the part is a condition tracked parent part. The system automatically populates Part and Part Org. If the part is a condition tracked child part, Condition will be automatically populated with the condition of the selected part.

Note: If the asterisk (*) condition is entered, store records will be created for each condition tracked child associated with the part. Also, the system will automatically populate Part and Part Org. for each store record with the values of the condition tracked child part and part org. The condition for each store record will be the same as the condition for each condition tracked child. If the condition entered is not an asterisk (*), Part and Part Org. will be automatically populated with the part and part org. of the child part condition associated with the selected condition.
Bin—Enter the bin number storing the part.
Lot—Enter the lot number or batch of the part.

Note: The SHOWLOT installation parameter determines whether lots are used for stock information for parts. The default setting for SHOWLOT is Y. If SHOWLOT is set to N, the system disables Lot, and it is hidden.
Qty. on Hand—Enter the available quantity of the part.
Core Qty.—If the part is core tracked, enter the number of core parts that are currently in this Bin location. These are parts that you plan to repair on internal repair work orders or to send to a supplier on external repair requisitions. The value of Core Qty. is available for work orders and requisitions. The system automatically populates UOM.

Note: You can only enter a value for Core Qty. when inserting a stock record. You cannot edit or modify Core Qty. after saving the record.
The system does not create a stock transaction for the part when you enter a value for Core Qty., nor does it make any price updates until the part is repaired and received back to Qty. on Hand.

If you attempt to delete the stock record for the part, the system verifies both the Qty. on Hand and the Core Qty.. If both the Qty. on Hand and the Core Qty. are not equal to 0, the system will not allow you to delete the stock record for the part.
Click Submit.

Note: If you enter a value greater than zero for Qty. on Hand, the system also creates a receipt transaction of type RECV for the part. However, if you enter zero as the quantity or do not enter a value for Qty. on Hand, the system creates a stock record for the part but does not create a receipt transaction for the part.
The system does not create a receipt transaction for the part when you enter a value for Core Qty., nor does it make any price updates.

The system treats the stock information entered for this part as a stock receipt and updates the Last Price of the part.

To delete a stock, select the stock to delete, and then click, Delete Stock Record. You cannot delete a stock record for a part if the quantity on hand of the part is greater than zero.

The system displays an Asset ID if the part is tracked by asset.

The system populates Price based on the setting of the PRICELEV installation parameter. If PRICELEV is set to P, the system populates Price with the base price of the part from the Prices tab of the Parts form. If PRICELEV is set to S, the system populates Price with the base price of the part from the Stores tab of the Parts form, and you can change the price as necessary.

To record a stockout for a store, select the store, and then click Record Stockouts.