Finding Order & Serialized Product Data in OneScan

Finding Order & Serialized Product Data in OneScan

Use this article to locate order information or serialized product data when you have one or more product identifiers such as an NDC, UPC, GTIN, LOT number, expiration date, or serial number.

Important: OneScan is case-sensitive. When entering or filtering by any value, make sure the capitalization matches exactly.

Quick Reference — Start Here

Use the table below to identify which workflow(s) to follow based on the information you have available.

Workflow A — Master Data: GTINs → Serial Number Table

Best for: Locating specific serialized product records when you have a GTIN, serial number, LOT, or expiration date.

The Serial Number table shows every serial number for a specific GTIN that has been consumed in OneScan. Use this to confirm whether a product was received or to find its associated order.

1. Navigate to Master Data > GTINs
2. Filter the list using a unique identifier shown on the page (e.g., GTIN, NDC, or drug name)
3. Once you find the correct GTIN, click the Edit button to the right of that line
4. Scroll to the bottom of the page — you will see a Serial Number table with the following columns: Number (Serial Number), Lot Number, Expiration, Status
5. Type in the text box beneath any column header to filter the list
6. To the right of any serial number line, click the blue button to view the full history of that serial number, including its associated Order ID

Workflow B — Master Data: Products → GTINs

Best for: When you have a UPC, NDC, or drug name and need to find the associated GTIN before using Workflow A.

Note on NDC format: Package-code NDCs (those with hyphens) must be converted to the 11-digit billing format before searching in OneScan. You can find the correct billing format at NDClist.com.

1. Navigate to Master Data > Products
2. Filter the product list by UPC, NDC, or drug name
3. Click Edit to the right of the desired product
4. Scroll to the bottom of the page and click the GTIN tab
5. This will display all GTINs associated with that NDC — copy the relevant GTIN and proceed to Workflow A

Workflow C — EPCIS Orders Page

Best for: Searching across orders when you have a UPC, LOT number, or serial number. Other identifiers (NDC, GTIN, expiration) are available as filters but may not return results as reliably.

Note: If you do not know the product's UPC, look it up first using Workflow B.

1. Navigate to the EPCIS Orders page
2. Filter the order list using one or more of the available fields — for best results use UPC, LOT, or Serial Number
3. The filtered results will display a list of orders containing that product
4. From there, you can review or export the data as needed

Workflow D — EPCIS T2 TNT Report

Best for: When you have the physical product with a 2D barcode, or a Serial Number + GTIN combination. This is the most direct way to pull a full product trace.

Note: If you do not have access to the T2 TNT Report feature, contact OneScan support.

1. Navigate to EPCIS and select T2 TNT Report
2. Either scan the 2D barcode on the physical product, or manually enter the GTIN and Serial Number (remember: OneScan is case-sensitive)
3. Click Look Up
4. The system will return the product record and its associated T2 report, which contains a variety of traceability details

Workflow E — Edge: Inquiry/Reprint

Best for: Quick general product history lookups when you have the physical product or its barcode. Note that this method only returns general product details and history — it is not the most complete source of order information.

1. Click Edge in the top menu bar and select Inquiry/Reprint
2. Scan or paste the product barcode into the barcode field
3. If the product's file has been successfully processed in OneScan, the system will display general product details and history
4. On the right side of the screen, the scanned product will appear — click the blue counterclockwise arrow button to view more in-depth history, including the Order ID the product came in on and shipped out on

Workflow F — Edge: Receive

Best for: Situations where you need to check whether a product was received, using its 2D barcode. Carries the same limitations as Workflow E.

1. Navigate to Edge > Receive
2. Scan the product's 2D barcode
   • If the product was previously received in OneScan: You will receive an error message indicating this, and the error will include the Order ID the product came in on
   • If the product has not been activated in OneScan: The product will scan in for activation — however, you can still find the order information on the left side of the screen next to "Order #" in the box where the product appears