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!

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!

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 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.

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!