Arne Hanssen | 21 Apr 12:35 2014
Picon

GL Reference Number.

I have noticed for some time that the GL Reference Number (GL 
transactions) have gaps in its counter.  I have set up that (for 2014) 
the number should start from '14-001'.  If I post some GL transactions 
one after another, it works as expected (14-002, 14-003 and so on), but 
if I do som other types of transaction (AR, AP, Cash receipt/payment) in 
between, and then return to GL transaction, the number has stepped over 
1 number.  I seems like the counter is updated twice.

Version 1.3.39.  Is this a bug or am I doing something wrong?

--

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

------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
Arne Hanssen | 21 Apr 12:15 2014
Picon

Credit Invoice / invoice.tex.

I use the xedemo/templates.  I noticed that when I create a credit 
invoice, the template 'invoice.tex' is used for this also.  But, at 
least in Norway, it is inconvenient that the printout is "labeled" 
FAKTURA (i.e. Invoice) in stead of KREDITNOTA, which would be the proper 
Norwegian term.

I have noe experience with TEX, so I don't know how to possibly edit 
'invoice.tex' to show a different heading depending on the amount being 
positive or negative.  Or would it be easier to let the Credit Note 
function use a different template than 'invoice.tex'?

--

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

------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
Benedict White | 20 Apr 12:13 2014
Picon

Debian package for 1.3.39

I thought I read somewhere that there was a package for 1.3.39...

Where could I find it?

Kind regards

Benedict White

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
jim.trainor.kanata | 19 Apr 18:43 2014
Picon

1.4 out of beta estimate?

Is there an idea when the 1.4 release will move beta to release status?

I will go through a period of experimenting and do some side-by-side 
book keeping for a few months while I test and learn ledgersmb.  Maybe 
I'm better off just going with 1.4 for this purpose?  It appears to be 
quite far along...

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
jim.trainor.kanata | 19 Apr 14:57 2014
Picon

AP_tax and AR_tax lnks

I've installed 1.3.38 and just started learning ledgersmb. Two questions 
to start:

1) Can I get a report that simply lists customers?  I don't see that 
option anywhere.

2) I setup a Canadian test business.  I don't see Canadian HST in the 
standard chart of the accounts that is created.  What are people 
typically doing?  Maybe that's an accounting question not a ledgersmb 
question.  I guess it is too variable (e.g. per-province rates) to add 
to the standard chart of accounts?

Many thanks for ledgersmb... fed up with my existing accounting 
software... hoping this will be the solution.

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Rich Shepard | 7 Apr 00:40 2014

New User Questions: Printing Reports, Templates, Selecting Cash Basis

   I copied my LaTeX templates directory for invoices, checks, etc. from the
L123 subdirectory to /opt/ledgersmb/templates/rshepard. I assume that the
'default' template for each printable document is that defined in the
subdirectory above since I entered that in System -> Defaults and saved the
information.

   However, when I want to print an income statement or balance sheet all I
see is html code on the displayed page. What have I missed here?

   For the Income Statement, there is a radio-button for accrual accounting,
but no way to unselect that and select cash accounting instead. Looking in
ledgersmb.conf I do not see where I can specify that, nor do I see that
option under System -> Defaults. Where can I select cash basis rather than
accrual basis?

Rich

------------------------------------------------------------------------------
Rich Shepard | 6 Apr 23:22 2014

New User Questions: Cash->Payment

   I'm transitioning from Ledger123/SQL-Ledger which I've used for a decade.
I see major differences between the way I used to cut checks for vendors and
what seems to be the limitations under lsmb-1.3.39.

   I just entered an invoice for a vendor, updated, saved, and posted.

   Now I want to print a check to be mailed tomorrow. Navigating to Cash ->
Payment I get a blank form rather than one showing all account payable
invoices awaiting payment. When I enter the first few letters of the
vendor's name in the payee field and press [Enter] I get a centered
radio-button list of all vendors, and strangely, the one with the pending
payment is not on the list. Going back one page I enter the vendor's name
click 'Continue' and am presented with the pending invoice. Entering the
check number in 'source', I hesitate because after updating, I don't have an
option to print the check without also posting it.

   What if there's a paper jam or a mis-feed? How can I reprint the check
before posting the transaction? Also, I don't see my printers (as defined in
CUPS), but what appears to be a generic list; "Epson," "Laser2," "Laser".
Shrugging my shoulders, I select "PDF" and "Laser2" and up pops a page for
Payment Order Number. I have absolutely no use for this ... and there's no
control buttons on the page either. I expected to print the check, not see a
page saying that zero dollars will be paid to the account.

   I'm sure there must be a way to 1) see all pending vendor invoices with
a selected check box for each one (in case I don't want to print one now);
2) print the check as a separate step from posting the transaction; and 3)
seeing my network printers so I can select the one to use. Better yet, let
me set the system defaults to a defined printer name and 'screen' for those
that I want to save to disk as a PDF file.
(Continue reading)

Arne Hanssen | 6 Apr 19:35 2014
Picon

Error creating invoice LSMB 1.3.39.

After [Post]-ing a sales invoice I can't print the invoice from the next 
screen.  When I click [Print] I get this error:

Internal Server Error
The server encountered an internal error or misconfiguration and was 
unable to complete your request.

Apache log shows:
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] DBD::Pg::st 
execute failed: ERROR:  column "remark" does not exist, referer: 
http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] LINE 8: ... 
'' AS customertaxnumber, sic_code AS sic, iban, remark,, referer: 
http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] 
                                                 ^ at LedgerSMB/IS.pm 
line 909., referer: http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] DBD::Pg::st 
execute failed: ERROR:  current transaction is aborted, commands ignored 
until end of transaction block at LedgerSMB.pm line 834., referer: 
http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] 2014/04/06 
19:14:48 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1102) -- Logging SQL 
State 25P02, error 7, string ERROR:  current transaction is aborted, 
commands ignored until end of transaction block, referer: 
http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] Can't use string 
("LedgerSMB::Setting") as a HASH ref while "strict refs" in use at 
LedgerSMB.pm line 942., referer: http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] Compilation 
(Continue reading)

Benedict White | 5 Apr 23:20 2014
Picon

Problems searching contacts in LedgerSMB 1.4.0

I've added a contact to LedgerSMB, (Me, I want to pay some expenses) and I can't search under contacts.

I went to Contacts->Search and get:
Contact Search

Entity Class Name Control Code E-mail Phone Contact Only Users Notes
(Only for Employees)
Account Number Address City State/Province Zip/Postal Code Country Active
From
Date to


When I run a search I get I get:


Error!

Unable to open script: LedgerSMB::Scripts::contact_reports : : You cannot coerce an attribute (start_from) unless its type (LedgerSMB::DBObject::Date) has a coercion at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 37
Moose::Exception::_build_trace('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)') called at reader Moose::Exception::trace (defined at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 9) line 7 Moose::Exception::trace('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)') called at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 49 Moose::Exception::BUILD('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)', 'HASH(0x6a21398)') called at /usr/lib/perl5/vendor_perl/Class/MOP/Method.pm line 128 Class::MOP::Method::execute('Moose::Meta::Method=HASH(0x6a71a20)', 'Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)', 'HASH(0x6a21398)') called at /usr/lib/perl5/vendor_perl/Moose/Object.pm line 56 Moose::Object::BUILDALL('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)', 'HASH(0x6a21398)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 282 Moose::Meta::Class::new_object('Moose::Meta::Class=HASH(0x6a22010)', 'HASH(0x6a21398)') called at /usr/lib/perl5/vendor_perl/Moose/Object.pm line 27 Moose::Object::new('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion', 'attribute_name', 'start_from', 'type_name', 'LedgerSMB::DBObject::Date', 'params', 'HASH(0x2657940)') called at /usr/lib/perl5/vendor_perl/Moose/Util.pm line 51 Moose::Util::throw_exception('CannotCoerceAttributeWhichHasNoCoercion', 'attribute_name', 'start_from', 'type_name', 'LedgerSMB::DBObject::Date', 'params', 'HASH(0x2657940)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 393 Moose::Meta::Attribute::_process_coerce_option('Moose::Meta::Attribute', 'start_from', 'HASH(0x2657940)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 262 Moose::Meta::Attribute::_process_options('Moose::Meta::Attribute', 'start_from', 'HASH(0x2657940)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 53 Moose::Meta::Attribute::new('Moose::Meta::Attribute', 'start_from', 'isa', 'LedgerSMB::DBObject::Date', 'definition_context', 'HASH(0x6a0a8a0)', 'coerce', 1, 'is', 'ro') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 101 Moose::Meta::Attribute::interpolate_class_and_new('Moose::Meta::Attribute', 'start_from', 'definition_context', 'HASH(0x6a0a8a0)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 716 Moose::Meta::Class::_process_new_attribute('Moose::Meta::Class=HASH(0x46fe5d8)', 'start_from', 'definition_context', 'HASH(0x6a0a8a0)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 709 Moose::Meta::Class::_process_attribute('Moose::Meta::Class=HASH(0x46fe5d8)', 'start_from', 'definition_context', 'HASH(0x6a0a8a0)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 573 Moose::Meta::Class::add_attribute('Moose::Meta::Class=HASH(0x46fe5d8)', 'start_from', 'definition_context', 'HASH(0x6a0a8a0)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose.pm line 77 Moose::has('Moose::Meta::Class=HASH(0x46fe5d8)', 'start_from', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Exporter.pm line 405 Moose::has('start_from', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at LedgerSMB/Report/Contact/History.pm line 275 require LedgerSMB/Report/Contact/History.pm at LedgerSMB/Scripts/contact_reports.pm line 19 LedgerSMB::Scripts::contact_reports::BEGIN at LedgerSMB/Report/Contact/History.pm line 0 eval {...} at LedgerSMB/Report/Contact/History.pm line 0 require LedgerSMB/Scripts/contact_reports.pm at (eval 453) line 1 eval 'require LedgerSMB::Scripts::contact_reports;' at lsmb-request.pl line 103 LedgerSMB::Handler::try {...} at /usr/share/perl5/vendor_perl/Try/Tiny.pm line 81 eval {...} at /usr/share/perl5/vendor_perl/Try/Tiny.pm line 72 Try::Tiny::try('CODE(0x47031b0)', 'Try::Tiny::Catch=REF(0x467a2e8)') called at lsmb-request.pl line 120 LedgerSMB::Handler::call_script('contact_reports.pl', 'LedgerSMB=HASH(0x33d7df8)') called at lsmb-request.pl line 84 require lsmb-request.pl at /opt/ledgersmb/contact_reports.pl line 8 Compilation failed in require at LedgerSMB/Scripts/contact_reports.pm line 19. BEGIN failed--compilation aborted at LedgerSMB/Scripts/contact_reports.pm line 19. Compilation failed in require at (eval 453) line 1.

dbversion: 1.4.0, company: ChilliTronix

Can anyone help?

Kind regards

Benedict White

------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Paul Bolger | 1 Apr 23:37 2014
Picon

Install in Debian Mint via aptitude

I'd like to try Ledgersmb on my local Debian machine but I'm getting an error:

Setting up ledgersmb (1.3.25-1) ...
ERROR: Module rewrite does not exist!
dpkg: error processing ledgersmb (--configure):

mod_rewrite (in apache) is definitely there and enabled, so what could
be the problem?

------------------------------------------------------------------------------
Rich Shepard | 30 Mar 19:42 2014

Accounts List in G/L

   I've just started using ledgersmb. When I make a G/L entry I do not see a
drop-down list of accounts from which to select those for each side of the
transaction. Is there a way of displaying the CoA on each page when accounts
need to be entered?

Rich

------------------------------------------------------------------------------

Gmane