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

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) / Report Writer: User de...
Microsoft Dynamics GP (Archived)

Report Writer: User defined functions

(0) ShareShare
ReportReport
Posted on by Jason Maggard 650

Hello,

I inherited a GP 10.0 install and did an upgrade to GP 2013. Everything has gone smoothly, but when I try to print off one of my reports, I get "Error in equation trxvoided". Easy enough to track down, and I'm now looking at the equation in question.

The equation uses a User Defined function: RW_SetVoidedFlag

Looking at the SDK documentation, I cannot find this function in GP 2013 or GP 10.0.

Is there some way to view the User Defined Functions? I have gone over the docs several times, and nothing tells me that there is. Are there user defined functions that are undocumented? How do I know what this function is doing, and where is the function defined?

Ummmm, help?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Dave Dusek Profile Picture
    Dave Dusek Microsoft Employee on at

    Jason,  

    RW_ functions are in the dynamics.dic source code, the only place you will see them would be in source code itself or in the SDK in the CoreParams_version.txt file and there it will just give you the parameters.  Here are the params from the SDK and it doesn't look like they have changed in a long time.  

    FINANCIAL GLOBAL FUNCTION:  RW_SetVoidedFlag

    ------------------------------------------------------------------------

    function returns         boolean                  rVoided;

    in                       Voided                   iVoided;

    in                       'Void Date'              iVoidDate;

    in                       string                   iEndDateStr;

    in                       string                   iEndDateMonthStr;

    in                       string                   iEndDateDayStr;

    in                       string                   iEndDateYearStr;

    ------------------------------------------------------------------------

    You do have to provide all of these parameters.  In looking at it, we do use this function in the Checkbook Register report in the trxvoided calc field.  Is that the report and field you are running into trouble with?  The calc field trxvoided conditional statement should look like this:

    RW_SetVoidedFlag'( 'CM_Transaction'.'Voided''CM_Transaction'.'Void Date'legend[ 18 ] legend[ 19 ] legend[ 20 ] legend[ 21 ]  )   =  1

  • Jason Maggard Profile Picture
    Jason Maggard 650 on at

    So, my fresh GP2013 install should already have this function present? So why are my reports erroring out?

    And FYI, you're correct, it is the Checkbook Register report that is erroring out.

    The current formula looks like: RW_SetVoidedFlag'( 'CM_Transaction'.'Voided''CM_Transaction'.'Void Date'legend[ 18 ] ) = 1

    This formula still works in GP 10.0.

    What I have done to get this report to work is just to check the "voided" status. So in a conditional field,

    CM_Transaction.Voided = 1

    The "trxvoided" field is just a boolean that puts an asterisk in front of the line if the check is voided, amiright? What does the RW_SetVoidedFlag do that I'm not accomplishing by simply checking the database to see if the transaction is set to Voided or not?

    Thanks very much for your help.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans