Duplicate account numbers in consolidated report (Accounts S500 1-0)

Changed a report to pick up 3 of our companies (A,P and C) 

(Created consolidated connector then exported and imported the report using the consolidated connection)

The accounts union report (Accounts S500)  is one of the many that are included in it.

When it is run out of C (for example) receive:

A row with duplicates was encountered at row number 16450 for data object Accounts
The values are:
AccountKey : 5359 - C
Company : C

The combination of columns [AccountKey,Company] needs to be unique for every row

Reviewing the data on the hidden account sheet it appears that the data is all company C, just triplicated.

Any assistance would be greatly appreciated.

(What we'd expected was the account information for all 3 companies)

Parents Reply Children
No Data