Work with inventory, Items, All records (DSR71101)

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).