web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Electronic Reporting -...

Finance | Project Operations, Human Resources, ...

Unanswered

Electronic Reporting - Collection letter report (Excel)

(1) Share

Report

Report

Posted on by TiniBosch

4

Hi,

I'm investigating the options to add the following two fields from the collection letter journal transaction table (collection letter lines) to the report.

- Calculation amount (=original invoice amount)

- Collection letter code

Has anyone of you did this before? If so, how did you manage to do that? As I'm getting stuck in the data source part.
For the Calculation amount, I added a new name label to the Excel Document and I managed to bind it with the AmountInCur field in the DataModel. This however is not bound yet to a datasource.
I would like to bind this DataModel Field to the Calculation amount from the CustCollectionLetterTrans table. This seems not to be available as a data source. Whereas other fields from the same table are available.

Any suggestions to make this work?

Regards,

Tini

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Duplicate question of https://community.dynamics.com/forums/thread/details/?threadid=5a435a49-8084-ef11-ac21-00224828b1f8

Helpful resources

Quick Links

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

#1

Martin Dráb 475 Most Valuable Professional

#2

André Arnaud de Cal... 399 Super User 2026 Season 2

#3

CU10121822-0 374

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans