Related topics
- About internal stock movements
- About unit handling in IBS Enterprise
- About working with inventory transactions
Depending on the menu item you have selected it is possible to access either the Inventory transaction entry or Exception material entry through the same program.
This program allows stock adjustment transactions to be entered into the system. The transaction is immediately updated through the whole system for the time axis and stock on hand values.
Note: Be aware that cost prices are not always updated correctly when receiving goods using this program. For example, if the cost type (defined in DIS control file) is FIFO, you will be prompted to enter the cost price of the item in this program. But the Average cost in the Item file will not be updated. This might cause problems if you use the average cost when calculating profit margin, as defined in the Margin cost basis field in DIS control file.
Only user-defined stock transaction types, (i.e. numbers higher than 1000) which have been entered in the Transaction type table are valid.
All transactions entered are stored in the Inventory transaction file and can be viewed at any time, e.g. in the Inventory transaction enquiry.
This panel is blank to begin with. As the transactions are entered they will be displayed in the middle section of the panel. When the panel is full it will automatically roll over to the next page. To update a transaction, simply enter a new transaction.
All transactions get a number, which follows them through the system. The transaction numbers are retrieved from the Number series table.
Note: The Purchase order and Line fields will be displayed if the Transit field is set to YES, the cost type for the company is set to 3 (i.e. FIFO) defined in the DIS control file, and the item has a transit delivery. You are only able to reduce the stock for items stored in transit stock. The purpose of this routine is to retrieve the cost price from a specific transit BtB order.
When goods are returned to your company they can be put back into stock. A restock action can be combined with a quality control inspection.
Although, technically, restock actions are the same as inventory transactions they are performed automatically when the goods are returned via the Work with requests and returns program.
Function keys
- Acc. per
- Tr
- This field is only displayed if the BtB function is activated, i.e. the BtB feature used field is set to YES in the DIS control file. Indicate if this item is a transit stock item (i.e. the item is stored in the transit stock). Note: Only withdrawals are allowed for transit stock transactions. If this field is set to YES and the item is batch-controlled, the batch must exist for the entered warehouse. An availability check is also performed against the Transit quantity fields in the Batch file.
- Type
- Enter the user defined transaction type, (i.e. a number higher than 1000), for which you want to perform the stock adjustment transaction. Note: If the Exceptional material entry panel is accessed this field will always display 977, and cannot be changed.
- Item
- Enter the complete item code, or short code.
- Whs
- Enter the warehouse code from the Warehouse file.
- Quantity
- Enter the quantity of the item. If the quantity requires decimals, the decimal sign should be entered along with the decimal amount. Valid number of decimals for this item is defined in the Item file.
Note: If the quantity is positive and the system cost price is FIFO (defined in the DIS control file), a panel is displayed where the cost price must be entered or selected from the FIFO transactions by clicking Select FIFO transactions.
If the quantity is negative and the system cost price is FIFO (defined in the DIS control file), the FIFO transaction panel is displayed, where one of the transactions must be selected.
Note: For batch-controlled items, only the FIFO records for the entered batch are displayed. When stock is reduced selection may only be done for FIFO records which are part of stock on hand quantity plus delivered not invoiced quantity and marked with an asterisk (*).
- Batch
- If the item is under batch control, enter the batch in which the item is stored.
- Bin loc
- This field is only used for a non-Warehouse Management items. If the item is under batch control, and a quantity has been entered (above) for a batch which does not exist, this field is mandatory. Enter the bin location in which the batch-controlled item is stored.
If a quantity has been entered (above) for a batch which does exist, this field is optional. If completed, the Bin location in the Batch file will be updated. (An entry in this field is not allowed if the item is not under batch control, nor if a negative quantity has been entered).
- Zone/Location
- These fields are only displayed if IBS Warehouse Management is installed and activated. They are a combination entry and are mandatory for normal and batch items. (For serial handled items, the zone/location is entered at a later stage: if receiving items into stock they are entered on the Location confirmation WMR911 panel. If removing items from stock they are entered on the DMR955 panel). You have two options:
- You can enter a zone/location combination that has this item connected to it in the Location table,
or - You can enter a zone/location combination that has no item connected to it in the Location table.
In both cases, the zone and location must exist in the Location table for the entered warehouse.
- You can enter a zone/location combination that has this item connected to it in the Location table,
- Order
- This field is only displayed if the Exceptional material entry panel is accessed.
- NCC no
- If you are entering transactions for a non-conformity certificate, enter the NCC number. All items rejected in the Confirm quality control note program, are entered on a non-conformity certificate, i.e. they get a NCC number. Items can also get a NCC number in the Enter inventory movements program.
- Auth
- An authoriser of this transaction must be entered if the NCC no field is completed. Enter a signature from the Signature table.
- Text
- A text of your choice can be entered to further describe the transaction.
- Rec. date
- The reception date may be entered to be used as informational purposes on the FIFO transactions or batch records.
- Order ref
- Enter the order number of the item for which a stock adjustment is being done.
- Line
- Enter the line number.
- Pallet
- Enter the pallet number for which a stock adjustment is being done. Note: Adding stock to an existing pallet is not possible.
Inventory transaction entry (DMR61004)
This panel is displayed if the system cost price is FIFO and the stock is decreased. From this panel you can retrieve cost for transit movements.
Function keys
| Update with average cost | If it is not known from which transit BtB order the cost price shall be retrieved, use this function key to create FIFO records using the average cost for the item. |
- Purchase order
- Enter the purchase order number of the item for which a stock adjustment is being done.
- Line
- Enter the line number.
Inventory transaction entry (DMR61005)
This panel is displayed if the system cost price is FIFO (defined in the DIS control file) and the stock is increased. You must enter a cost price, either manually or by clicking Select FIFO transactions.
Function keys
| Select FIFO transactions | Select the FIFO transaction to be used. |
- Cost price
- Enter the cost price for the item. This field is only displayed when item costing or system costing is set to FIFO.
This field is only displayed when item costing or system costing is set to FIFO.
Inventory transaction entry, Add batch info (DMR61006)
On this panel you enter additional batch information for the batch controlled item. This panel is displayed if the batch does not exist in the Batch file.
- Item
- Displays the item code.
- Batch
- Displays the batch for the item.
- Warehouse
- Displays the warehouse in which the item is stored.
- Bin location
- This field is only displayed for non-Warehouse Management items, where the item/batch is to be stored. Displays the bin location of the item.
- Quantity
- Displays the quantity of the batch for the item.
- Batch retention days
- A default value is retrieved from the Item file, but can be changed. Enter the number of days this batch information can be kept, after the last despatch time of this item, before it can be deleted from the Reorganise batch program.
- Supplier
- A default value of the main supplier is retrieved from the Item file, but it can be changed. Enter a valid supplier number from the Business partner file.
- Manufacturing date
- Optional entry. This field is only displayed if the Date handling field is set to YES in Item file. The default is today’s date. Enter the date the item was manufactured.
- Incubation date
- This field is only displayed if the Date handling field is set to YES in Item file. The default is today’s date. Enter the date up to which the item cannot be sold (i.e. this item must spend a certain amount of time in stock before it can be sold).
- Country of origin
- Optional entry. This field is only displayed if the EU reporting function is activated. The default value is retrieved from the Item file. Enter the code indicating in which country this item was made.
- Last arrival date
- This field is only displayed if the Date handling field is set to YES in Item file. Enter the last day the item must arrive at the customer site. (Last arrival date = Use by date – Batch security days).
- Batch security days
- This field is only displayed if the Date handling field is set to YES in Item file. The default value is retrieved from the Item file. Enter the minimum number of days allowed during which an item must arrive at the customer before it expires.
- Use by date
- This field is only displayed if the Date handling field is set to YES in Item file. Enter the date before which the item must be used (i.e. expires). (Use by date = Last arrival date + Batch security days).
- Hold
- This field is set to NO by default. Set to YES if this batch is to be held from further transaction processing.
- User defined date
- If the User def date 1-2 text fields were defined on the Inventory information (DMR00303) panel, these fields will be displayed with those headings. These fields are used for informational purposes only.
- User defined date
- If the User def date 3-4 text fields were defined on the Inventory information (DMR00303) panel, these fields will be displayed with those headings. These fields are used for informational purposes only.
Inventory transaction entry, Serial numbers (DMR61009)
On this panel you enter the serial number(s) of the item(s). This panel is only displayed if:
- the item is not controlled by IBS Warehouse Management
- the Serial no tracking field is set to YES for the item in the Item file
- no cost type is defined for the item in the Item file
- you have entered an NCC number for the transaction
Function keys
| List all | This function key is only displayed if you entered a negative quantity. List all valid serial numbers defined for this item. |
- NCC number
- Displays the NCC number.
- Quantity
- Displays the entered quantity.
- Serial number
- Enter the serial number(s) of the item(s).
- Bin location
- Enter the bin location for the serial number(s) for the item.
Inventory transaction entry, Select serial numbers (DMR61011)
This panel displays all valid serial number(s) for the item. Mark the serial number(s) you want to select and click OK.
- NCC number
- Displays the NCC number.
- Quantity
- Displays the entered quantity.
Inventory transaction entry, Serial numbers (DMR61013)
On this panel you enter the serial number(s) of the item(s). This panel is only displayed if:
- IBS Warehouse Management is activated
- the item is controlled by IBS Warehouse Management
- the Serial no tracking field is set to YES for the item in the Item file
- you have entered an NCC number for the transaction
Function keys
| List all | This function key is only displayed if you entered a negative quantity. List all valid serial numbers defined for this item. |
| Maintain zone/location | This function key is only displayed if you entered a positive quantity. Maintain the zone/location. |
- NCC number
- Displays the NCC number.
- Quantity
- Displays the entered quantity.
- Serial number
- Enter the serial number when increasing quantity for received goods. When decreasing quantity, enter a serial number that exists on the entered NCC number or click List all to select a valid serial number.
- Zone/Location
- When increasing the quantity the zone/location only displays what has been entered in the Location confirmation program. If you want to change that, click Maintain zone/location.
When decreasing the quantity, enter serial number and zone/location or click List all to list all serial numbers and select a valid one. You return to this panel where zone/location will automatically be filled in.
Inventory transaction entry, Serial numbers (DMR61017)
On this panel you enter the serial number(s) of the item(s). This panel is only displayed if:
- the item is not controlled by IBS Warehouse Management
- the Serial no tracking field is set to YES for the item in the Item file
- the Cost type field is set to 4 (Serial number costing) for the item in the Item file
- you have entered an NCC number for the transaction
Function keys
| List all | This function key is only displayed if you entered a negative quantity. List all valid serial numbers defined for this item. |
- NCC number
- Displays the NCC number.
- Quantity
- Displays the entered quantity.
- Serial number
- Enter the serial number when increasing quantity for received goods. When decreasing quantity, enter a serial number that exists on the entered NCC number or click List all to select a valid serial number.
- Bin location
- Enter the bin location for the serial number(s) for the item.
- Cost price
- Enter a cost price.