Description from the Publisher
mightymacros Dat add-in is designed to assist accounts payable and P2P staff, in the identification and prevention of unwanted duplicate payments. The tool installed within MS Excel, offers a non-intrusive option 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.