Associating a customer’s order number with your internal Purchase Order (PO) is a common process in purchasing, ERP, and logistics systems. The goal is to keep a cross-reference so both your team and the customer can track the same transaction easily. Here are the typical ways organizations do it.
1. Create a Cross-Reference Field (Best Practice)
Most systems include a field like:
Customer Order #
Customer Reference
External Order ID
Client PO
You simply store the customer’s number alongside your internal PO.
Example:
Field
Value
Internal PO
PO-45892
Customer Order
CUST-12077
Customer
ABC Manufacturing
Date
Mar 12, 2026
This allows searching by either number.
2. Add It to the PO Notes / Reference Section
If your system does not support a dedicated field, add it in:
Reference
Memo
Notes
Example:
Copy code
PO: 45892
Customer Order Ref: CO-12077
3. Use a Mapping Table (Database / ERP Method)
In databases or custom systems, create a mapping table:
Copy code
Customer_Order_Map
——————
customer_order_id
internal_po_id
customer_id
date_created
Example:
Customer Order
Internal PO
CO-12077
PO-45892
CO-12078
PO-45893
This is common in ERP integrations.
4. Include Both Numbers on All Documents
For clarity, include both numbers on:
Purchase Orders
Invoices
Packing slips
Shipping labels
Example line on documents:
Copy code
Customer Order: CO-12077 | Internal PO: PO-45892
5. Automation (If Using ERP / Inventory Software)
Most systems support automatic linking:
SAP ERP
Oracle NetSuite
Odoo
QuickBooks
Typical workflow:
Customer submits order with their PO number.
Sales order is created.
System generates internal PO.
ERP links both automatically.
✅ Simple rule used in many companies:
Internal PO = your tracking number
Customer PO = their reference number
Always store both in the same record.
💡 If you want, tell me:
what software or system you use (Excel, ERP, warehouse system, etc.)
whether this is for purchasing, warehouse, or accounting
…and I can show you the exact method or template to implement it quickly.