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) / Where to find the FUNC...
Microsoft Dynamics GP (Archived)

Where to find the FUNCTION_SCRIPT(RW_...) parameters in Report Writer

(0) ShareShare
ReportReport
Posted on by William Kow 3,795

Not all the FUNCTION_SCRIPT can be found in PartnerSource Knowledge, is there any other way for me to get detail information on how to set the parameters for a FUNCTION_SCRIPT.

For example, I managed to get the detial information on what input parameter for RW_SOP_GetCustomerItemNumber, and this calculated field can be correctly shown in the Modified Report.

However, there is not information for RW_SOP_GetCustomerItemDescription so I cannot get the result correctly.

Please advise, many thanks in advance.

 

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi William,

    I'm having a difficult time finding this User Defined Function. Which Series is it in?

    Kind regards,

    Leslie

  • William Kow Profile Picture
    William Kow 3,795 on at

    Dear L Vail,

    Please find the link below is the screenshot of the function that I am referring.

    http://img202.imageshack.us/img202/2295/20100415160204.png

    I use it in the SOP Blank Packing Slip Form to show the Customer-Item Description (maintained in   Cards > Sales > Customer Item)

    Appreciate for your help. Many thanks in advance.

  • Prakash P Profile Picture
    Prakash P 800 on at

    Hi William,

    The RW_SOP_GetCustomerItemDescription function retrieves the Customer Item Description that was assigned to the field "Field9 of globals" in the RW_SOP_GetCustomerItemNumber function.

    Therefore, RW_SOP_GetCustomerItemNumber function must be called first from the report writer to get the correct Customer Item Description.

    The input parameter for the function RW_SOP_GetCustomerItemDescription is "Item Number".

    Hope this will help you.

    Thanks,

    Prakash

     

     

  • William Kow Profile Picture
    William Kow 3,795 on at

    Yes, you are right.

    FUNCTION_SCRIPT ( RW_SOP_GetCustomerItemNumber
       1 
       SOP_LINE_LINE_WORK.Non IV
        SOP_LINE_LINE_WORK.Item Number
       SOP_LINE_LINE_WORK.Item Description
       SOP_HDR_WORK.Customer Numnber )

    FUNCTION_SCRIPT ( RW_SOP_GetCustomerItemDescription
       The-Calculated-field )

    The-Calculated-field is the returned result, in which it is the return value from RW_SOP_GetCustomerItemNumber.

    But previously I was using the SOP_LINE_LINE_WORK.Item Number which is incorrect.

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