Menu
▾
▴
Re: [WebERP-developers] Closing balances - bank accounts
|
From: Phil D. <ph...@lo...> - 2013-11-28 08:19:50
|
You are right - there is no need to make the GL entries creation contingent on the integration with debtors or creditors flags being enabled. Perhaps we could just remove those. However, some may just not want any GL and want to use the bank functionality without the GL. I assumed that if the creditors integration was off then no bank payments should create GL journals and likewise for debtors and bank receipts. This assumption may not be valid - happy if you think it is better to take this check out. It could be that transfers are created with a systype=12 rather than 2 and that could be causing the trouble as there is some interesting code to bring up the customer's name when the receipt is a customer receipt - and equivalent code to bring up the supplier when it is an AP payment. I am sure this will just be a display issue with that script. Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 28/11/13 01:43, icedlava wrote: >> 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 >> >> >> ------------------------------------------------------------------------------ >> 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 |
