Assign Alternate Match Rule Groups to Vendors in Infor CloudSuite FSM

Assign Alternate Match Rule Groups to Vendors in Infor CloudSuite FSM

Most organizations set their match rules and tolerances at go-live and never think about them again. An alternate rule group in Infor CloudSuite Financials and Supply Management (FSM) lets one vendor, or an entire vendor class, run on its own tolerances while every other vendor keeps the match company default.

In this video, we explain when an alternate rule group is worth creating and show where to assign one. We start with the annual review of match lines, both those that created match messages and those that didn’t, because outliers concentrated around one vendor or group of vendors call for a vendor-level fix.

We also share two client examples. A healthcare organization wanted tighter cost controls on its largest distributor, whose purchase order lines carried high quantities and low unit costs. Another wanted higher tolerances for its entire culinary vendor class, since those purchases produced cost messages that were almost always closed by paying the invoice price.

From there, we cover setup: building the rule group, then creating a separate match table so vendor use is easy to tell apart from match company use.

Then we go to the two places the override lives. For a single vendor, the fields are in the Match section of the vendor record’s Options page. For a vendor class, they’re under Match Options, which you reach through Administration, Vendor Structure, and Vendor Classes.

One rule of precedence covers both: a value on the vendor class overrides the match company default, and a value on the vendor master record overrides both.

Your match rules can fit the vendors that don’t fit the mold. If you’d like a second set of eyes on your own match messages, we’d love to dig in with you. Reach out to us at questions@rpic.com and we’ll connect you with the right person on our team.

Transcript

RD Davolio
My name is RD Davolio and I’m a senior finance consultant at RPI. Today’s session is on how to assign an alternate rule group, along with a couple of business reasons for wanting to do so.

Most organizations set up their match rules when they first go live and never look at or think about them again. Yet match rules and tolerances are one of the most consequential matching setup decisions. Ideally they shouldn’t be changed very frequently, but should be analyzed periodically, perhaps annually, to ensure that they are performing as expected. The analysis should include both match lines that create match messages as well as those that did not.

If you find there are a lot of items slipping through and matching within tolerance that, in retrospect, you wish would have received more scrutiny prior to payment, or many small variances creating cost messages that end with paying the invoice price, the conclusion of the analysis might be that the tolerances are set too low or too high and may need adjustment at the company level. However, if the outliers found in the analysis are concentrated around one specific vendor or a group of vendors, then perhaps the company rule group is working just fine and just these specific vendors need to be addressed.

In recent years I’ve worked with organizations to analyze their match messages and identified situations where some vendors’ purchase orders behaved differently than the general vendor population, which affected their invoice matching efficiency and effectiveness. The first example was a healthcare organization with a large main distributor that had high quantity, low unit cost items on their purchase order lines. They wanted tighter cost controls on this vendor, so they wanted tighter tolerances, but just for this large vendor.

Another recent organization wanted higher tolerances for the entire culinary vendor class because, due to the nature of the purchases, they created a disproportionate number of cost messages that were almost always closed with the action to pay the invoice price. In both of these situations, the answer was to create an alternate rule group to override the general match company default.

Now, some organizations are not even aware that alternate rule groups can be created and assigned to specific vendors or vendor classes, but that functionality does exist, and this session will focus specifically on this topic. If you need a refresher on how to understand the rule group setup, I encourage you to review a previous session dedicated to the setup.

Before assigning an alternate rule group, you should create a new one that meets the needs of your vendor or vendor class. I have two examples set up: one for the healthcare LUM vendor and one for the culinary vendor class. After setting up a rule group for a specific vendor or vendor class, I recommend also creating a separate match table where you can identify the match table specific to vendor use versus match company use. There’s not much to setting up a new match table other than to name the table, identify the table type, either company only, vendor only, or match company and vendor, and then associate it to the appropriate rule group. In this case, I associated it to the culinary vendor example.

Walking through the rule group assignment and hierarchy: the match table and rule group most commonly used for the majority of your vendors is set at the match company. The Main tab has the match table, and the Messaging tab has the rule groups, and there can be a different rule group for your PO cost messaging, your service matching, and your recon matching. But most organizations set these all up to the same rule group.

In the first example, with a single vendor assignment needed, populating the match table and match rule group at the vendor master level will override the match company setup for that vendor. I’m going to navigate to a vendor master record and display where you can find these fields to override. It’s under Vendors. In the vendor list, I’m going to select the vendor that I want to override. I’m going to go to the Options page and scroll down to the Match section. And in the Match section, you can use the dropdown to select the match table and match rule group that you created for this vendor, and then click Save.

If there’s a group of vendors, like in my example with culinary, setting it at the vendor class will override the match company for all vendors that are tied to this vendor class. I’ll now navigate to the vendor class setup and display where you can find these fields to override. I’m going to go to Administration. Under Vendor Structure, go to Vendor Classes. Select my culinary vendor class. Under Match Options, there are fields for match table and rule group where you can use a dropdown to select the appropriate match table and rule group that you set up for this. Again, entering a value on the vendor class will override the match company default, and entering a value on the vendor master record will override both the match company and the vendor class defaults.

That concludes the session on how to assign an alternate rule group. I hope you found the session valuable and can think of creative ways to make your matching process more effective and efficient. If you have any questions, please don’t hesitate to reach out to us at questions@rpic.com and your question will be directed to the most appropriate individual. Thank you for tuning in.

More How Tos