Share
ReportHello,
I created a sop integration by following the sample listed using a header, item and distribution file.
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hello,
I created a sop integration by following the sample listed using a header, item and distribution file.
*This post is locked for comments
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.
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
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?
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?
Ian.
I used Integration Manager
How did you create the integration? Using Integration Manager, eConnect, Web Services?
Best regards,
Ian.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (