Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Using Ship To User-Defined 2 on SOP documents

Posted on by 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?

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,863 on at
    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 Profile Picture
    Richard Wheeler 75,730 on at
    RE: Using Ship To User-Defined 2 on SOP documents

    This works like a charm. Thank you very much.

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,837 Moderator on at
    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 Profile Picture
    Richard Wheeler 75,730 on at
    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 Profile Picture
    Joseph Markovich 3,863 on at
    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

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans