Menu
▾
▴
web-erp-developers
|
From: iced l. <ice...@gm...> - 2013-11-27 01:35:07
|
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, |
|
From: iced l. <ice...@gm...> - 2013-11-27 02:14:20
|
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, > > > > > > |
|
From: iced l. <ice...@gm...> - 2013-11-27 02:23:23
|
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, >> >> >> >> >> >> > |
|
From: Phil D. <ph...@lo...> - 2013-11-27 06:40:19
|
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 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... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
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 > > |
|
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 |
|
From: icedlava <ice...@gm...> - 2013-11-27 12:43:47
Attachments:
signature.asc
|
> 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 |
|
From: Phil D. <ph...@lo...> - 2013-11-27 06:32:39
|
Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 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... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
From: iced l. <ice...@gm...> - 2013-11-27 06:47:40
|
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...>wrote: > > Phil > > Phil Daintree > Logic Works Ltd - +64 (0)275 567890http://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 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 > > |
|
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 |
|
From: Phil D. <ph...@lo...> - 2013-11-27 06:53:57
|
Where don't they show up? Phil Phil Daintree Logic Works Ltd - +64 (0)275 567890 http://www.logicworks.co.nz On 27/11/13 19:47, iced lava wrote: > 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. |
|
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 |
|
From: icedlava <ice...@gm...> - 2013-11-28 08:42:47
Attachments:
signature.asc
|
Hi Phil, Thanks for your ideas on the GL entry creation currently in place. From first looks I believe there are bugs in some cases (depending on GL on/off for CR or DR) on creation of the bank transaction/journals. Sometimes in fact it 'works' properly as you had previously described, other cases not- and (perhaps it was too late at night for me ..) it seems it might be dependent on type of account used in e.g. the receipting. In any case I will go through code rigourously for all the points you mention before I touch any code there. I will still have concern for any dependencies on the sys type apart from the obvious in General Ledger and the Receipts/Payments menus. Others might now of cases. Many thanks to all for the feedback! On 28 Nov 2013, at 18:49, Phil Daintree wrote: > 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 > > ------------------------------------------------------------------------------ > 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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X