Check Numbers...
|
View:
New views
3 Messages
—
Rating Filter:
Alert me
|
 |
Check Numbers...
by Stuart Sheldon
::
Rate this Message:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1 Hi everyone, Just wanted to say how much I love WebERP! This is our first month on it, and so far, so good... I do have a Question / Comment that I'd like to voice. I was wondering why the Payments aren't storing the cheque number anywhere. Being in the US, the cheque (or as we spell it check) number is kinda important to us when reconciling the account or canceling a payment with the bank. I was kind of surprised that it was not saved anywhere. Or am I missing something? I hacked up a quick fix that prepends the cheque number to the ref column in the tables I wanted to see it in, but I would think this should be it's own column somewhere... I've attached the diff if anyone has a book keeper that can't seem to get past the statement "But the program says I need to put the number on the form here". Thanks for your comments... Stu - -- For six long years I've been in trouble, no pleasure here on earth I found. For in this world I'm bound to ramble, I have no friends to help me now. ~ -- The Soggy Bottom Boys - "I am a man of constant sorrow" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkh/bcEACgkQK69Y+xPZrWawgACffqabYWDcl3K6Orwi1zYSq1iM KwQAn0Av5jNG0T8Pw8bTVRMIM8yGd4io =55r7 -----END PGP SIGNATURE----- --- webERP-3.09/Payments.php 2008-06-27 00:42:09.000000000 -0700 +++ webERP-live/Payments.php 2008-07-14 22:19:01.000000000 -0700 @@ -165,6 +165,9 @@ } +if (isset($_POST['ChequeNum']) and $_POST['ChequeNum']!=''){ + $_SESSION['PaymentDetail']->ChequeNum=$_POST['ChequeNum']; +} if (isset($_POST['Narrative']) and $_POST['Narrative']!=''){ $_SESSION['PaymentDetail']->Narrative=$_POST['Narrative']; } @@ -183,6 +186,11 @@ } } +if (isset($_SESSION['PaymentDetail']->ChequeNum)) { + $thischecknum = $_SESSION['PaymentDetail']->ChequeNum . " "; +} else { + $thischecknum = ""; +} $msg=''; @@ -390,7 +398,7 @@ '" . $_SESSION['PaymentDetail']->Paymenttype . "', " . ($_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) . ", " . (-$_SESSION['PaymentDetail']->Amount-$_SESSION['PaymentDetail']->Discount) . ", - '" . $_SESSION['PaymentDetail']->Narrative . "' + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "' )"; $ErrMsg = _('Cannot insert a payment transaction against the supplier because'); @@ -427,7 +435,7 @@ '" . FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', " . $PeriodNo . ", " . $_SESSION['CompanyRecord']['creditorsact'] . ", - '" . $_SESSION['PaymentDetail']->Narrative . "', + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "', " . $CreditorTotal . " )"; $ErrMsg = _('Cannot insert a GL transaction for the creditors account debit because'); @@ -448,7 +456,7 @@ '" . FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', " . $PeriodNo . ", " . $_SESSION['CompanyRecord']["pytdiscountact"] . ", - '" . $_SESSION['PaymentDetail']->Narrative . "', + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "', " . (-$_SESSION['PaymentDetail']->Discount/$_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) . " )"; $ErrMsg = _('Cannot insert a GL transaction for the payment discount credit because'); @@ -474,7 +482,7 @@ '" . FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', " . $PeriodNo . ", " . $_SESSION['PaymentDetail']->Account . ", - '" . $_SESSION['PaymentDetail']->Narrative . "', + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "', " . (-$_SESSION['PaymentDetail']->Amount/$_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) . " )"; @@ -486,7 +494,6 @@ } /*now enter the BankTrans entry */ - $SQL="INSERT INTO banktrans (transno, type, bankact, @@ -500,7 +507,7 @@ $SQL= $SQL . "VALUES (" . $TransNo . ", " . $Transtype . ", " . $_SESSION['PaymentDetail']->Account . ", - '" . $_SESSION['PaymentDetail']->Narrative . "', + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "', " . $_SESSION['PaymentDetail']->ExRate . " , " . $_SESSION['PaymentDetail']->FunctionalExRate . ", '" . FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ web-ERP-users mailing list web-ERP-users@... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
|
Re: Check Numbers...
by emdeex
::
Rate this Message:
Hi Stuart,
Its news to me that the cheque number is not being stored, are you sure? We used to have just a "reference" field, which stored the cheque number and any narrative text, then Tim(?) made a mod which allowed a separate field for the cheque number to allow use of pre-printed cheques. I'm surprised its not being stored. I'll hand-ball this over to Tim. Murray On Fri, Jul 18, 2008 at 2:05 AM, Stuart Sheldon <stu@...> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi everyone, > > Just wanted to say how much I love WebERP! This is our first month on > it, and so far, so good... > > I do have a Question / Comment that I'd like to voice. > > I was wondering why the Payments aren't storing the cheque number > anywhere. Being in the US, the cheque (or as we spell it check) number > is kinda important to us when reconciling the account or canceling a > payment with the bank. I was kind of surprised that it was not saved > anywhere. Or am I missing something? > > I hacked up a quick fix that prepends the cheque number to the ref > column in the tables I wanted to see it in, but I would think this > should be it's own column somewhere... > > I've attached the diff if anyone has a book keeper that can't seem to > get past the statement "But the program says I need to put the number on > the form here". > > Thanks for your comments... > > Stu > > - -- > For six long years I've been in trouble, no pleasure here on earth > I found. For in this world I'm bound to ramble, I have no friends > to help me now. > ~ -- The Soggy Bottom Boys - "I am a man of constant sorrow" > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > > iEYEARECAAYFAkh/bcEACgkQK69Y+xPZrWawgACffqabYWDcl3K6Orwi1zYSq1iM > KwQAn0Av5jNG0T8Pw8bTVRMIM8yGd4io > =55r7 > -----END PGP SIGNATURE----- > > --- webERP-3.09/Payments.php 2008-06-27 00:42:09.000000000 -0700 > +++ webERP-live/Payments.php 2008-07-14 22:19:01.000000000 -0700 > @@ -165,6 +165,9 @@ > } > > > +if (isset($_POST['ChequeNum']) and $_POST['ChequeNum']!=''){ > + $_SESSION['PaymentDetail']->ChequeNum=$_POST['ChequeNum']; > +} > if (isset($_POST['Narrative']) and $_POST['Narrative']!=''){ > $_SESSION['PaymentDetail']->Narrative=$_POST['Narrative']; > } > @@ -183,6 +186,11 @@ > } > } > > +if (isset($_SESSION['PaymentDetail']->ChequeNum)) { > + $thischecknum = $_SESSION['PaymentDetail']->ChequeNum . " "; > +} else { > + $thischecknum = ""; > +} > > $msg=''; > > @@ -390,7 +398,7 @@ > '" . > $_SESSION['PaymentDetail']->Paymenttype . "', > " . > ($_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) > . ", > " . > (-$_SESSION['PaymentDetail']->Amount-$_SESSION['PaymentDetail']->Discount) . > ", > - '" . > $_SESSION['PaymentDetail']->Narrative . "' > + '" . $thischecknum . > $_SESSION['PaymentDetail']->Narrative . "' > )"; > > $ErrMsg = _('Cannot insert a payment transaction against the > supplier because'); > @@ -427,7 +435,7 @@ > '" . > FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', > " . $PeriodNo . ", > " . > $_SESSION['CompanyRecord']['creditorsact'] . ", > - '" . > $_SESSION['PaymentDetail']->Narrative . "', > + '" . $thischecknum . > $_SESSION['PaymentDetail']->Narrative . "', > " . $CreditorTotal . " > )"; > $ErrMsg = _('Cannot insert a GL transaction for the > creditors account debit because'); > @@ -448,7 +456,7 @@ > '" . > FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', > " . $PeriodNo . ", > " . > $_SESSION['CompanyRecord']["pytdiscountact"] . ", > - '" . > $_SESSION['PaymentDetail']->Narrative . "', > + '" . $thischecknum . > $_SESSION['PaymentDetail']->Narrative . "', > " . > (-$_SESSION['PaymentDetail']->Discount/$_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) > . " > )"; > $ErrMsg = _('Cannot insert a GL transaction > for the payment discount credit because'); > @@ -474,7 +482,7 @@ > '" . > FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', > " . $PeriodNo . ", > " . > $_SESSION['PaymentDetail']->Account . ", > - '" . > $_SESSION['PaymentDetail']->Narrative . "', > + '" . $thischecknum . > $_SESSION['PaymentDetail']->Narrative . "', > " . > (-$_SESSION['PaymentDetail']->Amount/$_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) > . " > )"; > > @@ -486,7 +494,6 @@ > } > > /*now enter the BankTrans entry */ > - > $SQL="INSERT INTO banktrans (transno, > type, > bankact, > @@ -500,7 +507,7 @@ > $SQL= $SQL . "VALUES (" . $TransNo . ", > " . $Transtype . ", > " . $_SESSION['PaymentDetail']->Account . ", > - '" . $_SESSION['PaymentDetail']->Narrative . > "', > + '" . $thischecknum . > $_SESSION['PaymentDetail']->Narrative . "', > " . $_SESSION['PaymentDetail']->ExRate . " , > " . > $_SESSION['PaymentDetail']->FunctionalExRate . ", > '" . > FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > web-ERP-users mailing list > web-ERP-users@... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ web-ERP-users mailing list web-ERP-users@... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
|
Re: Check Numbers...
by Stuart Sheldon
::
Rate this Message:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1 I'll be darned if I can find it in any of the tables... It stores the Transaction number, but that's auto generated... If you find it, let me know... Stu emdeex wrote: | Hi Stuart, | | Its news to me that the cheque number is not being stored, are you sure? | | We used to have just a "reference" field, which stored the cheque | number and any narrative text, then Tim(?) made a mod which allowed a | separate field for the cheque number to allow use of pre-printed | cheques. I'm surprised its not being stored. | | I'll hand-ball this over to Tim. | | Murray | | On Fri, Jul 18, 2008 at 2:05 AM, Stuart Sheldon <stu@...> wrote: | Hi everyone, | | Just wanted to say how much I love WebERP! This is our first month on | it, and so far, so good... | | I do have a Question / Comment that I'd like to voice. | | I was wondering why the Payments aren't storing the cheque number | anywhere. Being in the US, the cheque (or as we spell it check) number | is kinda important to us when reconciling the account or canceling a | payment with the bank. I was kind of surprised that it was not saved | anywhere. Or am I missing something? | | I hacked up a quick fix that prepends the cheque number to the ref | column in the tables I wanted to see it in, but I would think this | should be it's own column somewhere... | | I've attached the diff if anyone has a book keeper that can't seem to | get past the statement "But the program says I need to put the number on | the form here". | | Thanks for your comments... | | Stu | |> - --- webERP-3.09/Payments.php 2008-06-27 00:42:09.000000000 -0700 +++ webERP-live/Payments.php 2008-07-14 22:19:01.000000000 -0700 @@ -165,6 +165,9 @@ ~ } |> |> +if (isset($_POST['ChequeNum']) and $_POST['ChequeNum']!=''){ + $_SESSION['PaymentDetail']->ChequeNum=$_POST['ChequeNum']; +} ~ if (isset($_POST['Narrative']) and $_POST['Narrative']!=''){ ~ $_SESSION['PaymentDetail']->Narrative=$_POST['Narrative']; ~ } @@ -183,6 +186,11 @@ ~ } ~ } |> +if (isset($_SESSION['PaymentDetail']->ChequeNum)) { + $thischecknum = $_SESSION['PaymentDetail']->ChequeNum . " "; +} else { + $thischecknum = ""; +} |> ~ $msg=''; |> @@ -390,7 +398,7 @@ ~ '" . $_SESSION['PaymentDetail']->Paymenttype . "', ~ " . ($_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) . ", ~ " . (-$_SESSION['PaymentDetail']->Amount-$_SESSION['PaymentDetail']->Discount) . ", - - '" . $_SESSION['PaymentDetail']->Narrative . "' + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "' ~ )"; |> ~ $ErrMsg = _('Cannot insert a payment transaction against the supplier because'); @@ -427,7 +435,7 @@ ~ '" . FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', ~ " . $PeriodNo . ", ~ " . $_SESSION['CompanyRecord']['creditorsact'] . ", - - '" . $_SESSION['PaymentDetail']->Narrative . "', + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "', ~ " . $CreditorTotal . " ~ )"; ~ $ErrMsg = _('Cannot insert a GL transaction for the creditors account debit because'); @@ -448,7 +456,7 @@ ~ '" . FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', ~ " . $PeriodNo . ", ~ " . $_SESSION['CompanyRecord']["pytdiscountact"] . ", - - '" . $_SESSION['PaymentDetail']->Narrative . "', + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "', ~ " . (-$_SESSION['PaymentDetail']->Discount/$_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) . " ~ )"; ~ $ErrMsg = _('Cannot insert a GL transaction for the payment discount credit because'); @@ -474,7 +482,7 @@ ~ '" . FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', ~ " . $PeriodNo . ", ~ " . $_SESSION['PaymentDetail']->Account . ", - - '" . $_SESSION['PaymentDetail']->Narrative . "', + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "', ~ " . (-$_SESSION['PaymentDetail']->Amount/$_SESSION['PaymentDetail']->ExRate/$_SESSION['PaymentDetail']->FunctionalExRate) . " ~ )"; |> @@ -486,7 +494,6 @@ ~ } |> ~ /*now enter the BankTrans entry */ - - ~ $SQL="INSERT INTO banktrans (transno, ~ type, ~ bankact, @@ -500,7 +507,7 @@ ~ $SQL= $SQL . "VALUES (" . $TransNo . ", ~ " . $Transtype . ", ~ " . $_SESSION['PaymentDetail']->Account . ", - - '" . $_SESSION['PaymentDetail']->Narrative . "', + '" . $thischecknum . $_SESSION['PaymentDetail']->Narrative . "', ~ " . $_SESSION['PaymentDetail']->ExRate . " , ~ " . $_SESSION['PaymentDetail']->FunctionalExRate . ", ~ '" . FormatDateForSQL($_SESSION['PaymentDetail']->DatePaid) . "', |> - ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ web-ERP-users mailing list web-ERP-users@... https://lists.sourceforge.net/lists/listinfo/web-erp-users |> |> | ------------------------------------------------------------------------- | This SF.Net email is sponsored by the Moblin Your Move Developer's challenge | Build the coolest Linux based applications with Moblin SDK & win great prizes | Grand prize is a trip for two to an Open Source event anywhere in the world | http://moblin-contest.org/redirect.php?banner_id=100&url=/ | _______________________________________________ | web-ERP-users mailing list | web-ERP-users@... | https://lists.sourceforge.net/lists/listinfo/web-erp-users - -- And all I can do is keep on telling you, I want you, I need you, But there aint no way Im ever gonna love you, Now dont be sad cause two out of three aint bad... ~ -- Meatloaf - "Two out of Three aint bad - Lyrics" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkh/+asACgkQK69Y+xPZrWbJWgCeJV2DrXP99YWdJhcFP409MzXe EPkAnjiAjduxIAAA2xETeYY4aXLhSw3j =8PxX -----END PGP SIGNATURE----- ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ web-ERP-users mailing list web-ERP-users@... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
| Free Forum Powered by Nabble | Forum Help |