Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SOP Blank Order Form

Status
Not open for further replies.

mtndew9

MIS
Jan 23, 2002
22
US
We are entering a new order and the customer has 2 Ship to Address ID's. We have setup Address ID’s of Ship1 and Ship2, they are different physical locations. We want Ship2 to print on the above report, but it is always printing the Ship1 Address. We have selected Ship to Address ID SHIP2 on the Sales TRX Entry screen. Is there something I Missed? Any help would be appreciated.
 
Can I suggest using the rw_SelectAddrLine user defined function in the system series.

You can pass in the number of the line you want and all the separate address information and it will return the lines without any blanks.

in integer nLineNum;
in string sLine1_Contact;
in string sLine2_Company;
in string sLine3_Add1;
in string sLine4_Add2;
in string sLine5_Add3;
in string sLine6_City;
in string sLine6_State;
in string sLine6_PostalCode;
in string sLine7_Country;

Create one calculated field for each of the lines you want returned, changing the first paramter accordingly.

David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.
 
Thank you for the reply. I just had to select the SHIP TO ADDRESS ID on the Sales order header instead of the line item and it worked fine. I am looking at your option in case we have 2 line items that ship to different places.

Again thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top