web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Electronic Reporting -...
Finance | Project Operations, Human Resources, ...
Unanswered

Electronic Reporting - Collection letter report (Excel)

(1) ShareShare
ReportReport
Posted on by Tini Bosch 22

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

Electronic Report...
I have the same question (0)
  • BillurSamdancioglu Profile Picture
    BillurSamdancioglu 19,856 Most Valuable Professional on at
    Hi,
     
    Please fill with details.
  • Ramit Paul Profile Picture
    Ramit Paul 22,797 Most Valuable Professional on at
    MODERATOR UPDATE ****UPDATED THE QUESTION FROM WORD DOC TO TEXT HERE******
     
    Hi,
    (For some reason my description is not visible to others, hence I’ll try a word attachment).
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans