EDI 810 - Vendor Item not matching due to special characters

Greets!

Does anyone know of a way to ignore special characters for 810 invoice matching on vendor item numbers, or to automatically assign the VendorItemStripped value on a PO rather than the VendorItem?

Example: Our PO may have Vendor Item 1554-01-106; however, the 810 will arrive with Vendor Item 155401106. This causes the 810 to not auto match due to the unequal values and thus requires manual intervention.

To correct this, we can Replace & Inactivate all of the Vendor Items through ISD to be the VendorItemStripped value; however, I want to believe that there would be a better way of accomplishing this. Thank you to anyone who has knowledge on this topic!

Find more posts tagged with

Accepted answers

All comments

unknown

Our Supply Chain, and AP departments suffer with this too. If anyone has a fix I'd be interested to hear it as well. Otherwise you are doing the exact same thing that we implemented.

gtesche

It's not a way to strip off special characters, but you can choose to match on vendor item OR system item for both the EDI receiver and the EDI invoice match. Someone else posted about this recently here. I'll try to add a link to that posting.

https://community.infor.com/infor-cloudsuite-financials/f/infor-cloudsuite-financials---supply-managment-topics/30437/allow-match-on-either-item-or-vendor-item

ryan-schumacher

Thanks, Gretchen! We are doing this today; however, we find that many vendors do not actually send back our item number and instead only send back the vendor item number. I am going to inquire with one of the vendors to see if they can start also sending our item number or if there is some sort of limitation on their side. A good suggestion on your part nonetheless.

ryan-schumacher

For any who might come across this in the future, we did learn that this scenario mostly happens with our Bill Only POs -- since we are not transmitting the 850 to the vendor, they are not transmitting our item number back on the 810 and thus we have only the vendor item number to match. Regardless, after submitting a ticket to Infor and noting the VendorItemStripped value already exists in the system, they were able to replicate the issue and have created triage JR-6509888. So, hopefully this situation will have a better resolution soon.

Copyright © 2025 Infor. All rights reserved.