Can't you tell it's Easter - part 2

Ok so I thought Good Friday week was quiet but last week even quieter. So not a lot happened on the Dynamics Nav side - just the following:
New Dynamics Nav client. Agreed call off order at discounted rate for 10 days.
Confirmed attendance for a new client for Dynamics Nav 2015 implementation walk through and potential attendance on super user training once agenda confirmed. Both required for add on from Solution Centre.
Now have remote access to new client's database so.....
Completed quick review of base configuration for same client and confirmed minor missing data.
Confirmed to German client Microsoft web link to compare Dynamics Nav versions and our web link for summary of differences. Client looking at potential upgrade or additional licence granule purchase. Depends on what is on new versions. Current version DE v5.
Confirmed reason for Intrastat missing journal entry as down to missing country / region code from shipment and therefore item ledger entry which is where intrastat journal lines come from.
Discussed various changes required by a client on GB v5 including new start for existing company, data extracts for another application and various other minor changes. Client will send email this week and we will respond to via a quote.
Set up new user for client on their Dynamics Nav (version 2009 application, version 4 database).
Bug reported on client's bespoke change to intrastat journals. Investigated and believe know what the issue is but need backup of latest database to develop, test and confirm. Waiting for backup.
Bar that waiting for responses to quotes to clients and responses to enquiries. Down to being Easter I think - I hope!
On the company front (Fraser Price Consulting Limited), changes made to share capital and directors last week. News of these changes will follow on our web site.
That's all for this week folks!

Can't you tell it's Easter!

Well it has been quiet this week but it is the first Easter week.
Dynamics Nav work completed this week includes:
Fixed further issues re permissions for non SUPER user for version 5 database - German version. Missed off bespoke client tables so added a new role just for these tables. Also needed to add on German specific modules.
Extract latest vendor data for a client who is moving from Dynamics Nav to another application. Used created dataports so simple process of text file creation across 30 different businesses.
Remote access to new client in the East Midlands will hopefully be set up this week so we can start to assist on implementation project.
Confirmed quote for POP configuration and training including document approval for Nav 2013 R2. Also fixed document approval bug in Nav 2013r2 (yes the latest patched version) for POP and SOP re approval value levels. Ignored value levels and forced all POs/SOs to go through approval process.
Chased up some quotes this week re on site training but no response. Will chase again next week.
Discussions re commission calculations on Dynamics Nav started with a client re what can and cannot be done out of the Nav application (v4). Expect these will continue this week and next and may (or may not) turn into chargeable work.
Confirmed quote to current client re logo changes (multiples using responsibility centres) to 7 report layouts (v5 GB). Waiting for approval and then we will complete the work.
So in short, lots of work prospects again but no one signing off on. Probably as it is Easter!
That's all for now folks.

2 weeks ending 27/3/15

As I was on holiday last week, combined 2 weeks into this blog.
Still regularly updating / answering forum questions where we have expertise to provide. We are also regularly (daily) updating facebook and twitter with hints / tips / observations.
Quite a few potential new client enquiries over the last 2 weeks including 2 to 3 days post go live support (hand holding to aid new Dynamics Nav users after go live), 1 day on site consultancy to review current Dynamics Nav configuration to make sure it will meet the client needs especially in relation to warehousing and manufacturing, on site training for super user and end user finance training. Quotes provided for all but yet to hear from any whether successful.
Agreed with client next stage of support re creating POP element to Dynamics Nav application (configuration work mainly on document approval and some on site training). Confirmed by new client support required from us pre and post go live. Pre go live to include review of current configuration and end user training. Post go live will be hand holding end users through their first use of the Dynamics Nav application.
Agreed with another client (very local) next stage of support (on site, configuration, small element of super user training) and provided quote accordingly.
As a matter on interest many more enquiries now from local (Nottingham) businesses using Dynamics Nav. So if you need a local Dynamics Nav resource we are just on your door step.
Work completed over the last 2 weeks included new column layout for fiscal year trends,slight changes to permission sets after user removed as SUPER user and properly configured, created step by step instructions on how to create a bank account, completed final elements of data migration out of Dynamics Nav (managed through mix of dataports and reports, fixed customer statement layout issue, confirmed why item card fields not editable (safety stock quantity non editable as no reorder policy), confirmed solution for item ledger entries where item tracking left as blank in error, confirmed process for unapplying and suggested reasons for user error
So basically the last 2 weeks has been active re new enquiries or agreeing next stage of work for current clients but very quiet on actual work done! Frustrating but there is an election on and it is Easter!
More next week on what we are doing re Dynamics Nav at FPC.

Week ending 13/3/15

On the Dynamics Nav side of the business, a quiet week. Some major internal achievements have included finally getting to grips with Nav instances in Nav 2013 and sql restores. We used to get application back ups from clients but from Nav 2013R2 onwards this is such a pain in the neck we now use sql backups. Still involves a lot of command prompts (or to use the more modern name Power Shell) but got it all working for a new client.
Work completed this week included data migration from Dynamics Nav to another system - more extracts (vendor bank) and responses to queries raised. One query was how to auto assign vendor class -  a field required for new system. Not easily done but made a few suggestions.
Blast from the past was a query on ODBC connections into Excel. Helped by confirming process. All working.
Started the process for a client (using Dynamics Nav v5 DE) to change all users from role SUPER to other role options. Started with a single user which resulted in 2 queries to date both of which fixed. One permissions error was around German specific module and the other on record links which standard Nav roles include as read only. So created MISSED permission role with new access rights to record links and ready for any other missing permissions.
Fixed bug on item forecast functionality (client bespoke) re production components production order quantity not being taken from the component line table. Corrected and now working. Also added more navigation options for item forecast standard form.
Fixed bug in German bespoke report that referred to dateformula of 1T which will not work when using the English language pack. Other bugs in same report fixed after copying to a new report id.
Received an enquiry off a potential new Dynamics Nav client to help with end user and super user training as part of their implementation. Meeting this week to discuss further and agree terms if they want us to help.
Never mind - holiday coming up next week for a break and to recharge the batteries.
So no blog next Monday.

Week ending 6/3/15

Another day, another dollar. Though we invoice in GBP!
Very active week on the web site front with daily facebook and twitter updates as well as review of various Dynamics Nav / Navision forums to answer queries raised if we can. At least 1 answered per day and so this is the target for the next few months. And this together with web site updates including (at last) the results of last year's customer survey means we are looking to generate more web presence! We have some new pages for the customer testimonials section which now includes the survey results (customer comments and stats). We have also renamed this section 'Why use us?'.
On the Dynamics Nav work side, we have completed the following:
On site support for a new client using Nav 2013 R2. Support included on site training and various discussions about what they require over the next 6 months.
Fixed permissions issue for a user who had been assigned the SUPER role as a short term fix to one task the user was trying to complete. Now configured properly and SUPER role removed.
Received enquiry for pulling in csv file data for sales and purchase invoices into Nav 2009. Queries raised and when answered we will quote of development work. Confirmed where dimensions set up and how to assign to item cards / pages. Fixed issue with Intrastat client bespoke fields for stats value not accounting for different lots on the purchase receipt.
Fixed client's Jet report for top x vendor list.
Fixed item forecast key field on bespoke table to allow multiple BOM entries for items where there is a cross over on items used in BOM.
Confirmed vendor details for a client from an old database we have. Client wanted to track any changes to current records (change log not switched on to track vendor master data) re payment terms.
That's all for this week folks.

Week ending 27/2/15

I am getting better at creating these each week! So this is this weeks blog.
Still very quiet on the accounts / tax side of the business but tax season just finished so this is quite the usual. Plus it is a very small % of revenue.
On the Dynamics Nav side, new client gained and I will be attending site at the end of this week. Enquiry originated from google search so web pages updated for key words again.
Developments completed this week:
Ongoing work re data migration from Nav to another application. Getting sample files for vendor payments and applications (via report) and general ledger entries (via dataport and some code).
First line support completed this week:
Teamviewer session for a new Nav user to show what the main elements of the application are etc.
Confirmed best approach for posting exchange rate movements on sub ledgers when the exchange rate loss / gain reflects 6 months of transactions and exchange rate batch job not run. Then helped to create general journal to update the sub ledger. In this case it was the bank ledger.
Confirmed how to make changes to menu suites for Nav 2013 - specifically how to trace a change to menu caption no longer required.
Received enquiry from one of our clients re web services for 2009 and why not on listed services. Not managed to resolve but helping as much as we can. We do not do installs but focus on application support.
Enquiry re Nav 2.01 resolved and client decided to just put application and database on an old server just in case access required.
Changed user permissions for allow more users to access specific bespoke functionality re debtor receipts and applications auto load and posting.
On non Dynamics Nav activities, continued to update web pages for more up to date content and added some more key words. LinkedIn advert ran for 2 months, cost a lot and generated no leads. Oh well been a while since I ran an advert. Stopped as of 28/2/15 as planned. Will not do another for 6 months.
That's all for this week folks. Don't forget we provide a full range of services covering all modules for Dynamics Nav / Navision versions 2 to 2015. This includes configuration, data migration, end user and super user training, first line support and developments. More details at this page.

Week ending 20/2/15

Decided Mondays a better day for updating the blog.
Quiet week last week probably due to half term week. Also on the Dynamics Nav side of the business there have been 2 of our clients where there has been a change in our key contact. Which puts all potential / booked work on hold for a few months.
So work completed last week was as follows:
Developments -
Rewrote item sales forecast report to include all historic item sales, new item sales forecast data and released / firm planned production orders. Previous report derived a list of item / customers using historic sales data.
Created a new report to calculate a safety stock quantity using vendor lead times and anticipated sales. The report then compares this value to the current safety stock quantity.
Further requests for data from Nav for migration to another application. This time for a month's transactions for purchase ledger (invoices posted, payments made) and general ledger. Sample files requested from us and we started work on this last week. Proposing, given the mix of data, to use dataports, include headers and then collect data not in main tables into globals. This work will be completed this week.
First line support-
Slot booked this week with German subsidiary of client for 2 hour Nav run through via TeamViewer for new member of staff.
Resolved default dimension posting for legacy data feeds caused by bespoke change to posting codeunit 12 to take all balance sheet type general ledger account postings to fixed dimension value. User had made a change to the general ledger account to make ot a balance sheet type account so bespoke forced dimension code triggered.
Made minor bug fix change to a client's aged stock report that picks up the last sales date. Used incorrect key that included location code. Needed just the item number and posting date key.
Made minor change to a report to include description 2 off the item record.
Received an enquiry re archiving Navision 2.01 - or at least how to ensure read only access. Responded and offered more help but no further emails. very old version - came out in 2000.
Outside Nav, updated the web pages for more recent content and slight change to layout. Checked Google Analytics and we get a high per cent bounce rate so made some changes to try and resolve this.
That's it for this week. On reflection did not seem a busy week but varied!