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.
Monday, 15 February 2016
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!
Monday, 18 January 2016
Week ending 15/1/16
Another week goes by and very busy. But this week looks a lot quieter.
Nothing to note re Dynamics Nav features though I did here a rumour that Nav 2016 allows data views in a consolidated business to each businesses GL entries. Turned out to be untrue in GB version after we tested it.
Work completed this week:
A day in London providing on site support for Dynamics Nav running through consolidation process [v5]. 2 days on site finalising management accounts for the month of December (yes we provide accounting expertise as well). [Nav 2013r2].
Development completed for EUR sales invoice with foot note re GBP value of VAT. [Nav 2009 Classic].
Final testing completed on auto emailing pdf remittance advices from the payment journal. Loaded into live along with all other developments (new fields / page actions off vendor and general ledger entries) today. [Nav 2013].
Also completed minor change to purchase order import via dataport re posting date. [Nav 2019 Classic].
So the majority of the week at client sites! But no client site visits this week though we need to complete for another client auto emailing posted sales invoices from the posting process in sales orders. Includes multiple language options for customers depending on language code assigned to customer card. SMTP set up table in Nav amended to hold email titles, bodies etc. [Nav 2013].
That's all for this week folks!
Nothing to note re Dynamics Nav features though I did here a rumour that Nav 2016 allows data views in a consolidated business to each businesses GL entries. Turned out to be untrue in GB version after we tested it.
Work completed this week:
A day in London providing on site support for Dynamics Nav running through consolidation process [v5]. 2 days on site finalising management accounts for the month of December (yes we provide accounting expertise as well). [Nav 2013r2].
Development completed for EUR sales invoice with foot note re GBP value of VAT. [Nav 2009 Classic].
Final testing completed on auto emailing pdf remittance advices from the payment journal. Loaded into live along with all other developments (new fields / page actions off vendor and general ledger entries) today. [Nav 2013].
Also completed minor change to purchase order import via dataport re posting date. [Nav 2019 Classic].
So the majority of the week at client sites! But no client site visits this week though we need to complete for another client auto emailing posted sales invoices from the posting process in sales orders. Includes multiple language options for customers depending on language code assigned to customer card. SMTP set up table in Nav amended to hold email titles, bodies etc. [Nav 2013].
That's all for this week folks!
Tuesday, 12 January 2016
Week ending 8/1/16
Hello all! Nothing to report re features apart from designing layouts in Nav 2013R2 a nightmare despite the provision of wizards. But then adding data grouping very easy even without table keys / indices.
Work completed this week included:
Client on site support visits to make changes to the existing configurations and develop to requirements. Developments included changes to a previous cash flow development data extract and included developing reports for data extracted. Created master new company and tested so this week will create an additional 3 new companies as per client request. Configured new test company on US database for sales tax so that the user can test transactions pre go live. Also created a report to show sales tax liability for past transactions using the new sales tax configuration data. Fixed previously developed (amended from standard Nav aged debt reports) Aged Debt KPI reports to show correct totals for ageing having swapped the ageing columns around. [Nav 2013R2].
Started auto email development for a client to allow emailing pdf of sales invoice from sales order post and print option where customer has been identified as emailing sales invoice a preference. Tested functionality so now about to roll out to specific post and print routine. [Nav 2013].
On site attendance to train an end user (new to client) on Dynamics Nav consolidation process. Work on site included balancing off group consolidation to published accounts. [Nav v5 DE].
That's it for this week folks. More on site visits tomorrow / Thursday re finalising management accounts and publishing. More accounting than Dynamics Nav.
Work completed this week included:
Client on site support visits to make changes to the existing configurations and develop to requirements. Developments included changes to a previous cash flow development data extract and included developing reports for data extracted. Created master new company and tested so this week will create an additional 3 new companies as per client request. Configured new test company on US database for sales tax so that the user can test transactions pre go live. Also created a report to show sales tax liability for past transactions using the new sales tax configuration data. Fixed previously developed (amended from standard Nav aged debt reports) Aged Debt KPI reports to show correct totals for ageing having swapped the ageing columns around. [Nav 2013R2].
Started auto email development for a client to allow emailing pdf of sales invoice from sales order post and print option where customer has been identified as emailing sales invoice a preference. Tested functionality so now about to roll out to specific post and print routine. [Nav 2013].
On site attendance to train an end user (new to client) on Dynamics Nav consolidation process. Work on site included balancing off group consolidation to published accounts. [Nav v5 DE].
That's it for this week folks. More on site visits tomorrow / Thursday re finalising management accounts and publishing. More accounting than Dynamics Nav.
Tuesday, 5 January 2016
Week ending 1/1/16
Hope you all had a good Xmas and New Year. Despite the seasonal nature of the break we were busy in between Xmas and New Year.
Features of Dynamics Nav: getting brackets on reports like report 25 for accounts schedules and getting the variances between budget and actual to show properly (bad news in bracket) whether a revenue or cost and whether 'show opposite sign' or not. Easy? Nope. Looked it re brackets but suggested solution (advanced settings in Regional settings for desktop) did not work so had to program in Nav in report 25. [Nav 2013R2].
Anyway on with the work completed:
Purchase deal report completed for client that finds purchases for a user defined period and confirms current stock levels for the purchased stock overall and for the main lot as well as overall stock for the same item. [Nav 2009 RTC].
Completed backups of redundant companies on UK and US database, deleted the same companies and then created a copy of the live company on each database as a test company. [Nav 2013r2].
Completed the above feature development to show brackets and proper variances for report 25 accounts schedules. Also attempted same fix for overview but much more complex so need to find a solution. Strangely despite by ranting and raving of the use of 'text' fields rather than decimals on Nav 2015/2016 accounts schedules this may be the way forward to get brackets and proper signage on accounts schedule overview. Watch this space.
Attended client site yesterday (hence delay in blog) to assist re Dynamics Nav 2013r2.
That's it for this week folks.
Features of Dynamics Nav: getting brackets on reports like report 25 for accounts schedules and getting the variances between budget and actual to show properly (bad news in bracket) whether a revenue or cost and whether 'show opposite sign' or not. Easy? Nope. Looked it re brackets but suggested solution (advanced settings in Regional settings for desktop) did not work so had to program in Nav in report 25. [Nav 2013R2].
Anyway on with the work completed:
Purchase deal report completed for client that finds purchases for a user defined period and confirms current stock levels for the purchased stock overall and for the main lot as well as overall stock for the same item. [Nav 2009 RTC].
Completed backups of redundant companies on UK and US database, deleted the same companies and then created a copy of the live company on each database as a test company. [Nav 2013r2].
Completed the above feature development to show brackets and proper variances for report 25 accounts schedules. Also attempted same fix for overview but much more complex so need to find a solution. Strangely despite by ranting and raving of the use of 'text' fields rather than decimals on Nav 2015/2016 accounts schedules this may be the way forward to get brackets and proper signage on accounts schedule overview. Watch this space.
Attended client site yesterday (hence delay in blog) to assist re Dynamics Nav 2013r2.
That's it for this week folks.
Subscribe to:
Posts (Atom)
