From: Phil D. <ph...@lo...> - 2013-11-27 06:55:37
|
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 |