Enter inventory transactions for batch controlled items

Related topics

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 for batch controlled items you can choose from the following three 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.
3. (Note: This alternative is only available from the DC1 UI Client only for batch controlled items.) Click the Fast adjustment function key. You will access the Fast adjustment panel where multiple inventory adjustments can be handled at the same time. The Updated field will automatically be set to YES when the inventory adjustment has been updated (i.e. you clicked OK to confirm the adjustment). See the panel help for the field descriptions.
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.

Batch: Enter the batch ID. If this is a new batch, see 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: If FIFO or Average cost is used in the system, enter the cost price.

Complete any other mandatory fields you are flagged to complete and click OK.

Serialized tracking when decreasing stock for batch controlled items
When decreasing stock for batch controlled items you will access the Serialized tracking, Inventory adjustment panel after clicking OK where you will be required to select a unique serialized tracking ID per stock unit if the SERTRACK (Serialized tracking) function is activated in Work with function controls and the batch controlled item is flagged for serialized tracking.

If you are adding to stock, and the batch you entered exists, the transaction is created. If this is a new batch, see the next step.

If adding to stock and the entered batch does not exist, you access Batch entry, where you can enter the following additional information regarding the batch:

Batch retention days: Defaults from the Item file, but can be changed. This is the number of days this batch information can be kept after the Last dispatch date of this item, before it can be deleted via the Reorganise batch file routine.
Supplier: Defaults with the Main supplier from the Item file, but can be changed.
Country of origin: Defaults from the Item file, but can be changed.
Hold: The system defaults the hold code to NO.

The following fields are only displayed if the item is date handled:

Manufacturing date: Defaults with today’s date.
Incubation date: Defaults with today’s date. Change this date to a later date if the item from this batch shall be kept a number of days in stock before it can be sold.
Last arrival date: Enter the last date the item from this batch must arrive at the customer site.; Tip: If you leave this field blank but complete the Batch security days and Use by date fields, the system will automatically calculate this date when you click OK.
Batch security days: Defaults from the Item file. It is the difference, in number of days, between Last arrival date and Use by date. Another commonly used term for batch security days is minimum shelf life time.
Use by date: Tip: Enter the date before which the item from this batch must be used (i.e. expires).; Tip: If you leave this field blank but complete the Batch security days and Last arrival date fields, the system will automatically calculate this date when you click OK.

Click OK to create the new batch in the entered warehouse.

Created transactions

The system creates transactions in the Bookkeeping transaction file of type 901 (Stock value) and updates the transaction type entered in Transaction type field. The Inventory transaction file is also updated with the entered transaction type.

Note: It is not possible to change a transaction. Enter a new transaction to correct any errors.