Phone Number on Sales Shipment document

I am looking for a way to get my customer’s phone number on the Sales Shipment document (Report 10077). I do not see anything related to the phone number as an available Dataset in the report.

If I create an Ship-To address in the customer card, I can put the phone number in the Ship To Address, but then it doesn’t show up in the Shipping or the Billing section of the Sales Order, and I also can’t find a way to add that information to the report.

The only way I could figure out how to do it was to put the phone number in the Address 2 field of the Address and Contact section of the customer card, but then it shows up on all of the billing addresses as well, and I don’t want that.

I feel like there should be an easy way to get a phone number on shipping documents, since businesses that do their own deliveries like we do would want that information available. Anybody have any suggestions?

Thanks!

Might be easiest to make the report a 50xxx report. Then with code you can get the phone number from the appropriate customer record and include it in the dataset using a Text variable. Once the report is good, then just update your Report Selections to point to your new report instead of the base report.

Diggity30,

You are correct. The Phone No. field is not in the Dataset for the report. You should ask your Partner to add the field to the Dataset and then you can update in Custom Report Layout.

Hope this helps.
Thanks,
Steve