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.
VERSION HISTORY
- Version 1.6.9 posted on 2020-08-04
This program is now Freeware. There has also been a major revision to improve response time and report outcomes. - Version 1.6.4 posted on 2020-05-27
Modified comments upload to handle the same items detected by a different rule - Version 1.6.2 posted on 2020-04-21
Now compatible with the latest version of SQL Server Express 2019 LocalDB - Version 1.6.1 posted on 2020-04-02
Security updates and support functions. - Version 1.5.9 posted on 2019-12-16
This update includes important bug fixes, including the addition of an update notification function that has been added to ribbon menu. - Version 1.5.2 posted on 2019-11-14
The stats function for duplicate invoices now includes the total items commented and the percentage that are duplicates. In addition, the charts multiple range selection method may have failed in certain regions. This has been updated and tested and hopefully now is fixed for all the other regions. - Version 1.5.1 posted on 2019-11-07
Updated Stats function providing charts for duplicate invoices and savings by quarter. This release includes important bug fixes. - Version 1.4.1 posted on 2019-10-12
Changes to queries and a bugfix applied to support the upload of invoices data where duplications have text case differences in the invoice reference - Version 1.4.0 posted on 2019-09-09
The option is now available to set a minimum amount for the duplicate report output, providing for a clearer focus on higher value items. - Version 1.3.0 posted on 2019-07-03
New optional fields for entry of payment date and payment status have been added and the currency field is now included on the report output. - Version 1.2.1 posted on 2019-03-27
Update improves the capture of duplicate invoices
Program Details
- Category: Business > Accounting & Finance
- Publisher: mightymacros
- License: Free
- Price: N/A
- Version: 1.6.9
- Platform: windows