Menu
▾
▴
Re: [WebERP-developers] Closing balances - bank accounts
|
From: icedlava <ice...@gm...> - 2013-11-27 12:43:47
|
> I think the fix needs to be in the GLJournalInquiry.php so it shows the journals created correctly. OK i'll look. But why is it we need GL on to make a GL transaction for bank accounts through General Ledger - bank receipt/payment, but do not need GL on to make a GL transaction in the journal area? If we go through the General Ledger menu then for consistency should not a transaction result in a GL entry in gltrans with or without GL switch on - this would be consistent instead of one doing so and one not doing so? Then, I could also fix the GLJournalInquiry if we can as you pointed out discriminate between GL payments and receipts and other bank transactions it should not be too difficult (i.e. 1 for GL payments, 2 for GL receipts). Thanks for your help! On 27 Nov 2013, at 17:25, Phil Daintree wrote: > I think the fix needs to be in the GLJournalInquiry.php so it shows the journals created correctly. > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890 > http://www.logicworks.co.nz > > On 27/11/13 19:52, iced lava wrote: >> > 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... <mailto: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 567890 <tel:%2B64%20%280%29275%20567890> >> 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... <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 > > ------------------------------------------------------------------------------ > 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 |
