Menu
▾
▴
Re: [WebERP-developers] Closing balances - bank accounts
|
From: iced l. <ice...@gm...> - 2013-11-27 06:47:40
|
Hi Phil, Thanks for the reply, you confirmed what i thought and what I did when I've had to enter bank balances at 30 June. The GL is off for all other 30 June balance entries which seems perhaps inconsistent and confusing to the customer. However - given that - there is a problem I think. With the GL off, you can go into the General Ledger menu and make GL journal entries. When adding the bank balance entries - the GL must be on for this even though you still go through the General Ledger menu which implies you are doing general journals (rather than through Payments or Receipts) The problem is the bank balances are created with Type 12 bank transaction type - not type 0 for general journal. This means that any General Ledger receipt or payments never show up in the journal enquiries which is confusing customers and they cannot get a full idea of for example, what may have gone into a clearing account at June 30 if bank accounts are involved - they don't display. It seems that if the bank transaction is entered through the General Ledger option then it should show up in the general ledger journal listings - but won't. If I change the GL type to 0 for the bank transactions in the gltrans table, as per my example, and leave the bank transactions as they are in the banktrans table, then everything works as expected. Except of course the bank transactions do not show up in the reconcilliation functions. Everything else is good - correct reports, trial balances etc. My question is: 1. Can we change the code for bank transactions made through the General Ledger option as a journal - to post into the gltrans table as a journal (type 0) to get correct reporting? 2. Can we then change the bank reconciliation functions to display journal bank transactions (like bank fees) that will not display if type 0? Is it safe to change the code to post bank transactions into the gltrans table as type 0? and what fix then do we need for reconciliation functions? Or - is there another way? Thanks in advance. On Wed, Nov 27, 2013 at 5:02 PM, Phil Daintree <ph...@lo...>wrote: > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890http://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 lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > > > > ------------------------------------------------------------------------------ > 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 > > |
