mightymacros Dat add-in helps accounts payable staff to identify uncaptured duplicate invoices before they become duplicate payments. The tool is installed within MS Excel and offers a non-intrusive means for scanning invoice information for duplicate transactions. 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.
Changelog for this release:
Modifications made to the stats form to order the date selection criteria.
Minimum requirements Windows 8.1, MS Excel 2010, MS SQL Express LocalDB version 12
Trial period of up to 30+ days