Invoice – Set the sate of a record
Scott asked 7 years ago
After import of all invoice data from GP to CRM using the CRM templates, I found that I could not import any invoices and line items using the [CRM_INVOICE_BK] map unless I set the record status to (New) and the state to (Active). This now leave me with history displaying incorrectly.
My task now is to validate the status of the invoices and update the state of the record. I am using the Invoice – Set the sate of the record, mapping and come unstuck with the ‘entity moinker’.
I have copied from the original map and have the entity reference the same as previous, yet received errors when trying to import.
Does anyone know how to update the state and status of an invoice and what the entity moniker is and where it may be found?
My task now is to validate the status of the invoices and update the state of the record. I am using the Invoice – Set the sate of the record, mapping and come unstuck with the ‘entity moinker’.
I have copied from the original map and have the entity reference the same as previous, yet received errors when trying to import.
Does anyone know how to update the state and status of an invoice and what the entity moniker is and where it may be found?
Answers
Scott answered 7 years ago
Normal
0
false
false
false
EN-AU
X-NONE
X-NONE
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:8.0pt;
mso-para-margin-left:0cm;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;
mso-fareast-language:EN-US;}
SmartConnectVersion: 20.15.0.51
SmartConnect Dynamics CRM Connector: 20.15.0.51
Microsoft Dynamics CRM: Online 2016
The error on import:
Error in ‘MsCrm2011Destination’.
Line ‘invoice__Microsoft__Crm__Sdk__Messages__SetStateRequest’.
Parameter ‘Entity Moniker’.
Parameter set value event.
Failed to set column Entity Moniker to an entity reference column : Object reference not set to an instance of an object.
Scott, what version of SmartConnect are you using? What version of Dynamics CRM are you using? EntityMoniker is used for setting the state request but that isn’t something you would set in your integration as it would be done in SmartConnect. What is the exact error you are getting? There are CRM rules that exist that may not allow you to update the state of the record.
SmartConnectVersion: 20.15.0.51
SmartConnect Dynamics CRM Connector: 20.15.0.51
Microsoft Dynamics CRM Online 2016
Error in ‘MsCrm2011Destination’.
Line ‘invoice__Microsoft__Crm__Sdk__Messages__SetStateRequest’.
Parameter ‘Entity Moniker’.
Parameter set value event.
Failed to set column Entity Moniker to an entity reference column : Object reference not set to an instance of an object.
Hello Lorren,
Still have not worked out how to change the status of an invoice as described above. Have you found anything further on this issue?