Week ending 22/5/15

Another busy Dynamics Nav week though this week will be a lot quieter.
Developments completed:
3 Jet reports created off Nav 2015 for client to layout as required subject to the limits of what Jet can do. Pretty good match and a good starter for analysing the results. Learned a bit more on pivot tables as I usually create my own using vlookups and sumifs in excel. But Jet will not cope with this.
Auto update on exchange rates in 1 business to other businesses on the same database for the same currency code / start date combination. (Nav 2009 RTC). All handled via the exchange rate table and the company table.
Changed item sales price selection to use Shipment Date not Order Date on match to sales prices start dates (Nav 2009 application v4 database). Also added an update sales document lines for any change in shipment date on the sale document header with a confirm box to get the user to confirm a change to sales document line unit prices required. Delivered and being tested.
Add dimension name for global dimension 1 on general ledger entries screen (Nav 5).
Training completed:
Provided 2 days on site training for Nav 2015 addon this week. Both went well.
First line support service resolved:
Permissions issue that was actually 'dirty' coding issue (Nav 2009 application, v4 database). Ability of a user to edit a specific field on the customer table handled by code in the table that looks for specific fixed text user ids. Should have used boolean on user set up table - more flexible. Anyway problem resolved by adding another user id as fixed text in code.
Confirmed excel upload for transfer order issue not down to upload but the user populating Transfer to location codes before shipping the transfer order.
Updated previously delivered development re pallets to latest live database objects. Previously delivered in Feb but needed updating to latest version for user acceptance testing.
Confirmed how to get client licence file from Nav 2009 Classic database.
On non Dynamics Nav related business, web site redesigned with a new home page and some of the other pages updated as well as a different look. Have a look at http://wwwhttp://www.dynamicsnavukhelp.co.uk/.dynamicsnavukhelp.co.uk/.
That's all for this week.