Structure of GL Records

[Paul Manning]

Correct

Paul

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


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