The Google-fu is weak with this one (this one being me). I read a post ages ago on the subject of SmartList wildcards which looked like it would be really useful, but then, after I’d forgotton the details, couldn’t find it again no matter what searches I tried.
Then, a couple of days ago, Tim Cruickshank, on the Rose Business Solutions blog, posted a few tips and tricks he’d picked up at Convergence, one of which was SmartList Wildcards.
Continue reading “SmartList Wildcards”
Well, they do say the old ones are the best. I recently installed Microsoft Dynamics GP on a client site and encountered the below error message when starting Integration Manager for the first time;
Continue reading “Error Running Integration Manager For The First Time”
A client recently tried to run their month end reports in FRx and got the below error message;
Continue reading “FRx Error 9060 during the CreateZIPfile procedure”
I was reviewing a specification for some development in Microsoft Dynamics GP yesterday and encountered an oddity on one of the supplied screenshots. I was going to add it to the issues list and pass it back to the developer but decided to check the window in GP so I could outline the exact requirements.
It was then that I found the screenshot actually looked exactly like the window.
Continue reading “Cashbook Bank Management – Cash Receipt Entry Oddity”
When doing sales demos or testing I tend to use the Microsoft supplied demo database to save time on rolling my own.
One annoyance in it is the warning message that is displayed when logging into Fabrikam;
Continue reading “Hiding The Fabrikam Demo Company Date Warning”
A client doing some work with Integration Manager 10 recently reported the following error when trying to load the VB Script Editor;
Continue reading “Integration Manager: “Argument ‘Start’ must be greater than zero””
Earlier this week I posted about a bug in Integration Manager where it added extra zeros into the phone and fax number fields when importing creditors. Well, the same bug also affects debtors but a similar script to update debtors via a CSV is also possible.
Continue reading “Update Debtor Addresses From CSV To Work Around An Integration Manager Bug”
I was doing some work for a client recently where we were loading lists of new creditors into Microsoft Dynamics GP from CSV files via Integration Manager. There is, however, a bug in IM 10 where it adds extra zeros to the phone and fax number fields of both creditors and debtors. These extra characters are, rather bizarrely, not always at the end but can be interspersed in the phone number.
The easiest work around was to put together a SQL script for loading the phone and fax numbers from CSV file which I did while on site which updated only a single address on the PM Creditor Master (PM00200) and PM Address Master (PM00300) tables.
Continue reading “Update Creditor Addresses From CSV To Work Around An Integration Manager Bug”
After a slight mid-week diversion, here is another script I produced a while ago which updates the Item’s Default Purchasing Unit of Measure. It was produced when a client wanted to bulk update a large number of records which would have taken a long time manually but by script only minutes to write and run.
Continue reading “Updating Item Purchasing Unit Of Measure From A CSV”
Windows 8 Consumer Preview now available for download.
Yesterday, at the Mobile World Congress in Barcelona, Spain, Microsoft announced the availability of the Windows 8 Consumer Preview.; full details at the Building Windows 8 blog.
I’m in the process of downloading it so I can see what improvements have been made since the Developer Preview and will post any thing of interest.