1. IBS Enterprise 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

Serial number
Displays the item serial number.
Customer no
Displays a number indicating the customer to whom the item was delivered.
Sales order
Displays the sales order number on which the item was delivered.
Line
Displays the sales order line number.
Dsp date
Displays a date indicating when the item was delivered to the customer.
Wh
Displays the warehouse in which the item is/was stored.
S
Indicates if the item is in stock.
Item/Item description
Only displayed if you have clicked Shift info to toggle between the different views.
Supplier no
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.
Purch order
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.
Line
Only displayed if you have clicked Shift info to toggle between the different views. Displays the purchase order line number.
Rec date
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 IBS Warehouse Management is not activated. Displays the location where the item is/was stored.
Zone
Displays the zone in which the item is stored.

Country of origin
Displays the country of origin of the item.
Location
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 Enter inventory movements 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.

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