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)