Hi everyone, 

I have a phone number field in the Sales Order Entry task, which appears to be a customization someone added at some point. It’s not a default field, right? The text label looks a bit different than the other fields and sometimes it seems to have a phone number in it without entering one.

It appears that it’s pulling the phone number from somewhere else, possibly the customer maintenance table, but I’m not sure if it (or mine, if this isn’t a default setup, i.e. to have a phone number in sales order entry) uses the main phone number in the customer maintenance table, which is usually an accounts receivable phone number, or a buyer’s phone number, by pulling from the Primary Contact table within the Customer Maintenance table. 

I tried to use the customizer on the sales order entry panel to see where the phone number was coming from, but I couldn’t figure that out - any tips there? 

I’m trying to integrate UPS Worldship in my setup and I’d like to have a phone number that’s connected with the sales order appear on the labels generated by Worldship. It would make the most sense to have a phone number that’s most closely related to the receiving department, although most companies don’t have such a department listed in my system and would just have a buyer’s phone number at best. Worldship requires that I create a dependency in the mapping between the various tables used to generate labels. I’m trying to automate everything I can.

I believe used the SO_SalesOrderEntryheader to find the fields I needed, but was unable to locate a field for the phone number. I can use another table, but I’m not sure which it is. It’s possible I could use the Primary Contact to get this information. I’m not sure which table I should use as the dependent table if a phone number isn’t accessible from the SO table I was using. If I link a table to another table, does anyone have advice that would create a dependency that should get the best phone number for the sales order? Which table would you pull the phone number from and which field would you use? 

I’m also a bit confused generally about the table types between header, wrk, detail, and others but as I understand, I’ll typically want to use header tables and avoid wrk tables. I’m not sure about detail tables and some of the others.

If anyone has any tips with this, I’d appreciate your help very much.