Related topics
- About unit handling in IBS Enterprise
- About working with items
- About working with stock count
- Setting up Item Classification pricing
This panel displays the warehouse information for the item you have chosen, which has been entered in the corresponding panel in the Item file. Changes to the data can be made in the Work with items program.
- Bin location 1
- Indicates the first location where the item is stored.
- Bin location 2
- Indicates the second location where the item is stored.
- Stock zone
- Indicates the number of the stock zone where the item is stored. This field is used as selection criteria in the stock take module.
- Minimum stock
- This field is only displayed if IBS Inventory Control is not installed. Indicates the minimum stock balance to be stored for an item within the warehouse. The information is used when internal replenishment suggestions are created.
- Dispatch quantity
- This field is only displayed if IBS Inventory Control is not installed. This quantity is used when internal replenishment suggestions are created and together with the information in the Minimum stock and Stock on hand fields it determines the proposed quantity that should be delivered to the sub-warehouse from the main warehouse.
An example of the calculation is as follows:
Minimum stock 1500
Stock on hand. /. 200
Required stock 1300Dispatch quantity = 37
Required stock/dispatch quantity = 36 (this figure was rounded up to the nearest tenth).
Proposed quantity: 37 x 36 = 1332
Note: If no dispatch quantity is entered the calculation for the proposed quantity to be delivered to the sub-warehouse from the main warehouse will be the minimum stock minus the stock on hand, (i.e. 1300).
- Stock take status
- The code in this field is automatically defined by the system and indicates the stock take status. The codes that could be displayed are:
Code Description BLANK Item is not under stock take. 1 Item is under stock take.
(The item is on a stock take list. No pick lists or reception notes can be produced for this item when the stock status is 1. When the Stock take update routine is run, code 1 will change back to blank.)Code Description 9 Item is suspended because there is open activity for the item in this warehouse. This item is not included on the stock take list printout. No more activity can take place for the item in this warehouse until the item has been counted. To get the item back on the stock take list, once open activity has stopped, you have to print the stock take list again (either with the Suspended only field set to YES or NO. When the list is printed the status will be reset to 1 if everything is OK (e.g., no more open activity for the item). To then reset to status Blank, count the item which is on the stock take list (if desired) and update it. Note: The Update stock take transactions routine only resets the status on items that are available on a stock take list, i.e. not with status 9).
Code Description 2 The item is under R/F count. Pick lists and reception notes can be printed for the item.
- Last stock take date
- This field, which is automatically updated by the system, indicates the date of the last stock take.
- User defined 0003N
- If the field name for this user defined numeric field has been defined in the DIS control file, it will be displayed here. You can use this field for whatever purpose you want, but is for your information only.
- User defined ALPHA 3
- If the field name for this user defined alpha field has been defined in the DIS control file, it will be displayed here. You can use this field for whatever purpose you want, but is for your information only.
- Direct delivery
- Indicates if the item is allowed to be included on BtB (Back to Back) orders with direct delivery (item is delivered from the supplier directly to the customer).
- Order type direct
- Indicates the default purchase order type to be used on BtB orders with direct delivery. This value is defined in the Purchase order type table
- Transit delivery
- Indicates if the item is allowed to be included on BtB (Back to Back) orders with transit delivery (item is delivered from the supplier to the transit warehouse and then to the customer).
- Order type transit
- Indicates the default purchase order type to be used for the item on BtB orders with transit delivery. This value is defined in the Purchase order type table.
- Order allocation
- Indicates if this item is to be handled by the Work with allocation routine. In the event of a shortage in stock the deliveries can be dispatched via this routine according to their priority. By using priority codes, special and individual treatment can also be provided to customers in terms of delivery service.
- Whs value and Item value
- The fields below the Whs value column heading denote the values applicable for the item in this particular warehouse, if defined.
The fields below the Item value column heading denote the values defined for the item, irrespective of in which warehouse the item is stored.
If values are displayed below the Whs value column, those will override the values defined for the item, i.e. values displayed below the Item value column.
- Supplier
- Indicates the main supplier of the item in this warehouse and on item level.
- Responsible
- Identifies the employee that is responsible for the item in this warehouse and at the item level. This value is defined in the Signature table.
- Item class
- Indicates the item class for the item in this warehouse and on item level.
The item class is used to define if the item is kept in stock or if it is purchased/manufactured on demand.
A standard item, in contrast to a configurator product, is an item which is consistent. A standard item can either be a stock item or a non-stock item. Non-stock items are purchased/manufactured on demand.
Note: Configurator products can only be handled if IBS Manufacturing is installed and activated.
- Planning method
- Indicates the planning method for the item in this warehouse and on item level. The planning method defines what function should be used when creating order proposals.
- Planning method 0 must be defined for fictitious items.
- Planning method 1 can only be used for items defined as item type 3 or 4 on the Manufacturing information panel in this file.
- Planning methods 2 – 5 are only valid if IBS Manufacturing is installed and activated.
- Planning methods 6 – 7 are only valid if IBS Supply Plan is installed and activated. In addition, these methods can only be used for items for which the Supply plan field is set to YES on the Inventory management panel in this file for at least one warehouse.
- Handling status
- The handing status indicates if specific restrictions apply for the item, e.g., the item is not allowed to be entered on a sales order. This value is defined in the Handling status table.
Item file enquiry, Warehouses (DMR17702)
This panel indicates stock information for the item in the warehouse you have chosen. The information is automatically updated/incremented by the system. There is no corresponding maintenance panel.
- Normal stock
- Indicates, in the fields below, statistical information for normal stock.
- In quality control
- Indicates the total quantity currently under quality control for the item in this warehouse.
- On hand
- Indicates the total quantity on hand for the item in this warehouse.
- On purchase order
- Indicates the total quantity on purchase order(s) for the item in this warehouse. These figures include items which may have been received, but are under quality control.
- Reservations
- Indicates the total quantity on sales orders order components and manual reservations for the item in this warehouse.
- Disp not invoiced
- Indicates the total dispatched quantity, not yet invoiced, for the item in this warehouse.
- Service WIP
- This field is only displayed if IBS Service is installed and activated. Indicates the total quantity on service work in progress reports.
- On IR order
- Indicates the total quantity delivered, not invoiced, on internal replenishment orders for the item in this warehouse.
- On return order
- Indicates the total quantity on return orders to suppliers for the item in this warehouse.
- Transit stock
- Indicates, in the fields below, statistical information for transit stock.
- In quality control
- Indicates the total quantity currently under quality control for the item in this warehouse.
- On hand
- Indicates the total quantity on hand for the item in this warehouse.
- On purchase order
- Indicates the total quantity on purchase order(s) for the item in this warehouse. These figures include items which may have been received, but are under quality control.
- Reservations
- Indicates the total quantity on sales orders and manual reservations for the item in this warehouse.
- Disp not invoiced
- Indicates the total dispatched quantity, not yet invoiced, for the item in this warehouse.
- Service WIP
- This field is only displayed if IBS Service is installed and activated. Indicates the total quantity on service work in progress reports.
- Usable non-conforming stock
- Indicates, in the fields below, statistical information for usable non-conforming stock.
- On hand
- Indicates the total quantity on hand for the item in this warehouse. This quantity has been rejected during the quality control function, or has been moved to the non-conforming stock, and is defined as usable.
- On return order
- Indicates the total quantity on return orders to the supplier for the item in this warehouse. This quantity has been rejected during the quality control function and is entered on a return order to the supplier, not yet confirmed as delivered.
- Unusable non-conforming stock
- Indicates, in the fields below, statistical information for unusable non-conforming stock.
- On hand
- Indicates the total quantity on hand for the item in this warehouse. This quantity has been rejected during the quality control function, or has been moved to the non-conforming stock, and is defined as unusable.
- On return order
- Indicates the total quantity on return orders to the supplier for the item in this warehouse. This quantity has been rejected during the quality control function and is entered on a return order to the supplier, not yet confirmed as delivered.
Item file enquiry, Warehouses (DMR17703)
This panel indicates data from the Sales and Purchase order statistics files. The information is automatically updated/incremented by the system and corresponds to that found in the Item file.
- No of issues YTD
- This field, which is automatically updated by the system, indicates the total number of times picking has been done, year to date.
- No of issues LY
- This field, which is automatically updated by the system, indicates the total number of times picking has been done during last year.
- Qty issued YTD
- This field, which is automatically updated by the system, indicates the total quantity of this item which has been delivered for sales orders year to date.
- Qty issued LY
- This field, which is automatically updated by the system, indicates the total quantity of this item which has been delivered for sales orders during the last year.
- Last issuing date
- This field, which is automatically updated by the system, indicates the last date a sales delivery was made for this item.
- No of receipts YTD
- This field, which is automatically updated by the system, indicates the number of times a purchase delivery order has been received for this item year to date.
- No of receipts LY
- This field, which is automatically updated by the system, indicates the number of times a purchase delivery order has been received for this item during last year.
- Qty received YTD
- This field, which is automatically updated by the system, indicates the total quantity of this item which was received from purchase orders year to date.
- Qty received LY
- This field, which is automatically updated by the system, indicates the total quantity of this item which was received from purchase orders during last year.
- Last reception date
- This field, which is automatically updated by the system, indicates the last date a purchase delivery orders was received for this item.
- No of returns YTD
- This field, which is automatically updated by the system, indicates the number of times this item has been returned to the supplier year to date.
- No of returns LY
- This field, which is automatically updated by the system, indicates the number of times this item has been returned to the supplier during last year.
- Qty returned YTD
- This field, which is automatically updated by the system, indicates the total quantity of this item which was returned to the supplier year to date.
- Qty returned LY
- This field, which is automatically updated by the system, indicates the total quantity of this item which was returned to the supplier during last year.
- Qty adjusted YTD
- This field, which is automatically updated by the system, indicates the total quantity of this item which has been adjusted year to date.
- Qty adjusted LY
- This field, which is automatically updated by the system, indicates the total quantity of this item which has been adjusted during the last year.
- Qty backlog YTD
- This field, which is automatically updated by the system, indicates the total quantity of this item which was put on backorder year to date.
- Qty backlog LY
- This field, which is automatically updated by the system, indicates the total quantity of this item which was put on backorder during last year.
- No of late iss YTD
- This field, which is automatically updated by the system, indicates the total number of times late deliveries to the customer occurred for this item, year to date.
- No of late iss LY
- This field, which is automatically updated by the system, indicates the total number of times late deliveries to the customer occurred for this item during last year.
- Qty late issued YTD
- This field, which is automatically updated by the system, indicates the total quantity of this item which had a late delivery to the customer year to date.
- Qty late issued LY
- This field, which is automatically updated by the system, indicates the total quantity of this item which had a late delivery to the customer during last year.
Item file enquiry, Warehouses (DMR17704)
This panel indicates cost price information for the item in the warehouse you have chosen, which has been entered on the corresponding panel in the Item file. Changes to the data can be made in the Work with items program.
Function keys
- Standard cost
- This field is used to define the cost of the item in this particular warehouse, if the cost type defined in DIS control file is Standard cost. The specified cost, whether it is FIFO, Average cost or Standard cost (this field), will be used in the statistics and bookkeeping. The value in this field is automatically calculated by the system if one of the following applies:
Purchased items:
The standard cost is calculated as:Std net purch price + Standard landed costs The standard net purchase price is defined on this panel. Any standard landed costs are calculated using the Refresh landed costs menu item. Landed costs are those cost, such as freight, duty, insurance and handling costs, which are over and above the price paid to a supplier for the goods. The standard landed costs can be displayed by using the applicable template on the Work with warehouses panel in this program.
Manufactured items:
(If IBS Manufacturing is installed, Item type is 1 or 2)The standard cost is calculated according to the structure of the manufactured item, i.e. the costs of the material and operations in the structure.
- Std net purch price
- Indicates the current net purchase price, for buying the goods from the supplier, without landed costs and receiving it to this particular warehouse. If supplier discounts are defined for the item they are also reduced, with the exception of limit dependent discounts. This price, together with any standard landed costs, is used to automatically calculate the Standard cost for purchased items. See the Standard cost field on this panel for the description. There are four ways in which this field can be updated:
- Manually enter the standard net purchase price, i.e. after deduction of supplier discounts, in the equivalent maintenance panel.
- Automatically update this field for this specific item via the Item file update program.
- Automatically update this field for this specific item via the Update cost from purchase price function key in the equivalent maintenance panel.
- Automatically update this field via the download functionality in the Item classification definition. The download of costs/prices from the Item classification definition level is done for all items connected to the Standard purchase price grouping structure of the item classification definition.
This field is only displayed if:
- the item is a purchased item (not manufactured within the company) item and the Cost type is standard cost, as defined in DIS control file.
- the item is fictitious
- Last purchase cost
- The value in this field can either be automatically calculated by the system or manually entered for this particular warehouse in the equivalent maintenance program. The value represents the latest recorded cost for reception of the item into stock from supplier, reported via goods reception or from manufacturing when goods have been manufactured in IBS Manufacturing. When the cost type is not FIFO for the item (see description of Cost type), the value will be used as the cost in the FIFO transaction creation during all methods of reception of goods (i.e. manual inventory transaction, goods reception from supplier or reception of goods from manufacturing).
The field is mandatory when:
- Cost per warehouse is set to YES
- the Cost type is FIFO and the item is a purchased item. This is in order to guarantee a cost value for positive stock take differences
OR
- the Margin cost basis is defined as Last purchase cost
Automatic calculation
The cost is calculated according to the following:
Purchased items:
- If the item is a purchased item (not manufactured within the company) the cost is calculated as: Net purchase price + sum of all discrete and distributed landed costs on order line. Landed costs are those costs, such as freight, duty, insurance and handling costs, which are over and above the price paid to a supplier for the goods.
Manufactured items:
- If the item is manufactured within the company, this is the actual pre-calculated manufacturing cost of the item the last time it was manufactured.
The Cost type parameter can be defined at:
- the company level (DIS Control file)
- and at the item level (Item file, Inventory information panel).
- Average cost
- This field is used to define the cost of the item in this particular warehouse, if the cost type defined in DIS control file is average cost. The specified cost, whether it is FIFO, average cost (this field) or standard cost, will be used in the statistics and bookkeeping. The value in this field is automatically calculated by the system when the item is received to this warehouse. The cost is calculated according to the following:
Purchased items:
((qty in stock + qty on IRO) x avg cost)+(rec’d qty x TLC)
———————————————————————
(qty in stock + qty on IRO + received quantity)where TLC (total landed cost) is calculated as:
TLC = Net purchase price + sum of all discrete and distributed landed costs on order lineLanded costs are those cost, such as freight, duty, insurance and handling costs, which are over and above the price paid to a supplier for the goods.
Manufactured items:
((qty in stock + qty on IRO) x avg cost)+(rec’d qty x PCU)
———————————————————————
(qty in stock + qty on IRO + received quantity)where PCU means one of the following:
- If IBS Manufacturing is installed: PCU = actual pre-calculated manufacturing order cost per unit.
- New std net pur prc
- This field is only displayed if:
- IBS Manufacturing is installed and activated.
- The item type is 3 or 4 (purchased).
- The Cost per warehouse field is set to YES in the DIS control file.
Indicates the new standard net purchase price for buying the goods from the supplier. This price together with any standard landed costs is used to update the Calc standard cost field.
- Calc standard cost
- This field is only displayed if IBS Manufacturing is installed and activated and the Cost per warehouse field is set to YES in the DIS control file. Indicates a calculated standard cost price. This field is used in combination with the Calc effect date field when you calculate product costing (basic data) with a future date. This field can also be updated from product costing for sub-assemblies and end items when you save a product costing based on a future date.
- Calc effect date
- This field is only displayed if IBS Manufacturing is installed and activated and the Cost per warehouse field is set to YES in the DIS control file. Indicates the start date for usage of the standard cost.
- Standard cost sales
- Standard cost sales is always calculated from the standard cost. This field is used as cost basis for margin calculation and sales pricing. The value is stored in cost unit. If the CLA-COPR (Classification costing/pricing) function is activated in the Function control file this field is automatically updated, via the following, using up-marks defined from the Standard purchase price (SPP) group in the item classification definition:
- The Update cost from purchase price function key on the equivalent maintenance panel. The update will be done for this specific item.
- Via the download functionality in the Item classification definition. The download of costs/prices from the Item classification definition level is done for all items connected to the Standard purchase price grouping structure of the item classification definition.
Otherwise the field must be updated manually in the equivalent maintenance panel.