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 maintain a clear cross-reference so both your team and your customer can track the same transaction easily.
Below are the most common ways organizations manage this process.
1. Create a Cross-Reference Field (Best Practice)
Most systems include a dedicated field such as:
- Customer Order #
- Customer Reference
- External Order ID
- Client PO
You simply store the customer’s order number alongside your internal PO number.
Example
| Field | Value |
|---|---|
| Internal PO | PO-45892 |
| Customer Order | CUST-12077 |
| Customer | ABC Manufacturing |
| Date | Mar 12, 2026 |
This setup allows your team to search using either number.
2. Add It to the PO Notes or Reference Section
If your system does not support a dedicated field, you can include the customer order number in:
- Reference
- Memo
- Notes
Example
PO: 45892
Customer Order Ref: CO-12077
This ensures the information is still captured and visible.
3. Use a Mapping Table (Database or ERP Method)
In databases or custom ERP systems, it’s common to create a mapping table that links customer orders with internal POs.
Example Table: Customer_Order_Map
| Customer Order | Internal PO |
|---|---|
| CO-12077 | PO-45892 |
| CO-12078 | PO-45893 |
This method is often used in ERP integrations or automated systems.
4. Include Both Numbers on All Documents
For clarity, always include both numbers on key documents such as:
- Purchase Orders
- Invoices
- Packing Slips
- Shipping Labels
Example
Customer Order: CO-12077 | Internal PO: PO-45892This helps both parties track the order throughout the entire process.
5. Automate the Link in Your ERP or Inventory System
Most modern systems support automatic linking between customer orders and internal POs, including:
- SAP ERP
- Oracle NetSuite
- Odoo
- QuickBooks
Typical workflow
- Customer submits an order with their PO number
- A sales order is created in the system
- The system generates an internal PO
- The ERP automatically links both numbers
Simple Rule Many Companies Follow
- Internal PO = Your tracking number
- Customer PO = Customer’s reference number
Always store both numbers in the same record for easy lookup.