Still relatively quiet on the Dynamics Nav services side. Gained first line support for next calendar year from a client which is brilliant news.
Ongoing support for customer remittance allocations csv file loads this week. Fixing issues as they arise (a few but then development testing and actual data / end user testing totally different) and suggested further enhancements to allow a file to load rather than trip out. Some issues down to data quality and variations and lesson learnt at FPC re quotes for this kind of work. First line support very quiet this week.
Transfer order excel file upload development signed off this week and delivered today after development testing. Client will complete extensive testing to make sure working as required which may lead to some minor changes.
2 on site client visits planned for next week as per client requests to review use of Dynamics Nav and future client plans. So may lead to more work, may not. Fingers crossed. First set of client site visits in a couple of months.
Enquiries this week limited to web services demo request off our web page. Probably need to revisit web page, LinkedIn, Google Ads, Bing Ads in the new year to update etc.
On the accounts and tax side, last few clients sent in their books for annual accounts and personal tax comps. So these will be done pre the January 31st deadline which is fast looming. 2 months to go!
That's all for this week.
Friday, 28 November 2014
Friday, 21 November 2014
Week ending 21/11/14
A quieter week on Dynamics Nav.
No response for ball park implementation costs submitted to potential clients but confirmed a discount on offer from Microsoft for Dynamics Nav purchases to 24th Dec.
Auto matching phase 2 development (allows changes to due dates and on hold status from vendor ledger entries associated with part receipt for customer invoices) delivered to a client's test database for user testing. Instructions on how to use sent as well.
New report developed for item listing including free stock and quantity on POs with expected receipt in the next 30 days.
Allocations csv file load development went live this week. A number of issues arose (document type document number imbalances) as a result of live csv files being processed which gave rise to significant changes to the development. All done and working.
Confirmed payment discounts set up and process with Dynamics Nav and how it operates with VAT.
Most significant issue this week was broadband failure Thursday. Caused a few issues but only lasted half a day.
As I said a quiet week. That's all for now folks.
No response for ball park implementation costs submitted to potential clients but confirmed a discount on offer from Microsoft for Dynamics Nav purchases to 24th Dec.
Auto matching phase 2 development (allows changes to due dates and on hold status from vendor ledger entries associated with part receipt for customer invoices) delivered to a client's test database for user testing. Instructions on how to use sent as well.
New report developed for item listing including free stock and quantity on POs with expected receipt in the next 30 days.
Allocations csv file load development went live this week. A number of issues arose (document type document number imbalances) as a result of live csv files being processed which gave rise to significant changes to the development. All done and working.
Confirmed payment discounts set up and process with Dynamics Nav and how it operates with VAT.
Most significant issue this week was broadband failure Thursday. Caused a few issues but only lasted half a day.
As I said a quiet week. That's all for now folks.
Friday, 14 November 2014
Week ending 14/11/14
Another week gone by. But at least it has stopped raining!
On the Dynamics Nav side, a few enquiries this week from brand new potential Dynamics Nav users. Linked up with a Microsoft Partner that sells the licences to confirm ball park costs.
Also confirmed to one of our clients process to change Dynamics Nav partner - not us as we are too small. Waiting to hear what the client wants to do. If they change we can action a change of licence or quote for an upgrade from version 5 to 2015.
Developments completed:
Amendments to csv import file to allow remittance data in file to create receipt journal and assign applications during load process. Amendments included single line bank entries by unique payment id (was balancing entry), allow for payments on account (no applications), include payment types (new field for journal table) and confirm value of receipt by bank account.
Added column headings to an export dataport for data going from Nav to legacy system.
Dataport completed to allow item and purchase price data changes to be loaded from csv file with column headings as first line. Data load completed as well.
Added vendor number filter to user id table to ensure end users can only see relevant items.
Final stage re auto match for receipts and linked payment invoices. User can now select line items that make up a summary invoice to create a receipt line and when posted related vendor ledger entries will be taken off hold and the due date recalculated.
Step by step screen based instructions created for 2 developments to allow users to use.
First line support issues resolved:
Item tracking in 2009 does not force a user to select a New Lot Number from a drop down list. Fixed via table relation property on item tracking table.
Confirmed rounding error on posting purchase return order on Nav 2009 SP1 is on a hot fix. Our client has contacted their Solution Centre who will supply the fix for testing. So a known bug.
Confirmed issue with budget load from excel into Nav 2009. End user using bespoke menu not standard Nav. Confirmed standard Nav to be used.
Confirmed issue re dimension 3/4 totalling on accounts schedule down to licence - or lack of. No access to analysis views.
Confirmed payment tolerance is per line transaction.
Other:
Telephone enquiry from current client re combining several sources of legacy data to a summary invoice in Nav. Awaiting more details to formalise a quote.
Basically all this work has covered versions 4, 5, 2009, 2013.
That's the update for this week! :)
On the Dynamics Nav side, a few enquiries this week from brand new potential Dynamics Nav users. Linked up with a Microsoft Partner that sells the licences to confirm ball park costs.
Also confirmed to one of our clients process to change Dynamics Nav partner - not us as we are too small. Waiting to hear what the client wants to do. If they change we can action a change of licence or quote for an upgrade from version 5 to 2015.
Developments completed:
Amendments to csv import file to allow remittance data in file to create receipt journal and assign applications during load process. Amendments included single line bank entries by unique payment id (was balancing entry), allow for payments on account (no applications), include payment types (new field for journal table) and confirm value of receipt by bank account.
Added column headings to an export dataport for data going from Nav to legacy system.
Dataport completed to allow item and purchase price data changes to be loaded from csv file with column headings as first line. Data load completed as well.
Added vendor number filter to user id table to ensure end users can only see relevant items.
Final stage re auto match for receipts and linked payment invoices. User can now select line items that make up a summary invoice to create a receipt line and when posted related vendor ledger entries will be taken off hold and the due date recalculated.
Step by step screen based instructions created for 2 developments to allow users to use.
First line support issues resolved:
Item tracking in 2009 does not force a user to select a New Lot Number from a drop down list. Fixed via table relation property on item tracking table.
Confirmed rounding error on posting purchase return order on Nav 2009 SP1 is on a hot fix. Our client has contacted their Solution Centre who will supply the fix for testing. So a known bug.
Confirmed issue with budget load from excel into Nav 2009. End user using bespoke menu not standard Nav. Confirmed standard Nav to be used.
Confirmed issue re dimension 3/4 totalling on accounts schedule down to licence - or lack of. No access to analysis views.
Confirmed payment tolerance is per line transaction.
Other:
Telephone enquiry from current client re combining several sources of legacy data to a summary invoice in Nav. Awaiting more details to formalise a quote.
Basically all this work has covered versions 4, 5, 2009, 2013.
That's the update for this week! :)
Friday, 7 November 2014
Week ending 7/11/14
I know what you are thinking - not long since the last update!
On the accounts / tax side, a few more books, accounts and tax completed and bills paid. More to follow but well ahead of scheduled deadline for personal tax returns.
On the Dynamics Nav side, developments completed this week include:
Amended remittance advice csv file load to allow multiple customer accounts under a single payment file id.
Other work completed this week:
Brief demo of Nav 2015 GB to a client via TeamViewer. As a result submitted a ball park figure to get the client from version 5 to version 2015.
Quotes submitted and approved this week include:
Remittance advice csv file import enhancements.
Amendment to Analysis View report to show posted document line descriptions by GL entry.
New form to show number of GL transactions.
New menu options off customers, items to sales order archive data.
New dataport for loading item and purchase price data to each table.
Amendment to portals to reflect items listed for specific customers and vendor links and to remove columns from some forms.
New dataport to export customer details.
New fields off customer card to show last receipt date and value.
Changes to posted sales invoice and credit memo line layouts for specific customers.
Bug fixing completed for:
Auto purchase price update from change to PO direct unit cost - confirm box showing after change already made.
First line support issues resolved:
Get receipts not collecting receipts as currency code on receipts not same as vendor. Removed currency code from created purchase invoice. Default currency code and vendor currency code same.
Posting error re discounts on GL lines for a PO. Caused by lack of GL codes on GL Posting Setup. Actually error on PO line - no discount to be applied to GL code line.
So busy week. Did not start out like that but this is all good when you are running your own business.
Replaced one of the business PCs with a Dell XPS8700. Very impressed so far - really quiet. On the downside a Windows 8.1 machine but on the upside Dynamics Nav versions 5, 2009 and 2013 all sitting on the same PC. All good!
On the accounts / tax side, a few more books, accounts and tax completed and bills paid. More to follow but well ahead of scheduled deadline for personal tax returns.
On the Dynamics Nav side, developments completed this week include:
Amended remittance advice csv file load to allow multiple customer accounts under a single payment file id.
Other work completed this week:
Brief demo of Nav 2015 GB to a client via TeamViewer. As a result submitted a ball park figure to get the client from version 5 to version 2015.
Quotes submitted and approved this week include:
Remittance advice csv file import enhancements.
Amendment to Analysis View report to show posted document line descriptions by GL entry.
New form to show number of GL transactions.
New menu options off customers, items to sales order archive data.
New dataport for loading item and purchase price data to each table.
Amendment to portals to reflect items listed for specific customers and vendor links and to remove columns from some forms.
New dataport to export customer details.
New fields off customer card to show last receipt date and value.
Changes to posted sales invoice and credit memo line layouts for specific customers.
Bug fixing completed for:
Auto purchase price update from change to PO direct unit cost - confirm box showing after change already made.
First line support issues resolved:
Get receipts not collecting receipts as currency code on receipts not same as vendor. Removed currency code from created purchase invoice. Default currency code and vendor currency code same.
Posting error re discounts on GL lines for a PO. Caused by lack of GL codes on GL Posting Setup. Actually error on PO line - no discount to be applied to GL code line.
So busy week. Did not start out like that but this is all good when you are running your own business.
Replaced one of the business PCs with a Dell XPS8700. Very impressed so far - really quiet. On the downside a Windows 8.1 machine but on the upside Dynamics Nav versions 5, 2009 and 2013 all sitting on the same PC. All good!
Friday, 31 October 2014
Week ending 31/10/14
This is just a blog to record what we as a business have been doing this week - actually for the last 2 weeks as I did not publish a blog last Friday.
On the accounts and tax side, some client books, accounts and tax returns completed well before the deadline of 31/1/15. So that is all good. About half way through so plenty of time to complete all pre the deadline.
On the Dynamics Nav side, we have completing the following jobs for clients over the last 2 weeks:
On site training for Nav 2013 financial modules but also including Rapid Start (aka in 2009 as Data Migration).
Developments completed for receipt and remittance advice csv files (load data, create journal, end user then posts), auto purchase price creation where direct cost on PO line changed and misc changes to forms, pages etc for new menus, new columns and new rows. Also completed minor changes to dataports created for sales and purchase document imports / exports as requested.
Started phase 2 of an auto match development for amending linked customer and vendor ledger entries where, say, a detailed line on a summary invoice is settled, the corresponding line on the vendor ledger has the due date reset and is taken off hold. Should be complete next week ready for user acceptance testing.Client signed off phase 1 this week so will be in live next. Phase 1 was auto match on a posted summary sales invoice to all vendor ledger entry lines linked.
Completed some final elements of data migration for version 4 for a client.
First line support issues resolved / answered for payment tolerances, error message meanings, transaction explanations.
That's it for this week.
On the accounts and tax side, some client books, accounts and tax returns completed well before the deadline of 31/1/15. So that is all good. About half way through so plenty of time to complete all pre the deadline.
On the Dynamics Nav side, we have completing the following jobs for clients over the last 2 weeks:
On site training for Nav 2013 financial modules but also including Rapid Start (aka in 2009 as Data Migration).
Developments completed for receipt and remittance advice csv files (load data, create journal, end user then posts), auto purchase price creation where direct cost on PO line changed and misc changes to forms, pages etc for new menus, new columns and new rows. Also completed minor changes to dataports created for sales and purchase document imports / exports as requested.
Started phase 2 of an auto match development for amending linked customer and vendor ledger entries where, say, a detailed line on a summary invoice is settled, the corresponding line on the vendor ledger has the due date reset and is taken off hold. Should be complete next week ready for user acceptance testing.Client signed off phase 1 this week so will be in live next. Phase 1 was auto match on a posted summary sales invoice to all vendor ledger entry lines linked.
Completed some final elements of data migration for version 4 for a client.
First line support issues resolved / answered for payment tolerances, error message meanings, transaction explanations.
That's it for this week.
Friday, 17 October 2014
Week ending 17/10/14
Apologies for the lack of imagination re blog title. I have run out of ideas!
Relatively quiet week on Dynamics Nav side of the business. Quotes completed this week for 5 clients. 1 signed off and development completed. Remainder not yet signed off. So prospective work for the next few weeks if the quotes are signed off.
Final amendments completed for aged stock report and development approved by client.
Chased up progress re client for auto matching development re final phase. Only really worth starting final phase when all other phases signed off and in the live database. This is likely to happen next week so final phase development work scheduled to start next week.
Chased up approval for mod on Dynamics Nav reminders process. Tested by client and approved but not yet on the live database. Need final confirmed approval via email and then we will transfer from test to live.
Completed 4 new dataports for a client this week re open sales orders exports and open sales order imports.
A number of first line support queries this week re depreciation calculation (not enough being charged so use force number of days), issue with accounts scheduling and row numbering (10, 100, 1000 considered by sql to be in the same range), issue with Intrastat Journals where bespoke value field using sum of document lines not document line on its own.
No new clients this week but we received 2 new enquiries - one for training in Manchester and one for using a product called Concur with Dynamics Nav. Could not help re latter but quoted for on site training for Dynamics Nav 2013.
On the accounts / tax side, again a quiet week but processing of books ongoing.
That's all for this week.
Relatively quiet week on Dynamics Nav side of the business. Quotes completed this week for 5 clients. 1 signed off and development completed. Remainder not yet signed off. So prospective work for the next few weeks if the quotes are signed off.
Final amendments completed for aged stock report and development approved by client.
Chased up progress re client for auto matching development re final phase. Only really worth starting final phase when all other phases signed off and in the live database. This is likely to happen next week so final phase development work scheduled to start next week.
Chased up approval for mod on Dynamics Nav reminders process. Tested by client and approved but not yet on the live database. Need final confirmed approval via email and then we will transfer from test to live.
Completed 4 new dataports for a client this week re open sales orders exports and open sales order imports.
A number of first line support queries this week re depreciation calculation (not enough being charged so use force number of days), issue with accounts scheduling and row numbering (10, 100, 1000 considered by sql to be in the same range), issue with Intrastat Journals where bespoke value field using sum of document lines not document line on its own.
No new clients this week but we received 2 new enquiries - one for training in Manchester and one for using a product called Concur with Dynamics Nav. Could not help re latter but quoted for on site training for Dynamics Nav 2013.
On the accounts / tax side, again a quiet week but processing of books ongoing.
That's all for this week.
Friday, 10 October 2014
Week ending 10/10/14
But at least it has not been that long since my last update. :)
So what has happened this week?
On the Dynamics Nav side of the business, attended client site to run through some accumulated queries on Dynamics Nav v5. Last visit well over 2 years ago so quite a few. All resolved. Probably be back in another 2 years. Received a PO today to confirm we will provide 2 days on site training on Dynamics Nav 2013 for later this month - new client! Completed work on a new report for another client re stock ageing and quoted for / completed some other developments requested in the week. Various support calls and emails from a number of clients - all resolved. Next week collaborating with another business to help create purchase order imports and sales order exports to / from Dynamics Nav 2009.
Amendment to excel data file import requested and quoted for this week. Waiting to here back.
So a good week but a little quiet. This is week 2 of a 2 month trial for first line support and all going well. Though very quiet calls / email wise today.
On the accounts / tax side, client books received over the last few weeks and some done already. Loads of time pre the personal tax deadline of 31/1/15 but we are getting on with the work.
Minor re-design of the web site this week to look a little more modern. Only the Dynamics Nav web site (http://www.dynamicsnavukhelp.co.uk/) though at the moment to see what the feedback is like.
That's all for this week.
So what has happened this week?
On the Dynamics Nav side of the business, attended client site to run through some accumulated queries on Dynamics Nav v5. Last visit well over 2 years ago so quite a few. All resolved. Probably be back in another 2 years. Received a PO today to confirm we will provide 2 days on site training on Dynamics Nav 2013 for later this month - new client! Completed work on a new report for another client re stock ageing and quoted for / completed some other developments requested in the week. Various support calls and emails from a number of clients - all resolved. Next week collaborating with another business to help create purchase order imports and sales order exports to / from Dynamics Nav 2009.
Amendment to excel data file import requested and quoted for this week. Waiting to here back.
So a good week but a little quiet. This is week 2 of a 2 month trial for first line support and all going well. Though very quiet calls / email wise today.
On the accounts / tax side, client books received over the last few weeks and some done already. Loads of time pre the personal tax deadline of 31/1/15 but we are getting on with the work.
Minor re-design of the web site this week to look a little more modern. Only the Dynamics Nav web site (http://www.dynamicsnavukhelp.co.uk/) though at the moment to see what the feedback is like.
That's all for this week.
Subscribe to:
Posts (Atom)
