Re: [WebERP-developers] Closing balances - bank accounts

[iced l. <ice...@gm...>]

Provisos and issue remaining:

1. The opening balance transaction in the example with GL trans should
occur with GL turned off (if instructions in manual are correct)

2. The behaviour cannot be applied generally to transactions through
General Ledger unless the these transactions are displayed, such as bank
fees, in the bank reconcilliation listings. They do not display when type
is set to 0 (general journal) in the gltrans table and so fix should be
determined for the reconcilliation functions.

Comments appreciated.

Thanks,



On Wed, Nov 27, 2013 at 12:44 PM, iced lava <ice...@gm...> wrote:

> As an example:
> I note that if I enter the bank balances at 30 June with GL on, I can
> change the Type of transaction in the gltrans table to 0 (general journal).
> Appropriate [next] incremented general journal numbers a can provided to
> these transactions by editing as well [and systype incremented accordingly
> and chart detail also adjusted].
>
> If this is done then the year closing journals appear as required in the
> journal listings, on the trial balance and the bank listings and reports
> also seem correct (transactions are left untouched in banktrans table).
>
>
> This is as expected for the entry made through General Ledger bank
> receipts.
>
>
> Is this a bug?
> Should this behaviour also happen for other bank receipts and payments
> made through General Ledger option? I would think so.
>
> I can fix if required.
>
> Thanks.
>
>
>
>
> On Wed, Nov 27, 2013 at 12:04 PM, iced lava <ice...@gm...> wrote:
>
>> Could I have confirmation on what should happen when bank account
>> balances are entered in  for end of year closing balances eg at 30 June.
>>
>> Here is the current behaviour I see in latest  webERP. Note that usually
>> according to documentation year end balances should be done with GL
>> integration off.
>>
>> 1. With GL integration turned off, the bank balances are taken on at 30
>> June by entering a receipt (General Ledger - Bank account receipt entry).
>>
>>    - This transaction only appears as a single entry in the banktrans
>>    table - nowhere else
>>    - there is no corresponding balancing transaction - it would have to
>>    be made manually
>>    - as such the bank account balances do not appear in any 30 June
>>    trial balance
>>    - a listing of 30 June journal entries does not show any 30 June
>>    entries for any bank accounts GL accounts
>>    - trial balance as a consequence does not have any entries for these
>>    bank transactions
>>
>>
>> 2. With the GL integration turned on - if the bank balances are taken on
>> at 30 June by entering a receipt (General Ledger - Bank account receipt
>> entry)
>>
>>
>>    - The transaction appears as an entry in the banktrans table
>>    - there is a corresponding transaction in the gltrans table and the
>>    balancing transaction(s)
>>    - the chartdetails table has entries for these transactions
>>    - trial balance shows an entry for these bank accounts
>>    - the listing of 30 June journal entries does not show anything for
>>    the bank accounts
>>    - the type in the gltrans table is type 12 - bank transaction, not 0
>>    for general journal
>>
>>
>> This is causing confusing with customer.
>>
>> The behaviour I thought would happen is that any bank transactions
>> entered through the General Ledger - Bank account [receipt/payment] should
>> in fact have entries in gltrans table and subsequent entries in the chart
>> details. They then should appear in journal reports.
>>
>> This would be in contrast to payments/receipts made via the Payments and
>> Receipts menus for debtors and creditors.
>>
>> However, for bank fees and such which must be entered through General
>> Ledger payment (not a creditor), this poses a problem as the  amounts will
>> show in bank account transaction listings/reconcilliations - as they
>> should. Howevrer they will never show as a general journal or reports as
>> such (they are trans 12 not 0).
>>
>> Thanks in advance for any advice.
>>
>> Cheers,
>>
>>
>>
>>
>>
>>
>