URS-028 · Initiate Return Requests for Products

Status: PASS  ·  Duration: 2m 2s  ·  Run Date: April 21, 2026

---

Test Scenarios

Step 1: Navigate to returns

PASS

---

Step 2: Fill return form

PASS

---

Step 3: Submit return

PASS

---

Step 4: Verify return recorded

PASS

Recordings

step 01 navigate returns

step 02 fill return form

step 03 submit return

step 04 verify return

Database Validations

Return record created

PASS

At least one return should have been created by Bob Kauffman in the last 30 minutes

SELECT r.id, r.return_number, r.status, r.date_of_event,
        r.sales_account_id, r.manufacturer_organization_id,
        r.sales_organization_id, r.reporting_user_id,
        r.return_location_id, r.replacement_location_id,
        r.created_at, r.created_by_user_id
      FROM returns r
      WHERE r.created_by_user_id = $1
        AND r.created_at > NOW() - INTERVAL '30 minutes'
      ORDER BY r.created_at DESC
      LIMIT 5

id	return_number	status	date_of_event	sales_account_id	manufacturer_organization_id	sales_organization_id	reporting_user_id	return_location_id	replacement_location_id	created_at	created_by_user_id
019dadd9-fc81-7128-9de2-6eb5e27a3a8c	RET-1	submitted	2026-04-20T05:00:00.000Z	fea7b8c9-d0e1-2345-0123-456789012345	a1b2c3d4-e5f6-7890-abcd-ef1234567890	b2c3d4e5-f6a7-8901-bcde-f12345678901	17b8c9d0-e1f2-3456-1234-567890123456	6ea3b4c5-d6e7-8901-6789-012345678901	6ea3b4c5-d6e7-8901-6789-012345678901	2026-04-21T02:23:57.552Z	17b8c9d0-e1f2-3456-1234-567890123456

---

Return number generated

PASS

Return should have a return number in RET-XXXXX format

SELECT r.id, r.return_number
      FROM returns r
      WHERE r.created_by_user_id = $1
        AND r.created_at > NOW() - INTERVAL '30 minutes'
        AND r.return_number IS NOT NULL
        AND r.return_number != ''
      ORDER BY r.created_at DESC
      LIMIT 1

id	return_number
019dadd9-fc81-7128-9de2-6eb5e27a3a8c	RET-1

---

Return status is submitted

PASS

Return status should be “submitted”

SELECT r.id, r.return_number, r.status
      FROM returns r
      WHERE r.created_by_user_id = $1
        AND r.created_at > NOW() - INTERVAL '30 minutes'
      ORDER BY r.created_at DESC
      LIMIT 1

id	return_number	status
019dadd9-fc81-7128-9de2-6eb5e27a3a8c	RET-1	submitted

---

Return items created

PASS

At least one return item should exist for the submitted return

SELECT ri.id, ri.return_id, ri.product_id, ri.lot_number,
        ri.return_item_number, op.title as product_name
      FROM return_items ri
      JOIN returns r ON ri.return_id = r.id
      JOIN org_products op ON ri.product_id = op.id
      WHERE r.created_by_user_id = $1
        AND r.created_at > NOW() - INTERVAL '30 minutes'
      ORDER BY r.created_at DESC, ri.created_at DESC

id	return_id	product_id	lot_number	return_item_number	product_name
019dadd9-fc82-7c09-a80e-83d836bb86e5	019dadd9-fc81-7128-9de2-6eb5e27a3a8c	01989ca1-f2f8-7ab7-8269-7179342797cc	URS028-RETURN-001	RET-1-FL516SNA-1	FiberLocker® Instrument SN

---

Return item has correct lot number

PASS

Return item should have lot number “URS028-RETURN-001”

SELECT ri.id, ri.lot_number, ri.return_item_number
      FROM return_items ri
      JOIN returns r ON ri.return_id = r.id
      WHERE r.created_by_user_id = $1
        AND r.created_at > NOW() - INTERVAL '30 minutes'
        AND ri.lot_number = $2
      LIMIT 1

id	lot_number	return_item_number
019dadd9-fc82-7c09-a80e-83d836bb86e5	URS028-RETURN-001	RET-1-FL516SNA-1

---

Return linked to correct organizations

PASS

Return should be linked to ZuriMED (manufacturer) and StellarTech (distributor)

SELECT r.id, r.return_number,
        r.manufacturer_organization_id, mo.name as manufacturer_name,
        r.sales_organization_id, so.name as sales_org_name
      FROM returns r
      JOIN organizations mo ON r.manufacturer_organization_id = mo.id
      JOIN organizations so ON r.sales_organization_id = so.id
      WHERE r.created_by_user_id = $1
        AND r.created_at > NOW() - INTERVAL '30 minutes'
      ORDER BY r.created_at DESC
      LIMIT 1

id	return_number	manufacturer_organization_id	manufacturer_name	sales_organization_id	sales_org_name
019dadd9-fc81-7128-9de2-6eb5e27a3a8c	RET-1	a1b2c3d4-e5f6-7890-abcd-ef1234567890	ZuriMED	b2c3d4e5-f6a7-8901-bcde-f12345678901	StellarTech Medical Solutions

---

Return has locations set

PASS

Return should have both return and replacement locations set

SELECT r.id, r.return_number,
        r.return_location_id, rl.name as return_location_name,
        r.replacement_location_id, repl.name as replacement_location_name
      FROM returns r
      JOIN real_world_locations rl ON r.return_location_id = rl.id
      JOIN real_world_locations repl ON r.replacement_location_id = repl.id
      WHERE r.created_by_user_id = $1
        AND r.created_at > NOW() - INTERVAL '30 minutes'
      ORDER BY r.created_at DESC
      LIMIT 1

id	return_number	return_location_id	return_location_name	replacement_location_id	replacement_location_name
019dadd9-fc81-7128-9de2-6eb5e27a3a8c	RET-1	6ea3b4c5-d6e7-8901-6789-012345678901	BOSS - Shipping	6ea3b4c5-d6e7-8901-6789-012345678901	BOSS - Shipping

---

Return has reporting and created_by users

PASS

Return should have both reporting_user_id and created_by_user_id set

SELECT r.id, r.return_number, r.reporting_user_id, r.created_by_user_id,
        u1.name as reporting_user_name, u2.name as created_by_user_name
      FROM returns r
      JOIN users u1 ON r.reporting_user_id = u1.id
      JOIN users u2 ON r.created_by_user_id = u2.id
      WHERE r.created_by_user_id = $1
        AND r.created_at > NOW() - INTERVAL '30 minutes'
      ORDER BY r.created_at DESC
      LIMIT 1

id	return_number	reporting_user_id	created_by_user_id	reporting_user_name	created_by_user_name
019dadd9-fc81-7128-9de2-6eb5e27a3a8c	RET-1	17b8c9d0-e1f2-3456-1234-567890123456	17b8c9d0-e1f2-3456-1234-567890123456	Bob Kauffman	Bob Kauffman

Downloads

• report.md
• result.json
• screenshots-index.json

Feedback