Interesting facts re Dynamics Nav this week included how to export any BLOB type field. Nav holds as an * so you cannot copy and paste. So process involves converting this to text and then creating a file. So why is this of interest? Nav notes (not comments) and specifically their content are BLOBs.
Anyway work completed this week:
Completed data migration for opening trial balance for 2 companies. [Nav 2013r2]
Review and comment on potential candidate CVs for key finance role in a client.
Minor report amendment for a pick list [Nav 2009 RTC].
Report development to allow warehouse item journal upload from excel [Nav 2009 Classic] approved and completed.
Enhance sales price excel upload [v4 database, 2009 Classic application] to auto close (end date) old prices where minimum quantity is 0 or 1 rather than on an exact match on minimum quantity (as well as other key fields).
Amend report for stock valuation to exclude goods in bins when calculation free stock quantity and valuations. In other words not free so reduce free stock.
Finished quote with business partner for Nav 2016 new install, configuration, data migration and training. Submitted to client for approval and waiting to here. Watch this space.
Plans for this week include on site attendance to run through VAT rec work completed for last 2 years trading for a client [Nav 2009], 2 days on site to complete management accounts [Nav 2013r2], run through proposed development for ancillary data re service contracts [Nav 2013r2] and potentially assisting a client with interviews.
That's all for this week folks.
Monday, 7 March 2016
Monday, 29 February 2016
Week ending 26/2/16
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.
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, 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!
Monday, 25 January 2016
Week ending 22/1/16
Spent all last week at the office. No client visits and the same for this week. All change next week though!
Work completed last week included:
Non Dynamics Nav related, more accounts related: balanced up last statutory accounts to Nav and will post off final audit related journals today.
Fixed a number of misc changes to reports for layouts, fitting on a landscape A4 page etc. [Nav 2013r2].
Finished final testing and delivery of auto emailing vendor remittance pdfs so this is finally completed. Issues caused by hosted solution and issues re where files located and what needs to be done to attach file to an email. Action depends on whether creating or smtping! [Nav 2013].
Started auto emailing sales orders as part of the posting process. All finished so just need to deliver to client when smtp server settings confirmed. [Nav 2013].
Added more fields to an export to excel report as required by client. [Nav 2009 Classic].
Finished creating 3 new businesses from created master business. [Nav 2013r2].
Amended some jet reports previously created for a client. [Nav 2015]. Discovered that we cannot make some new reports as spec'd as we do not have Jet Essentials (not at the price Jet charge for it) and so cannot use additional functionality for NL function available in Essentials not in Express. For example 'First', 'Sum' etc which means no Report tab required and so multiple tabs possible on same spreadsheet. Never mind!
Sign off for US sales tax received so now configured on live US company on US database. Client will invoice this week.
Something changed on BingAds such that a landing page must be the same as that displayed on the advert. But character restriction on advert so had to redesign part of the web pages so that some new hidden web pages linked from BingAds would work. As a result 23 adverts suspended now all active. A bit of a hassle!
That's it for this week!
Work completed last week included:
Non Dynamics Nav related, more accounts related: balanced up last statutory accounts to Nav and will post off final audit related journals today.
Fixed a number of misc changes to reports for layouts, fitting on a landscape A4 page etc. [Nav 2013r2].
Finished final testing and delivery of auto emailing vendor remittance pdfs so this is finally completed. Issues caused by hosted solution and issues re where files located and what needs to be done to attach file to an email. Action depends on whether creating or smtping! [Nav 2013].
Started auto emailing sales orders as part of the posting process. All finished so just need to deliver to client when smtp server settings confirmed. [Nav 2013].
Added more fields to an export to excel report as required by client. [Nav 2009 Classic].
Finished creating 3 new businesses from created master business. [Nav 2013r2].
Amended some jet reports previously created for a client. [Nav 2015]. Discovered that we cannot make some new reports as spec'd as we do not have Jet Essentials (not at the price Jet charge for it) and so cannot use additional functionality for NL function available in Essentials not in Express. For example 'First', 'Sum' etc which means no Report tab required and so multiple tabs possible on same spreadsheet. Never mind!
Sign off for US sales tax received so now configured on live US company on US database. Client will invoice this week.
Something changed on BingAds such that a landing page must be the same as that displayed on the advert. But character restriction on advert so had to redesign part of the web pages so that some new hidden web pages linked from BingAds would work. As a result 23 adverts suspended now all active. A bit of a hassle!
That's it for this week!
Subscribe to:
Posts (Atom)
