G/L Account - Sorting

ashtaroth
ashtaroth Member Posts: 5
edited 2005-12-15 in NAV/Navision Classic Client
Hi everybody!

We have a problem here regarding the sorting of G/L Accounts. The 'No.'-field in this table is code-type. Regarding the sorting, code is treated as a string - so '11046' is followed by '1105' is followed by '11051'. That's ok so far...

But when I want to summarize our customer-accounts e.g. 11000 to 16999, there are several accounts involved that should be ignored (like 1210, 1400 and so on). I want to create two new accounts and summarize every account between these two numbers.
CRONUS is using account-numbers less than 10000 so I'm not able to imitate the standard :(. And unfortunalely we have to use the existing account-numbers. Does anyone have a clue how to set this up?

Thanks in advance,
ASH 
SELECT * FROM users WHERE clue > 0;
0 rows returned

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Are you using SQL or are you implementing a belgian account schedule?

    In Belgium the code field for No. was replaced by a textfield for this purpose.

    Totaling should be done automaticaly when the smaller g/l accounts are total accounts.
    Marije Brummel | Freelance Business Central Specialist
  • ashtaroth
    ashtaroth Member Posts: 5
    Hi!

    Yes, we will use a SQL 2005 server.
    No, I'm from Germany and so we are using a german account-template, delivered by Datev (http://www.datev.com/).

    I've tried to summarize the smaller accounts in a extra summary, unfortunately with no effect :(. Or what do you mean with "total accounts"?

    PS: Our accounts are referenced by pre-defined numbers:
    - 1xxx is "financial and private accounts" like bank-accounts or "cash register"
    - 7xxx is "stocks of products"
    - >= 10000 is for own use

    Do the belgian customers use text-based accounts? 
    SELECT * FROM users WHERE clue > 0;
0 rows returned
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Yes, I know that in Belgium they have changed to text because of this. Their accout schedile is like

    1
    10
    100
    2
    20
    200

    And navision assumes every code has the same length.

    But maybe belgian engineers can correct me if I am wrong...
    Marije Brummel | Freelance Business Central Specialist
  • ashtaroth
    ashtaroth Member Posts: 5
    Oh, now I understand. So for them it seems to be the right way. 
    SELECT * FROM users WHERE clue > 0;
0 rows returned
  • kine
    kine Member Posts: 12,562
    You are not able to fill the no with 0 from left to same length??? Why?

    ...
    01105
    11046
    11051
    ...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ashtaroth
    ashtaroth Member Posts: 5
    Ok, this works just perfect - although I think it's not quite clear.

    Thanks everybody \:D/. 
    SELECT * FROM users WHERE clue > 0;
0 rows returned

Categories