+1-888-319-3663

COMMUNITY FORUM

SOP records being doubled

Daniel asked 4 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?

Answers

0 Vote Up Vote Down

Daniel answered 4 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.