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

[Phil D. <ph...@lo...>]

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 27/11/13 14:34, iced lava 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.
>


Nope the GL integration should only be turned off when entering debtors 
or creditors opening balances by entering open invoices.
To enter the GL opening balances the GL integration with debtors needs 
to be enabled if entering a receipt (or creditors if entering a payment).
The trial balance is of course a general ledger thing and naturally you 
need to have general ledger journals created to have any balances 
created in the general ledger.


> 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 should work with debtor integration turned on?
The balances created on 30 June should flow through to July? With 
chartdetails showing the bfwd balances
The bank balance should reflect the receipt?

Any screen shots?

> 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,
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers