fmiser | 5 Dec 23:46 2014
Picon

Stock Debian Wheezy (stable) install troubles

I'm having troubles with what I think should be a simple, stock
install on Debian Wheezy using the default Wheezy package
(1.3.18-2).

I can't seem to setup a database!

See the end of my post for installation details, etc.

I can browse to http://192.168.1.207/ledgersmb/setup.pl, enter
"ledgersmb" as the user (not "admin", which is what I expected)
and the password (wordpass) I assigned during the package
setup (that I thought belonged with the use "admin" but that
pair doesn't work) , I see this message in the browser:

###############
Database Management Console
Confirm Operation
Logged in as ledgersmb
Unknown database found.
Cancel?
 [yes]
Backup
[backup DB] [backup Roles]
###############

That doesn't look like it was successful.  But the choices
aren't helpful either.  What next?

So I try going to http://192.168.1.207/ledgersmb/admin.pl.  I
can't seem to find a correct username/password.  I tried:
(Continue reading)

Peter van Bussel | 4 Dec 09:47 2014
Picon

LSMB 1.4.8 error adding contacts

Hi Chris,

 

I upgraded to LSMB 1.4.8. When I try to add a new contact, I get this error:

 

Error!

Can't call method "list_roles" on an undefined value at LedgerSMB/Scripts/contact.pm line 317.

dbversion: 1.4.8, company: bus004

 

 

Regards,

 

Peter

 

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Peeter Pärtel | 3 Dec 17:29 2014
Picon

Support in Estonia / Estonian language?

Is there anyone in the list or do You know someone who could provide LedgerSMB support in Estonia and in Estonian language?

Background:
I have been using LedgerSMB since the beginning of it's existence and before used SQL-Ledger. I'm providing support to two accounting companies (7 users) now with over 200 databases. Some of their clients also enter data to LedgerSMB directly. This has been hobby and I have no more time for this. So I need someone to come in and replace me...

Tasks needed to get done:
- additional Report for VAT reporting to Estonian tax authority (all invoices over 1000 EUR per partner per month)
- help with creating customized invoices and other templates in tex

We still use LedgerSMB 1.2.26. So after completing urgent tasks the next task would be upgrading LedgerSMB to latest version.

If there is any advanced level users in Estonia, please let me known about Yourself!

Vastust ootama jäädes,

Peeter Pärtel

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Peter van Bussel | 3 Dec 09:53 2014
Picon

Delete / Drop From All

Hi All,

 

I am missing Delete / Drop From All in my 1.4.7 contacts list.

 

Any suggestions?

 

Regards,

 

Peter

 

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Joachim Holst | 1 Dec 20:48 2014
Picon

Printing problem.

Hi! This is my very first newbie post to the list. Guess I'll send a couple 
more coming as time goes by ;-)

I'm testing LedgerSMB 1.4.7 and when I try to print an invoice to screeen (or 
paper), I get the following error:

'latex error - pdflatex exited with errors:
! Undefined control sequence.
l.157 ...r|}{Utg\ra{}ende moms, 25\% on 500.00 }
'

I'm running the system in Swedish, but I've set the customer in question to 
US.

I'm trying to print both US English and Swedish since my initial guess was 
that it might be a template problem.

I've applied all UTF8 fixes I could find (this page: 
http://ledgersmb.org/faq/localization-internationalization/im-using-non-ascii-unicode-characters-why-cant-i-generate-pdf).

Would really appreciate some help on this.

For other interesting notes, I'm running on Ubuntu 14.04 (virtual machine).

Very best regards,
Joachim Holst

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Max van Biezen | 29 Nov 19:47 2014
Picon

1.4.8rc1: Can't locate employee.pm

Hi,

Trying to figure out my other issue of not being able to save
invoices. I noticed that the username and password field was empty in
HR/employee. However when I tried to set that I got the error below. A
find on the file name does not match. I can find
LedgerSMB/Entity/Person/Employee.pm. Is a file missing in 1.4.8rc1?

Max

Unable to open script: LedgerSMB::Scripts::employee : No such file or
directory: Can't locate LedgerSMB/Scripts/employee.pm in  <at> INC ( <at> INC
contains: /etc/perl /usr/local/lib/perl/5.14.2
/usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5
/usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at
(eval 1320) line 1.

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Max van Biezen | 29 Nov 19:14 2014
Picon

1.4.8rc1: ERROR: invalid input syntax for type boolean: ""

Hi,

I upgraded from 1.4.7 to 1.4.8rc1. When I make a sales invoice from a
quote and I want to save the invoice I get the error below and cannot
continue. Is a quick, manual, fix possible or should I downgrade for
the moment (can I)?

Max

                                          ^ at LedgerSMB/IS.pm line 1493.
2014/11/29 19:09:07 - ERROR - Form::_error LedgerSMB/Form.pm (437) -- '
                UPDATE ar set
                       invnumber = ?,
                       ordnumber = ?,
                       quonumber = ?,
                       description = ?,
                       transdate = ?,
                       entity_credit_account = ?,
                       amount = ?,
                       netamount = ?,
                       paid = ?,
                       datepaid = ?,
                       duedate = ?,
                       invoice = '1',
                       shippingpoint = ?,
                       shipvia = ?,
                       terms = ?,
                       notes = ?,
                       intnotes = ?,
                       taxincluded = ?,
                       curr = ?,
                       person_id = ?,
                       till = ?,
                       language_code = ?,
                       ponumber = ?,
                       approved = ?,
                       crdate = ?,
                       reverse = ?,
                       is_return = ?,
                       setting_sequence = ?
                 WHERE id = ?

ERROR:  invalid input syntax for type boolean: ""
LINE 28:                        reverse = '',
                                          ^ at LedgerSMB/IS.pm line 1493
'
2014/11/29 19:09:07 - ERROR - Form::_error LedgerSMB/Form.pm (438) --
dbversion: 1.4.8, company: <company>
exit at LedgerSMB.pm line 632.
Compilation failed in require at /usr/local/lsmb14/is.pl line 7.

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Gary Richardson | 21 Nov 18:20 2014
Picon

1.4.7 ap transaction sales tax

I just upgraded ledgersmb from 1.3.38 to 1.4.7 and in 
posting a ap transaction the program no longer has the 
provision for inserting the sales tax on a purchase. In 
Pennsylvania, I have found it convenient to just pay the 
sales tax on consumables rather defer paying the tax and 
filing forms with the state to pay the tax. This is also 
convenient as I only owe the tax on items the business 
personally uses rather than all purchase from a particular 
vendor.

Is it possible for me to reinstate this feature without too 
much complication?

--

-- 
Gary Richardson

gary.richardson (at) nodirtyfloors.com
Richardson Janitorial & More
Make your partner happy, make me Clean that tile

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Max van Biezen | 19 Nov 09:16 2014
Picon

permission denied for sequence invoice_id_seq

Hi,

Using 1.4.7 I have a user/sales person that I want to be able to make
quotes (add,change,remove) and to convert them to invoices and to
create invoice directly. This user when clicking save in the invoice
created from the quote gets the error as shown below.

What role to select to allow this user to save/post/send invoices? I
have currently checked:
- base user
- ar invoice create
- ar transaction list
- sales quotation create/delete/list

2014/11/19 08:37:14 - ERROR - Form::_error LedgerSMB/Form.pm (438) --
dbversion: 1.4.7, company: <company_name>
exit at LedgerSMB.pm line 631.
Compilation failed in require at /usr/local/lsmb14/is.pl line 7.
DBD::Pg::db do failed: ERROR:  permission denied for sequence
invoice_id_seq at LedgerSMB/IS.pm line 1062.
2014/11/19 08:37:40 - ERROR - Form::_error LedgerSMB/Form.pm (437) -- '
                                INSERT INTO invoice (description)
                                     VALUES ('Wed Nov 19 08:37:40 201418223')
ERROR:  permission denied for sequence invoice_id_seq at
LedgerSMB/IS.pm line 1062

Kind regards,

Max

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Max van Biezen | 19 Nov 09:02 2014
Picon

how to manually remove a user from DB?

Hi,

Referring to bug https://sourceforge.net/p/ledger-smb/bugs/1287/

I have a user that was created and exists in the DB, but I cannot log
on as that user. How to remove/change that entry from the database?

Max

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Arne Hanssen | 10 Nov 19:47 2014
Picon

Internal server error.

After upgrading to 1.3.45 (upgrading to 1.3.46 didn't help) I get this 
error when trying to post a payment of invoice from apache error.log):

[Mon Nov 10 19:38:20 2014] [error] [client 192.168.1.1] Can't use string 
("{2040}") as an ARRAY ref while "strict refs" in use at 
LedgerSMB/DBObject/Payment.pm line 800., referer: 
http://ledgersmb.kingel.net/payment.pl
[Mon Nov 10 19:38:20 2014] [error] [client 192.168.1.1] Compilation 
failed in require at /home/httpd/ledgersmb/payment.pl line 8., referer: 
http://ledgersmb.kingel.net/payment.pl
[Mon Nov 10 19:38:20 2014] [error] [client 192.168.1.1] Premature end of 
script headers: payment.pl, referer: http://ledgersmb.kingel.net/payment.pl

2040 is the amount to be paid.

I thought I read something about this in the list, but I cannot find 
anything.  How can I fix this?

--

-- 
Vennlig hilsen / Best regards      |\     ___,,--,        _
Arne Hanssen, Senja, Norway        /,`--''        \-,,__,'/
[ Linux counter #102028  <at>  ]       |,4   ) )_    ) /~-----'
[ http://linuxcounter.net ]------'---^~(_/-_)--(_/_)-------
	

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk

Gmane