mightymacros Dat add-in is designed to assist accounts payable and P2P staff, in the identification and prevention of unwanted duplicate payments.
Version: 1.1.68mightymacros Dat add-in is designed to assist accounts payable and P2P staff, in the identification and prevention of unwanted duplicate payments.
License: Free To Try $65.00
Operating System: Windows
The tool installed within MS Excel, offers a non-intrusive option for scanning invoice information for duplicate transactions, meaning no external contractor or third party gets to handle your sensitive information. The tool relies on a standard set of invoice information that you upload into an Excel spreadsheet from an ERP or accounting system.
The information is then uploaded into a SQL database, where it is analysed by the program and returns a report back into an Excel workbook. The SQL database that Dat add-in uses is a localDB version of SQL Server Express having around 5 times the capacity of an MS Access database.
Among other advantages the localDB version does not require any configuration or administration.by the user. mightymacros Dat add-in is designed for regular use, ideally to be used for validation prior to a weekly payment run.
Version 1.1.68: Option is now available to set custom row header names that match upload sheets. This update should help smooth the upload process.