Substring seach in ER.

(2) Share

Report

Posted on by Lexington83

Hi,

I’ve had a request to enhance a customer remittance import configuration I built in ER so that it can handle substring matching. Sometimes customers send remittance files where the invoice number provided is 12345, but the original invoice number in the system might be something like INV12345.

I can work around some example by using text functions like LEFT, RIGHT, and MID, or reconstruct the expected invoice number using concatenation. However, I wanted to check whether anyone is aware of a substring, fuzzy‑match, or approximate‑match function available in ER formulas, or whether there is a native X++ method that ER can call to support this.

Any ideas or recommended approaches would be appreciated.

Thanks,

Lex

Categories:

Dynamics 365 Finance

I have the same question (0)