1. Home
  2. /
  3. User Guides
  4. /
  5. Warehouse Management
  6. /
  7. Appendices
  8. /
  9. Interface to DC1 Distribution

Interface to DC1 Distribution

Related topics

This document describes how and where DC1 Warehouse Management is integrated with DC1 Distribution.

Sales order handling

Sales order maintenance and copy

For sales orders with an order type without pick document, the following applies:

  • Zone/location must be entered for items that are activated for Warehouse Management processing. In case of a return from customer, the zone/location will have to be entered and the system will automatically check that the location is valid and that the item exists in the location. Multiple locations can be entered for one order line.
  • For batch controlled items, each specified batch has to be confirmed with the entered zone/location. Multiple locations can exist for a batch.

Pick list print

Prints of individual and consolidated pick suggestions:

The sales order pick list (also called “pick suggestion”) will be printed using the pick list printout function in DC1 Warehouse Management. The selections of locations and sequences will be based on the warehouse/zone/location/item setup and will follow the rules specified in Pick rules.

For customer returns, the customer return location will be suggested on the return list.

  • DC1 Distribution decides how much to pick and DC1 Warehouse Management decides where to get the items. The locations used will be updated with allocated quantity reserved for picking.
  • When using items under batch control one line is printed per batch to be picked, showing the zone/location. If, for example, an item that is to be picked uses multiple batches and the batches are spread out in the warehouse on multiple locations per batch, then the same pick suggestion line will occur on several places on the pick suggestion and show one line for each combination of item/warehouse/zone/location/batch.
  • For BtB transit orders, the pick list displays the transit location for the connected order.
  • When using items under batch control, quantities for batches residing in locations defined with certain stock categories connected to quantity types will reduce the available quantity for a batch. For example, if a part of a batch resides in a location defined with the quantity type “Unsellable”, then the quantity in the location for the batch will be reduced from the total “on hand” quantity for the batch when the available quantity is calculated.

Pick list confirmation

This section describes the confirmation of the pick suggestion.

  • When confirming pick suggestion lines, zone and location have to be specified for each line. The zone/location will be defaulted from the suggestion but can be overridden. If a line was picked from multiple locations (and this was not specified on the pick list), then the user can mark the line and confirm the zone/location and the quantity used from each location. The confirmation program will check the “on hand” quantity for each location used.
  • The pick confirmation routine will force the user to enter zone/location on item/batch level for batch controlled items. A check will be made to ensure that the on hand quantity exists on the location (for used batch). When calculating the on hand quantity in a warehouse/location for a batch, the quantity types defined are taken into consideration. For example, if the batch resides in a location defined with the a stock category connected to a quantity type “Unsellable”, then the quantity in the location will be reduced from the “on hand” quantity for the batch when the available quantity is calculated.
  • For serial number items, an additional panel is displayed on which you can select the serial numbers that have been picked.
  • When the R/F handling is used for picking, quantities are defaulted according the R/F pick. The goods are also moved from the pick locations to the staging locations during the R/F handling. During the pick list confirmation the goods will be confirmed from the staging location.

Stock replenishment

Purchase suggestion

The purchase suggestion handling considers locations defined with a stock category connected to quantity types indicating unavailable stock, when the required quantity to replenish is calculated. For example, if items reside in a location defined with the quantity type “Unsellable”, then the quantity in the location will be reduced from the “on hand” quantity for the item. See the Panel help for Work with stock categories and Work with quantity types for more information about different quantity types.

Purchase order maintenance

Using an order type without reception document.

Zone/location entry

When maintaining an order using an order type that is not using the reception note, then zone and location have to be entered for items that are using a warehouse under DC1 Warehouse Management control. A validation of the entered location is performed. Multiple locations can be entered per order line.

  • Items under batch control require an entry of zone and location for each entered batch. If a batch is distributed on different locations, then all locations will have to be specified.

Goods reception note printout

Print of individual and consolidated goods reception notes.

The reception note, individual and consolidated, will be printed using the Put away suggestion print function in DC1 Warehouse Management. The reception note is called “put away suggestion” when produced in DC1 Warehouse Management.

General

The reception zone/location can be specified when the printing of the put away is started and will be valid for all non-QC items on the put away suggestion. The reception zone/location can also be specified on item/warehouse and warehouse level as default values, in case the zone/location fields are left blank on the start panel for put away suggestion print. If all these entries for reception zone and location have been left blank, then the assignment of reception zone/location will be based on the rules described in Put away rules.

Quality control

Items using quality control will get the suggested put away zone/location printed from the QC reception zone/location field that can be specified when the printing of the put away suggestion is started and will be valid for all QC controlled items on the put away suggestion. The QC reception zone/location can also be specified on item/warehouse and warehouse level as default values, in case the zone/location fields are left blank on the start panel for put away suggestion print. If all these entries for QC reception zone and location have been left blank, then zone and location will be suggested according to general rules. The balance will be held until the quality of the quantity has been confirmed.

Transit

The transit zone/location can be specified on the put away suggestion when printed. If the location is specified on the put away suggestion it will apply to all lines connected to the order. Transit locations can be specified on item/warehouse level as well as warehouse level and will then be a default value. The location specified on these levels will be retrieved if no location is entered on the put away suggestion.

For returns to supplier, no zone and location is printed as a “pick from” location. It is assumed that the user knows where the goods to return are stored. However, for NCC returns the zone and the location will be printed.

Goods reception note confirmation

During the confirmation of individual and consolidated goods reception notes, the system suggests zones and locations according to the put away rules in the following cases:

  • Zone and location is suggested for the confirmation of received goods, but can be changed. A validation of the entered location is performed. Multiple locations can be entered for each line reported as received.
  • Zone and location is suggested for each batch when batch items are received, but can be changed. If a batch is placed on several locations, then each location has to be specified.
  • Zone and location is suggested for serial number items that are received. An additional panel is displayed on which you select the serial numbers that have been received for the specified zone and location.
  • A transit zone and location is suggested for transit order lines that are received, but can be changed. The entered zone and location must be defined as a transit location.

The system does not suggest a zone and location when you confirm a return to supplier note. In this case, the zone and location from where the returned goods have been picked must be entered manually. However, for NCC returns the NCC zone and location will be suggested.

Replenishment line reception

For a description of reception of replenishment line, see Goods reception note confirmation above.

Book receipt

Items that have been received on purchase orders that require landed cost are held in the location until the receipt is booked. The book receipt process automatically releases the actual held balance into regular stock.

Quality control print

The quality control note printout displays the actual zone/locations that are held due to quality control for the purchase order lines.

Quality control note confirmation

When the QC note is confirmed, the actual held balance will be released into regular stock and then be available for pick. It is preferable that stock that has been received into a QC location is moved to final pick locations.

Non-conformity certificate (NCC) creation

Zone and location have to be entered per NCC when goods are reported as rejected on an NCC during QC note confirmation. The entered location must be an NCC location with the same stock category that is used for the NCC certificate. An NCC location is a location assigned to a stock category connected to a quantity type 6 (NCC usable) or 7 (NCC unusable).

Note: When rejecting items using batch control, zone and location have to be entered for each rejected batch. If a batch is placed on several locations, then each location has to be specified. When rejecting items using serial number control, zone and location have to be entered for each rejected serial number. Locations confirmed for storage of non-conforming goods during the DC1 Warehouse Management location confirmation (integrated with NCC creation) must have the same stock category assigned that was specified during the NCC creation.

Stock control

Inventory movements

When doing inventory movements, zone/location in the “from” as well as the “to” warehouse have to be entered. The zone/location and available quantity are validated. Apart from moving normal stock between different locations, you can also move stock from one NCC category to another, or move NCC stock to normal stock.

Inventory transactions

When doing adjustments using the inventory transaction routine, zone and location have to be entered. If the items are batch or serial number controlled or the item is stored under a non-conformity certificate (NCC), validations are performed accordingly.

Stock count

The stock count process in DC1 Distribution provides extended functionality for items activated for DC1 Warehouse Management processing. Two main count procedures can be used:

  • Item count
  • Location count

Item count is very similar to the counting procedure in DC1 Distribution, but with some variation and additional options for items activated for DC1 Warehouse Management processing. The location count offers additional functionality for selection of count and recount instructions.

Note: A location is treated as not available for stock count if any activities are going on, e.g., the location has been printed on a pick suggestion that is still open, a put away from bulk suggestion is open for the location, etc.

Note: Locations defined with a stock category which is connected to quantity type 5 (QC location), 6 (NCC usable), 7 (NCC unusable) or 9 (Transit location) are excluded from all stock take handling.

R/F stock take

The R/F stock take function allows R/F terminals with scanners to be used for the stock take. Once the R/F stock take list is created, the R/F instruction batch can be created and assigned to a handler to process.

Balance reconciliation

The balance reconciliation function is there to be used to correct any discrepancies between the stock on hand figure in DC1 Distribution and DC1 Warehouse Management by means of ordinary stock take routines. The major difference between balance reconciliation and non-balance reconciliation is how the system performs the comparison and update of the stock in DC1 Distribution and DC1 Warehouse Management.

If balance reconciliation is selected, then:

  • All locations for an item within the selected warehouse must be available for stock take (see the note above) if the item should be subject to a balance reconciliation count.
  • The update of the stock on hand balances in DC1 Distribution and DC1 Warehouse Management are different (see the example below).

The quantities that have been counted in the locations in the warehouse are reported to the system via normal stock take entry routine. A stock take control list can be printed before the counted quantities are updated into the Item/Warehouse file and the Location balance file.

Ordinary bookkeeping transactions for stock take differences are created. The value of the stock take difference is based on the difference between the total counted quantity and the stock on hand quantity in DC1 Distribution. The quantities in the location balance file are corrected with the counted quantities, but as mentioned above, the difference reported to the General Ledger is based on the difference in DC1 Distribution before and after stock count.

Note: Balance reconciliation is only applicable for items and warehouses that have been activated for DC1 Warehouse Management processing.

Note: Location count cannot be selected as list type and zones and locations cannot be selected in combination with balance reconciliation, as all locations must be counted.

When balance reconciliation is NO, the adjustment of the current stock on hand quantity in DC1 Distribution is performed based on the total of detected stock take differences per location. If balance reconciliation is YES, then the adjustment is performed on item level based on the total quantity of all locations for the item after stock take update in DC1 Warehouse Management. That means that all locations for the item are first updated with the counted quantities. Secondly the new stock on hand quantities in all locations are added together and are compared to the stock on hand balance in DC1 Distribution.

Example:

Let us assume that you count 3 locations for an item. The stock on hand in DC1 Distribution is 540 and the total stock on hand in DC1 Warehouse Management is only 539.

When Stock take update is run, the locations in DC1 Warehouse Management will always be updated with the counted quantity irrespectively of balance reconciliation or not:

location A will be changed to 34 (-1)
location B and C will remain 500
location C will be changed to 6 (+2)

but the stock on hand quantity in DC1 Distribution will be affected differently.

If balance reconciliation has not been selected, then the update in DC1 Distribution would be:

541 (540-1+0+2)

as the system updates DC1 Distribution with the net total of every detected difference per location (-1+2=+1).

If balance reconciliation has been selected, then the update in DC1 Distribution would be:

540 (34+500+6)

which is the total stock on hand quantity for location A, B and C for the item in DC1 Warehouse Management after stock take update in DC1 Warehouse Management. Now, both DC1 Distribution and DC1 Warehouse Management have a total stock on hand quantity of 540 and they are reconciled.

Note: If balance reconciliation has been selected, locations that have not been reported back to the system via the stock take entry routine before the stock take update run is performed will be seen as a “perfect count” by the system. A “perfect count” means that the system assumes that there was not any difference between the physical quantity and the counted quantity in these locations.

Item count

Item count allows both warehousing items and non-warehousing items to be processed simultaneously. If both types are included in the selection, two count lists will be printed with different list numbers.

When item count list is selected, both location and item selections can be made. If location specific selections are made, activity will only be prevented in the locations included on the count list.

Location count

The location count provides the ability to perform a wall-to-wall warehouse count where the counter gets instructions to count not only the locations where items should exist, but also the locations that are empty.

When location count list is selected, only location selections can be made. This can be made either on item/warehouse level for non-warehousing items using Stock zone and Bin location 1 & 2 for selection or on location level for warehousing items using Zone/location, Movability and Location last stock take date.

Suspension

When suspending an item or location the system changes the stock take status code on the location or item/warehouse record to 9. This indicates that no more activity will be suggested (e.g., pick lists, reception notes) until the location or item has been counted.

In addition to the selection possibilities for stock count list print in DC1 Distribution, the following options can be defined:

  • Item count
    Suspend if needed = NO and Item count = YES

    When issuing an “item count” list without any location selections and one or more of these locations are not available for stock count, the item will be excluded from the count procedure as activities are going on and item count was selected:

    • The item will be printed on the stock take list on a line without any line number reference and with the comment “Open activity exists“.
    • The stock take status remains ‘ ‘ (blank) for the item and on all locations where it resides.
      If all locations are available for stock count, the item will be included in the count procedure:
    • All locations where the item resides will be printed on the stock take list.
    • The stock take status will change to 1 for the item and on all locations where it resides.

  • Location count
    Suspend if needed = NO and Location count = YES

    When issuing a count list for “location count”, all items existing in a selected location must be available to be counted (more than one item can be stored in the same location) if the location should be printed on the stock take list.

    If one or more of these items are not available for stock count:

    • All locations with no on-going activity are printed on the stock take list.
    • All locations containing items with on-going activities are excluded from the count procedure and no comments are printed on the stock take list.

  • Item count
    Suspend if needed = YES and Item count = YES

    When issuing an “item count” list without any location selections and one or more of these locations are not available for stock count, the item will be excluded from the count procedure:

    • The item will be printed on the stock take list on a line without any line number reference, with the comment “Open activity exists“.
    • The stock take status will change to 9 for the item indicating that the item has been suspended. If all locations are available for stock count, then the item will be included in the count procedure:
    • All locations where the item resides will be printed on the stock take list.
    • The stock take status will change to 1 for the item and on all locations where it resides.

  • Location count
    Suspend if needed = YES and Location count = YES

    When issuing a count list for “location count” all items existing in a selected location must be available to be counted (more than one item can be stored in the same location). All locations with no on-going activity:

    • Will be printed on the stock take list.
    • Stock take status for these locations will change to 1.
    • Stock take status on the item will remain ‘ ‘ (blank).

  • All locations with on-going activities are excluded from the stock take list and:
    • Will be printed on the stock take list on a line without any line number reference, with the comment “Open activity exists“.
    • Stock take status for these locations will change to 9.
    • Stock take status on the item will remain ‘ ‘ (blank).

Suspended only

If “Suspend if needed” has been used on prior count lists, then “suspended only” can be used to limit the selection of what locations or items to include on the stock take list. If set to YES, only locations or items with a stock take code of 9 (= suspended at previous stock take print) will be considered for the count list.

Recount

DC1 Warehouse Management has extended options for recount selection. In addition to the standard selections available in DC1 Distribution, the following options for location selections are available:

  • Zone/Location, specific zones and locations.
  • Movability, the movability code on location level.
  • Cost difference/prior counts, a cost difference amount can be entered as selection. The amount will be compared to a calculated quantity difference expressed in cost value using the current cost price. If the difference is greater than the entered value, a recount instruction is printed.
    • If two or more counts have been recorded for a location, the difference between the recorded counts can be used for selection of recount instructions.
    • When two counts have been recorded, the difference of the two counts expressed in cost value is compared to the value entered here.
    • When more than two counts have been recorded the difference used is the smallest difference of the last three counts.

Example:

An item has been counted four times. The cost price of the item is 2.00 per unit.

Count Qty diff Value diff
1 100 200.00
2 106 212.00
3 125 250.00
4 121 242.00

The two differences used are:

  • Count 2 minus Count 4 = 30.00- (absolute value 30.00)
  • Count 3 minus Count 4 = 8.00

The smallest difference (8.00) is compared to the entered cost difference value entered.

Related topics