Share
Report
454Hello 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
or
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
All responses (
Answers (
