David Singleton

Prague, Czech Republic
Freelance Consultant Dynamics NAV
Male
  • 6,520 Posts
  • 63,613 Points
  • Joined: 2001-4-12
  • Last Online: 2012-5-17 8:32
  • DynamicsNAVMVPModeratorSystemAdministrator

Shared Favorites

View all favorites

Shared Feeds

David Singleton has not entered any shared feeds.

My Bio

I started working with Navision as an End User. That was on ver 3.04 on OS/2 and DOS. That company eventually became a Navision reseller, and I joined PC&C to create NTR's (Navision Territorial Representatives) in Central and Eastern Europe. I then created my own consulting company, where I consulted to NSCs (Navision VARS) and also developed Add-Ons. I have implemented 189 Navision systems in 17 countries, and lost count of the number of consultants and developers that I have trained over the years. These days most of my work involves training people how to implement Navision on Budget, and helping End Users to control the cost of their Implementation mainly through management of their NSC.

Announcements

My Activity

View more

My Comments

Emanuel Galvan Salazar wrote Hi David I've seen your one of the most active members in this community and I see a reply you m
on 2009-10-14 4:51

Hi David!

I'm a project leader for a global project with NAV, and a member of my team who's a junior developer made an import dataport that imports what our customer calls "opening balance entries", but it creates it directly into the G/L Entry table instead of into the Gen. Journal Line (as its supposed to be done for its later post into the system).

My team member aware him of the risk of doing this and she told me that the person with whom she spoken to told her that they don't want to pass through the Journals as it has to be done, due to the Currency conversion routines that we made (they have Functional, Reporting and Original Currencies for its application).

So, my team member developed this dataport (without knowledge by my side) and what's currently happening is that our customer had been using this dataport on all their databases (25 countries already) and they are experiencing errors with the Close Income Statement due to they are using the Dimensions option of this report, and these imported entries were not replicated into the Ledger Entry Dimension (just into the GL Entry table) as its done by the NAV standard code.

Could you give me some advice on this, I think that these entries should be recreated but imported into the Gen. Journal Line table as it had to be done since the begining for its later post into the system to follow all the NAV standard routines, and look for a way to avoid these Currency conversion routines in order to do this correctly.

I would like to know your opinion on this, receive many kind regards.

Emanuel Galvan.