Before you know it it is nearly a month since the last blog. Oh how time flies.
On the accounts / tax side of the business, last tax returns going in today and so complete ahead of the deadline.
On the Dynamics Nav side, the following work has been completed recently:
3 days super user training including an introduction to C/Side coding. Training on database makeup as well as how to create tables, forms, reports and dataports. Based on Nav 2009 Classic.
GRNI analysis report off the relevant GL code completed and in client testing. The user confirms the end date (has to be accumulative to pick up all relevant receipts and invoices) and the report collects PO data for each receipt and invoice and then summarises by PO number. Slight issue on invoices with multiple receipts but found a useful cross reference in the Value Entry table. All working and delivered. Also found useful You Tube videos on creating Nav 2013 report layouts quickly and easily. All part of the learning process.
Set up Nav 2013 instances etc so we now have step by step instructions on how to do this. Like rolling back time given the amount of command prompt type code.
We also now have remote access to a client database for the first time - any object deliveries were via TeamViewer.
Completed ad hoc work for a client re their migration off Dynamics Nav. Basic customer and vendor masters.
Created new company (with a base configuration) for a client and loaded into the live database.
New field on item table to allow updated calculation for a client of their free stock.
So a busy 2 weeks for January. But now very quiet. A lot of quotes out awaiting client approval so we could be busy in the next week. We will have to wait and see.
Will try and post a blog this Friday.
That's all for now folks.
Tuesday, 20 January 2015
Friday, 12 December 2014
Week ending 12/12/14
Another week goes by. :)
On the accounts side, still chasing up books for tax returns for a few clients. Just completed first draft partnership accounts for a client with a few queries to follow up next week pre submission to client.
On the Dynamics Nav side, completed the following work:
On site 'master' Dynamics Nav class in London for a day.
Change to dataport to remove line feeds copied into Nav in error by end users. Learnt a lot re ascii codes this week as a result. All very useful.
Further and final fix re text overflow issue for a report previously developed. Number length logic error.
Quotes submitted but not yet approved for:
Sweep up unallocated receipts and related ledger entries where applies to id common.
Dimension auto allocation development to allow user / project type dimension codes to be split based on user assigned split across dimensions.
All not yet approved but likely to be approved in January at the earliest now.
Super user training (on site 3 days) booked for early January.
First line support desk activities have included:
Resolved warehouse shipment would not post query - a bin code issue.
Confirmed issue with csv file export down to invisible characters on Nav data caused by users copying and pasting from excel into Nav. Development amended to account for these characters (see comment above).
Completed some permission changes against users for a client. Confirmed reason for accrual feed at zero values to client - down to zero values on a particular column within an excel file loaded and invoices created.
Resolved accounts schedule difference issue (down to design) and consolidation issue where consolidated company included in consolidation. Surprised it allows this.
Completed a list of developments completed on a version 4 database for a client since 2005.
For the members of my family who have told me they read this blog, told you I would mention you on the blog. Looking forward to seeing some of you on 20th at the wedding. Don't forget I am not driving (so definitely drinking) and father of the groom is buying (pretty sure that is what he said) at the Piano bar at 12.30pm. So see you then!
That's all for now folks. For a change I am stopping work now as there is nothing happening in the business. Expect next week to be even quieter.
On the accounts side, still chasing up books for tax returns for a few clients. Just completed first draft partnership accounts for a client with a few queries to follow up next week pre submission to client.
On the Dynamics Nav side, completed the following work:
On site 'master' Dynamics Nav class in London for a day.
Change to dataport to remove line feeds copied into Nav in error by end users. Learnt a lot re ascii codes this week as a result. All very useful.
Further and final fix re text overflow issue for a report previously developed. Number length logic error.
Quotes submitted but not yet approved for:
Sweep up unallocated receipts and related ledger entries where applies to id common.
Dimension auto allocation development to allow user / project type dimension codes to be split based on user assigned split across dimensions.
All not yet approved but likely to be approved in January at the earliest now.
Super user training (on site 3 days) booked for early January.
First line support desk activities have included:
Resolved warehouse shipment would not post query - a bin code issue.
Confirmed issue with csv file export down to invisible characters on Nav data caused by users copying and pasting from excel into Nav. Development amended to account for these characters (see comment above).
Completed some permission changes against users for a client. Confirmed reason for accrual feed at zero values to client - down to zero values on a particular column within an excel file loaded and invoices created.
Resolved accounts schedule difference issue (down to design) and consolidation issue where consolidated company included in consolidation. Surprised it allows this.
Completed a list of developments completed on a version 4 database for a client since 2005.
For the members of my family who have told me they read this blog, told you I would mention you on the blog. Looking forward to seeing some of you on 20th at the wedding. Don't forget I am not driving (so definitely drinking) and father of the groom is buying (pretty sure that is what he said) at the Piano bar at 12.30pm. So see you then!
That's all for now folks. For a change I am stopping work now as there is nothing happening in the business. Expect next week to be even quieter.
Friday, 5 December 2014
Week ending 5/12/14 - not long til Xmas!
This week at FPC.
On the accounts and tax side, client's chased for books or missing data. The deadline is fast approaching for personal tax returns.
On the Dynamics Nav side of the business, 2 client on site visits this week and 1 booked for next week. One this week was a meet and greet with a discussion on upgrading from Dynamics Nav v4 to 2015 and what the benefits would be. We do not do upgrades so this may or may not lead to more work if the client can find a business case.
Another client visit for a very intense day on what Dynamics Nav has on offer. The client is a current user but only for base financials. So the day consisted of running through all the functionality in Nav. Went well.
Also confirmed this week maximum number of users for Dynamics Nav is circa 500. More than I thought but there must be some benefits to the Internet friendly end user interface.
Next week I am at a client site providing some on site training re Dynamics Nav - or as the client calls it a master class.
Work completed this week was mainly around first line support. Issues resolved included:
Confirmed reason for error in excel data sales data file load. Error fixed by client on excel file and reloaded successfully.
Completed a number of bug fixes / enhancements for developments previously delivered. Included text overlap error resulting from inconsistent text lengths for related but different objects.
Confirmed latest client UAT database copy of live from last week.
Developments completed this week, delivered and now in live:
Transfer order excel file load.
Quotes provided this week for:
Alternate business address for new business within set of Nav books.
Adding posted document line descriptions to GL entries form.
Bar code search development - so when bar codes (yes codes) are added to the cross reference table on Nav, a item field called bar code search is updated with all bar codes assigned to the item. the user can then user standard Nav data fields to search for bar codes.
Auto match posted customer ledger entries with common reference point. Really a clear up for posted entries from another development that did not clear due to net refunds.
Waiting for approval and will then schedule the work.
Still looking at / investigating the following:
Jet report issue #VALUE error.
Journals created but at a zero value for sales legacy load (journal represents cost accrual which is created at the same time as sales invoice data).
That's it for this week. :)
On the accounts and tax side, client's chased for books or missing data. The deadline is fast approaching for personal tax returns.
On the Dynamics Nav side of the business, 2 client on site visits this week and 1 booked for next week. One this week was a meet and greet with a discussion on upgrading from Dynamics Nav v4 to 2015 and what the benefits would be. We do not do upgrades so this may or may not lead to more work if the client can find a business case.
Another client visit for a very intense day on what Dynamics Nav has on offer. The client is a current user but only for base financials. So the day consisted of running through all the functionality in Nav. Went well.
Also confirmed this week maximum number of users for Dynamics Nav is circa 500. More than I thought but there must be some benefits to the Internet friendly end user interface.
Next week I am at a client site providing some on site training re Dynamics Nav - or as the client calls it a master class.
Work completed this week was mainly around first line support. Issues resolved included:
Confirmed reason for error in excel data sales data file load. Error fixed by client on excel file and reloaded successfully.
Completed a number of bug fixes / enhancements for developments previously delivered. Included text overlap error resulting from inconsistent text lengths for related but different objects.
Confirmed latest client UAT database copy of live from last week.
Developments completed this week, delivered and now in live:
Transfer order excel file load.
Quotes provided this week for:
Alternate business address for new business within set of Nav books.
Adding posted document line descriptions to GL entries form.
Bar code search development - so when bar codes (yes codes) are added to the cross reference table on Nav, a item field called bar code search is updated with all bar codes assigned to the item. the user can then user standard Nav data fields to search for bar codes.
Auto match posted customer ledger entries with common reference point. Really a clear up for posted entries from another development that did not clear due to net refunds.
Waiting for approval and will then schedule the work.
Still looking at / investigating the following:
Jet report issue #VALUE error.
Journals created but at a zero value for sales legacy load (journal represents cost accrual which is created at the same time as sales invoice data).
That's it for this week. :)
Friday, 28 November 2014
Week ending 28/11/14
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.
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, 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!
Subscribe to:
Posts (Atom)
