[WebERP-developers] Closing balances - bank accounts

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

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,