Page 1 of 11812345678910...2025303540...Last »

Values for SY01402 – System User Defaults

I needed to research the settings in the System User Defaults table recently, so I took out my list of what the syDefaultType field translated to. The table below shows the value and its definition. These constants are from the GP2013R2 build


syDefaultType Definition
1 SCBARAUTOHIDE
2 SCBARWHICHSIDE
3 SCBARWIDTH
4 SCBARICONSIZE
5 SCBARAUTOOPEN
6 UNDERLINED_PROMPTS
7 COLORSCHEME
8 BACKGROUND
9 TOOLBARBUTTONS
10 MESSENGER
13 REMINDERS
14 MAPPOINT
15 FIELDSECURITY
16 COMMISSIONS
17 VENDORLISTSORT
18 VENDORLISTINACTIVECB
19 CUSTLISTSORT
20 CUSTLISTINACTIVECB
21 ITEMLISTSORT
22 ITEMLISTINACTIVECB
23 SOPITEMMISSINGCB
24 POPITEMMISSINGCB
25 EMPLISTSORT
26 EMPLISTINACTIVECB
30 AUTOCOMPLETE
31 PRINTONEPOPERADDRESS
40 HRVETSNAICSNUMBER
41 LISTWINDOWSIZE
42 NAVBAR_BIGBTNCOUNT
43 SOPMANAGESOPTYPE
45 CPRCONVERSION
46 SQLREPORTING_TARGETLOC
47 SQLREPORTING_RPTMGRLOC
48 SQMOPT
49 SHAREPOINTSERVERURL
50 LOCKEDTOOLBARS
51 REGKEY
52 HOMEPAGEMETRIC
53 HOMEPAGEREMINDERS
54 HOMEPAGEOUTLOOK
68 MFG_MODULE_ENABLED
69 REMINDERSCUES
70 REMEMBEREDCOMPANY
71 REMEMBERUSERENABLED
72 SHOWALLMETRICS
80 RPTTEMPLATES_ENABLED
82 RPTTEMPLATES_ALLOWSTDORTEMPLATE
83 POSITIONCONTROL
84 FACTBOX_ROTATIONFREQUENCY
85 FACTBOX_IMAGESIZE
90 ISSHAREPOINTONLINE
91 EMAIL_SERVER_TYPE
92 EMAIL_PROTECT_WITH_PASSWORD
93 EMAIL_PASSWORD_RADIO
94 EMAIL_PROTECT_PASSWORD
95 PHONEHOME
96 SLAHWINDOW
97 WEBCLIENTSQLLOGIN
1493 SMARTLIST
22001 MBS_DEXPROFILE
22002 MBS_SQL_LOG

Enjoy!
Leslie

More:
Values for SY01402 – System User Defaults

March 2, 2015 · Leslie Vail · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 7

What can Winthrop Development Consultants do for you?

David Meego - Click for blog homepageYou have probably heard that I was made redundant (laid off) from Microsoft in October 2014 and have since restarted and updated the consulting business that I had before my 13.5 years with Microsoft as Winthrop Development Consultants.

Now I hear you ask, “What can David Musgrave and Winthrop Development Consultants do for you?”.

Well, read on to understand what Winthrop Development Consultants’ business model and plans are….

After working with Microsoft Dynamics GP since version 1.0 and developing for Dynamics GP since version 2.0 in 1994, I have more than 20 years’ experience working with the development tools for Microsoft Dynamics GP including Dexterity, Modified, Report Writer, Visual Basic for Application, Visual Studio and SQL Server.

I have developed a number of products and features which have either been included in Microsoft Dynamics GP or are available as ISV add-on products. These include Named Printers, Advanced Security, Field Level Security, POP Taxes, Business Activity Statement and Pay As You Go reporting (for Australian GST), Omni Tools, Omni Price, Support Debugging Tool and Menu for Visual Studio Tools.

I have presented at numerous conferences on topics such as cross dictionary development, other development techniques, and the Support Debugging Tool.

While at Microsoft, I led the Microsoft Dynamics GP Asia Pacific Development team, the Microsoft Dynamics GP Asia Pacific Professional Services team and spent about 10 years leading the Microsoft Dynamics GP Asia Pacific Support team in the role of Escalation Engineer.

For more details of my experience and history, please see the About Page on the Winthrop Development Consultants website.

So now you know “almost” everything about my career with Microsoft Dynamics GP, let me explain what I can offer you.


Winthrop Development Consultants offers my development experience to the customers, partners, consultants and ISVs (Independent Software Vendors) in the Microsoft Dynamics GP community. While I am happy to work with any organisation in the Microsoft Dynamics GP community, when working directly with a customer I will also liaise with their partner to keep them in the loop.

The offerings from Winthrop Development Consultants can be divided into the following four areas:

Development

If you have a Microsoft Dynamics GP customisation you want developed, enhanced or updated for a new version, Winthrop Development Consultants can help. With over 20 years’ experience developing for Dynamics GP, Winthrop Development Consultants can develop high quality code quickly.

Even if you have your own development staff, think of Winthrop Development Consultants when they have too much work and need additional resources.

Consulting

Sometimes there will be times when your own development team need an extra opinion from someone with an outside perspective. If you need help designing the methodology for your customisation, help implementing a difficult customisation or assistance with complex development techniques (such as cross dictionary or multi-platform hybrid development), please don’t hesitate to contact Winthrop Development Consultants.

Training

If you don’t have any development staff, but want to get someone trained up, or have existing development staff who you wish to train in Microsoft Dynamics GP customisation tools (especially in Dexterity) then Winthrop Development Consultants can satisfy your training needs.

Products

At this stage I don’t have any products on offer, but am negotiating with Microsoft for ownership of the Support Debugging Tool for Microsoft Dynamics GP, Menus for Visual Studio Tools for Microsoft Dynamics GP and SnapShot for Microsoft Dynamics GP.

I also have a number of my own ideas for new products and will be working on them. Keep an eye on the blog for updates and details in the future.


 

If you are looking at using Winthrop Development Consultants’ services you can purchase time on an ad-hoc basis, blocks of discounted pre-paid time or request a fix price quote.

If you have any questions or think that I can assist you, please don’t hesitate to contact me.

I will be at Convergence 2015 in Atlanta, on 16-19 March 2015, please track me down to have a chat.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Business, Development, Dexterity, Dynamics, GP, Menus for Visual Studio Tools, Microsoft, Modifier, Products, Report Writer, Support Debugging Tool, Visual Basic for Applications, Visual Studio Tagged: Development, General, News

View the original here:
What can Winthrop Development Consultants do for you?

February 20, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 33

Dynamics GP 2015 – Printing Arabic Text

If you are planning to upgrade to GP 2015 and currently having Arabic text in your database need to be printed using report writer, make sure NOT TO UPGRADE to GP 2015.

Normally for printing Arabic text in report writer, if your keyboard was language the text will be displayed as rubbish data as below:

In order to get this printed properly, we used to switch the keyboard language to Arabic and the text will back to normal as below:

However for GP 2015, the system will automatically switch the keyboard language to English upon the generation of the report, and unfortunately the same switch is occurred upon hitting the print button, therefore the Arabic text will never be printed in Arabic and customers will start nagging!

Hope that Microsoft could resolve this soon!


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

See original article:
Dynamics GP 2015 – Printing Arabic Text

February 1, 2015 ·  · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 42

SQL view for total payments to 1099 vendors in the prior year

We received several requests just yesterday for a listing of total vendor payments in the prior calendar year. Below is a view that will show the total payments in the prior year for all 1099 vendors. This is not necessarily meant to match the report that comes out from the Print 1099 window, rather this is total payments for […]

View article:
SQL view for total payments to 1099 vendors in the prior year

January 20, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 19

GP 2015 Web Client Uninstall – Issue & Resolution

In my earlier post, I discussed about an issue that I came across while installing web client. This one’s while uninstalling the web client.

My VM is added to my work domain and when I installed web client, my VM was connected to my work network. Back at home, in my holidays, I was experimenting with various stuff. Got my VM web client corrupted and decided to uninstall it.

Running the web client uninstall started off properly but threw the following error soon after:

Screen Shot 2015-01-02 at 6.45.37 PM

Screen Shot 2015-01-02 at 6.45.48 PM

You may see the point in time at which the uninstall process stopped: ConfigureUsers.

Tried various things, as usual, but could not fix it. Every time I tried to uninstall, it stopped exactly at ConfigureUsers.

My instinct was telling me that it was something to do with domain network issue. As I was trying this at home, it could probably be something related to that.

I connected to my work VPN and then restarted the uninstall process. This time around, the process went on smoothly and completed.

Screen Shot 2015-01-02 at 6.49.15 PM

Remember. If your machine (or a VM) is affiliated to your work domain when you installed the web client, make sure that your machine (or a VM) is connected to your work domain when you try to uninstall.

This makes a world of difference. You do know what that difference is, by now.

VAIDY

Filed under: #MSDYNGP, Dynamics GP 2015, GP 2015, GP Web Client, GP2015, Microsoft Dynamics GP, Troubleshooting, Web Client

Read more here:
GP 2015 Web Client Uninstall – Issue & Resolution

January 6, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 40

Microsoft Dynamics GP 2015 Documentation & Resources

In my opinion, Microsoft Dynamics GP team might have hurried the release of GP 2015 RTM.

Think about this. You install GP 2015 and the user manuals that comes with that are GP 2013 R2 manuals. For instance, Visual Studio Tools manual that we get after installing the tool is of version GP2013 R2, as shown below:

Screen Shot 2015-01-04 at 4.22.25 PM

Not just this manual, there are also other manuals that are basically for GP 2013 R2 but somehow got shipped with GP 2015 installation media.

Where can we get the latest manuals then? Answer is this link: Documentation and resources for Microsoft Dynamics GP 2015 and 2013.

First section on this post would be directing you to GP 2015 manuals.

QUICK UPDATE #1: I was wrong. Even this link seems to be not having *all* manuals. So probably the new ones are still under construction.

VAIDY

Filed under: #MSDYNGP, Documentation, Dynamics GP 2015, GP 2015, GP2015, Microsoft Dynamics GP, User Manuals

Read this article:
Microsoft Dynamics GP 2015 Documentation & Resources

January 4, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 70

GP 2015 Web Client Installation – Port Conflict Issue & Resolution

I have been doing some R&D with GP2015 (Desktop & Web Client) on my virtual machine for almost a week now. On that note, let me share with you one particular issue, that’s a bit silly, yet possible to be faced by many of you out there.

I had a working instance of GP 2015 Web Client on my VM (that’s connected to my work domain). I uninstalled it due to an SSL conflict with local web site. Uninstall went on smoothly.

I worked on that local web site stuff and decided to install web client back. When I began the installation, following error message happened:

Screen Shot 2015-01-02 at 3.49.01 PM

Screen Shot 2015-01-02 at 3.50.47 PM

I had no idea about this port, as this port number was never used while setting up the web client installation. I am not an expert in networking either. So googled this error and got this link on Microsoft Support KB: How to determine which program uses or blocks specific transmission control protocol ports in Windows.

I used the command netstat -ano to figure out which process is using the port 48665. Below is the list that I got:

Screen Shot 2015-01-02 at 3.50.25 PM

Highlighted on RED box is the one that was using the port 48665. This process was System Process, as found through Task Manager:

Screen Shot 2015-01-02 at 4.15.35 PM

Well, only to that extent could I proceed. My instinct asked me to restart the VM once and see if that clears this port. And it did.

Screen Shot 2015-01-02 at 3.55.00 PM

And my web client installation went on well and completed without any issues.

Reason: After uninstalling my Web Client earlier, I did not restart my machine. I continued with the local web site task and tried to install Web Client again. Previous installation would have held that port (just my assumption) and did not release it till I restarted my VM.

Resolution: If you are going to install Web Client, just make sure that you restart the server.

On my next post, I shall discuss about an issue that I faced while uninstalling my web client and the resolution to the same.

VAIDY

Filed under: #MSDYNGP, Dynamics GP 2015, GP 2015, GP Web Client, GP2015, Microsoft Dynamics GP, Troubleshooting, Web Client

Read more here:
GP 2015 Web Client Installation – Port Conflict Issue & Resolution

January 2, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 53