On Sage 100 Advanced 2021 sp5.
I created a container with only the AR_InvoiceHistoryHeader file.
added 4 fields. set the filters to a single date and only Source Journal "SO"
the invoices are all duplicated. I tried the same thing on a different install to be sure it works and it does.
What would cause the data to duplicate?
I've seen this when a report was created in the Consolidation Connection and had the same co code in there twice.
Some things to try:
Recreate the report making sure the container is under the Auto…
that was it. it appears when a new user was added last week, it added the company code a second time.
I deleted it and the reports are working. Thanks to all for your assistance.
Add HeaderSeqNo to make sure it is a reporting issue (not actual duplicate data).
same thing. data not duplicated.
did that and built another report in Crystal to see the data.
data is not duplicated. Not that I can find anyway.
