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
