Structure of GL Records

[Andrew McVeigh]

We have one transaction per record and one amount field along with a Credit/Debit boolean

Then the logic does the postings to add or subtract and put the amount in the right columns

30 years now it’s worked for

Andrew McVeigh
Surfway Real Solutions
Phone 02 44412679 Mobile 0418428016
www.surfway.com.au
www.berrarabeach.com.au


 <http://www.surfway.com.au/>
 <http://www.surfway.com.au/>
> On 14 May 2022, at 3:40 am, 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