[AccessD] Accounting: digits only for account numbers?

Hi Charlotte

Thanks Charlotte. Neither have I seen it, but many systems have
strings for account numbers which would allow literals.

/gustav


> 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