Michael Richardson | 1 Jan 2011 19:26
Picon
Gravatar

setup for external line of credit


Previous to this past November my company had a line of credit account
at the same bank as it's bank account.  The LOC was a seperate account
that was part of my personal line of credit, and it moved to a new bank
when my mortgage moved.

Previously, it was a transfer between accounts, and I just invoked it
online, and was done.  Now, I need to write a checque. (North American
banking sucks...) 

Since I like to have my checques printed nicely, I'm wondering what the
best way to set this up.  Using the "Transfer" function under cash does
not give me a chance to print a checque.

I can not set Expense/Asset option as well as Payment for my LOC asset
account, so it won't fit into the Add Transaction.  What else can I do?

(The interest charges are easy: set up the bank as a payable against an
expense account for the interest)

--

-- 
]       He who is tired of Weird Al is tired of life!           |  firewalls  [
]   Michael Richardson, Sandelman Software Works, Ottawa, ON    |net architect[
] mcr@... http://www.sandelman.ottawa.on.ca/
|device driver[
   Kyoto Plus: watch the video <http://www.youtube.com/watch?v=kzx1ycLXQSE>
	               then sign the petition. 

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
(Continue reading)

frank | 1 Jan 2011 19:51
Favicon

Unable to change tax rate

Hi,

The VAT rate changes in the United Kingdom on 4th January 2011.  I've
hit an issues when attempting to change the rate in both versions
1.2.20 and 1.2.21.

  1. Select System->Taxes from menu

  2. Close off a tax rate by entering a 'Valid To' date

  3. Click 'Update' - an extra line is inserted

  4. Enter a new percentage rate in the new line and click save -
     error message is displayed:

  DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
"" at LedgerSMB/AM.pm line 1607. Error!

  INSERT INTO tax (chart_id, rate, taxnumber, validto,
  pass, taxmodule_id)
  VALUES (?, ?, ?, ?, ?, ?)
  ERROR: invalid input syntax for integer: ""

Although the error occurs in save_taxes in LedgerSMB/AM.pm, the cause
is the 'pass' form parameter not being set when the 'Update' button is
clicked.  The attached patch for both versions 1.2.20 and 1.2.21
fixes this.

Cheers,

(Continue reading)

Phil | 2 Jan 2011 21:31
Picon

Re: Unable to change tax rate

Hi Frank

This worked a treat, thank you!

Regards
Phil

On Sat, Jan 1, 2011 at 6:51 PM,  <frank-lists@...> wrote:
> Hi,
>
> The VAT rate changes in the United Kingdom on 4th January 2011.  I've
> hit an issues when attempting to change the rate in both versions
> 1.2.20 and 1.2.21.
>
>  1. Select System->Taxes from menu
>
>  2. Close off a tax rate by entering a 'Valid To' date
>
>  3. Click 'Update' - an extra line is inserted
>
>  4. Enter a new percentage rate in the new line and click save -
>     error message is displayed:
>
>  DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
> "" at LedgerSMB/AM.pm line 1607. Error!
>
>
>  INSERT INTO tax (chart_id, rate, taxnumber, validto,
>  pass, taxmodule_id)
>  VALUES (?, ?, ?, ?, ?, ?)
(Continue reading)

Pongrácz István | 3 Jan 2011 10:26
Picon

Lsmb 1.2.21 + debian + lighttpd + perl 5.10

Dear All,

First of all, Happy New Year to You :)

I planned to make an openvz virtual machine with ledgersmb (sql-ledger etc.)

The system background is:

  • perl 5.10
  • Postgresql 8.3
  • lsmb 1.2.21
  • lighttpd (cgi)

I successfully installed a fork of SQL-Ledger (to be conform to Hungarian rules), it is working perfectly.

I installed Lsmb 1.2.21, following the INSTALL and relevant documents, all dependencies installed via apt-get and cpan.

I am facing with some problems with this configuration:

When I want to add a new dataset (select the chart, press Continue) and I got the following error message in the browser:

Error!

No such file or directory

I got the given database, but it did not create any tables, just an empty dataset.

In the error log I only got these messages:

Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
Math::BigInt: couldn't load specified math lib(s), fallback to Math::BigInt::FastCalc at LedgerSMB/Form.pm line 36
Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
Math::BigInt: couldn't load specified math lib(s), fallback to Math::BigInt::FastCalc at LedgerSMB/Form.pm line 36
Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
Math::BigInt: couldn't load specified math lib(s), fallback to Math::BigInt::FastCalc at LedgerSMB/Form.pm line 36
Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
Math::BigInt: couldn't load specified math lib(s), fallback to Math::BigInt::FastCalc at LedgerSMB/Form.pm line 36
Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
DBD::Pg::db do failed: ERROR:  language "plpgsql" already exists at LedgerSMB/User.pm line 418.

 

Does anybody has similar experience? I did not solve this issue yet, I need some hints.

Thank you very much!

 

Üdvözlettel / Kind regards

Pongrácz István
ügyvezető / CEO

StartIT Kft.
+36 20 4489 581

StartIT Kft.  |  Fit-PC2 oldal  |  Mini PC oldal  |  Csoportmunka  |  Webáruház  |  Javasolt Google motoros kereső  |  Keress a Facebook-on

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Stroller | 3 Jan 2011 15:56
Picon

Re: Lsmb 1.2.21 + debian + lighttpd + perl 5.10


On 3/1/2011, at 9:26am, Pongrácz István wrote:
> ...
> Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at
> /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
> Math::BigInt: couldn't load specified math lib(s), fallback to
> Math::BigInt::FastCalc at LedgerSMB/Form.pm line 36
> Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at
> /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
> Math::BigInt: couldn't load specified math lib(s), fallback to
> Math::BigInt::FastCalc at LedgerSMB/Form.pm line 36
> Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at
> /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
> Math::BigInt: couldn't load specified math lib(s), fallback to
> Math::BigInt::FastCalc at LedgerSMB/Form.pm line 36
> Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at
> /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
> Math::BigInt: couldn't load specified math lib(s), fallback to
> Math::BigInt::FastCalc at LedgerSMB/Form.pm line 36
> Name "Config::Std::Hash::DEMOLISH" used only once: possible typo at
> /usr/local/share/perl/5.10.0/Class/Std.pm line 522.
> DBD::Pg::db do failed: ERROR: language "plpgsql" already exists at
> LedgerSMB/User.pm line 418.

These are all Perl modules. 

/usr/local/ledgersmb/doc/release_notes lists a number of required "CPAN" modules - CPAN is the Perl
module library. See also /usr/local/ledgersmb/_build/prereqs 

/usr/local/ledgersmb/README.debian says:

   In the dists/deb directory, there files which provide
   information on which prerequisites can be installed via
   apt-get and which ones need to be installed via CPAN.

HTH,

Stroller.

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
Pongrácz István | 3 Jan 2011 21:10
Picon

Re: Lsmb 1.2.21 + debian + lighttpd + perl 5.10

----------------eredeti üzenet----------------- Feladó: "Stroller" stroller-J8c/PZ/aHpCP1P/rox5WkSp2UmYkHbXO@public.gmane.org Címzett: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org Dátum: Mon, 3 Jan 2011 14:56:35 +0000 ------------------------------------------------- > > These are all Perl modules. > > /usr/local/ledgersmb/doc/release_notes lists a number of required "CPAN" > modules - CPAN is the Perl module library. See also > /usr/local/ledgersmb/_build/prereqs > > /usr/local/ledgersmb/README.debian says: > > In the dists/deb directory, there files which provide > information on which prerequisites can be installed via > apt-get and which ones need to be installed via CPAN. > > HTH, > > Stroller. Hi Stroller, Nice to see you :) Thank you very much for your feedback. I started with install these requirements from these files (deb & cpan modules). I also installed other modules, which are only recommended if somebody would like to use POS terminals, too (or whatever). I installed apache2 and it seems, with apache2 it is working well. I think, the problem comes from unknown PATH. So, this problem definetely related to lighttpd and wrong/unknown PATH. Now I try to find a solution :) Cheers, István
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Pongrácz István | 4 Jan 2011 09:51
Picon

SOLVED: Lsmb 1.2.21 + debian + lighttpd + perl 5.10

Hi,

The solution was so easy.

Just edit ledgersmb.conf at the PATH lines.

It is necessary to add /bin and /usr/bin to the PATH and now everything is working well.

-------------------- >8 --------------------------

[environment]
# If the server can't find applications, append to the path
PATH: /bin:/usr/bin:/usr/local/pgsql/bin
PATH: /bin:/usr/bin:/usr/local/bin

-------------------- >8 --------------------------

The reason, it seems using lighttpd perl use 'sh' instead of bash and environment variables wll be not passed. (Maybe this is not the exact reason, you should correct me, but adding these paths fixes these problems.)

Ciao.

Üdvözlettel / Kind regards

Pongrácz István
ügyvezető / CEO

StartIT Kft.
+36 20 4489 581

StartIT Kft.  |  Fit-PC2 oldal  |  Mini PC oldal  |  Csoportmunka  |  Webáruház  |  Javasolt Google motoros kereső  |  Keress a Facebook-on


 

----------------eredeti üzenet-----------------
Feladó: "Pongrácz István" <pongracz.istvan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Címzett: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org, "Stroller" <stroller-J8c/PZ/aHpCP1P/rox5WkSp2UmYkHbXO@public.gmane.org>
Dátum: Mon, 3 Jan 2011 21:10:12 +0100
----------------------------------------------------------


----------------eredeti üzenet----------------- Feladó: "Stroller" stroller-J8c/PZ/aHpCP1P/rox5WkSp2UmYkHbXO@public.gmane.org Címzett: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org Dátum: Mon, 3 Jan 2011 14:56:35 +0000 ------------------------------------------------- > > These are all Perl modules. > > /usr/local/ledgersmb/doc/release_notes lists a number of required "CPAN" > modules - CPAN is the Perl module library. See also > /usr/local/ledgersmb/_build/prereqs > > /usr/local/ledgersmb/README.debian says: > > In the dists/deb directory, there files which provide > information on which prerequisites can be installed via > apt-get and which ones need to be installed via CPAN. > > HTH, > > Stroller. Hi Stroller, Nice to see you :) Thank you very much for your feedback. I started with install these requirements from these files (deb & cpan modules). I also installed other modules, which are only recommended if somebody would like to use POS terminals, too (or whatever). I installed apache2 and it seems, with apache2 it is working well. I think, the problem comes from unknown PATH. So, this problem definetely related to lighttpd and wrong/unknown PATH. Now I try to find a solution :) Cheers, István
------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________ Ledger-smb-users mailing list Ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

 

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Jigme Datse Rasku | 4 Jan 2011 18:33
Gravatar

warnings regarding depricated features used?

I don't know if this is something that should go here, or to the devel
list.  I am getting warnings as soon as I log in on the top of the
screen.  I will have to setup email on the box that it runs on, so I
can give a further explanation.  My question right now is if I should
do something about my install, or if these warnings are something that
can safely be ignored.

Jigme Datse Rasku

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
Stroller | 5 Jan 2011 01:41
Picon

Re: warnings regarding depricated features used?


On 4/1/2011, at 5:33pm, Jigme Datse Rasku wrote:

> I don't know if this is something that should go here, or to the devel
> list.  I am getting warnings as soon as I log in on the top of the
> screen.  I will have to setup email on the box that it runs on, so I
> can give a further explanation.  My question right now is if I should
> do something about my install, or if these warnings are something that
> can safely be ignored.

They're probably related to the version of Perl you have installed.

Depreciated features should be fixed quite quickly in new releases of LedgerSMB.

What version are you running?

Stroller.

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
david | 5 Jan 2011 03:55
Picon

upgrade issue - can't log in

I'm upgrading from Ubuntu 8.04 LTS to 10.04 LTS.

First I cloned the old server using mondo to a virtualbox server, then 
did <apt-get dist-upgrade>. All services are working (with some 
tweaking), but I can't log into LSMB.

I'm suspecting a PERL problem, but would appreciate any pointers.

Postgresql is running.

Firefox gives me:

  Error message:
  Premature end of script headers: login.pl

Apache log:

[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] Math::BigInt: 
couldn't load specified math lib(s), fallback to Math::BigInt::FastCalc 
at LedgerSMB/Form.pm line 36, referer: http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] Can't locate 
MIME/Lite.pm in  <at> INC ( <at> INC contains: /etc/perl 
/usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 
/usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 
/usr/local/lib/site_perl .) at LedgerSMB/Mailer.pm line 39., referer: 
http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] BEGIN 
failed--compilation aborted at LedgerSMB/Mailer.pm line 39., referer: 
http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] Compilation 
failed in require at LedgerSMB/Form.pm line 39., referer: 
http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] BEGIN 
failed--compilation aborted at LedgerSMB/Form.pm line 39., referer: 
http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] Compilation 
failed in require at LedgerSMB/Sysconfig.pm line 7., referer: 
http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] BEGIN 
failed--compilation aborted at LedgerSMB/Sysconfig.pm line 7., referer: 
http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] Compilation 
failed in require at /usr/local/ledgersmb/login.pl line 52., referer: 
http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] BEGIN 
failed--compilation aborted at /usr/local/ledgersmb/login.pl line 52., 
referer: http://xxx.com.au/ledgersmb/
[Wed Jan 05 12:59:49 2011] [error] [client xx.xx.xx.xx] Premature end of 
script headers: login.pl, referer: http://xxx.com.au/ledgersmb/

thanks...

David.

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl

Gmane