Integration Manager for Returns and multiple line items

(0) Share

Report

Posted on by nihad

182

Hello guys

I need help setting up Integration fro returns (Credit memos) and also for multiple line items, at the moment I can do one line invoice using Integration Manager

those are the sources I use for invoices, what sources do I need to use for return?

Thanks

5265.Capture11.PNG

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

sandipdjadhav 18,306 on at

Like (0)

Report

RE: Integration Manager for Returns and multiple line items

Hello Nihad,

On Destination mapping-->SOP Type need to select as "Return".

Let me know how it goes.

Thanks much

Sandip

Was this reply helpful? Yes No
nihad 182 on at

Like (0)

Report

RE: Integration Manager for Returns and multiple line items

Hello Sandip,

Thank you for answering,

when I try to change Type under the mapping it only allows me to chose Order and Invoice, I can't see return in there

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (0)

Report

RE: Integration Manager for Returns and multiple line items

Hi Nihad

You are using the econnect adapter for this and that adapter only allows Orders or Invoices.

You will need to change over to the standard IM adapter as that will allow you to import Returns.

If you have lots of transactions to import then you will need to look at either SmartConnect or Scribe for importing your transactions as the standard IM adapter is slow to import when you have lots of transactions with multiple line items.

Was this reply helpful? Yes No
nihad 182 on at

Like (0)

Report

RE: Integration Manager for Returns and multiple line items

Hello Jeffrey

Thank you for answering my question,

I'm totally new to GP I would appreciate it if you could explain to me how to change to standard IM adapter?

would that work for multiple line invoices as will?

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (0)

Report

RE: Integration Manager for Returns and multiple line items

In your integration you see the destination.

Instead of selecting Microsoft Dynamics GP eConnect, select Microsoft Dynamics GP > Sales Order Processing > Sales Transaction.

You can use the same source files as your eConnect integration most likely

Yes, you can import multiple line items. Make sure that you have the Query relationship setup between files so that the header record has one or many details.

Was this reply helpful? Yes No
nihad 182 on at

Like (0)

Report

RE: Integration Manager for Returns and multiple line items

Thank you Jeffrey,

should I remove the source files in Sales Order Processing > Sales Transaction and insert the same sources as eConnect?

and how can I copy the Query relationShips from eConnect?

Thank you

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (0)

Report

RE: Integration Manager for Returns and multiple line items

Hi Nihad

Keep the existing Integration that uses eConnect as you can still use it for invoices/orders and it will import much faster than using the standard connectors.

Use the current integration as a reference and set everything up the same except for the destination where you will select the standard IM destination.

click on the query relationships line and it will open a window to allow you to set the relationships.

Was this reply helpful? Yes No