How To Rewrite A Sub Domain To A Directory In IIS

When I signed up with my current web host the deal was limited to six domains and unlimited websites; a restriction I figured I could live within as a lot of what I intended to do would be in sub-domains and the unlimited websites allowed me to have each sub-domain in an individual website.

However, since I signed up they have, without giving any form of notification, changed the deal so it is now unlimited domains and only six websites. I’m currently in a position that I have five domains and twelve websites without the ability to create another website; the control panel shows me as having 12 of 6 websites. The only positive is that they have not, as yet, required me to trim down the number of websites I have.

I therefore spent a little time yesterday looking for a resolution to this problem. Continue reading “How To Rewrite A Sub Domain To A Directory In IIS”

Transferring GP To A New Server Without Resetting All Passwords

[One of the annoyances when migrating a client’s installation of Microsoft Dynamics GP to a new server is that, unless the new server has the same name as the old one, the password of every user needs to be reset as the server name is encrypted in with the password.

The is another alternative though and that is to create a DNS CNAME Alias and use this as the server name in the SQL Server ODBC instead of the servers actual name. When GP is migrated to a new box you only need to amend the DNS CNAME Alias and users can continue logging in with the same password. Continue reading “Transferring GP To A New Server Without Resetting All Passwords”

How To Change The SQL Server Backup Folder

Microsoft SQL ServerWhen you install Microsoft SQL Server you select the Data, Logs and Backup folder during the installation process. If you subsequently need to change these folders you can only change two of them through the SQL Server Management Studio UI. On the Server Properties dialog there are boxes for the Data and Logs default locations;

Server Properties

Continue reading “How To Change The SQL Server Backup Folder”

VAT 100 Is Missing

Microsoft Dynamics GPI ran into an issue recently when installing Microsoft Dynamics GP 2010 R2 where the VAT Return was not available. I was configuring the system in preparation for training a new client and was running through the Company options (Microsoft Dynamics GP menu » Tools » Routines » Company » Company » Options button) where I was sure the Enable VAT 100 option was but in this case wasn’t;

Company Options - No Enable VAT 100 Option

Continue reading “VAT 100 Is Missing”

Financial Year End Closing – Only Open Year Error Message

Microsoft Dynamics GPI was recently doing some training for a new client and, when showing them how to do period and year end processing encountered an error message when trying to do the Financial Year End Closing (Microsoft Dynamics GP menu » Tools » Routines » Financial » Year End Closing);

Financial Year End Closing - You must set up a new financial year before you can close the only open year.

This had me stumped for a few minutes as there were Open Year calendars (Microsoft Dynamics GP menu » Tools » Setup » Company » Financial Periods) on the system for 2011, 2012 and 2013. Typically in the UK a financial year runs from 1st April to 31st March; but this isn’t a hard and fast rule. This particular client has a different financial year and the error message was being produced as there was a gap of one day between the end of 2011 and the start of 2012. Once the calendar was fixed, the Year End Closing could be run without issue.

How To Rename A SQL Server

Microsoft SQL ServerLike some other posts recently, this one is the result of a conversation with a colleague at my new company, where I found they were unaware of something I took for granted; the ability to easily rename a comuter which has a stand alone instance of SQL Server installed.

I do this fairly often as I use quite a lot of Virtual Machines for testing different configurations, but I don’t want to have to build a new one every time, so I make copies of a base VM and rename it each time I want a new one (there is often more than one running at any one time and I want to avoid conflicts).

As well as renaming the machine inside the VM, I also rename the SQL Server to make sure it matches the name of the machine; I’ve had problems before with Microsoft Dynamics GP when I’ve not done so.

Doing this is actually very simple. Continue reading “How To Rename A SQL Server”

Feature Explained: Reporting Ledgers

Microsoft Dynamics GPIn Microsoft Dynamics GP 2010, Microsoft introduced the Reporting Ledger functionality which allows journals to be posted to one of three reporting ledgers; base, local, or International Financial Reporting Standards (IFRS).

This functionality is controlled via the General Ledger Setup window (Microsoft Dynamics GP menu » Tools » Setup » Financial » General Ledger);

Reporting Ledgers: Enabling via General Ledger Setup

Continue reading “Feature Explained: Reporting Ledgers”

Home Screen Connect Error – Server Error in ‘/lus’ Application.’

Microsoft Dynamics GPA client testing Microsoft Dynamics GP 2010 R2 prior to going live rang to say they were getting a runtime error when logging in. I dialled in and checked the home screen and couldn’t see any problem with the dynsa home screen so asked for a screenshot showing the error;

The screenshot they sent showed the below error message;

Home Screen Connect Error - Server Error in '/lus' Application.'

Continue reading “Home Screen Connect Error – Server Error in ‘/lus’ Application.’”

Automate Login To Microsoft Dynamics GP 10

Microsoft Dynamics GPClients who have upgraded to Microsoft Dynamics GP 2010 can use the new remember user and password functionality, but what about those who have not yet upgraded?

Well, in Microsoft Dynamics GP 10, and before, you can use a login macro to automate the login process. A macro can be created by pressing Alt + F8 on the login screen and following the normal login process before pressing Alt + F8 again to stop recording. Continue reading “Automate Login To Microsoft Dynamics GP 10”

Windows 7: Working With Images Leading to FFFFFFFUUUUUUUUU

WindowsOne of the issues which has annoyed me about Windows 7 for a while now has, since I started writing this blog, moved on from being an annoyance to being seriously aggravating. It’s a meme I don’t really like but it does perfectly convey my emotions;

FFFFFFUUUUUUUU

Continue reading “Windows 7: Working With Images Leading to FFFFFFFUUUUUUUUU”