ER reporting - Customer direct debit from Customer payment journal line

(0) Share

Report

Posted on by ShawnDEV

680

Hi All,

In case a customer payment journal line links to several invoice lines, the invoice column displays with * mark.

then when I create a ER reporting with the following model mapping it shows several <MarkedInvoice>* per line as you can see below.

How can I group them to show only one <MarkedInvoice>* instead of many?

I have the same question (0)

All responses (4)

Answers (2)

Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can refer to this official documentation: Electronic reporting (ER) overview - Finance & Operations | Dynamics 365 | Microsoft Learn. This article provides an overview of the Electronic reporting (ER) tool. It includes information about key concepts, the scenarios that ER supports, and a list of formats that have been designed and released as part of the solution. Or you can also try custom development to solve this problem.

Best regards,

Kevin

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

When you settle more than one invoice to a payment journal line, you will get * to indicate that there are more than one invoice that is marked to the journal line. In order to change this routine you need to do a customization.

While on ER side, you can create a modification to show group of invoiceId that are marked to a journal line based on settlement information.

Example:

Was this reply helpful? Yes No
ShawnDEV 680 on at

Like (0)

Report
Copy link

Link copied!

Hi Alireza,

Thank you.

if I follow your suggestion,

it shows linked invoice ids. but what I want is to show one <MarkedInvoice>*<MarkedInvoice> per journal line. Can we do that?

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Shawn,

You can try to use COUNT function to count invoices and if they are over than 1, it will show <MarkedInvoice>*<MarkedInvoice>.

Was this reply helpful? Yes No