PO Name too long caused ghost line items to appear linked to invoice

Bug #1691562 reported by Jeanette Lundgren
18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Evergreen
Confirmed
Undecided
Unassigned

Bug Description

This is an issue with vendor imposed maximum field length in PO Name, but perhaps a check in Evergreen could help prevent time consuming cleanup...

Scenarios:
1- library gets busy and accidentally creates a PO name that exceeds vendor max length
2- library uses a duplicate PO name and Evergreen appends a year to the end of the name which causes it to exceed the maximum length

Known vendors affected: Ingram and Baker & Taylor

Workflow
1- library creates a PO with a name that is too long
2- library doesn't notice and activates the PO
3- in the EDI, the Line Item ID is truncated on the vendor side

This results in:
1- invoices not being matched to PO
2- incorrect matches on Line items (they can be old, with a different PO name, from a different org unit)
3- the incorrect line items appear once in the invoice screen, but there may be many of them attached

Workarounds -
1- libraries can manually link the invoices to the POs
2- If they try to receive all line items from the Invoice screen they get a permission error because they do not have permission to create/edit another library's line items that was linked incorrectly.
3- One workaround is to use the detach link to remove the incorrect line items Click detach. Save. Do it again if the line item reappears until you have them all.
4- Alternate workaround is to receive line items from the PO screen.

If you have a big PO with many line items and invoices attached, this can be a time consuming process to clean up. For example for a PO with 200+ line items, the first invoice had a ghost line item attached 67 times. That is a lot of detaching and saving. See attached image. First line item is the ghost.

Is there a way a check could be made in Evergreen to match on the PO name to prevent these ghosts from appearing? Or a way to alert the user before activating?

Revision history for this message
Jeanette Lundgren (jlundgren) wrote :
tags: added: acq-edi acq-invoice acq-po
Revision history for this message
Christine Morgan (cmorgan-z) wrote :

We just came across this issue in 3.7.2

Changed in evergreen:
status: New → Confirmed
Revision history for this message
Tiffany Little (tslittle) wrote :

Would it work to add a field to the provider record for "Max Vendor PO Name Length"? Then possibly when creating the PO name there would be a constraint on length?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

Bug watches keep track of this bug in other bug trackers.