Skip to main content

Notifications

Announcements

Announcing Category Subscriptions!
News and Announcements icon
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 20

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

  • Tini Bosch Profile Picture
    Tini Bosch 20 on at
    Electronic Reporting - Collection letter report (Excel)

    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

  • Anton Venter Profile Picture
    Anton Venter 18,788 Super User 2024 Season 2 on at
    Electronic Reporting - Collection letter report (Excel)
    Can you add you question again? Someting went wrong and there is no text, just 2 bullets.
     

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans