Features of Dynamics Nav found this week - exporting Notes which are technically BLOBS so you cannot simply export from a table. Needs conversion first.
Work completed last week included:
Instructions on bulk auto emailing sales invoices as part of the posting shipped sales order process completed and sent to client.
Development completed to allow warehouse reclassification journal load from excel including warehouse related item tracking. [Nav 2009 RTC].
Resolved incorrect posting of depreciation issue for v5 DE database. Basically client had reversed the transaction and not cancelled the entries. This is only available in the fixed asset module and if not used but transaction reversed, you cannot rerun depreciation calculation.
On site visit with client to discuss next month end planning (my accounts job) and next set of proposed changes re Dynamics Nav. [Nav 2013r2].
Did some HR related stuff this week for a client as well re job specification for a Financial Controller role and initial review of CVs from candidates.
Plans for this week include review of extra data requirement for service management module for software rental client, complete label printing reporting solution and complete development to amend item list [Nav 2009 RTC] to include GOODS IN bin data by lots.
So quiet week overall.
Monday 29 February 2016
Monday 22 February 2016
Week ending 19/2/16
Work completed last week included:
Smtp auto email settings in Nav changed and now working. [Nav 2013].
Confirmed best method for exporting GL entries to excel to work around 5000 line xml limit. [Nav 2013].
Confirmed our costs for moving accounts schedules from v5 DE to 2006 GB. We are not doing the upgrade (not something we do) but given quote received by partner for moving accounts schedules we provided an alternative quote at a tenth of the cost for this specific task.
Completed 3 way VAT reconciliation work for client and results delivered with recommendations. [Nav 2009 RTC].
Re-analysis and reposting of recharge lines for a client so that recharge reflects recovery not revenue, misc changes to accounts schedules, send spend reports to various members of client staff. [Nav 2013r2].
Create new read only permission set for client. Amend as required for permission issues around bespoke tables and German addons. [v5 DE].
Fixed PO import issue on file where file not in document number order. [Nav 2009 Classic].
Prospects wise re more work, contact who started a new contract role for sort out Dynamics Nav implementation in touch last week to update me. I would provide Nav expertise, she is the project manager.
Yet to hear from client re NDA sign off and therefore the start of more work following receipt of their application backup.
Outstanding work yet to do which needs finishing this week includes:
Last financial year final postings for a limited company. [Nav 2013r2].
Balance and clear VAT recs for last year. [Nav 2013r2].
Complete initial data migration for new companies (opening balance sheets). [Nav 2013r2]
Complete step by step instructions on smtp auto email on posting sales orders as invoices. [Nav 2013].
Complete label printer report and load into live database for testing. [Nav 2009 Classic, v4 database].
Developments to complete this week (quoted for approved last week) include an excel import for warehouse reclass journals. [Nav 2009 RTC].
Need to chase up transfer of MS Partner for our client to our business partner in Ireland and therefore confirm our first line support costs. [Nav 2013r2].
One on site client visit booked for later this week.
Monday 15 February 2016
Week ending 12/2/16
Quieter week this week.
Work completed this week:
Still trying to resolve issues with SMTP set up in Dynamics Nav 2013. Basically Nav not connecting to smtp server. Trying to resolve with client IT support. [Nav 2013]
Completed management accounts for UK and US business for January including accruals, prepayments and using accounts schedules in Dynamics Nav extensively. [Nav 2013r2].
Attend client site to provide support on various issues including VAT set up and posting, dimension reporting (global and non global, the latter using Analysis by Dims) and various other issues. [Nav 2009 RTC]. As a result of this work signed off to 3 way reconcile VAT statements for last 2 years quarter ends from return submitted (pdf) to Nav VAT statement to Nav GL codes for VAT. Due to start this this week.
Completed budget loads into Nav. [Nav 2013r2].
Confirmed object changes over last calendar year for client. [v5 DE].
Just been asked to quote for excel file load for warehouse reclass journals - obviously not 2013, 2015 or 2016 as you can copy and paste direct but for 2009 RTC. Will get this quote out today with work scheduled for next week.
That's it for this week folks.
Work completed this week:
Still trying to resolve issues with SMTP set up in Dynamics Nav 2013. Basically Nav not connecting to smtp server. Trying to resolve with client IT support. [Nav 2013]
Completed management accounts for UK and US business for January including accruals, prepayments and using accounts schedules in Dynamics Nav extensively. [Nav 2013r2].
Attend client site to provide support on various issues including VAT set up and posting, dimension reporting (global and non global, the latter using Analysis by Dims) and various other issues. [Nav 2009 RTC]. As a result of this work signed off to 3 way reconcile VAT statements for last 2 years quarter ends from return submitted (pdf) to Nav VAT statement to Nav GL codes for VAT. Due to start this this week.
Completed budget loads into Nav. [Nav 2013r2].
Confirmed object changes over last calendar year for client. [v5 DE].
Just been asked to quote for excel file load for warehouse reclass journals - obviously not 2013, 2015 or 2016 as you can copy and paste direct but for 2009 RTC. Will get this quote out today with work scheduled for next week.
That's it for this week folks.
Monday 8 February 2016
Week ending 5/2/16
2 on site client site visits completed last week - one was for an existing client providing Dynamics Nav support and the other was a new client (1st visit) cramming 4 days training into 1. [Nav 2013r2] The latter (Central London) was a very intense day and was equally split between a question and answer session from 4 end users and a run through the financial management module for 1 user. Then received another on site support request later in the week for the same week but could not do. So this may be a very important client re work. Time will tell. Sent off signed (from FPC) NDA so just waiting to receive fully signed version.
Developments completed included enhancing a report showing last 3 years sales report by customer (excel export) by month for all 3 years to include open sales order (not invoiced value) for the current year split by month. [Nav v2009 application, Nav v4 database].
Looks like we have a fix for smtp issues re nav 2013. Issue on the client network and exchange server settings. Will be testing today.
First line support has a number of issue calls including corrupt pdf files in emails for sales invoicing (v4, extensive use of SLEEP command, issues from change in server by client) which we are struggling to replicate and therefore fix. Granted access to the same server today so we will try again to replicate. Definitely a server performance / Nav performance issue.
Out a client sites for 3 days this week. 2 days as a management accountant (preparing management accounts in Nav) [Nav 2013r2] and 1 day on site support [Nav 2009 Classic]. Both local.
So a quieter week last week but busy with more on site visits this week.
That's all for now folks.
Developments completed included enhancing a report showing last 3 years sales report by customer (excel export) by month for all 3 years to include open sales order (not invoiced value) for the current year split by month. [Nav v2009 application, Nav v4 database].
Looks like we have a fix for smtp issues re nav 2013. Issue on the client network and exchange server settings. Will be testing today.
First line support has a number of issue calls including corrupt pdf files in emails for sales invoicing (v4, extensive use of SLEEP command, issues from change in server by client) which we are struggling to replicate and therefore fix. Granted access to the same server today so we will try again to replicate. Definitely a server performance / Nav performance issue.
Out a client sites for 3 days this week. 2 days as a management accountant (preparing management accounts in Nav) [Nav 2013r2] and 1 day on site support [Nav 2009 Classic]. Both local.
So a quieter week last week but busy with more on site visits this week.
That's all for now folks.
Monday 1 February 2016
Week ending 29/1/16
Another week in the office (no client visits) but busy none the less.
Features found in Dynamics Nav:
smtp and create emails with pdfs attached in a hosted Nav 2013 requires different treatment for the location of the saved pdf file. Weird one!
First issue with dimension set id for vendor standard purchase codes in Nav 2013. Those assigned to a vendor purchase code do not come through when you Get Vendor Codes from an invoice or order. Dimension set id does and when you view the dimensions from the invoice or order line the dimensions are shown and as you exit they are shown on the line. Nothing before though! Again weird.
US database specific one this [Nav 2013r2] - you can configure US sales tax in Nav but beware - if you do not complete various ad hoc tick boxes, what works in standard sales invoicing does not for service management invoicing. All looks ok in service management until you post. Then sales tax disappears. Again a really strange one!
Work completed last week:
At last worked out a solution for label printing from Nav 2009 that does not involve creating a text file with printer specific language commands. Went back to creating a label type report in standard Nav and then tweaked for label sizes! Works - as you would expect.
Completed export to excel from sales price form using a form action. [Nav 2009 Classic].
Completed sales price excel import development. [Nav 2009 Classic] Having some strange issues when it comes to finding current lines that are the same in excel and Nav. Sometimes the codes cannot find what is in Nav. Need to resolve this week.
First line support issues resolved last week:
Completed a number of changes to improve and fix bugs re Nav 2009 Classic report.
Investigated and suggested solution for email pdf reports from posted sales invoice. [Nav v4]. Previous development completes had to use SLEEP command in Nav to slow the process down so Nav can find pdf created. Client moved users onto another server (not new) and generally performance slow (even for print preview) so emailing pdfs crashing or cannot find pdf. So suggested increasing SLEEP from 1000 (1 sec) to 5000 (5 secs). See what feedback we get this week.
Plans for this week: 2 client visits mid week - one to provide accountant and Dynamics Nav expertise, the other to train1 person on the financial management module on Dynamics Nav 2013r2 in 1 day. The latter will be a very busy day!
That's all for this week folks!
Features found in Dynamics Nav:
smtp and create emails with pdfs attached in a hosted Nav 2013 requires different treatment for the location of the saved pdf file. Weird one!
First issue with dimension set id for vendor standard purchase codes in Nav 2013. Those assigned to a vendor purchase code do not come through when you Get Vendor Codes from an invoice or order. Dimension set id does and when you view the dimensions from the invoice or order line the dimensions are shown and as you exit they are shown on the line. Nothing before though! Again weird.
US database specific one this [Nav 2013r2] - you can configure US sales tax in Nav but beware - if you do not complete various ad hoc tick boxes, what works in standard sales invoicing does not for service management invoicing. All looks ok in service management until you post. Then sales tax disappears. Again a really strange one!
Work completed last week:
At last worked out a solution for label printing from Nav 2009 that does not involve creating a text file with printer specific language commands. Went back to creating a label type report in standard Nav and then tweaked for label sizes! Works - as you would expect.
Completed export to excel from sales price form using a form action. [Nav 2009 Classic].
Completed sales price excel import development. [Nav 2009 Classic] Having some strange issues when it comes to finding current lines that are the same in excel and Nav. Sometimes the codes cannot find what is in Nav. Need to resolve this week.
First line support issues resolved last week:
Completed a number of changes to improve and fix bugs re Nav 2009 Classic report.
Investigated and suggested solution for email pdf reports from posted sales invoice. [Nav v4]. Previous development completes had to use SLEEP command in Nav to slow the process down so Nav can find pdf created. Client moved users onto another server (not new) and generally performance slow (even for print preview) so emailing pdfs crashing or cannot find pdf. So suggested increasing SLEEP from 1000 (1 sec) to 5000 (5 secs). See what feedback we get this week.
Plans for this week: 2 client visits mid week - one to provide accountant and Dynamics Nav expertise, the other to train1 person on the financial management module on Dynamics Nav 2013r2 in 1 day. The latter will be a very busy day!
That's all for this week folks!
Subscribe to:
Posts (Atom)
