1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Work with inventory, Items,...

Work with inventory, Items, All records (DSR71101)

Related topics

This panel displays the existing inventory for the warehouse displayed in the header. The warehouse defined for your user profile is defaulted, but you can change it by clicking Select warehouse. If a warehouse is not defined for your user profile, then the main warehouse from the DIS control file is defaulted.

You are able to view all inventory transactions via two different views:

  • Location balance view
  • Item balance view

If WHM is activated for the warehouse in the header, then the Location balance view is displayed when you first access the panel. If WHM is not activated for the warehouse, then the Item balance view is displayed. Note: If the WMS application (external warehouse management system) is activated and the selected warehouse is activated for WMS, then the Location balance view is not available.

By selecting the applicable option from this panel, normal inventory, transit inventory and NCC inventory can be adjusted or moved to another warehouse.

This routine also supports the update and validation of files received from an external client (e.g., Iptor WM1). If any transactions sent from an external client end up in error, you will automatically access Transaction in error mode when you select the warehouse from the initial Work with inventory panel. The erroneous transactions can be viewed and manually corrected (if applicable) by switching in Transactions in error mode. Example of errors are:

  • Cost price is missing.
  • Standard cost price in the Item file is zero.
  • The inventory transaction lacks information (e.g., a transaction for a batch item was sent but the batch ID was not supplied).

Options

Correct Only displayed in Transactions in error mode. Select this option to correct errors created from external files.
Inventory adjustment Only displayed in All records mode. Select this option to adjust the item inventory.
Warehouse movement Only displayed in All records mode. Select this option to move a part of or the whole item inventory to another warehouse.
NCC move Only displayed in All records mode. Select this option to manage inventory movements to NCC stock, from NCC stock or between different NCC categories. Only allowed for Trade and Normal warehouses.
Create pallet Only displayed from the Locations view and in All records mode. Select this option to create new pallets from existing stock units in a location.
Display error Only displayed in Transactions in error mode. Select this option to view error details from external files. All transactions sent from an external client are stored in the WMS transaction log file. Depending on the type of error, you can manually correct the error in this routine if applicable, or click the Retry option from the WMS transaction log (for the transaction) if the DC1 WMS Interface application is activated. If the error is caused because of a lack of information, the error should ideally be corrected in the external client if possible; else in this routine after communication with the warehouse personnel.

Function keys

Entry Access the Inventory adjustment panel where 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.
Fast adjustment Access the Fast adjustment panel where multiple inventory adjustments can be handled at the same time for normal stock adjustments. Note: No transit stock adjustments can be handled from this panel, nor can serial number controlled items and CMI related transactions be handled. In addition, transactions requiring a cost price must be entered using the single entry panel or the inventory adjustment panel. Batch controlled items can be handled from the DC1 UI Client Client only.
Locations/
Item/warehouse
Toggle to change between location balance view and item balance view. The panel sub-heading differs accordingly. If the selected warehouse is activated for DC1 WMS Interface, then the location balance view is not available.
Select warehouse The warehouse defined for your user profile is defaulted to the header. If a warehouse is not defined for your user profile, then the main warehouse from the DIS control file is defaulted. Use this function key to select another warehouse.
Transactions in error/All records Toggle between viewing only transactions in error (if they exist) and all records. The panel sub-heading differs accordingly.

Warehouse
Displays the defaulted or selected warehouse and its description.
Item
This column lists the items in the warehouse and their descriptions.
Unit
This column lists the item units.
Quantity
This column displays the total quantity for the item in stock units.
Transit
This column displays the total transit stock on hand quantity for the item in stock units.
Batch
This column lists the batch code for the item, if it is under batch control.
Stock take status
This column denotes the stock take status of the item.

The following codes could be displayed:

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.)
Usable NCC stock
This column displays the total NCC usable stock on hand quantity for the item in stock units.
Unusable NCC stock
This column displays the NCC unusable stock on hand quantity for the item in stock units.
Unsellable stock
This column displays the unsellable stock quantity.
Unavailable stock
This column displays the unavailable stock quantity.

Work with inventory, Inventory details (DSR71104)

Related topics

This panel displays the inventory details.

Warehouse
Displays the warehouse in which the item is stored.
Item
Displays the item code and description.
Unit
Displays the stock unit of the item in the warehouse.
Bin location 1 / 2
Only displayed if the item/warehouse is activated for WHM, and if you accessed this panel from the item balance view. Displays the first and second bin location.
Stock on hand
Displays the total stock on hand quantity for the item in the warehouse.
Available
Displays the item quantity currently available in the warehouse.
Transit
Displays the total transit stock on hand quantity for the item in the warehouse.
Unsellable
Only displayed if the warehouse is activated for WMS. Displays the unsellable stock on hand quantity for the item in the warehouse.
Batch
Displays the batch code for the item, if it is under batch control.
Pallet
Only displayed if you accessed this panel from the location balance view. Displays the pallet number for pallet stock.

Work with inventory, Locations, All records (DSR71105)

Related topics

This panel displays the location balance for the selected warehouse. In Transactions in error mode, you are able to correct errors created from external files.

Options

Correct Only displayed in Transactions in error mode. Select this option to correct an error created from external files.
Inventory adjustment Only displayed in All records mode. Select this option to adjust the item inventory.
Warehouse movement Only displayed in All records mode. Select this option to move a part of or the whole item inventory to another warehouse.
NCC move Only displayed in All records mode. Select this option to manage inventory movements to NCC stock, from NCC stock or between different NCC categories. Only allowed for Trade and Normal warehouses.
Create pallets Only displayed from the Locations view and in All records mode. Select this option to create new pallets from existing stock units in a location.
Display error Only displayed in Transactions in error mode. Select this option to view error details from external files.

Function keys

Entry Access the Inventory adjustment panel where 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.
Fast adjustment Access the Fast adjustment panel where multiple inventory adjustments can be handled at the same time for normal stock adjustments. Note: No transit stock adjustments can be handled from this panel, nor can serial number controlled items and CMI related transactions be handled. In addition, transactions requiring a cost price must be entered using the single entry panel or the inventory adjustment panel. Batch controlled items can be handled from the DC1 UI Client Client only.
Locations/
Item/warehouse
Toggle to change between location balance view and item balance view. The panel sub-heading differs accordingly.
Select warehouse The warehouse defined for your user profile is defaulted to the header. If a warehouse is not defined for your user profile, then the main warehouse from the DIS control file is defaulted. Use this function key to select another warehouse.
Transactions in error/All records Toggle between viewing only transactions in error (if they exist) and all records. The panel sub-heading differs accordingly.

Warehouse
Displays the defaulted or selected warehouse and its description.
Zone
This column lists the warehouse zones where the items are stored.
Location
This column lists the warehouse locations where the items are stored.
Item
This column lists the items stored in the warehouse zone/locations and their descriptions.
Unit
This column lists the item stock units.
Quantity
This column denotes the total quantity of the item in the warehouse/location in stock units.
Batch
This column lists the batch code for the item, if it is under batch control.
Stock take status
This column denotes the stock take status of the item.

The following codes could be displayed:

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.)
Location type
This column lists the location types.
Reserved for pick
This column displays the reserved quantity calculated for the preferred pick unit.
Usable NCC stock
This column displays the usable NCC stock on hand quantity of the item in the warehouse/location in stock units.
Unusable NCC stock
This column displays the unusable NCC stock on hand quantity of the item in the warehouse/location in stock units.
On NCC
This column displays the stock on hand quantity of the item currently on a non-conformity certificate.
Landed cost required
This column denotes if landed cost is required.
In quality control
This column denotes if the quantity on the zone/location requires quality control in order to be available.
Transit delivery
This column denotes if the item is allowed on transit deliveries.
Held balance
If the item is being held, this column displays the quantity on hold in this location.
Unsellable stock
This column displays the unsellable stock quantity.
Unavailable stock
This column displays the unavailable stock quantity.

Work with inventory, Enter batch info (DSR71108)

Related topics

This panel is only displayed if the item is a batch controlled item with date handling (defined on the Inventory information panel in the Item file) and the batch does not exist for the item. On this panel you enter the batch information.

Warehouse
Displays the warehouse in which the item is stored.
Item
Displays the item code and description.
Unit
Displays the stock unit of the item.
Stock on hand
Displays the total stock on hand quantity for the item in the warehouse.
Available
Displays the item quantity currently available in the warehouse.
Transit
Displays the total transit stock on hand quantity for the item in the warehouse.
Batch
Displays the batch code for a batch item.
Quantity
Displays the quantity for the item in stock units.

Batch retention days
Enter the number of days the batch information can be kept, after the Last dispatch date of the item, before it can be deleted via 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 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 the 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 the 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 the Item file. Enter the last day the item must arrive at the customer site. (Last arrival date = Use by 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.
Batch security days
This field is only displayed if the Date handling field is set to YES in the 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 the Item file. Enter the date before which the item must be used (i.e. expires). (Use by date = Last arrival date + Batch security days).
User defined date
If the User def date 1-2 text fields were defined on the Inventory information panel in the Item file, then 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 panel in the Item file, then these fields will be displayed with those headings. These fields are used for informational purposes only.

Work with inventory, Inventory adjustment (DSR71110)

Related topics

On this panel you enter the adjustment details or correct a transaction in error. If you accessed this panel from the location balance view, then the field values are retrieved from the selected record’s zone/location.

Stock on hand, transit stock on hand, NCC usable stock on hand or NCC unusable stock on hand (this is defined by the NCC number and quantity type) can be adjusted from this panel. If the warehouse is activated for WMS, then the transaction type also determines, together with the quantity, what should be adjusted.

After validation, click OK to confirm the inventory adjustment.

Function keys

Warehouse movement This function key is displayed in Entry mode (i.e. you clicked the Entry function key on the initial panel). Access the Inventory movement panel where the Item, Warehouse and “from” Zone/Location fields will be open for input allowing you to move quantities to another warehouse. Note: Only movements within the same country is allowed. Otherwise, the movement must be done using IRO orders.
Select FIFO transactions This function key is only displayed if the system cost price is FIFO (defined in the DIS control file). If you are increasing the stock you must enter a cost price manually or by clicking this function key to access the FIFO transaction selection panel where you select the FIFO transaction to be used to retrieve the cost price for the inventory transaction. If the transaction entered is a stock withdrawal (negative quantity in the Quantity field), you will access that panel automatically where you select the FIFO transaction to be used to retrieve the cost price for the inventory transaction.
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 and description. 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.
Unit
Displays the stock unit of the item in the warehouse.
Stock on hand
Displays the total stock on hand quantity for the item in the warehouse.
Available
Displays the item quantity currently available in the warehouse.
Transit
Displays the total transit stock on hand quantity for the item in the warehouse.

Accounting period
Only displayed if period change is allowed. Enter the accounting period for the inventory adjustment.
Reception date
Enter the reception date for the adjustment.
Transaction type
Enter the transaction type for the adjustment.
Stock on hand
Indicate if the stock on hand quantity should be adjusted.
Transit
Indicate if the transit stock on hand quantity should be adjusted. NO is defaulted.
Quantity
Enter a positive or negative quantity to indicate how the item should be adjusted. If a quantity is added, then a cost price must be entered on this panel. If the quantity is decreased, then a new panel is displayed where you select the cost price from previous transactions.

For Customer Deposit Stock (CDS) inventory contracts, you cannot increase the quantity on a contract line via a manual inventory adjustment if the CMI-MULT (CMI Multiple reception) function is not activated in the Function control file. Instead you must create a new contract line.

Zone/Location
Only displayed if the item/warehouse is activated for WHM. Enter the zone and location for the inventory adjustment.
Pallet
Only displayed if the item/warehouse is activated for WHM. Enter the pallet ID for pallet stock.
Batch
Only displayed and mandatory for batch controlled items. Enter the batch code for the item.
Bin location
Only displayed if the item/warehouse is not activated for WHM. Enter the bin location for the item.
Order reference
Only displayed if the item/warehouse is activated for WHM. Enter the order number and line number of the item for which a stock adjustment is to be done for transit stock.
Cost price
Enter the item cost price.
Cost unit
Enter the item cost unit.
Reason code
Enter a code from the Non-conformity reason code table to indicate the reason for the inventory adjustment.
NCC number
Enter the NCC number. Mandatory entry if NCC usable or NCC unusable stock on hand quantity should be adjusted (defined by the NCC number).
Authorizer
Enter the user ID of the person who authorized the adjustment. Mandatory entry if NCC usable or NCC unusable stock on hand quantity should be adjusted (defined by the NCC number).
Text
Enter free text for the adjustment.
Inventory contract
This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated. Enter the inventory contract identity in the first input field and the line number for the adjustment in the adjacent field.

If the CMIQTYDECR (Quantity on CMI contract decreased) alert has been configured in the system, it will be triggered and sent to the recipient, (i.e. normally the handler on the inventory contract), when a contract line quantity is decreased on an inventory transaction.

Quantity before
This field is displayed after clicking OK to confirm the adjustment. Displays the item quantity before the inventory transaction.
Quantity after
This field is displayed after clicking OK to confirm the adjustment. Displays the item quantity after the inventory transaction.

Work with inventory, Locations, Location balance details (DSR71111)

Related topics

This panel displays location balance details of the selected item/warehouse combination. The item must exist on several instances/order numbers in the same zone/location.

Warehouse
Displays the warehouse in which the item is stored.
Item
Displays the item code and description.
Zone
Displays the warehouse zone where the item is stored.
Location
Displays the warehouse location where the item is stored.
Order ref
This column lists the order numbers.
Line
This column lists the order line numbers.
NCC no
This column lists the NCC numbers for stock on NCC.
Pallet no
This column lists the pallet numbers for pallet stock.
Batch
This column lists the batch codes for batch controlled items.
Quantity
This column lists the item quantities.

Work with inventory, Inventory movement (DSR71114)

Related topics

Stock on hand, transit stock on hand, NCC usable stock on hand or NCC unusable stock on hand (defined through NCC number and quantity type) quantities be can be moved to another warehouse from this panel. On this panel you enter the movement details. Note: Only movements within the same country is allowed. Otherwise, the movement must be done using IRO orders. Click OK when done to confirm the movement.

Warehouse
Displays the warehouse in which the item is stored and from where the stock should be moved. If this panel was accessed in Entry mode (i.e. you clicked the Entry function key on the initial panel, and then the Warehouse movement function key on the Inventory adjustment panel), this field is open for input.
Item
Displays the item code and description. If this panel was accessed in Entry mode (i.e. you clicked the Entry function key on the initial panel, and then the Warehouse movement function key on the Inventory adjustment panel), this field is open for input.
Unit
Displays the stock unit of the item.
Zone/Location
Only displayed if the item/warehouse is activated for WHM. Displays the zone and location where the item is stored. If this panel was accessed in Entry mode (i.e. you clicked the Entry function key on the initial panel, and then the Warehouse movement function key on the Inventory adjustment panel), this field is open for input.
Stock on hand
Displays the total stock on hand quantity for the item in the warehouse.
Available
Displays the item quantity currently available in the warehouse.
Transit
Displays the total transit stock on hand quantity for the item in the warehouse.
Unsellable
Only displayed if the warehouse is activated for WMS. Displays the unsellable stock on hand quantity for the item in the warehouse.

Accounting period
Only displayed if period change is allowed. Enter the accounting period for the inventory movement.
Receiving warehouse
This field is always displayed for movements regardless if DC1 Warehouse Management is active or not. Enter the receiving warehouse.
Receiving zone/loc
Only displayed and mandatory if the item/warehouse is activated for WHM. Enter the receiving zone and location for the inventory movement.
Stock on hand
Indicate if the stock on hand quantity should be moved.
Transit
Indicate if the transit stock on hand quantity should be moved. NO is defaulted.
Quantity
Enter the quantity that should be moved to another warehouse.
Reason code
Enter a code from the Non-conformity reason code table indicating the reason for the inventory movement.
Pallet
Only displayed if the item/warehouse is activated for WHM. Displays the pallet number for pallet stock, but can be changed.
Order reference
Only displayed if the item/warehouse is activated for WHM. Enter the order number and line number of the item for which an inventory movement is to be done for transit stock.
Batch
Only displayed and mandatory for batch controlled items. Enter the batch code for the item.
Bin location
Only displayed if the item/warehouse is activated for WHM. Enter the bin location for the item.
Text
Enter free text for the inventory movement.
Quantity before
This field is displayed when you have clicked OK to confirm the movement. Displays the item quantity in the sending warehouse before the inventory movement.
Quantity after
This field is displayed when you have clicked OK to confirm the movement. Displays the item quantity in the sending warehouse after the inventory movement.

Work with inventory, Non-conforming stock movement (DSR71115)

Related topics

On this panel you enter the NCC details. Click OK when done and to confirm the movement.

Warehouse
Displays the warehouse from which the stock movement should be done.
Item
Displays the item code and description for the stock movement.
Unit
Displays the stock unit of the item in the warehouse.
Zone/location
Only displayed if the item/warehouse is activated for WHM. Displays the zone and location for the item/warehouse combination.
Stock on hand
Displays the total stock on hand quantity for the item in the warehouse.
Available
Displays the item quantity currently available in the warehouse.
Transit
Displays the total transit stock on hand quantity for the item in the warehouse.
Unsellable
Only displayed if the warehouse is activated for WMS. Displays the unsellable stock on hand quantity for the item in the warehouse.

Accounting period
Only displayed if period change is allowed. Enter the accounting period for the NCC stock movement.
Receiving warehouse
This field is always displayed for movements regardless if DC1 Warehouse Management is active or not. Enter the receiving warehouse for the stock movement.
Receiving zone/loc
Only displayed and mandatory if the item/warehouse is activated for WHM. Enter the receiving zone and location for the stock movement.
Inventory contract
This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated and the warehouse is defined for an SCS- or Logistic SCS inventory contract. It is a mandatory entry. Enter the inventory contract identity to which the NCC number is connected.
Inventory contr line
This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated and the warehouse is defined for an SCS- or Logistic SCS inventory contract. It is a mandatory entry. Enter the inventory contract line to which the NCC number is connected.
Normal to NCC
Indicate if you are moving from normal stock to NCC stock. NO is defaulted.
NCC to normal
Indicate if you are moving from NCC stock to normal stock. NO is defaulted.
NCC between cat
Indicate if you are moving between different NCC stock categories, e.g. from NCC usable to NCC unusable. NO is defaulted.
Quantity
Enter the quantity that should be moved.
Transit
Indicate if the transit stock on hand quantity should be moved. NO is defaulted.
Reason code
Enter a code from the Non-conformity reason code table to indicate the reason for the stock movement.
Pallet
Only displayed if the item/warehouse is activated for WHM. Enter the pallet number for pallet stock.
Batch
Mandatory entry for batch controlled items. Enter the batch code for the item.
Bin location
Only displayed if the item/warehouse is activated for WHM. Enter the bin location for the item.
Order reference
Mandatory entry when transit stock is selected. Enter the order number and line number of the item for which an inventory movement is to be done for transit stock.
NCC number
Enter the NCC number of the stock that should be moved.
Authorizer
Enter the user ID of the person who authorized the movement of NCC stock.
From category
Enter the NCC stock category from which the stock should be moved.
To category
Enter the NCC stock category to which the stock should be moved.
Text
Enter free text for the NCC stock movement.

Work with inventory, Create pallet (DSR71116)

Related topics

Only applicable if the item/warehouse is activated for WHM and have been set up for pallet creation. On this panel you create a pallet in a location. Click OK when done. Click OK again to confirm the pallet creation.

Warehouse
Displays the warehouse in which the item is stored.
Item
Displays the item code and description.
Unit
Displays the stock unit of the item.
Zone/Location
Only displayed if the item is activated for WHM. Displays the zone and location in the warehouse where the item is stored.
Stock on hand
Displays the total stock on hand quantity for the item in the warehouse.
Available
Displays the item quantity currently available in the warehouse.
Transit
Displays the total transit stock on hand quantity for the item in the warehouse.

To zone
Enter the zone where the pallet should be stored.
To location
Enter the location where the pallet should be stored.
Quantity
Enter the item quantity that should be moved to the pallet.
Batch
Only displayed and applicable for batch controlled items. Enter the batch number from which the item quantity is moved to the pallet.
Pallet type
Enter the pallet type for the pallet that you are creating.
Pallet
This field is displayed when you have clicked OK to confirm the pallet creation. Displays the number of the created pallet, which is automatically retrieved by the system.
Label
Indicate if a pallet label should be printed.
Partial
This field is set to NO by default denoting that a full pallet should be created for the entered quantity. Set to YES if a partial pallet should be created for the entered quantity as quantity on hand. When a partial pallet should be created, the default pallet configuration is retrieved from the Item file/Warehouse management file (Quantity in pallet, which specifies the full pallet size and pallet type). If a default does not exist, then the full pallet size is set to Actual quantity + 1. A pallet is considered as partial when Actual quantity is less than Quantity in pallet.
Quantity before
This field is displayed when you have clicked OK to confirm the pallet creation. Displays the total stock on hand quantity for the item in the warehouse before the pallet creation.
Quantity after
This field is displayed when you have clicked OK to confirm the pallet creation. Displays the total stock on hand quantity for the item in the warehouse after the pallet creation.

Work with inventory, Fast adjustment (DSR71117)

Related topics

On this panel you can handle multiple inventory adjustments at the same time for normal stock adjustments. Note: No transit stock adjustments can be handled from this panel, nor can serial number controlled items and CMI related transactions be handled. In addition, transactions requiring a cost price must be entered using the single entry panel or the inventory adjustment panel.

Accounting period
Only displayed if period change is allowed. Displays the accounting period for the inventory adjustment.
Reception date
Displays the reception date for the inventory adjustment.

Transaction type
Enter the transaction type for the inventory adjustment.
Warehouse
Enter the warehouse for the inventory adjustment. If Item has been entered, and you click the window prompt to select a warehouse, only those warehouses in which the item is active will be displayed for selection.
Item
Enter the item for the inventory adjustment.
Quantity
Enter the quantity for the inventory adjustment.
Batch
This field is only displayed in the DC1 UI Client Client and is only displayed and mandatory for batch controlled items. Enter the batch code for the item.
Zone
Only displayed if the item/warehouse is activated for WHM. Enter the zone for the inventory adjustment.
Location
Only displayed if the item/warehouse is activated for WHM. Enter the location for the inventory adjustment.
Updated
This field is automatically set to YES when the inventory adjustment has been updated (i.e. you clicked OK to confirm the adjustment).