TMS Issue Tracking - QA and Production

Duplicate invoices on different loads

When carriers bill multiple loads in batches, they often enter the same invoice number for each one of those loads. This does not break anything in TMS, but when the invoices are extracted for account payable, oracle objects to non-unique invoice numbers.

How can we systemically make these unique? Or prevent carrier portal user from entering non-unique invoice numbers?

Astro had already suggested to carriers to add the load ID digits to the end of the invoice number to make them unique, but they don't always follow this recommendation.

Example:

Primary Reference

Invoice Number

LD95650 (Load ID)

19267

LD99371 (Load ID)

19267

LD94926 (Load ID)

19267

LD95609 (Load ID)

19267

LD95602 (Load ID)

19267

LD95671 (Load ID)

19267

LD95679 (Load ID)

19267

LD95613 (Load ID)

19267


  • Kayvan Shadpour
  • Jul 14 2021
  • Product Triage
  • Attach files