Enter inventory transactions with FIFO selection

The following describes how you enter an inventory transaction when FIFO is defined as cost type in the DIS control file.

Select the Work with inventory menu item.
You access Work with inventory, Locations, All records if the Warehouse defaulted for your user profile is a DC1 Warehouse Management controlled warehouse; else Work with inventory, Items, All records. To switch to another warehouse, click the Select warehouse function key and select the applicable warehouse.
To adjust inventory you can choose from the following two alternatives:
1. Highlight the applicable inventory transaction and click the Inventory adjustment option to adjust inventory for the item in the warehouse.
2. Click the Entry function key. When you access the Inventory adjustment panel the Item and Warehouse fields will be open for input allowing you to enter/select the item and warehouse for the inventory adjustment. All other fields will be initiated with blanks except for the Accounting period, Reception date, Stock on hand and Transit.
On the Work with inventory, Inventory adjustment, the fields to to be completed will depend on how you accessed this panel.

Warehouse: Displays the warehouse in which the item is stored. If this panel was accessed in Entry mode (i.e. you clicked the Entry function key on the initial panel), this field is open for input.

Item: Displays the item code. If this panel was accessed in Entry mode (i.e. you clicked the Entry function key on the initial panel), this field is open for input.

Transaction type: Enter the user defined transaction type from the Transaction type table. This code must be in the range of 1000 – 99999. Transaction types less than 1000 are system defined and cannot be used for manual transactions.

Reception date: This reception date is used as informational purposes on the FIFO transaction the system creates, if you add goods to stock.

Quantity: Enter the quantity. If the transaction entered is a stock withdrawal (negative quantity in this field), go to step 4.

Pallet: This field is only displayed if the item is a DC1 Warehouse Management controlled item and the location has a pallet for the item. This is an optional entry. When you are doing a stock adjustment, adding to or withdrawing from stock, you can refer to a pallet to which the stock should be added or from which the stock should be removed. If you are removing stock, the system will validate that there is enough quantity on that pallet.

Cost price: Manually enter a cost price for the transaction, or click the Select FIFO transactions function key to view existing FIFO transactions and select a cost price from one of them. See step 4.

Complete any other mandatory fields you are flagged to complete and click OK to create the inventory transaction.

You access FIFO transaction selection. Select the transaction you want to use to retrieve the cost price for the inventory transaction. Note: Selection can only be made for those transactions marked with * in the Act (Active) column. The transactions marked with * are the transactions needed to cover the stock on hand quantity plus the quantity that has been delivered to the customer but not invoiced. Click OK after you select a FIFO transaction to create the inventory transaction.