web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How does RW_RMAddrIDIn...

Finance | Project Operations, Human Resources, ...

Suggested Answer

How does RW_RMAddrIDInfo work?

(0) Share

Report

Report

Posted on by Richard Wheeler

75,852 Moderator

I was given a modified blank invoice form and there is a calculated field called Attn_ContactName. I can only assume it is doing some with contact names. It is defined as:

FUNCTION_SCRIPT(RW_RMAddrIDinfo RM_Customer_MSTR_ADDR.Customer Number RM_Customer_MSTR_ADDR.Address Code 1)

What is this doing? Whenever I print an invoice no contact information appears on the invoice using a Word Template even though it is set to use this modified form.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

David Musgrave MVP ... 14,137 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Richard

RW_RMAddrIDinfo() is one of the about 50 RW Functions I added to Dynamics GP v7.0.

The documentation is in the RW_Func.doc in the GP SDK.

Also available from my article:

https://winthropdc.wordpress.com/2008/09/01/using-the-built-in-report-writer-functions/

Here is the parameter information:

function returns string OUT_String;
in 'Customer Number' IN_Customer_Number;
in 'Address Code' IN_Address_Code; { Leave Blank for Default }
in integer IN_Field;

{
IN_Field should use the following values:-
1 = Contact Name
2 = Address 1
3 = Address 2
4 = Address 3
5 = City
6 = State
7 = Zip
8 = Country
9 = Phone 1
10 = Phone 2
11 = Phone 3
12 = Fax
13 = Country Code
14 = User Defined 1
15 = User Defined 2
}

If you want data from the Customer Master record pass in the Customer Number and an empty Address Code (empty string constant).

If you want data from the Customer Master Address record pass in the Customer Number and the Address Code.

I would suggest printing the RM_Customer_MSTR_ADDR.Customer Number and RM_Customer_MSTR_ADDR.Address Code fields to the report as I doubt they have the key data you are looking for, with those values you could also use RM_Customer_MSTR_ADDR.Contact Person to get the data from the record linked by the relationship.

The whole idea of the RW function is to be able to retrieve data from records NOT linked by a table relationship. I would expect the values passed in to be from the SOP_HDR_WORK or SOP_LINE_WORK tables.

Regards

David

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 617

#2

André Arnaud de Cal... 461 Super User 2026 Season 1

#3

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans