Using Ship To User-Defined 2 on SOP documents

(0) Share

Report

Posted on by Richard Wheeler

75,730

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?

Categories:

Microsoft Dynamics GP

All responses (5)

Answers (1)

Joseph Markovich 3,900 on at

Like (0)

Report

RE: Using Ship To User-Defined 2 on SOP documents

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.

Joe
Suggested answer

Richard Wheeler 75,730 on at

Like (0)

Report

RE: Using Ship To User-Defined 2 on SOP documents

This works like a charm. Thank you very much.
Verified answer

David Musgrave MVP ... 13,932 Most Valuable Professional on at

Like (1)

Report

RE: Using Ship To User-Defined 2 on SOP documents

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

}
Richard Wheeler 75,730 on at

Like (0)

Report

RE: Using Ship To User-Defined 2 on SOP documents

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.
Joseph Markovich 3,900 on at

Like (0)

Report

RE: Using Ship To User-Defined 2 on SOP documents

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