PO number / Customer reference number changes - HACH

Issue Summary:

Users are unable to create a shipment because the Purchase Order (PO) number exceeds the allowed character limit, causing a failure in the shipment creation process.

Investigation Steps:

1. Open Developer Tools:

   • Navigate to the Delivery Window.

   • Right-click anywhere and select Inspect.

   • Go to the Network tab.

2. Check API Call:

   • Look for the JOB_API request in the Network tab.

   • Click on it and identify the API ID.

   • Search within the payload or response for the PO number.

3. Validate PO Number Length:

   • Check if the PO number length exceeds 39 characters.

   • If yes, this is likely causing the issue.
     
     
     

Database changes:

Use the following queries to adjust the delivery and line item details:

SELECT * FROM delivery_delivery WHERE ID = "Delivery_ID"

SELECT * FROM delivery_lineitem WHERE ID = "Delivery_ID";

Replace "Delivery_ID" 

Solution:

• If the PO number is indeed too long:

  • Update the PO number in the database to conform to the 39-character limit.

  • Revalidate the shipment creation process.

Final Step:

• After the fix, confirm with the client that the shipment can now be created successfully.

Notes:

• Always backup the affected records before making changes in the DB.

• Consider adding validation logic to prevent oversized PO numbers in the future.