Change GP Invoices to CRM
harry asked 9 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
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
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
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
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