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?

Thanks

Views: 24

Reply to This

Replies to This Discussion

Howard,

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.

Karl

Hi Howard.

I suggest downloading the latest Dashboard Analysis report from the Report Utility and see if you still have the same problem after importing it.

https://www.sageintelligence.com/report-utility/sage-300/

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2017   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service