I hope you all had a great Easter!
I have forgotten how much I dislike amending reports on Dynamics Nav 2013R2 - especially those written for Nav 2009 RTC with the infamous GetData / SetData code within the Layout area. Specific issue last week was report 1401 cheque remittance report. Once resolved all the changes (easy ones were the formatting changes, more complex adding more column totals) we then faced the fixed number of lines per A4 page issue. Then I remembered in Nav 2009 RTC this is set as an iteration maximum. So fixed this as well to allow for things such as a vendor address at the top of the remittance. Anyway after a few days of banging head against a brick wall, all fixed and delivered to client for testing.
Other work completed last week:
Attended 2 client sites to record ERP requirements data for, eventually, sending to potential ERP suppliers. I will be getting the notes taken into a requirements document (updating it) this week.
Attended 1 client site to provide on site Dynamics Nav support [Nav 2013r2]. Received a number of development requests and other work some of which will be finished today (transactions in a new company (to Nav) to date to be loaded and posted - data conversion done) and some tested today (tweaking of aged debt report to show columns by complete months).
So last week mainly on site visits. This week no on site visits but plenty of work to do.
That's all folks.
Tuesday 29 March 2016
Monday 21 March 2016
Week ending 18/3/16
Time flies when you are having fun. Easter from Friday!
Work completed this week included on site attendance at 2 sites -1 to start ERP requirements specification by collecting data on what is required. This involves a number of visits to client site to discuss end user requirements as well as expectation as to what the ERP application will provide out of the box. More discussions with end users this week. The other client site visit was to get standard Nav report working on a label printer. Previous solution was text file creation. All working using printer selections table to default report to label printer. [Nav 2009 application, v4 database].
New company set up and configured for client with no customers and vendors but the same base configuration as the existing business. [Nav 2009 Classic].
Migrated 2 years financial data for a company on Dynamics Nav and balanced off ready for use for March 2016 transactions. Converted budget data to load into Dynamics Nav. Amend a number of accounts schedule column layouts for new financial year. [Nav 2013r2]. Review a number of CVs and comment on for new Financial Controller's role at client.
Plans for this week are 3 on site visits. 2 days for completing the requirements specification data collection for a future ERP selection and 1 day on site support [Dynamics Nav 2013 R2]. One all ERP requirements data collected it will take a few days to pull the requirements document together which will be done next week.
So that's it folks. Have a great Easter!
Work completed this week included on site attendance at 2 sites -1 to start ERP requirements specification by collecting data on what is required. This involves a number of visits to client site to discuss end user requirements as well as expectation as to what the ERP application will provide out of the box. More discussions with end users this week. The other client site visit was to get standard Nav report working on a label printer. Previous solution was text file creation. All working using printer selections table to default report to label printer. [Nav 2009 application, v4 database].
New company set up and configured for client with no customers and vendors but the same base configuration as the existing business. [Nav 2009 Classic].
Migrated 2 years financial data for a company on Dynamics Nav and balanced off ready for use for March 2016 transactions. Converted budget data to load into Dynamics Nav. Amend a number of accounts schedule column layouts for new financial year. [Nav 2013r2]. Review a number of CVs and comment on for new Financial Controller's role at client.
Plans for this week are 3 on site visits. 2 days for completing the requirements specification data collection for a future ERP selection and 1 day on site support [Dynamics Nav 2013 R2]. One all ERP requirements data collected it will take a few days to pull the requirements document together which will be done next week.
So that's it folks. Have a great Easter!
Monday 14 March 2016
Week ending 11/3/16
This week's interesting fact re Dynamics Nav -
‘Warehouse item tracking permission issue. Permissions held in page / form 6550 Nav 2009 RTC so need to include this in any development. #Nav2009Wwarehouse’.
Work completed last week included 3 on site visits (2 days management accounts work and Dynamics Nav on site support, 1 day run through VAT reconciliation work completed for a client for the last 2 financial years) and changes to report developments (excel sales price load, amend quantity on assembly to recalculate value within report). Covering Nav v2009 RTC, Nav 2013r2.
Final fix for excel upload re warehouse item journals. [Nav 2009 RTC]. Bugs re line creation finally sorted by treating warehouse journal line table as very buggy. Think all the creation code does not sit on the table but in a codeunit. Anyway fixed now.
It was a good week for quotes - send a few out and most already approved. Quite a few requests for remittance / cheque reports or cheque reports on their own. Always thought we have moved away from this in UK to BACS reports but obviously not. There is a standard Nav report remittance / cheque but as most clients use pre printed stationery the vast bulk of any work on this is testing, aligning, testing etc. Also agreed terms for a bulk PO for another client for 10 days (so price reduced) for various elements of work on Nav 2013r2 subject to NDA being signed off by FPC. So just waiting for the NDA.
Plans for this week include first on site visit to new client to map current processes and on site support to fix Nav for new label printer.
That's all for this week folks.
‘Warehouse item tracking permission issue. Permissions held in page / form 6550 Nav 2009 RTC so need to include this in any development. #Nav2009Wwarehouse’.
Work completed last week included 3 on site visits (2 days management accounts work and Dynamics Nav on site support, 1 day run through VAT reconciliation work completed for a client for the last 2 financial years) and changes to report developments (excel sales price load, amend quantity on assembly to recalculate value within report). Covering Nav v2009 RTC, Nav 2013r2.
Final fix for excel upload re warehouse item journals. [Nav 2009 RTC]. Bugs re line creation finally sorted by treating warehouse journal line table as very buggy. Think all the creation code does not sit on the table but in a codeunit. Anyway fixed now.
It was a good week for quotes - send a few out and most already approved. Quite a few requests for remittance / cheque reports or cheque reports on their own. Always thought we have moved away from this in UK to BACS reports but obviously not. There is a standard Nav report remittance / cheque but as most clients use pre printed stationery the vast bulk of any work on this is testing, aligning, testing etc. Also agreed terms for a bulk PO for another client for 10 days (so price reduced) for various elements of work on Nav 2013r2 subject to NDA being signed off by FPC. So just waiting for the NDA.
Plans for this week include first on site visit to new client to map current processes and on site support to fix Nav for new label printer.
That's all for this week folks.
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.
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.
Subscribe to:
Posts (Atom)
