Menu
▾
▴
Re: [WebERP-developers] Closing balances - bank accounts
|
From: iced l. <ice...@gm...> - 2013-11-27 06:52:13
|
> It is not necessary to modify the transaction type in the gltrans table. To see the bank transactions in the general journal enquiries we do. >Can you point me to where the manual said the integration should be off when taking on GL balances? I will take another look and let you know - i know i found it confusing when i first used webERP and went on a google hunt. It's been some time since i looked at that part of the manual and i've always turned on GL for bank transactions and off for everything else added through the General Ledger menu. > Which listings are you not able to see the balances ... script names ideally please GLJournalInquiry.php - will not display bank transaction journals. And yes, trial balance shows balances correctly :) Thanks for taking a look. On Wed, Nov 27, 2013 at 5:09 PM, Phil Daintree <ph...@lo...>wrote: > 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 567890http://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...> 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...> 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 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 > > |
