Dynamics Community Forum Thread Details

D365FO:Formula Edits Revert to Baseline in Derived Model Mapping (CustomerInvoice)

Hello Community,

I created a derived version from Invoice model mapping (FR) 322.395.11 (Definition: CustomerInvoice)

I want to modify a calculated field custinvoicejour to point directly to table record CustInvoiceJourLines (standard CustInvoiceJour) to bypass French B2B domestic view dependencies (CustInvoiceJourView).

The main Problem:

Formula Edits Revert on Save:

Modifying the formula for CustInvoiceJour inside the Formula Designer shows no validation errors. However, saving and re-opening silently restores the old expression.

The standard expression of calculated field CustInvoiceJour:

FILTER(CustInvoiceJourLines, AND(CustInvoiceJourLines.InvoiceId=CustInvoiceJourView.InvoiceId, CustInvoiceJourLines.InvoiceDate=CustInvoiceJourView.InvoiceDate, CustInvoiceJourLines.LedgerVoucher=CustInvoiceJourView.LedgerVoucher))

The new expression:

FILTER(CustInvoiceJourLines, CustInvoiceJourLines.RecId = $JournalRecId)

My question is: Why does ER silently override the formula on the calculated field?

Two checks first: is the derived version in Draft status, and are you saving inside the Formula Designer before closing it? Edits to a Completed version don't persist, and the formula designer needs its own save separate from saving the mapping.

If both are fine, the thing I'd question is $JournalRecId. That doesn't look like ER binding syntax — ER resolves references against data sources in the tree. If it doesn't resolve, ER dropping the expression on save would look exactly like what you're seeing, validation errors or not. Where is JournalRecId defined in your mapping?

Also worth checking: your new expression drops the CustInvoiceJourView dependency, but other components in the base mapping are probably still bound to it.

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL