AX 2012 To CRM Online - transfer delivery and invoicing address of an invoice.

I want to import invoices from AX to CRM, I am able to publish an XML file by putting the table CustInvoiceJour into the event handling of the Scribe setting. But this XML contain only the  basics info, and I need to also import import the delivery and invoicing address which were not in this XML.

 

I have modify the  web service,  by  adding the fields deliveryPostalAddress and invoicingPostalAdress, wich are both RecID,  in  the class SalesSalesInvoice_CustInvoiceJour.  This modification adds fields  In the XML, but  instead of having a RecId I have the Location_LocationId.  I know this field is from the AX table LogisticsLocation and I can join to the table LogisticsPortalAddress to get the details.

 

But  I don’t know how to manage that in Scribe to get the detail of these address (street, zip code ,city etc…).

 

Anybody knows how to transfer Invoices addresses from AX 2012 to CRM Online.

 

Thanks

  <?xml version="1.0" ?>

- <SalesInvoice xmlns="http://schemas.microsoft.com/dynamics/2008/01/documents/SalesInvoice" ScribeOperation="Update" ScribeObject="CustInvoiceJour" ScribeModifiedDate="2017-07-27T17:47:17" ScribeModifiedBy="bcyr" ScribeObjectKey="5637533076" ScribePublishDate="" ScribeLabel="" MessageLabel="FromAX_CustInvoiceJour" ScribeChangeLogID="">

  <DocPurpose>Original</DocPurpose>

  <SenderId>asi</SenderId>

- <CustInvoiceJour class="entity">

  <_DocumentHash>80528c9ab240891f33494c93d116726a</_DocumentHash>

  <Backorder>No</Backorder>

  <CurrencyCode>CAD</CurrencyCode>

  <CustGroup>USD</CustGroup>

  <DeliveryName>BELL CANADA ben</DeliveryName>

- <DeliveryPostalAddress>

  <Location_LocationId xmlns="http://schemas.microsoft.com/dynamics/2008/01/sharedtypes">000009374</Lo...

  <ValidFrom localDateTime="2017-07-11T15:52:02" timezone="GMTMINUS0500EASTERNTIME" xmlns="http://schemas.microsoft.com/dynamics/2008/01/sharedtypes">2017-07-11T19...

  </DeliveryPostalAddress>

  <DueDate>2017-09-25</DueDate>

  <DueDateTimeEinvoice>2017-09-25T13:47:18</DueDateTimeEinvoice>

 

Login