[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