Wednesday 1 December 2010

Has it been that long since the last blog?

A bit of a surprise when I found out the last time I blogged! Time flies.
On the Dynamics Nav front, spent the last 2 weeks bedding in a development for a client. Some first line support issues after use in live despite extensive user testing. Not unexpected given what the development is trying to emulate! Client activity bar that quiet! Waiting for client sign offs for some Dynamics Nav work and the starting pistol for approved work which was due to start 1 month ago!
Iphone development for a client to pilot stage done. Shown to client who has requested some other items as part of the pilot. Once this is done, next stage is to demo to a wider audience at the client. Transferring development to spare 2nd edition Itouch so that client can show to others the current version. This has been hard work but only because this is a new area of development for us. We are new to it!
Busy time of year for the impending self assessment tax returns due in for the end of January 2011 as long as submitted on line. If paper, you are too late! Completed client books and prepared first draft tax calculation. Other client's tax calcs due to follow in the next week and then we submit on line on our client's behalf.
Don't forget all of you out there that account for VAT - standard rate changes from 4/1/11 to 20%!
For Dynamics Nav users, the changes include setting up a new VAT Prod Posting Group and assigning values for each VAT Bus Posting Group. And then changing any default VAT groups assigned to items and GLs, for example. And then making sure the correct VAT is charged on billings from 4/1/11. Anyone know why HMRC as adopted the 2 week rule??? Probably to make it more complicated!
That's it for this time! Still snowing here! If you want to ready a grumpy old man's rantings on 1 flake of snow and the whole country grinds to a halt, look at the 'Misc at fpc'.

Friday 19 November 2010

Mostly support this week....

Most of the work this week has been Dynamics Nav support - either ongoing fixed price or post development when users completing testing. One set of Dynamics Nav developments for automating manual amendments to data passed user testing and will be on live next week. Hoping for the same of the enhanced email development. Then we can start the final piece of the development for the client. All coming together.
Next week is a client visit for a post pilot review and support for development completed. Again Dynamics Nav.
But clients still holding back on purchase order approvals. So pipeline looking thin at the moment but as ever the potential business very good. Had a thoroughly enjoyable time being treated to a meal by a client. A great evening - my only wish was that I should have booked a room so I could drink!!
Received a phone call enquiry re Dynamics Nav training. Part of the requirement was for Manufacturing training 1 and 2. Never heard of '1 and 2' but we do not do manufacturing module training. We cover all the base modules bar manufacturing and warehouse. We have experience of bith but not enough to train users. Passed details of colleagues in the same area who can provide this training to the person enquiring. I hope they find someone.
Also started looking at earnest at clients books for annual accounts and tax returns. Silly season for tax returns approaching (on line submission deadline 31/1/11).

Monday 15 November 2010

Another development completed on Dynamics Nav

Just finished the pdf file attachment enhancement for a client using BullZip pdf creator on Navision v4. Instructions sent and awaiting user feedback.
We have also now created a network accessible Dynamics Nav 2009 RTC database. Accessible across the network from our server. We have been supporting 2009 Classic for some time.
First Iphone development coming along. Painful learning curve on this one but we are learning all the time. Just need to fix the 'back' navigation button and filter the details to show only those details requested. Currently the development  show google maps and locations as loaded and when a user selects the 'pin' the standard blue arrow button appears and this triggers a new screen when selected.
Still waiting to start the financial reporting using consolidation and accounts schedules in Dynamics Nav. Conference call tomorrow on Hungarian reporting requirements.
Lots of potential work out there (awaiting client PO sign off)!!

Tuesday 9 November 2010

Quick post today!

Just a quick post today.
On the Dynamics Nav front, just confirmed a quote for enhancing the current email development for Navision v4. Fingers crossed it will be acceptable and the client will want this asap. Still quiet on the signed off PO front.
They say it is a small world! Logged into Linked In today and found my old IT director from my Sketchley days when I was Finance Director. Managed to make contact so hopefully we will keep in touch. It has been a few years.
No business admin  (debt chasing) today but Emily will be back from maternity leave in the next few weeks. Agreed terms for the return (Emily wanted to go part time and I, as the grandfather, would prefer my daughter to look after my grandson - very old fashioned I know!) so I am looking forward to that. Less business admin!
Still a relatively quiet week. Come on clients - sign off quotes please!

Monday 8 November 2010

VAT rate change and Dynamics Nav (Navision)

Forgot to mention in the last post received our first request to confirm what changes are required for change of VAT rate to 20% on 4th January 2011.
So if you are using Dynamics Nav (Navision) and need to know, drop us an email at navhelp@fraserpriceconsulting.co.uk.

May be a quieter week this week!

We have had a client request for an iphone application. Our first such request following our Iphone / Ipad / Itouch development training in August this year. Looking for show stoppers at the moment with a view to creating a pilot application within 1 month if there are no show stoppers. Made good progress today. Watch this space!
On the Dynamics Nav (Navision) front, a further request from a client for emailing pdf files rather than htmls in Navision 4. Spec'd up and requested confirmation that the best free pdf creator that works with Navision 4 be used. Waiting for confirmation before quoting for the development cost as seriously caught out on last email development quote (very under costed!) due to issues with the client server set up and IT policy.
Chased debts today from all clients. May be I should look at factoring debt so I spent less time on business admin? Doesn't look good for qualified chartered accountant and experienced Finance Director. So probably won't! I have only recently has issues with client payments so I need to be patient!
Accounts schedule and consolidation work for a client signed off delayed for a week or two. Shame as this is what is making this a quiet week!
Still waiting for sign off on a large PO this week from a client. Not sure what the hold up is as I thought the requirement needed to be completed asap.
That's all for now!

Thursday 4 November 2010

Another day another dollar.....

More support than developments this week on Dynamics Nav.
Last week as a first view of a development by the users. A small but significant misunderstanding on 1 criteria which had an effect on what was created against their original requirements. Additional development effort confirmed and signed off on. Delivered Tuesday this week and UAT will start in earnest next week.
For another client, finally found a work around for email from Navision v4 that complies with the client's internet access policy for their Navision application. Original development well under quoted for. UAT started and a queries raised and resolved. Hoping for go live on email next week. Another development completed for the same client was well down the line of UAT so expecting sign off and transfer to live next week. Then we can start the last element of the signed off developments!
A few queries on the first line support Dynamics Nav help desk but all either resolved or quoted for if a development.
Another client signed off on training for Dynamics Nav 2009 and this was completed yesterday. It was a question and answer session.
And finally some accounts schedule and consolidation work signed off. This will be started in earnest next week when some data has been provided.
So next week will be a very busy week.
And scheduled an iphone development day on Monday.

Friday 22 October 2010

Another busy week!

Not had much time for blogs this week but I thought I would post one up before the week end!
On the advertising front, now agreed terms for advertising book keeping services and Dynamics Nav services through 2 different periodicals over the next 6 months. We will then see whether we get any takers.
Never advertised Dynamics Nav services in this way before so this is a 'suck it and see' case!
Busy on 2 developments this week split between 2 clients. 1 has been written this week and we have just started development testing. The other was written a few weeks ago and finally loaded into the client's test database this week. As a result the development has been fully tested by the users and amendments made. I am hoping that the last amendment has been made and we can load the development into live next week.
For this client this will mean I can focus on a work around for the email issue on their test database.
We are planning to complete testing on the other client development by mid week next week ready for UAT.
Put in some more quotes this week but nothing signed off as yet. In fact more delays to sign off expected as a result of the cost cutting by the government. I am hoping not but......

Monday 18 October 2010

Post holiday blog

Back from holidays now. Straight into work with a new development for a client for tracking new customers and their satisfaction with the service. Nice intellectual challenge!
Nothing much else happening but that is a relief. Still quite busy but waiting to see what happens with the government spending cuts this week. Keeping fingers crossed!

Friday 8 October 2010

Last post pre holiday!

Looking forward to a break away in sunny (I hope!) Cornwall in our holiday bungalow! Not sure body boarding is on the cards but the weather forecast is reasonable.

Today was making some changes as part of fixed price support for 2 clients and quoting for developments for 2 clients. Keeping fingers crossed that both quotes are approved. For one I have confirmed a discount as it is over 10 days! It has been busy up until now but will be quiet next week. A good time to go on holiday but I would prefer to know I have signed off POs. Call me fussy!
Support issue for 1 client was an Nav process delay on changing a Prod BOM from new to certified. Caused by a blank Prod BOM Number which has valid item number lines. Of course you cannot delete a blank number  Prod BOM but deleting the lines and closing the BOM cleared up the error.
Always learning something new!

Thursday 7 October 2010

Well it has been a while......

For those that are following the blog, apologies for the delay since the last posting. Thankfully this is down the a large workload for the last few months. Just coming out of delivering a host of Dynamics Nav developments for a number of clients. Some are still work in progress but today is the first day that I have had a spare few hours for updating the blog.
On the Dynamics Nav front, I have learnt something new about htm templates and how you can get Nav to populate specific areas of the template even where there is html code. Very useful!! Also had a potential client contact for training in Nav pre purchase. Must update our web site for this as an option as I can see the logic. Why not get a day's specific training in Nav before you buy from an organisation like ours that does not sell the software. We only support it. And although it is always great to get new Nav clients, we can quite easlily provide non Nav related services to support any client that decides against Nav.
The last few months have involved on site attendance for a development go live, on site attedance for a Nav sql install and bespoke Nav super user training, training on Accs Sch in Nav and developments for email templates, telesales, email (for Navision V4), email support for Navision v3.7.
Phew! Busy period and long may in continue! More details for Dynamics Nav support (versions 2.x to 2009 Classic) available at www.dynamicsnavconsultant.co.uk.
Hopefully next blog will be next week.

Friday 23 July 2010

Busy busy busy!

What a turnaround this week - loads of PO sign offs with deliver dates for Dynamics Nav developments in the next few weeks. And its holiday season! Just completed 2 day super user training for a client which is at least a start for them to be reasonable self sufficient for most Nav issues. Went well so any simple development requests by the client that can be achieved through amending an existing form or report object to creating a new one through the wizard can be done by the client. First line fixed price Dynamics Nav support for this client starts week after next.
Also learnt a little more for interaction templates for Dynamics Nav and available fields from tables. All can be changed (VERY carefully) through codeunit 5054. Client wanted a customer number on one of the templates and this was achieved via this codeunit.
A reasonable week for client contact - one to confirm approval for a quote from 3 months ago and an urgent request from another client for a change.
More and longer blogs next week. Very busy Dynamics Nav development week!

Monday 19 July 2010

'Never stop learning'

An interesting day today. Had a phone call from a back links supplier on the www.dynamicsnavconsultant.co.uk web site and what they could do for a fee to improve referrals / clicks. Very interesting - we are doing most of the potential optimisations already but back links are more difficult. Our ranking has also slipped to 10th on the first page from 2nd. So we need to do something. Going back to the supplier by the end of this week. If it works, it should get us more hits!
And then we had an issue with Nav sql version. Sql 2008 all ok and database looks ok. But you cannot access the database in Nav - .stx error. It all started with trying to restore the latest client sql database back up into our server. No problem in sql management studio but could not access in Nav sql. So tried all sorts including trying to restore old back ups. Made an assumption that the issue was in sql and yet the error message was in Nav.
Now fixed. All down to where was the error message (Nav) and re-installing the Nav client. The re-install failed but it must have replaced a corrupt .stx file because now we have the latest database on our machine. A result and more importantly a lesson learnt - track the error message against the application it appears in first.
Busy day and a very busy week. 2 days out super user training on Dynamics Nav for a client and behind on some of the developments because of the failed restore issue above. But we will catch up!

Monday 12 July 2010

POs confirmed!!

Started work today on Dynamics Nav developments (http://www.dynamicsnavconsultant.co.uk/devel) for a client. POs signed off last week which will keep us busy this week. Hope this is a sign of things to come. Also need to prepare for Dynamics Nav super user training (http://www.dynamicsnavreports.co.uk/training) that I am providing for a client. No code teaching just a general understanding of Dynamics Nav, how it works and how to create simple reports and forms using the Nav wizard. Training over 2 days next week.
HMRC phoned up today to confirm we have hit their radar re agency code for client self assessment and corporation tax return submissions on line. Thank goodness! 1 client wants returns in by the end of next week.

Monday 5 July 2010

Booked chargeable days

Some work is coming in now! At last. Dynamics Nav work as well - not sure if it is down to the reduction in day rates but it is welcome in any case. Not a lot but it is a start. I am just hoping the announced 40% cuts in central government will not have a knock on effect to us.
Some other chargeable days booked but waiting for clients to confirm access and bits of data. Seems to be taking a long time.
Also discovered today that following a phone call to the HMRC helpdesk, a tax agent code can only be requested in writing no matter what it says on the web site. So I have just sent a letter off and I hope there will be a reply soon! I have a lot of tax returns to do for clients before the end of the month. Yes this is early but if that is what the client wants!
Interesting phone call earlier! Change of tactic by a business trying to sell to me. Suggested that they wanted a service from me but it turned out to be something we can sell as a reseller. On line storage but from a quick review of the pricing details, pricing looks too high! I don't think any of my clients would go for it.
Out at a client tomorrow (chargeable part day) so no blog tomorrow.

Thursday 1 July 2010

Reduction in Dynamics Nav development day rates

We are already competitive for Dynamics Nav developments in terms of quality of solution, estimated effort to complete and day rates. But the issue we have is reaching potential customers! We are not big enough for a full blown Dynamics Nav Solution Centre so we do not get client referrals from Microsoft. We get our clients from their web searches when they are completely fed up of their assigned Solution Centre.
And we do get new clients this way.
But we are now in our 2 quietest months of the year because of holidays - we assume!
So I have just sent an email to all existing clients confirming for July and August a reduction of 20% on the day rates charged for Dynamics Nav developments for orders placed in July and August. In the next week, I will put the new prices on the main Dynamics Nav domains we own (www.dynamicsnavconsultant.co.uk, www.dynamicsnavreports.co.uk) and see if this draws any new clients from the web.
Just had call today from BT guy about web positioning and what they can do for us. Asked for the details on an email and awaiting this.

Tuesday 29 June 2010

Just another day in a recession!!!

Success and failure today. RAID pc now working, booting into windows and backed up data for client as requested. Work quoted for yesterday that needed to be completed by next Tuesday (and it was 4 days work plus 1 day on site hanh holding) no longer required - client already has solution in place. Just been paid by a client for book keeping work.
So all in all a mixed day. Need to check fixed price support clients have paid by close of play tomorrow. And then raise new support invoices on 1st July.

Monday 28 June 2010

Client site visit today to quote for work. Quote submitted this afternoon for first line Dynamics Nav support (http://www.dynamicsnavconsultant.co.uk/support) together with a 1 page wonder detailing the service, pre requisites, costs and benefits. Also quoted for a specific development against user requirements.
This will be a tax return week for a number of clients. Bar that still quiet on the support desk. Are we really that good?

Thursday 24 June 2010

Forgot to mention that we have a client who has a RAID pc which is failing to boot into Windows 7. Initially fault was intermitent but now complete failure with missing operating system followed by non bootable disk. And the client does not have a current back up.
So the big question is how to recover data from RAID disks when you cannot get windows started. Completely outside our comfort zone here. So we are going to try and install an IDE disk as the primary disk, install fresh version of windows 7 and then hope (and pray) that windows recognises the RAID disks and we can then recover the client's data.
Another busy couple of days with clients making contact for work and potential work. Fingers crossed this leads to more. Conference call on DBXtra work and client will check work to date and confirm if ok. Job completed subject to any queries from the client. Completed a Dynamics Nav report enhancement for a client same day as requested so we can turn such requests around very quickly.
Purchased and downloaded on line personal tax filing software ready for client tax returns that need to be done in the next month - per client requests.
Balanced up PAYE/NHI control in FPC books to payment due in July.

Tuesday 22 June 2010

So I have now looked at the key features of the budget and what do I conclude? Without seeing the nitty gritty and assuming that the East of England does not include the East Midlands, why won't we all create a new business and transfer everything to the new business so that we will not pay NHI? I am sure there will be a long list of exclusions and exceptions in the nitty gritty!!
And they are reducing the rate of Corp tax but NOT small companies rate. So to generate wealth takes lots of new small businesses but no tax breaks for them! Irish!! Unless of course this is the NHI freeby! But why should I create a new business to do this!
And who has kept the economy going during the recession? The only people whose income has remained constant - those receiving benefits. So tackling the benefits system may not help the recovery.

Just the ramblings of a business owner who has yet to feel better off from 4 decades of budgets!
No blog for a few days and another early one! Like buses! Today is all about the budget - how they (the government) have been managing expectations re bad news and how I suspect that it will not be as bad as they say! But then again I could be wrong. I am keeping my fingers crossed that client inactivity is down to the combination of an election and this budget. I am hoping that business may be more forthcoming after today but I am not holding my breath!
Had a meeting with my bank relationship manager yesterday. I have banked with Lloyds TSB since the business started in 2003 and this is the first time I have met one! But then again we run a tight and very simpleship re bankings. Offered me a new tariff which would save about £2 a month. So not changing tarriff.
Work at the moment is mainly on client management accounts and year end accounts. No Nav work at the minute but there is some fixed price support work. 2 simple requests which will complete as part of the fixed price support so there is no additional charge to the client. That is after all what they pay for!!
Ironically, changing the VAT rate may bring in some support work for clients - fully configurable in Dynamics Nav via VAT Prod Posting Groups and assigning defaults to GLs, items, resources etc.

Thursday 17 June 2010

More work on DBXtra queries.Some links to other legacy system master files to be confirmed but all done bar that. Spent more time on internal admin now that Emily has gone on maternity leave including processing our payroll. Client payrolls are next week.
Need to confirm

Wednesday 16 June 2010

An early blog today. 2 bits of work delivered to clients and so awaiting feedback before I can go any further.

The Dynamics Nav matched bank rec data load utility developed needed tweaking for maximum number of rows (me being thick!) and document types. Then it loaded fine and is now posting. As 30k lines have been loaded, this is taking a while. Hopefully client will be happy as doing this manually would be a nightmare.

So today is a web page update day. Created a new DBXtra support web page to go with the domain purchased (www.dbxtrahelp.co.uk). Brief at the minute but it does get some web presence at least. A start as they say.
Added these blogs (there are 3 at the moment) to a number of the domains today and I am just amending the main FPC web page to include the blogs and look better! It has been a while since this web page was updated.

Once that is done, I will sit here waiting for client response.

Tuesday 15 June 2010

Slight delay to work this week - all day with youngest daughter at hospital. All ok though so that's great!
Emily has now left and is on maternity leave until mid Nov. She will be sorely missed but all at FPC wish her well and good luck with the imminent birth. Especially the prospective grandad. Feeling old!!
Work wise I have been focusing on catch up from yesterday in terms of a clients set of accounts for the last tax year, DBXtra query for a PO list and Dynamics Nav support for a development (www.dynamicsnavreports.co.uk) delivered to a client recently on loading matched bank rec items via Excel. The latter was a simple issue in the end - down to a simple coding error re row numbers etc.
So a busy day again!
Dynamics Nav support (first line) desk (www.dynamicsnavconsultant.co.uk/support) slightly busier but still very quiet given previous activity.Tomorrow will be amending the PO list query via DBXtra for client comment and continued support for matched bank rec data loads.

Friday 11 June 2010

A busy couple of days - hence no blogg yesterday! Ongoing work on the DBXtra for a client with a steep learning curve for me. But I am getting somewhere. Issue is that I am 'blind' to the actual data so I cannot cross check results from a DBXtra query.

Also been working on clients year end books for the tax year end 2010. This work has been brought forward from the usual work slot as Emily is off on maternity leave from next Tuesday. Completed a VAT return for 1 client.

Had a number of enquiries over the last 2 weeks for MS Office Accounting (2008) support (including configuration, training and support) and MS Office 2007 training. Awaiting to hear from both after confirming effort and costs.

Still waiting to hear from a number of clients on Dynamics Nav development sign offs. We could be very busy if this work is signed off. Fingers crossed for next week.

Neil

Wednesday 9 June 2010

Update for 09/6/2010

Today has been a day of getting to grips with an independent query tool (DBXtra) for a client on their legacy database. Has the look and feel of Access in how you create the query and links. Requires some knowledge of the legacy database which I do not have but I am learning.
Also nearly completed some management accounts for a client after receiving the bank statements and supporting invoices this morning. 1 query and then we can publish. Then do the VAT return for them and start the year end process.
So a busy day. Also started a web page for the DBXtra support based on information that is useful and I only found via searching the web. Will see if I can get a suitable domain for the pages, complete the pages and publish. We do our own web page design and updates via KompoZer. A simple tool with good and bad features but it does allow web search optimisation.

Neil

Tuesday 8 June 2010

Well guess what I found!

I have been trying to set up a business blog for a while. First attempt was via the FPC domain supplier - 1and1. But this seem to encourage loads of spam mail! We originally had 3 forums - 1 for each of 3 domains.
So I was today trying to set up a Twitter link off our www.dynamicsnavconsultant.co.uk when I discovered a blog off google! We also use Google Adwords as part of our advertising / marketing campaigns.

Anyway we now have a blog and link to our recent twitter account. Success. We will now start to use the blog and twitter to see if anyone needs our services and give an insight into what we do each day.

Neil