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

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

It is not necessary to modify the transaction type in the gltrans table.
Can you point me to where the manual said the integration should be off 
when taking on GL balances? I can see where it says this in relation to 
setting up debtors and creditors balances i.e the open items in the 
sub-ledgers.
Which listings are you not able to see the balances ... script names 
ideally please. Maybe this is where the problem lies - assuming the 
trial balance shows the balances correctly!

Phil

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

On 27/11/13 15:23, iced lava wrote:
> 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... 
> <mailto: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...
>     <mailto: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,
>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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