Field not appearing in XML generated by document service AIF

Finance and Operations/AX Developer Forum
1

Hello,

I have modified the SalesSalesInvoiceService query (AxdSalesInvoice) to include the CustTable. I included the CustTable as a data source for the CustInvoiceJour data source and set the relation to: CustInvoiceJour.OrderAccount == CustTable.AccountNum as an OuterJoin with a 1:n relation.

I updated the AIF services using the wizard tool and refreshed the services in Basic > Setup > AIF > Services. I can see the CustTable fields in the schema but when I create an Invoice, the XML generated doesn’t include anything from the CustTable, is there a possibility that my relation is setup wrong or what else could cause no CustTable information to appear?

2

Hi,

Does the query have other data-sources at the same level as CustTable? If so, what is the value of the JoinMode property on the data-sources?

I’ve been caught out by this in the past, if the first data-source on a given level is set to an inner join, it may have problem reaching the other child data-sources on the same level. See here for info:
http://msdn.microsoft.com/en-us/library/bb314836.aspx