Small and medium business | Business Central, N...

Remittance Advice not showing payment date

(0) Share

Report

Posted on by Wildax

When we produce remittance advice from a payment it creates a PDF that is send in an email. For some reason the payment date is not shown. Is there a way to alter the template used to produce this PDF to include that?

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

Check the report ID that is being sent (when doing the sending, if there is another pop-up for the report, press Ctrl+Alt+F1 and on right side You should see the report ID). In Report Layout Selection You can check what kind of layout is used. You can try to switch it to Word, and then in Custom Report Layouts create Your design.

But if the report contains code calculated values and has some advanced logic in it, it might not be possible.

Was this reply helpful? Yes No
Suggested answer

Akash Shukla 365 on at

Like (0)

Report

Hi,

You can export the remittance report from Report Layout Selection and then you can modify the report as per your requirement.

I believe there are some additional fields are there in the report which is hide, and you can add them to make visible, or can add new fields by taking the help of Developer.

I hope this will helpful to you .

Was this reply helpful? Yes No
Wildax 5 on at

Like (0)

Report

thanks for the fast reply. I've looked at this, it shows the report id as 2487, however in the Report Layout Selection this report number does not appear!

Was this reply helpful? Yes No
KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

Try searching by name, might be You are mixing the ID with Page ID.

Was this reply helpful? Yes No
Akash Shukla 365 on at

Like (0)

Report

As you mentioned earlier, the report ID is 2487, but we couldn't find this report ID in any of the Business Central Localizations. Could you please double-check the report ID.

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

Hi Wildax,

To display the payment date in your report you';; need some customization. you need to modify the report layout and data item, as well as the main data set in your report

checkout this blog it might help you more yzhums.com/.../

Was this reply helpful? Yes No
Wildax 5 on at

Like (0)

Report

This is what we see for the detail of this report - not sure i am looking correctly

Was this reply helpful? Yes No
Wildax 5 on at

Like (0)

Report

these are the only 2 reports that have the word remittance in them!

Was this reply helpful? Yes No
Suggested answer

Akash Shukla 365 on at

Like (0)

Report

You are viewing the wrong details. When you click on generate vendor remittance at the time you view this table and check the ID which is showing under table option.

Alternatively you can check on the vendor card if any remittance advice tagged on that. Please see below images:

Was this reply helpful? Yes No
KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

Report 399 or 400 should be the correct ones. currently You are using RDLC layout, and it could be that these don't have a prepared Word layout.
To know for sure - try to Change RDLC to Word for one of them and try to Print - You should be quickly able to understand which of those 2 reports is the one You need.

Then Press on Custom Layouts, create a New one and insert Word layout. Then Export the Layout - adjust it as You need (for this You might need to google regarding Custom Word Layouts - some initial info is here: Create and Modify Custom Layouts for Reports and Documents | Microsoft Docs - OnlineHelp (to-increase.com)

Was this reply helpful? Yes No