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.

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.

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! :)

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!