AIF Service Surrogate foreign key expansion errors

I have created a new AIF service using Tools → Application Integration Framework → Create Document service. In the query I have used Ledger JournalTable and LedgerJournalTrans as datasources. I have deployed the service. When I try to use the service in Excel Add in its giving the following error.

Please help me on this.

Hi Ashish,

This may not be the issue with AIF service but an issue with Excel add-in. Just to be double sure, have you tested the AIF service first without using Excel add-in?

Hi Harish,

Excel Add in is working fine for the existing standard services, i am able to update the data successfully using standard services.