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!
Monday, 18 January 2016
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.
Monday, 21 December 2015
Week ending 18/12/15
No 'features' to report this week.
Work completed this week included:
On site for 2 days creating and publishing management accounts. So more an accountants role rather than Dynamics Nav. [Nav 2013r2].
Amend aged accounts payable report to show external document number (supplier invoice number) rather than document number. Did you know option to show one or other in US database [Nav 2013R2] though UK report id does not exist in US and US has its own specific report id?
New jet reports (2) off Nav 2015 on contracts add on summarising contract ledger entry transactions.
Change to data export codeunit (yes not developed in a dataport!) for vendor data extracts. [Nav 2009 Classic].
Minor changes to pick list report to show line repeated data in header. [Nav 2009 RTC].
Minor changes to accounts schedules report to make row number invisible. Again did you know invisible in US database same report? [Nav 2013R2].
Changes to vendor ledger entry page to show dimension code from posted purchase document lines. UK and US databases. [Nav 2013R2].
Completed development to track unit cost (average cost) pre uplift across chronological ledger entry transactions in value entry. Data created held in bespoke table and will be used for more reports to be completed for same client this week. [Nav 2009 RTC].
That's it for this week folks. Hope you all have a great Xmas and New Year!
Work completed this week included:
On site for 2 days creating and publishing management accounts. So more an accountants role rather than Dynamics Nav. [Nav 2013r2].
Amend aged accounts payable report to show external document number (supplier invoice number) rather than document number. Did you know option to show one or other in US database [Nav 2013R2] though UK report id does not exist in US and US has its own specific report id?
New jet reports (2) off Nav 2015 on contracts add on summarising contract ledger entry transactions.
Change to data export codeunit (yes not developed in a dataport!) for vendor data extracts. [Nav 2009 Classic].
Minor changes to pick list report to show line repeated data in header. [Nav 2009 RTC].
Minor changes to accounts schedules report to make row number invisible. Again did you know invisible in US database same report? [Nav 2013R2].
Changes to vendor ledger entry page to show dimension code from posted purchase document lines. UK and US databases. [Nav 2013R2].
Completed development to track unit cost (average cost) pre uplift across chronological ledger entry transactions in value entry. Data created held in bespoke table and will be used for more reports to be completed for same client this week. [Nav 2009 RTC].
That's it for this week folks. Hope you all have a great Xmas and New Year!
Wednesday, 16 December 2015
Week ending 11/12/15
Nothing to report on 'features' on Dynamics Nav this week. A good sign? The only point of note is that if you are using the Jet addin for Dynamics Nav, remember it is free for Nav 2009 onwards and there are over 30 free reports designed that come with it which require minimal editing to get working on your database. Oh and copying and deleting companies from Nav 2013R2 onwards really easy though backing up a company can be done but from development environment in later versions of Nav 2013R2.
Work completed this week included:
A number of client visits for on site support (including creating and amending Jet reports) which resulted in more work requests for Dynamics Nav 2009 reports (with export to excel option) and Jet reports (off Nav 2015 database).
Confirmed how to configure US Dynamics Nav database (Nav 2013R2) for state sales tax. Very easy. Just waiting for client to confirm when change needs to be made for.
Completed 1st pass at bespoke development for cash flow data extracts for a client [Nav 2013R2]. Bit buggy so need to resolve next week and then deliver. Completed spread development for client [Nav 2013R2] which allows a user to forward spread post a sales invoice to a number of future periods (user confirms start date for spread and number of months). Delivered to client but awaiting rationalisation of existing companies (delete old unused companies and create a new test company as a copy of live).
That's it for now folks!
Work completed this week included:
A number of client visits for on site support (including creating and amending Jet reports) which resulted in more work requests for Dynamics Nav 2009 reports (with export to excel option) and Jet reports (off Nav 2015 database).
Confirmed how to configure US Dynamics Nav database (Nav 2013R2) for state sales tax. Very easy. Just waiting for client to confirm when change needs to be made for.
Completed 1st pass at bespoke development for cash flow data extracts for a client [Nav 2013R2]. Bit buggy so need to resolve next week and then deliver. Completed spread development for client [Nav 2013R2] which allows a user to forward spread post a sales invoice to a number of future periods (user confirms start date for spread and number of months). Delivered to client but awaiting rationalisation of existing companies (delete old unused companies and create a new test company as a copy of live).
That's it for now folks!
Monday, 7 December 2015
Week ending 4/12/15
Let's start with the interesting points found in supporting Dynamics Nav this week. All tweeted and facebooked last week:
Watch out for DATE2DMY when you are using a UK
database on US server. You will need to use WINDOWSLANGUAGE. Cannot find create fiscal year as an action in Nav 2013
onwards? Down to the profile assigned to user id. Changing column order in page lists easy in Nav 2013
onwards. Highlight line or lines in design mode and use UP or DOWN arrow. First time had to use Analysis by Dimensions to get
accounts schedules and filtering to work on non global dims.
Work completed this week included:
Creating analysis by dimensions for non global dims so that filtering works and other specifically formatted account schedule per client requirements. Standard Nav functionality so configuration only. [Nav 2015].
Added 2 more data sets to new Get Cash Flow data page functionality. Was just contract service next rolling 12 months. Now added due debts and liabilities from sales and purchase ledger respectively using a different source but same basic output. Approved by client and client requested add in other cash flow related items such as overhead spend (using last month as example) etc. [Nav 2013R2].
Agreed rationalisation of companies on both UK and US database and confirmed will delete old unused companies (only1 live company per database). Also amended user end view so users can only see 1 company. Positively received by end users. [Nav 2013R2].
Attended client site today to explain how foreign currency works on sub ledgers (very easy to configure and maintain), the difference between Amount and Amount (LCY) and the difference between transaction foreign currency on sub ledgers and additional reporting currency. [Nav 2009 Classic].
Attended client site today to explain how foreign currency works on sub ledgers (very easy to configure and maintain), the difference between Amount and Amount (LCY) and the difference between transaction foreign currency on sub ledgers and additional reporting currency. [Nav 2009 Classic].
Attended client site to support accounts preparation process for depreciation and payroll journals. Explained use of standard journals (basically saving a fixed journal in format to use again). Returning to site at the end of this week to complete this process. Also working on additional development to spread revenue and costs to future periods. [Nav 2013R2].
That's it for this week folks.
Tuesday, 1 December 2015
Week ending 27/11/15
Work completed this week included:
On site support for reviewing / fixing Jet reports previously created and creating new Jet reports as per client requirements.[Nav 2015].
Added dimension code values to the item ledger entry page list. [Nav 2009 RTC].
Completed first stage emailing of remittance pdfs through vendor email details and a new page action off the payment journal page. Eventually this will be replaced with an auto email remittances as pdfs. Also made changes to the unposted remittance report including adding the company information logo. [Nav 2013].
Started this week the 5 for the price of 4 days discount for December 2015 and January 2016. So for every PO for 5 days you will be charged for 4. So a day for free. More details at http://www.dynamicsnavukhelp.co.uk/offers/.
And we have Nav 2016 UK up and running on a PC at our office with web services installed. So if you want to preview, email us.
Plans for this week and next include 3 on site client visits for either on site support or to discuss requirements.
Points of interest for this week re developments was the SaveAsPDF option on c/side code. Did not appreciate that this saved pdfs to the the Nav instance server and therefore any attempt to add the pdf created to an email off a user's desktop proved fruitless. So did you know that there is a DOWNLOAD command in c/side but this is worse than useless as it prompts the user to confirm the file to retrieve and the directory to save it to. So less automated for emailing pdfs. Managed to get this working via more code which means pdf attached to email.
That's all for this week folks!
On site support for reviewing / fixing Jet reports previously created and creating new Jet reports as per client requirements.[Nav 2015].
Added dimension code values to the item ledger entry page list. [Nav 2009 RTC].
Completed first stage emailing of remittance pdfs through vendor email details and a new page action off the payment journal page. Eventually this will be replaced with an auto email remittances as pdfs. Also made changes to the unposted remittance report including adding the company information logo. [Nav 2013].
Started this week the 5 for the price of 4 days discount for December 2015 and January 2016. So for every PO for 5 days you will be charged for 4. So a day for free. More details at http://www.dynamicsnavukhelp.co.uk/offers/.
And we have Nav 2016 UK up and running on a PC at our office with web services installed. So if you want to preview, email us.
Plans for this week and next include 3 on site client visits for either on site support or to discuss requirements.
Points of interest for this week re developments was the SaveAsPDF option on c/side code. Did not appreciate that this saved pdfs to the the Nav instance server and therefore any attempt to add the pdf created to an email off a user's desktop proved fruitless. So did you know that there is a DOWNLOAD command in c/side but this is worse than useless as it prompts the user to confirm the file to retrieve and the directory to save it to. So less automated for emailing pdfs. Managed to get this working via more code which means pdf attached to email.
That's all for this week folks!
Subscribe to:
Posts (Atom)
