I am using this template to build a report for a client but I am finding that all of the AR invoice amounts have been doubled ie. the client is billed for $30k but the report shows $60k. I have opened the Sales worksheet and reviewed the data and all of the amounts in the invoice fields ie. Invoice Amount Exclusive, are doubled. Has anyone else had this issue?
Duplication is usually a table linking issue with any reporting software. You might look at the container in the connector module and see if a table is linked to another that has multiple records for each customer invoice. I don't use Sage 300, so I'm not familiar with the tables.
I suggest downloading the latest Dashboard Analysis report from the Report Utility and see if you still have the same problem after importing it.