Ensuring the accuracy and privacy of your customer or vendor data should always be top of mind, but that’s especially true when it comes to their bank account details.
Orchid’s EFT Processing module provides audit logging and reporting capability ‘out of the box’ to assist with this, but when you combine it with Orchid Extender it can easily be taken to another level. Read on to find out more.
“Out of the Box” Logging & Reporting
EFT Processing maintains an audit log of all changes to Customer and Vendor bank details in Sage 300. (What changed, when it changed, who changed it, what it changed from, what it changed to.)
It also comes with a standard report, allowing you to view all those changes, and filter for selected Vendors, Customers and/or date ranges.
Alternatively, you can access the audit log table directly if you wish to write your own custom reports.
Advanced Logging & Alerts with Extender
Logging changes to (your) EFT Bank details
Maintaining the integrity of your customer and vendor bank account details is one thing, but how about your own bank account?
Using Orchid Extender (Configurator Edition), you can also log changes to your EFT Bank fields. Changes are stored in the Extender log, from where they can be viewed or reported on.
Generating Alerts (Notes or Emails) when bank account details change
Extender (Configurator Edition) lets you create a Note (see Orchid Notes), or send an email, when a monitored field changes. In this case, that could be a change to Customer or Vendor bank details.
Why might you want to do this? Here are just a couple of examples:
- If you are paying staff via EFT, you may need keep the bank details in your payroll system in synch with the Vendor bank details in EFT Processing. It’s much easier to be alerted for each change than to sift through a full log of all changes.
- A Note displaying the latest change to bank details could be displayed next to the AP Invoice screen. When entering an invoice, you can then confirm at a glance that the Vendor bank details currently stored in EFT Processing match the details on the invoice.
OK, I’m interested! How exactly how do I do all this?
Our Business Partners can find lots of articles on EFT Processing and Extender configuration in our KnowledgeBase. For detailed instructions on the scenarios above, start with this EFT Processing Logging & Alerts article (login required).
