I am now on holiday (ferry setting off) so there will be no posts for a couple of weeks.
azurecurve Posts Archive WordPress Plugin – Beta Testers Wanted
I recently created a WordPress archive of my Twitter posts using the plugin and theme from Ozh.
Part of the theme was a sidebar posts archive which I quite liked the look of and have now extracted and turned into a WordPress plugin so I can use it on any site (including this one):
Check out the archive in action in the sidebar to the right below the Calendar and above the Tag Cloud.
I am thinking about releasing it via the WordPress Plugins Directory, but before doing so, wondered if anyone might be interested in doing some beta testing? It is a very easy install (upload to plugins folder, activate and then place widget in widget area) and currently has no options although I am willing to create some if necessary (such as the ability to change the display name).
The plugin only reads the number of posts and does not write back to the database so there is no risk.
If you’re interested in beta testing get in touch with me (by email if you have it or use the Contact page) and I’ll send you a download link (I’m not posting publicly as I want to keep numbers under control while it gets tested).
azurecurve Twitter Archive Created
Apparently Twitter only allows you to download the last 3,200 posts you have made. While I am substantially short of this number at present, I thought it might be useful to keep an archive of these posts myself so I always had access to them.
The CMS I am most used to these days is WordPress and I recently came across a plugin and theme from Ozh which allows you to make an archive of your Twitter which looks like the new Twitter. This azurecurve Twitter Archive is now available; it has been themed to look very like my Twitter page but has all the functionality of WordPress.
Extract ABR Transactions For Import As Statement
this is a simple script, but I’ve written it about four times now so I figured I’d post it so I can find it easily next time I lose my local copy.
Perfect Image are resellers of the Advanced Bank Reconciliation module from Nolan Business Solutions (along with the other add-ons they’ve written for Dynamics GP) and I often need to demo this replacement for the standard Bank Rec module.
One item I typically show is the auto-Propose function which matches transactions against statement lines in the Reconcile Bank Transactions window ().
To do this I need to be able to import statement lines which match the transactions in Dynamics GP; the easiest way of doing this is to extract the transactions.
This can be done with a very simple SQL script:
SELECT
ORPSTDDT
,ORDOCNUM
,TRXAMNT
,SOURCDOC
FROM
NCABR012
Once the data has been extracted it can be imported during the demo using the standard ABR Import Statement routine.
SQL Server Cannot Start Following Maintenance
I’ve just finished doing some maintenance on one of my development servers and encountered a problem where I could not restart the SQL Server. The development server was a virtual machine running on VMWare which had a second virtual HDD installed for SQL Server to store the database and log files. This disk had been provisioned at 200GB and over time had acquired a lot of files, such as database backups, which became unnecessary and had filled the 200GB.
I needed to get some of the space back on the VM host so I stopped the SQL Server, copied the SQL mdf and log files to a new HDD, deleted the SQL HDD and then set the drive letter of the new HDD to that of the old one.
I then tried to start SQL Server and received the following error:
Windows Event Viewer – FCB::Open failed: Could not open file E:\SQL208RTM\Live\DYNAMICS.mdf for file number 1. OS error: 5(failed to retrieve text for this error. Reason: 15105).Continue reading “SQL Server Cannot Start Following Maintenance”
SQL Script To Locate Columns With Different Collation
A while ago I posted about a problem with a collation conflict on a couple of columns in the Tax table. It seems I posted about how to fix the problem, but it seems I didn’t post how I found the problem columns.
I did this with a fairly simple SQL script:
DECLARE @Collation SYSNAME SET @Collation = 'SQL_Latin1_General_CP1_CI_AS'
SELECT
TABLE_NAME AS 'Table'
,COLUMN_NAME AS 'Column'
,DATA_TYPE AS 'Data Type'
,COLLATION_NAME AS 'Collation Name'
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
DATA_TYPE IN ('varchar','char','nvarchar','nchar','text','ntext')
AND
COLLATION_NAME <> @Collation
Deactivate All Reports (Except PM EFT Payment Register) In All Companies
Microsoft Dynamics GP includes a large number of reports which will automatically print off when a transaction or batch is posted; and some postings produce many different reports.
When I implement a new client I typically leave them on during training with an instruction to identify which ones they want to use after go-live as I will switch off any I’m not told to leave on.
I used to do it the other way and tell people to let me know which ones they wanted switched off; however, this lead to all reports being left on and then it being mentioned a year or so down the line that they get all these reports printing that they don’t want.
So now, all get switched off unless I am specifically told to leave them on. As I’ve dealt with clients with many companies (I think the largest is 180 companies) this is not something I want to do manually.
Fortunately, the settings for whether the reports should print is stored in SQL table which means a SQL script can be written to switch them off in bulk.
Continue reading “Deactivate All Reports (Except PM EFT Payment Register) In All Companies”
Microsoft Dynamics GP 2013 R2 Coming Soon
The next version of Microsoft Dynamics GP, 2013 R2, is going to be released soon. I can hardly wait, but, unfortunately, I have to 🙁
The Dynamics GP Support and Services Blog have posted an article today outlining their intended blog post schedule where they are going to run through the upgrade process and all of the new features which are due in the coming version.
- April 29 – Lifecycle
- May 1 – Upgrade Planning
- May 6 – Known Upgrade Issues
- May 8 – Version Checks & Upgrades
- May 13 – Database Upgrade
- May 15 – Modified Dictionary Upgrade
- May 20 – Upgrade Troubleshooting
- May 22 – GP is upgraded – what’s next?
- May 27 – Upgrading Web Client
- May 29 – Tables Changes in R2 – Review the SDK
- June 3 – Identity Management
- June 4 – Azure Backups
- June 5 – New Workflow
- June 10 – Requisition Management
- June 11 – OLE Document Attach
- June 12 – Human Resource Time Entry
- June 17 – Project Accounting Time Entry
- June 18 – General Ledger
- June 19 – Payables Management
- June 24 – Receivables Management
- June 25 – Bank Reconciliation
- June 26 – Analytical Accounting
- July 1 – Fixed Assets
- July 2 – Sales Order Processing
- July 3 – Inventory Control
- July 8 – Purchase Order Processing/Encumbrance Management
- July 9 – Email or Print any report in Word
- July 10 – SmartList Designer 2.0
- July 15 – Office 365
- July 16 –Take Company Offline
- July 17 – Ribbons in Desktop
Integration Manager – An Item With The Same Key Has Already Been Added
I was working with a client the other day with Integration Manager to import some purchase orders when we received the following error on some of the purchase orders:
5. 820909 Insert Failed 0. Seconds
DOC 4 ERROR: An item with the same key has already been added.The vast majority of the documents integrated without problem. When we examined the documents which failed, we determined that those which failed were those which had a currency of Euro.
Integration Manager errors are typically very unhelpful and this was no different; the first thing we checked was to see if the PO Number existed in GP, but as we expected it did not.
We did some investigating and found that the Euro Exchange Rate’s Transaction Rate Default in GP was defined as Exact Date; I was able to update this to Next Date after which the integration stopped producing errors.
Integration Manager Bank Transaction – Unimplemented Cast From Btype ‘BROWSETYPE_UNKNOWN’
I’ve been configuring an integration in Integration Manager for a client recently to assist with an Intercompany Bank Reconciliation process. When we started discussing the integration I had taken a quick look at the sample Bank Transaction integration which ships with Integration Manager and had no problem.
As the project progressed and I created the Bank Transaction integration on the client’s server I encountered the below error:
Show/Hide Error Message
Integration Log
Integration: Intercompany Bank Transfer - Transaction (ID: 66)
Action: None
Start Time: 25/02/2014 14:36:53
25/02/2014 14:36:58 Source: IIntegrationEngine_Run, Status Code: 0 Opening source query...
25/02/2014 14:36:59 Source: IIntegrationEngine_Run, Status Code: 0 Establishing source record count...
25/02/2014 14:36:59 Source: IIntegrationEngine_Run, Status Code: 0 Beginning integration...
1: GBP Insert Failed 2. Seconds
DOC 1 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
2: GBP Insert Failed 0. Seconds
DOC 2 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
3: GBP Insert Failed 0. Seconds
DOC 3 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
4: GBP Insert Failed 0. Seconds
DOC 4 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
5: GBP Insert Failed 0. Seconds
DOC 5 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
6: GBP Insert Failed 0. Seconds
DOC 6 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
7: GBP Insert Failed 0. Seconds
DOC 7 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
8: GBP Insert Failed 0. Seconds
DOC 8 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
9: GBP Insert Failed 0. Seconds
DOC 9 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
10: GBP Insert Failed 0. Seconds
DOC 10 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
11: GBP Insert Failed 0. Seconds
DOC 11 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
12: GBP Insert Failed 0. Seconds
DOC 12 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
13: GBP Insert Failed 0. Seconds
DOC 13 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
14: GBP Insert Failed 0. Seconds
DOC 14 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
15: GBP Insert Failed 0. Seconds
DOC 15 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
16: GBP Insert Failed 0. Seconds
DOC 16 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
17: GBP Insert Failed 0. Seconds
DOC 17 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
18: GBP Insert Failed 0. Seconds
DOC 18 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
19: GBP Insert Failed 0. Seconds
DOC 19 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
20: GBP Insert Failed 0. Seconds
DOC 20 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
21: GBP Insert Failed 0. Seconds
DOC 21 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
22: GBP Insert Failed 0. Seconds
DOC 22 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
23: GBP Insert Failed 0. Seconds
DOC 23 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
24: GBP Insert Failed 0. Seconds
DOC 24 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
25: GBP Insert Failed 0. Seconds
DOC 25 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
26: GBP Insert Failed 0. Seconds
DOC 26 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
27: GBP Insert Failed 0. Seconds
DOC 27 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
28: GBP Insert Failed 0. Seconds
DOC 28 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
29: GBP Insert Failed 0. Seconds
DOC 29 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
30: GBP Insert Failed 0. Seconds
DOC 30 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
31: GBP Insert Failed 0. Seconds
DOC 31 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
32: GBP Insert Failed 0. Seconds
DOC 32 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
33: GBP Insert Failed 0. Seconds
DOC 33 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
34: GBP Insert Failed 0. Seconds
DOC 34 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
35: GBP Insert Failed 0. Seconds
DOC 35 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
36: GBP Insert Failed 0. Seconds
DOC 36 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
37: GBP Insert Failed 0. Seconds
DOC 37 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
25/02/2014 14:37:12 Source: FinishIntegration, Status Code: 3 Integration Failed
25/02/2014 14:37:12 Source: FinishIntegration, Status Code: 3 Integration Results
37 documents were read from the source query.
37 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
37 failed to integrate.
Finish Time: 25/02/2014 14:37:12
Source Total: 37
Successfully Integrated: 0
Integrated With Warning: 0
Failed: 37
Completion Status: Completed
Integration Status: No Documents Succeeded
I fiddled around without being able to identify a cause of the problem and, while I was doing this, found that the 37 transactions in the file had actually integrated despite the error message (an error in IM usually means the transaction or line will not be successfully integrated).
I brought a copy of the Integration Manager back to my test system and ran it on there and all of the files integrated without error.
The difference between my test system and the client’s system is that I have Microsoft Dynamics GP 2013 Service Pack 2 while the client is still on Service Pack 1.
In the medium term we will be upgrading the clients system to service pack 2, but in the meantime we’ll need to make do with increasing the number of permitted errors and accepting that an error will be displayed even as the transaction is integrated.