Skip to content


SOP records being doubled

Daniel asked 5 years ago
trying to import SOP transactions and the number of records is doubled that what it should be.   I’m picking a “header ID” as the key field which is unique but when I preview in the data source tab it shows all of the header and detail records.  But when I preview the data in the mapping and only grouping on the header ID, I only get the number of header records…
any idea why this is happening?
Daniel answered 5 years ago
found my error….  I’m doing multiple companies at once and I had a vba script to select the company and I also had a company checked, so it was doing 2 records in each “company”, even though it was the same company.

If you would like to submit an answer or comment, please sign in to the eOne portal.