mightymacros Dat add-in helps accounts payable staff to identify uncaptured duplicate invoices before they become duplicate payments.
Version: 1.6.4mightymacros Dat add-in helps accounts payable staff to identify uncaptured duplicate invoices before they become duplicate payments.
License: Free To Try $49.00
Operating System: Windows
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 1.6.4: Modified comments upload to handle the same items detected by a different rule
Version 1.5.9: This update includes important bug fixes, including the addition of an update notification function that has been added to ribbon menu.
Version 1.5.4: Modifications made to the stats form to order the date selection criteria.
Version 1.3.0: 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: Update improves the capture of duplicate invoices
Version 1.1.8: Expanded the configuration of the tool to improve the capture of duplicate invoices.
Version 1.1.7: Option is now available to set custom row header names that match upload sheets. A new Setup file is now available to automatically check and load prerequisites on install, and the trial period has been re-set for with this download for re-evaluation.
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.