COA sorting

Comments

• Options

  lvanvugt Member Posts: 774

  2010-11-22

  Are both COAs in the same database? And on which database server (Native or SQL).
  I am asking as it seems that the first one is sorted as Text and the second as Code (i.e. numerical).

  Luc van Vugt, fluxxus.nl
  Never stop learning
  Van Vugt's dynamiXs
  Dutch Dynamics Community

  0
• Options

  David_Singleton Member Posts: 5,479

  2010-11-22

  Some versions of Navision have been modified to allow sorting like this in line with legal requirements. I can't be certain, but I think Spanish, Finish and Swedish are examples there are more. Maybe its one of those versions you are looking at.

  David Singleton
  

  0
• Options

  lvanvugt Member Posts: 774

  2010-11-22

  You are fully right David.
  These Western European countries have a text sorting: BE, ES, PT, CH, NO, SE, GR
  And these countries not, i.e. they have numerical sorting: NL, FI, UK (and IE), IT, DE, DK, FR, TR
  (i.e these are the countries I have been working in the MS team I was on)

  Luc van Vugt, fluxxus.nl
  Never stop learning
  Van Vugt's dynamiXs
  Dutch Dynamics Community

  0
• Options

  dkgarden Member Posts: 38

  2010-11-23

  Hi guys,
  
  I think i found the issue.. the former is using SQL database where the latter is in Native database.
  
  Anyway thanks a lot for the kind reply.

  0
• Options

  David_Singleton Member Posts: 5,479

  2010-11-23

  lvanvugt wrote:

  You are fully right David.
  These Western European countries have a text sorting: BE, ES, PT, CH, NO, SE, GR
  And these countries not, i.e. they have numerical sorting: NL, FI, UK (and IE), IT, DE, DK, FR, TR
  (i.e these are the countries I have been working in the MS team I was on)

  
  
  Thanks, I have updated my Wiki page from this.
  
  GL Account as Text instead of Code :thumbsup:

  David Singleton
  

  0