1,065
Hello Everyone,
I would like to know if the format of the Phone field in company setup can be changed
example the default is set to (111) 111-1111 Ext 0000. The Ext cannot be remove.My issue with this is I am generating a report in report writer, this reports requires the company phone number, and the phone is pulling from the company setup table. How do I removed the ext part of the field so it dosen't reflect on the report.
thanks for your help
*This post is locked for comments
I've read through the above recommendations but our company is a little more complex than the company wide change. We currently have multiple databases. Within each company database the phone number format will be multi-country across vendor and customer master records. I recall someone suggesting using the link capabilities in modifier to identify the country code to determine the format. Unfortunately I am not able to find this information and don't recall how it was accomplished.
Does anyone have any ideas for accomplishing this?
Thank you very much for your assistance, the step by step process you provided me worked perfectly. You have definitely expose me to a feature I can explore feather.
thanks
Below are the steps to change the formats. Please note that these steps will take effect system wide, that is for ALL companies.
How to change the Phone Format for Windows and Reports
======================================================
You can change the Phone format in Great Plains for windows (using Modifier) and for reports (use Report Writer).
These formats are not used by Smartlist and the Letter Writing Assistant. To change the format used by Smartlist and Letter Writing Assistant requires an additional process using the Modifier please refer to KB 921632.
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;921632
To change the Phone format for windows and reports use the steps below:
1) From Great Plains click Tools, click Customise, click Modifier or Report Writer.
2) Select Great Plains or Microsoft Dynamics GP.
3) Click Resources >> Formats.
4) Select the Phone_Number format and click Open to the Format Definition window.
5) In the right hand side of the window, click on the format in the Format Strings list.
6) Click Remove to remove the old format.
7) If you want a blank format, skip to step 10.
8) Edit the format in the Format String field as desired.
9) Click Insert to add the new format back.
10) Click OK to confirm the changes.
11) Click File, click Great Plains or Microsoft Dynamics GP to exit Modifier or Report Writer.
NOTE: You can change the Phone_Number3 format using the same steps, this is the format used for the Phone 3 field.
NOTE: For the format resource changes to take effect for both reports and windows, the Phone_Number and Phone_Number3 formats must be changed in both the Report Writer and the Modifier.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
I appreciate you taking the time to assist me with this, I hope this will benefical to others.
I would like to change the phone format system wide. We have a few companies in GP 10, and I would like the phone # the report pulls to be dynamic,ofcourse depending on which company we are generating the report for. I would deeply appreciate your help in getting this matter resolved.
thanks
The answer depends on whether you want to remove the Extension system wide or not.
The simplest method to "fix" this one report would be to create a new phone format of just "(XXX) XXX-XXXX" and assign that to phone number field in the report writer. This will override the default formatting with the extension.
Let me know if you need more assistance, or if you want to change the format system wide?
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (