Announcements
No record found.
I am using RM00102.USERDEF2 to hold a value that needs to print on SOP documents. This value is used for the Ship To Address code. On the packing slip form the Customer Master Address File is linked but it is using the ADRSCODE field which unfortunately defaults to the billing address. I have tried to switch it to the primary shipping code but that field is not even listed as an option. Is there any way to get the packing slip to use the ship to address record as opposed to the bill to address record?
Richard, I haven't used Report Writer in so long -- can you add the Customer Master Address in Tables a second time and join it to Primary Ship To Address Code in Sales Transaction Work?
The other option that pops into my head is using VBA and a SQL query to get the value to a calculated field. Yes, I know, VBA is deprecated, but it would still work.
Joe
I tried adding the Customer Master Address table a second time but it does not appear on the list in R/W even after choosing the primary ship to address code. I think we will convert our forms using GP Reports Viewer from Flex-Solutions.
Hi Richard
You cannot add a table to the report writer twice and it can only use the defined relationships on the tables.
But there is an easy solution for you using the RW_RMAddrIDInfo() RW Function I added into the core code back in 2002 and updated to include the UDF1 and UDF2 fields in 2014.
Just create a calculated field using the user defined function in the system series and pass in the Customer Number, Address Code and a integer constant value of 15.
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
}
This works like a charm. Thank you very much.
Hi Richard-
If you were going to go down the route of using SSRS, I have a TON of SQL views and SSRS templates I've used and am happy to share them with you. My ISV solution of choice for this has been Dynamics Report Manager from Rockton Software.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 555 Most Valuable Professional
André Arnaud de Cal... 484 Super User 2026 Season 2
CU10121822-0 378
