Error: “A row with duplicates was encountered at Row number 3459 for data object Accounts. The Values are : AccountKey: Accounts Receivable Company: 1110. The combination of columns [AccountKey, Company] needs to be unique for every row”.
“A row with duplicates was encountered at Row number XXXX for data object Accounts. The values are: AccountKey: YYYYYY Company: ZZZ. The combination of columns [AccountKey, Company] needs to be unique for every row” occurs when running a report designer add-in report.
Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.
- Make copy of the canned Report Designer Add-in report
- In the copy, point to the original report template
Look on Accounts tab, and verify the validity of account referenced in error. May possibly need to delete account in Account Maintenance (if unable to delete; using DFDM look in GL_PeriordPostingHistory and GL_PeriodBudgetDetail files for $0.00 records for the AccountKey referenced in error.