Dynamics Community Forum Thread Details

Electronic Reporting model mapping: Invoice line data repeats on incorrect lines

Hello everyone,

I'm about 1.5 weeks into ER model mapping and format mappings and I'm having a problem obtaining the ProjId from the table: CustInvoiceLineInterProj.

I've tried to trace the table relationships I see by using Visual Studio View References command as shown below:

Looking at Table relations we see:

But I note some of the starting paths available in the ER Mapping DATA SOURCE is:

So I tried some of these starting paths with the following results:

Trying to map to:

CustInvoiceJour.'#01CustInvTable'.'<Relations'.'CustInvoiceLine.CustInvoiceTable_ParentRecId'.ProjId

But that resulted in no Data

Trying to map to:

CustInvoiceJour.'#01CustInvTable'.'<Relations'.'CustInvoiceLine.CustInvoiceTable_ParentRecId'.'<Relations'.CustInvoiceLineInterProj.ProjId

This resulted in just the projId being repeated for all rows.

Trying map to:

CustInvoiceJour.'$CustInvoiceTable'.'<Relations'.'CustInvoiceLine.CustInvoiceTable_ParentRecId'.'<Relations'.CustInvoiceLineInterProj.ProjId

This resulted in just the projId being repeated for all rows.

Trying map to:

CustInvoiceJour.'$CustInvoiceTable'.'<Relations'.CustInvoiceTable.'<Relations'.'CustInvoiceLine.CustInvoiceTable_ParentRecId'.'<Relations'.CustInvoiceLineInterProj.ProjId

This resulted in just the projId being repeated for all rows.

I'm wondering if the problem is the path to the CustInvoiceLineInterProj.ProjId field

is there some formula (https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-formula-language?context=%2Fdynamics365%2Fcontext%2Ffinance) I'd have to use to have the ProjId from each Intercompany customer invoice line while using one of the above binding paths?

- Jim