Menu
▾
▴
Re: [WebERP-developers] Closing balances - bank accounts
|
From: Phil D. <ph...@lo...> - 2013-11-27 06:53:23
|
Well I thought no journals are created in the GL if the debtors GL integration is off when entering receipts and no GL journals created when entering payments if the GL integration with creditors is turned off. Type 0 is for GL journals type 1 is for GL payments type 2 is for GL receipts type 12 is for customer receipts type 22 for creditior/vendor payments Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 27/11/13 19:47, iced lava wrote: > 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... > <mailto:ph...@lo...>> wrote: > > > Phil > > Phil Daintree > Logic Works Ltd -+64 (0)275 567890 <tel:%2B64%20%280%29275%20567890> > 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... <mailto:Web...@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... > <mailto:Web...@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 |
