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.