Sage 100

Sage Intelligence - ""a row with duplicates was encountered at row 1877 for data Main Accounts"" somehow for one company code on a multi-company consolidation tries to bring in the main accounts twice when the report generates to excel. Has anyone seen this before? If I remove the one company code the report is fine (with the other 5 companies). Version 4.5

I have seen this with the multi- company GL enhancement installed. When the user sets up a new main account in company 1 it asks you want to set it up in company 2. If the user says yes it writes the main account and 3 digit company code from company 1 to company 2 ( instead of writing company 2's 3 digit company code). So when you consolidate them you have the main account and 3 digit company code from company 1 and the main account and 3 digit company code (of company 1) from company 2, making a duplicate row when the designer runs. To fix it, I went into DFDM and changed all the incorrect 3 digit company codes in the GL data to the correct company code for the data set.

Interesting - that makes sense. They are not using multi-company but I probably need to take a look at some of the GL tables through DFDM and see if there is anything strange there.