Monday 7 March 2016

Week ending 4/3/16

Interesting facts re Dynamics Nav this week included how to export any BLOB type field. Nav holds as an * so you cannot copy and paste. So process involves converting this to text and then creating a file. So why is this of interest? Nav notes (not comments) and specifically their content are BLOBs.
Anyway work completed this week:
Completed data migration for opening trial balance for 2 companies. [Nav 2013r2]
Review and comment on potential candidate CVs for key finance role in a client.
Minor report amendment for a pick list [Nav 2009 RTC].
Report development to allow warehouse item journal upload from excel [Nav 2009 Classic] approved and completed.
Enhance sales price excel upload [v4 database, 2009 Classic application] to auto close (end date) old prices where minimum quantity is 0 or 1 rather than on an exact match on minimum quantity (as well as other key fields).
Amend report for stock valuation to exclude goods in bins when calculation free stock quantity and valuations. In other words not free so reduce free stock.
Finished quote with business partner for Nav 2016 new install, configuration, data migration and training. Submitted to client for approval and waiting to here. Watch this space.
Plans for this week include on site attendance to run through VAT rec work completed for last 2 years trading for a client [Nav 2009], 2 days on site to complete management accounts [Nav 2013r2], run through proposed development for ancillary data re service contracts [Nav 2013r2] and potentially assisting a client with interviews.
That's all for this week folks.

No comments:

Post a Comment