Thread: [webERP-users] Cheque Number not being stored in GLTRANS table

Accounting & Best Practice Business Administration System

Brought to you by: daintree, exsonqu, rchacon, tim_schofield, turbopt

web-erp-users

[webERP-users] Cheque Number not being stored in GLTRANS table

From: R2-G <r2g...@gm...> - 2016-03-10 17:01:04

Hi,

Am using webERP 4.12.3 on a system that has been live and working well since
December 2013 
I have just discovered that the system has all along not been storing cheque
numbers in the *gltrans*
table *chequeno* field. Upon looking at the *gltrans* table via phpmyadmin,
the chequeno field is 0 for
all transactions even though the user has always entered cheque numbers for
all payments made 
via  *Bank Account Payments Entry* and *Enter a Payment to, or Receipt from
the Supplier*.

I searched this list and the forum and found other post regarding this same
issue but no solutions to the problem

Any ideas on how to solve this will be greatly appreciated 

Thanks in advance


R2-G

   



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Cheque-Number-not-being-stored-in-GLTRANS-table-tp4658551.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Cheque Number not being stored in GLTRANS table

From: gilberto d. s. a. <gs...@gm...> - 2016-03-11 06:38:57

please look at [1] and you could see that form var cheque and chequenum.

see line  358 that is used cheque not chequenum

follow updates on this source and compare with yours.

[1] https://sourceforge.net/p/web-erp/code/HEAD/tree/trunk/Payments.php

2016-03-10 13:32 GMT-03:00 R2-G <r2g...@gm...>:

> Hi,
>
> Am using webERP 4.12.3 on a system that has been live and working well
> since
> December 2013
> I have just discovered that the system has all along not been storing
> cheque
> numbers in the *gltrans*
> table *chequeno* field. Upon looking at the *gltrans* table via phpmyadmin,
> the chequeno field is 0 for
> all transactions even though the user has always entered cheque numbers for
> all payments made
> via  *Bank Account Payments Entry* and *Enter a Payment to, or Receipt from
> the Supplier*.
>
> I searched this list and the forum and found other post regarding this same
> issue but no solutions to the problem
>
> Any ideas on how to solve this will be greatly appreciated
>
> Thanks in advance
>
>
> R2-G
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Cheque-Number-not-being-stored-in-GLTRANS-table-tp4658551.html
> Sent from the web-ERP-users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

Re: [webERP-users] Cheque Number not being stored in GLTRANS table

From: R2-G <r2g...@gm...> - 2016-03-14 10:38:15

Hi gsavix

The cheque no is still not getting stored in gltrans table 
even after modifying line 358 from chequeno to chequenum

any other ideas anybody ?

Thanks in advance


R2-g
 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Cheque-Number-not-being-stored-in-GLTRANS-table-tp4658551p4658561.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Cheque Number not being stored in GLTRANS table

From: gilberto d. s. a. <gs...@gm...> - 2016-03-14 14:58:18

hi. i will run tests on weberp.org environment to better understand what is
going on.

2016-03-14 7:09 GMT-03:00 R2-G <r2g...@gm...>:

> Hi gsavix
>
> The cheque no is still not getting stored in gltrans table
> even after modifying line 358 from chequeno to chequenum
>
> any other ideas anybody ?
>
> Thanks in advance
>
>
> R2-g
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Cheque-Number-not-being-stored-in-GLTRANS-table-tp4658551p4658561.html
> Sent from the web-ERP-users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

Re: [webERP-users] Cheque Number not being stored in GLTRANS table

From: R2-G <r2g...@gm...> - 2016-03-15 11:33:34

Hi gsavix,

I have tried entering payments with cheque numbers in the weberp.org demo
system
and created a report (gltrans-listing) to view the content of gltrans table.
The payment transactions I entered appear in the report but the cheque
number is still
NOT stored in gltrans table.



R2-g


 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Cheque-Number-not-being-stored-in-GLTRANS-table-tp4658551p4658564.html
Sent from the web-ERP-users mailing list archive at Nabble.com.

Re: [webERP-users] Cheque Number not being stored in GLTRANS table

From: gilberto d. s. a. <gs...@gm...> - 2016-03-15 15:30:45

yes. this will enhance debug. i create more detailed test on my test
environment. but on my productions environments we stell 4.11.3 modified
version.

2016-03-15 8:04 GMT-03:00 R2-G <r2g...@gm...>:

>
> Hi gsavix,
>
> I have tried entering payments with cheque numbers in the weberp.org demo
> system
> and created a report (gltrans-listing) to view the content of gltrans
> table.
> The payment transactions I entered appear in the report but the cheque
> number is still
> NOT stored in gltrans table.
>
>
>
> R2-g
>
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Cheque-Number-not-being-stored-in-GLTRANS-table-tp4658551p4658564.html
> Sent from the web-ERP-users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
> _______________________________________________
> web-ERP-users mailing list
> web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil