Structure of GL Records

[Das Goravani]

So two records in the GL file, and one record in the Transaction table? And there may be more than 2 records in GL for one transaction, correct? If they want to credit and debit different accounts that relate to the transaction. 

> On May 13, 2022, at 1:14 PM, Paul Manning via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> 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 
> 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com