[AccessD] Accounting: digits only for account numbers?

Yes, I understand that.  I've just never seen that particular kind of
account numbering.  If you use a surrogate primary key, it shouldn't
make any difference what literals they use, although you may need a
sortkey field to get them in the appropriate order in your chart of
accounts.

Charlotte Foust 

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Monday, March 08, 2004 10:13 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Accounting: digits only for account numbers?


Hi Charlotte

Thanks, no it wouldn't be a "new thing".
I should stress that I'm not talking about primary keys but, of course,
of unique numbers with or without literals.

/gustav


> I've never seen it, but then I've been out of active accounting for 
> years and it may be something new.  If I'm designing a system, they 
> can use anything they want because I'm not going to use that as the 
> primary key anyhow. <VBG>

> Charlotte Foust

> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Monday, March 08, 2004 9:24 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Accounting: digits only for account numbers?


> Hi all

> Some of you, I know, are quite experienced in accounting and/or
> accounting systems.

> Have any you encountered setups (for serious use) where literals were
> not only allowed - they are quite often - but actually used in
building
> the chart of accounts for the general ledger?

> I'm not thinking of setups where simple formatting of numbers could do
> it, like:

>   U0900-34.00
>   U7301-22.01
>   U8398-12.00

> but something like this:

>   KH43TBB
>   KL43TBS
>   M3799JH


> Also, I'm not thinking of old legacy systems nor customer or part
> numbers as you can meet everything possible here.

> Slightly OT, I know, but where else to ask?

> /gustav

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com