Hello,
I created a sop integration by following the sample listed using a header, item and distribution file.
*This post is locked for comments
How did you create the integration? Using Integration Manager, eConnect, Web Services?
Best regards,
Ian.
I used Integration Manager
Its hardly the case that you ran the integration twice and had it set to update?
Try deleting the SOP document and running it again.
What field are you linking the tables on?
Integration is set to Insert only. Deleted everything and re ran 3 times since last week with the same results. I have the Header.DocNo linked to both the Distribution.DocNo and the Items.DocNo
Should I be grouping anything?
Is there a way to map the debit acct # and the credit acct # from the same line? This may be why it's giving me 2 line items. But i only see the 1 distribution account in the mapping section which is why I did it this way. Thats why I also asked about the grouping.
Doc No Dist Acct Debit Amt Credit Amt Dist Type
Inv-8826 12000-000-0000-0000-0000 11000 0 RECV
Inv-8826 21000-000-SYNDI-0000-0000 0 11000 SALES
Yes, you need two lines for the two account codes.
You will need the relevant groupings on the header file to prevent multiple inserts. When you're setting up the grouping you can use the Preview on the source to veryify you have the correct number of header records to be inserted.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
