Structure of GL Records

[Paul Manning]

I agree with this as well.  You may though want to have a ’Transaction’ table that links these 2 records together.  This table would have the common information.  Dates Description etc.

Paul

************************************************
Paul R. Manning
paulrmanning58 at icloud.com



> On May 13, 2022, at 1:01 PM, Jeffrey Jones <jjones at synergos.com> wrote:
> 
> Yes, you will want two lines that balance one another and can be posted to different accounts.
> 
> -Jeff
> 
>> On May 13, 2022, at 9:47 AM, Das Goravani <goravanis at gmail.com> wrote:
>> 
>> 
>> Hello,
>> 
>> Sorry the the again off topic question.
>> 
>> I’m wondering how to construct a General Ledger. 
>> 
>> The records, do you think it’s best to store the debit and credit as two separate records in the same table?
>> 
>> Or have your GL Table setup with two sides in each record?
>> 
>> I’m thinking one file with two types of records, one debit and one credit.
>> 
>> Any input?
>> 
>> Das
>> _____________________________________________________________
>> Manage your list subscriptions at https://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com