Skip to content
+1-888-319-3663

COMMUNITY FORUM

Change GP Invoices to CRM

harry asked 8 years ago
Hello, i am working on the CRM_INVOICE_CH map in the CRM Templates.

First i use the GP_INVOICE_RT to sent the invoice from CRM to GP, works ok and the invoice record was created in SOP10020 table, then i posted this record in GP and running the CRM_INVOICE_CH map,this will update the record in CRM and set the status as paid.this still works.

The issue is, when the data sent from GP to CRM, not update the exist invoice detail but add a new invoicde detail record under the invoice.I can see the smartconnect use the LNITMSEQ field to identifier the records,but this field in crm invoice detail is null before the records sent to GP.

Any idea on this issue?

Thank you in advance for any assistance you may be able to provide!

Harry


Ruaan Jonker replied 8 years ago

Hi Harry

I am not sure what you mean in this thread.
Our templates only push invoices from Great Plains to CRM once the invoive inside Great Plains have been posted, which means you cannot add new line items to the invoice.

We do not update the CRM order again, but only create an Invoice in CRM from the data in GP.

Please clarify a little more if there is something else you need.

Regards,
Ruaan

harry replied 8 years ago

Thanks Ruaan,

Please ignore the previous  issue.

The map in template named as "CRM_INVOICE_RT".The data source for this map link to the GP Dynamic database "DYN2013", but my GP dynamic database name is "DYNAMINC", So i changed the "DYN2013" to "DYNAMINC" in the GP real time data source,but after that, the map can't be trigger when i posted an invoice in GP, do you know how to resolve this?

Very thanks,

Harry

Ruaan Jonker replied 8 years ago

Hi Harry

After changing the DYNAMICS database name in the GP Connector setup window, please click the "Re-Register Maps" button.

This should re-register all real time triggers withing GP.
Please note if GP is open at this time, you will have to restart it for the triggers to take affect.

Regards,
Ruaan


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