1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Serial number tracking enquiry...

Serial number tracking enquiry (DMR18001)

This panel displays all serial number items. You can view or browse through history, text and non-conformity certificates for the serial number items. Use the selection fields to narrow down the number of displayed records.

Options

Display Select this option to view details about the serial number item of a record.
History Select this option to view the serial number history of a record.
Text Select this option to view the serial number text of a record.
Non conf detail Select this option to access the Non-conformity certificate enquiry panel for a record. This is only possible if the item has been entered on a non-conformity certificate.

Function keys

Selection fields

Item
This column displays the item code.
Serial number
This column displays the item serial number.
Customer no
This column displays a number indicating the customer to whom the item was delivered.
Sales order
This column displays the sales order number on which the item was delivered.
Line
This column displays the sales order line number.
Dispatch date
This column displays a date indicating when the item was delivered to the customer.
Whs
This column displays the warehouse in which the item is/was stored.
Serial number in stock
This column indicates if the item is in stock.
Zone
This column is only displayed if Warehouse Management is installed and activated. Displays the zone in which the item is stored.
Location
This column is only displayed if Warehouse Management is installed and activated. Displays the location in which the item is stored.
Item description
This column is only displayed if you have clicked Shift info to toggle between the different views.
Supplier no
This column is only displayed if you have clicked Shift info to toggle between the different views. Displays a number indicating from what supplier the item was delivered.
Purchase order
This column is only displayed if you have clicked Shift info to toggle between the different views. Displays the purchase order number on which the item was delivered.
Purchase order line
This column is only displayed if you have clicked Shift info to toggle between the different views. Displays the purchase order line number.
Reception date
This column is only displayed if you have clicked Shift info to toggle between the different views. Displays a date indicating when the item was received from the supplier.

Serial number tracking enquiry (DMR18004)

This panel displays detailed information about the item, with the specific serial number. This detailed information relates to the last orders on which that serial number was used, including a purchase order type generating a return note to the supplier (the Order/Return field is set to 2 in the Purchase order type table).

Function keys

History Access the Serial number history enquiry.
Text Access the Serial number text enquiry.
Non conf detail Access the Non-conformity certificate enquiry. This is only possible if the NCC number field on this panel contains a value.
Item
Serial number
Displays the serial number connected to the item.
Warehouse
Displays the warehouse where the item is/was stored.
Bin location
Only displayed if DC1 Warehouse Management is not activated. Displays the location where the item is/was stored.
Zone
This field is only displayed if Warehouse Management is installed and activated. Displays the zone in which the item is stored.

Country of origin
Displays the country of origin of the item.
Location
This field is only displayed if Warehouse Management is installed and activated. Displays the location in which the item is stored.
Manually entered
Indicates if the record is manually entered in this file.
On IR order
Indicates if an internal replenishment order exists for the serial number item.
In stock
This field is set to YES if the item is still in stock or NO if the item is sold.
In transit delivery
Indicates if the item is delivered on a BtB order with transit delivery.
In quality control
Indicates if the item is printed on a quality control note, but not yet confirmed.
Rejected at qual ctl
Indicates if the item was rejected in the Confirm quality control note program.
Stock category
Displays the stock category if the item is entered on a non-conformity certificate (i.e. the NCC number field contains a value). The stock category controls if the item is usable or not.
NCC number
Displays the non-conformity certificate number if the item has been entered on such a certificate. Items that are rejected in the Confirm quality control note program, always receive a NCC number. Items can also be entered on non-conformity certificates during the Work with inventory program.
Stock take status
The stock take code indicates if the item is under stock take or not. If the field is blank, the item is not under stock take.

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.)
Last stock take date
Displays the date when the last stock take was performed.
Stock take list
If the item is under stock take (i.e. the Stock take status field is set to 1), displays the stock take list number where the item is printed.
Stock take list line
If the item is under stock take (i.e. the Stock take status field is set to 1), displays the stock take list line number, where the item is printed.
Cost
Displays the cost price that is unique for this serial number item. This field is displayed if:

  • A cost price exists for this serial number.
  • Neither a cost price nor a transit cost price exists for this serial number.
  • The user has authority to see the cost price.
Transit cost
Displays the transit cost price that is unique for this serial number item. This field is displayed if:

  • A transit cost price exists for this serial number.
  • Neither a transit cost price nor a cost price exists for this serial number.
  • The user has authority to see the transit cost price.

Supplier
Displays the supplier number and name, from where the item was delivered.
Reception date
Displays the date when the item was received from the supplier.
Diff tax base amount
The differential tax base amount is the actual amount upon which VAT is to be levied and is calculated as the difference of the sale and the purchase price of the particular item. This amount is computed automatically and cannot be overridden. See About differential taxation (Germany) for more information.
Purchase order
Displays the purchase order number on which the item was delivered.
Purchase order line
Displays the line number on the purchase order.
Reception note
Displays the reception note number on which the item was printed.
Reception note line
Displays the line number on the reception note.
Inventory contract
This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated. If the item received belongs to an inventory contract, this field displays the inventory contract ID.
Inv contract line
This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated. If the item received belongs to an inventory contract, this field displays the inventory contract line number.

Serial number tracking enquiry (DMR18005)

This panel displays detailed information about the customer who received the item. This detailed information relates to the last orders on which that serial number was used, including a sales order type generating a credit note to the customer (the Invoice/Credit note field is set to 2 in the Sales order type table).

Function keys

History Access the Serial number history enquiry.
Text Access the Serial number text enquiry.
Item
Serial number
Customer number
Displays the customer number to whom the item was delivered.
Customer name
Displays the customer name to whom the item was delivered.
Quotation number
Only displayed if the serial numbered item is included in a quotation. Displays the quotation number.
Quotation version
Only displayed if the serial numbered item is included in a quotation. Displays the version number of the quotation.
Quotation line
Only displayed if the serial numbered item is included in a quotation. Displays the number of the quotation line that contains the reference to the item.
Dispatch date
Displays a date indicating when the item was delivered to the customer.
Sales order number
Displays the sales order number on which the item was delivered.
Sales order line
Displays the line number on the sales order.
Pick list number
Displays the pick list number on which the item was printed.
Pick list line
Displays the line number on the pick list.
BPR number
Information is displayed in this field only if the serial numbered item is included in a request. Displays the BPR number.
BPR line
Information is displayed in this field only if the serial numbered item is included in a request. Displays the BPR line number.

Serial number tracking enquiry, More selections (DMR18011)

Function keys

More selections

  • Item
    Note: This field can be used for positioning within the selected interval.
  • Serial number
    Note: This field can be used for positioning within the selected interval.
  • Quotation
  • Sales order
  • Customer number
  • Dispatch date
  • Purchase order
  • Supplier number
  • Reception date
  • Warehouse
  • In stock
    Set this flag to YES if you want to select serial numbers in stock. Set to NO if you want to select serial numbers out of stock.