Announcements
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?
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
This works like a charm. Thank you very much.
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
}
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.
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156