Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | All TechTalks
I am trying to synchronize Nav Posted Sales Shipments to a CRM custom entity of the same name. I am basicaly able to synchronize all basic data except the Line items. I get a error message: Could not find key "new_postedsalesshipmentsid" in Dictionary<string, object> for entity "new_postedsalesshipments". I'm not sure how the items should be integrated in CRM. Should I simply create a subgrid that has a 1:N Relationship with my products or create a second enity for the product only, the same way it is done for the Invoices and invoices Product.
Is the NAV posted Sales Shipments a Header with multiple lines? If this is the case then you will need to have a line entity in CRM as well.
I have had to do this with Orders and Order Lines going from CRM - Nav and Back
If you have access to the Connector SDK it can be done (according to my Dev's) but I was quoted ridicules times from them so went with the above method
To integrate the line items also you will have to create a second entity and use the same way Order. I would suggest that you see the Order mappping instead of Invoice because it has more fields mapped that invoice.
Thank you for your replies.
Maybe I'm doing this wrong, but I created the 2 Entities:
1. Sales Shipments
2. Sales Shipments Products
The mapping with the connector is done with Sales Shipments Header in Nav. Up to there everything works fine. I can have the header sync in the CRM, but when it comes to the Sales Shipments Line, I still get the error that I mention in my 1st post. From what I understand is that, I am doing a lookup on a product line that does not exist in CRM. I followed what was done in Sales Order mapping. No luck.
Do I need to sync the Sales Shipments Line aswell in CRM?
( I tried it already and I am getting an error).
One or more parameters were null
--- Exception Dump ---
Caught Exception: [Microsoft.Dynamics.Integration.AdapterAbstractionLayer.AdapterException] One or more parameters were null
at Microsoft.Dynamics.Integration.Adapters.Crm2011.CRM2011AdapterUtilities.MapUnitOfMeasure(String mappedPropertyName, Dictionary`2 mappedLookupObject, EntityReference uomSchedule, CRM2011Adapter CRM2011Adapter)
at Microsoft.Dynamics.Integration.Adapters.Crm2011.ProductObjectProvider.MapLookup(Dictionary`2 dictionary, Entity entity, String propertyName, ComplexType ct, FieldDefinition field, Dictionary`2 mappedValue)
at Microsoft.Dynamics.Integration.Adapters.Crm2011.CrmObjectProvider.SetProperties(Dictionary`2 dictionary, Entity entity)
at Microsoft.Dynamics.Integration.Adapters.Crm2011.CrmObjectProvider.WriteParentEntity(Object value, String queryProperty)
at Microsoft.Dynamics.Integration.Adapters.Crm2011.CrmObjectProvider.WriteParentEntity(Object value)
at Microsoft.Dynamics.Integration.Service.Tasks.RecordWork.DoRecordWork(DbMap map, Object key, OperationType operationType, DateTime startTime, String loggingSourceName)
The log donot say much about the field causing error, but there is some attribute missing in mapping. May be detailed logs will be of some help.
Business Applications communities