Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Modify Cash Receipt Re...
Finance | Project Operations, Human Resources, ...
Suggested answer

Modify Cash Receipt Report

(1) ShareShare
ReportReport
Posted on by JBurgess 70
I'm trying to modify the Cash Receipt report that can be used to email a "remittance" of sorts to customer that make payments. I've modified reports in GP before with success, however I'm not able to get any additional fields to show up/pull data on the report. Is there anything special about this report that others have seen? I can update text fields and move default fields around on the report to confirm changes are being made and the modified version is used, but adding a table/field will not pull the data.
Categories:
Microsoft Dynamics GP
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 548 on at
    Modify Cash Receipt Report
    What version of GP are you on?  If you aren't on GP 18.5 or newer, you may want to consider if upgrading to get the Microsoft Dynamics GP October 2022-Print Cash Receipts and email enhancement would help.
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Modify Cash Receipt Report
    The available fields in Report Writer are subject to the tables that are linked into the report... If you need more fields from other tables, you have to link them first, which isn't always obvious in RW. 
    You might have a quicker result by using SSRS and using one of Victoria Yudin's pre-backed SQL views.. 
     
    Hope that helps.
    Beat (aka GP Geek)
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,949 Most Valuable Professional on at
    Modify Cash Receipt Report
    Without checking the actual source code, I would say that the report is using a temporary table and only populating the fields used on the report.
     
    So, creating relationships to other tables might not work if the key fields used are not populated.
     
    Try dragging any fields you are trying to use onto the report to see if they have values.
     
    With GP Power Tools it might be possible to either populate other fields in the temporary table, or use custom RW functions to return any additional data needed to the report.
     
    Regards

    David

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 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