mightymacros Dat Add-in Audit Report
Creating the Dat report
The DAT report needs to be prepared or generated before it can be downloaded into Excel, and split by category/rule type onto worksheet tabs
Analysing the report output
- Work through selecting one rule tab at a time
- Check results against ERP and invoice records
- Determine the cause if any, then select the comment from the dropdown in the comment 'column J' that best fits
- Click the 'Update' button of the 'Comments' group on the DAT add-in ribbon menu to update or add new comments to the database
Any changes to highlight or minimum values must be done before the report is generated