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 / Microsoft Dynamics GP (Archived) / Cutt date not printing...
Microsoft Dynamics GP (Archived)

Cutt date not printing in the customer statement

(0) ShareShare
ReportReport
Posted on by Romryan

In the customer statement,the cutt off date doesn't print on the statement together with summarized date...these 2 fields come from RM40501  (RM Statements Options File).Is it a bug or there is something that can be done?.they don't print even in gp2013.

Thanks

*This post is locked for comments

I have the same question (0)
  • Mike Smith Profile Picture
    Mike Smith 6,840 on at

    I've encountered this before in that the table doesn't actually populate with that date. I think we have had to implement a trigger for this in scenarios where this was a requirement.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi Romryan,

    The RM40501 table stores the details of your Statement IDs. Of course, you can change those at any time, so that table only shows the current value of your selections. What's more, the Statement ID isn't stored with the Statement detail. Therefore, the values in that table are worthless after the statement is printed. You know that, but for the benefit of others I thought I'd mention it.

    Mike's answer is probably the best, but here's another approach to consider. Still, you need to use VBA to get this to work.

    I take the values from the RM40501 table at the time the statement is printed and, using VBA, put them on the report. In order to store the date values, I hijack the STMTID and PHONE3 fields in the RM30701 table and write the date (as strings) to those fields.

    It may not be very elegant, but it works.

    Kind regards,

    Leslie

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans