Michael Richardson | 30 Jun 05:18 2015
X-Face
Picon

balance sheet csv missing description


On the PDF and the HTML output, the account description comes out fine.
On the CSV output, that column is blank.
(I have to use the CSV so that I can then sort by GIFI and generate my T2SCH100)

This is 1.4.12.

------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Michael Richardson | 29 Jun 16:45 2015
X-Face
Picon

GIFI reports


With 1.4.12, how do I get incoming and balance sheets rolled up
by GIFI account rather than chart of accounts?

------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
Michael Richardson | 28 Jun 18:53 2015
X-Face
Picon

payments in the future


I was entering a bill (Vendor Invoice) that will get invoiced to a CC next
week.  With 1.4.11ish (I'll upgraded to 1.4.12 this afternoon), when I
entered a day that was in the future in the payment part, something seemed to
think it was blank, and complained at me.

Finally, I entered nothing, and used the Cash/Payment to mark it as paid,
and that worked fine.  I think I've done this in the past with other
versions.

Feature or bug?

--
]               Never tell me the odds!                 | ipv6 mesh networks [
]   Michael Richardson, Sandelman Software Works        | network architect  [
]     mcr@...  http://www.sandelman.ca/        |   ruby on rails    [

------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
Bob Crandell | 26 Jun 02:05 2015

Printing 2

Hi Guys,

openSUSE 13.2
LedgerSMB 1.4.12

I am getting SO close.

I am following:
http://ledgersmb.org/topic/installing-ledgersmb-14101-debian-wheezy-7x
Including:
http://sourceforge.net/p/ledger-smb/code/HEAD/tree/branches/1.4/INSTALL

Printing a Sales Order:
Error!

'Attempt to reload LedgerSMB/Template/LaTeX.pm aborted.
Compilation failed in require at (eval 483) line 2.
'

dbversion: 1.4.12, company: Demo Company

/var/log/apache2/error_log:
[Thu Jun 25 16:05:50.287666 2015] [cgi:error] [pid 2135] [client ::1:37716] AH01215: 2015/06/25
16:05:50 - ERROR - Form::_error 
LedgerSMB/Form.pm (437) -- 'Attempt to reload LedgerSMB/Template/LaTeX.pm aborted., referer: 
http://localhost/ledgersmb/oe.pl?action=edit&id=1 
[Thu Jun 25 16:05:50.287725 2015] [cgi:error] [pid 2135] [client ::1:37716] AH01215: Compilation
failed in require at (eval 483) line 
2., referer: http://localhost/ledgersmb/oe.pl?action=edit&id=1 
[Thu Jun 25 16:05:50.287730 2015] [cgi:error] [pid 2135] [client ::1:37716] AH01215: ', referer: 
(Continue reading)

Bob Crandell | 22 Jun 22:24 2015

Printing Error

Hi Guys,

LedgerSMB 1.4.11
openSUSE 13.2
 
When printing a Sales Order I get:
Server error!

The server encountered an internal error and was unable to complete your request.

Error message:
malformed header from script 'oe.pl': Bad header: This is XeTeX, Version 3.14159

If you think this is a server error, please contact the webmaster.
Error 500

The Apache Logs:
tail -30 /var/log/apache2/error_log
[Mon Jun 22 11:17:46.988088 2015] [cgi:error] [pid 6586] [client ::1:33276] AH01215: 2015/06/22 11:17:46 - ERROR - Form::_error
LedgerSMB/Form.pm (438) -- dbversion: 1.4.11, company: testgen, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:17:46.988097 2015] [cgi:error] [pid 6586] [client ::1:33276] AH01215: exit at LedgerSMB.pm line 632, <FILE> line 93., referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:17:46.988111 2015] [cgi:error] [pid 6586] [client ::1:33276] AH01215: Compilation failed in require at
/srv/www/htdocs/ledgersmb/oe.pl line 7, <FILE> line 93., referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
<Snip>
[Mon Jun 22 11:32:20.508562 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: , 'fileid', 061915, 'login', '', 'bin_2', '', 'stylesheet',
'ledgersmb.css', 'orderitems_id_1', 2) called at LedgerSMB/OE.pm line 61, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508580 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \tOE::get_files('OE', 'Form=HASH(0x60a8920)',
'LedgerSMB::Locale::en=HASH(0x3d3d570)') called at bin/oe.pl line 955, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508589 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \tlsmb_legacy::form_footer at bin/io.pl line 963, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508599 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \tlsmb_legacy::display_form at bin/oe.pl line 111, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508607 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \tlsmb_legacy::edit at bin/io.pl line 2035, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508620 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \tlsmb_legacy::print_form('Form=HASH(0x6b0f2a0)') called at
bin/io.pl line 1574, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508628 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \tlsmb_legacy::print at old-handler.pl line 206, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508642 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \tlsmb_legacy::try {...}  at
/usr/lib/perl5/vendor_perl/5.20.1/Try/Tiny.pm line 81, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508654 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \teval {...} at
/usr/lib/perl5/vendor_perl/5.20.1/Try/Tiny.pm line 72, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508670 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \tTry::Tiny::try('CODE(0x607d9c0)',
'Try::Tiny::Catch=REF(0x62f99e0)') called at old-handler.pl line 225, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508681 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: \trequire old-handler.pl at /srv/www/htdocs/ledgersmb/oe.pl
line 7, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508688 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: ', referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508705 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: 2015/06/22 11:32:20 - ERROR - Form::_error
LedgerSMB/Form.pm (438) -- dbversion: 1.4.11, company: testgen, referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508714 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: exit at LedgerSMB.pm line 632, <FILE> line 95., referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1
[Mon Jun 22 11:32:20.508728 2015] [cgi:error] [pid 6589] [client ::1:33293] AH01215: Compilation failed in require at
/srv/www/htdocs/ledgersmb/oe.pl line 7, <FILE> line 95., referer:
http://localhost/ledgersmb/oe.pl?action=edit&id=1

I'm guessing this has more to do with the installation than a bug somewhere.  If this is so, then what part of the install affects printing?
 
Thanks for all your hard work
Bob
 
------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Bob Crandell | 22 Jun 18:09 2015

First Use Questions

Hi guys,

We are testing LedgerSMB 1.4.11 mostly for the POS to replace Microsoft's RMS.  I'm using openSUSE 13.2.

I added an employee - which worked, then went back to adjust the employee's permissions and got this:

Unable to open script: LedgerSMB::Scripts::employee : No such file or directory: Can't locate LedgerSMB/Scripts/employee.pm in <at> INC (you may need to install the LedgerSMB::Scripts::employee module) ( <at> INC contains: /usr/lib/perl5/site_perl/5.20.1/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.20.1 /usr/lib/perl5/vendor_perl/5.20.1/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.20.1 /usr/lib/perl5/5.20.1/x86_64-linux-thread-multi /usr/lib/perl5/5.20.1 /usr/lib/perl5/site_perl .) at (eval 419) line 1.

I looked for employee.pm and it really isn't there.  There is an employee.pl.  Nick said it works for him.  It doesn't work for Max or me.  I checked a few versions and that file seems to come and go.  I'm guessing, for now, install 1.4.7 then install 1.4.11 to get the employee.pm in LedgerSMB/Scripts.

Thanks
Bob
------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Michael Richardson | 16 Jun 02:45 2015
X-Face
Picon

how to change payment with 1.4.11(ish)


I have entered an invoice with a payment.  I have posted it.
See:
      http://www.sandelman.ca/tmp/mcrcapture/8506.2015-06-15/capture1.png

I've entered the wrong payment account. It should be paid by a CC.
(I've just done ten of these two the wrong payment account... thanks to
copy--to-new not copying the payment, and I have enter it again)

Now what can I do with this?  can I Void it? No.
Can I delete it? No.

I will enter a general journal entry from one payment account to the
other, but given that I haven't reconciled this payment, I don't
see why it should be locked like this at this time.
In fact, given that it's locked, why can I even edit the things
in the boxes?  And what things can "Save Info" actually save?

--
]               Never tell me the odds!                 | ipv6 mesh networks [
]   Michael Richardson, Sandelman Software Works        | network architect  [
]     mcr@...  http://www.sandelman.ca/        |   ruby on rails    [

------------------------------------------------------------------------------
Chris Travers | 15 Jun 20:43 2015
Picon

Significant issue found, fix in 1.4.12, workaround included

Hi all;

We have found a problem with LedgerSMB 1.4 which can cause brief service unavailability.  In theory it could be used to deny service to the application if abused by otherwise trusted users, but this is somewhat unlikely.  More likely is accidental misconfiguration.

LedgerSMB 1.4 allows account headings to be arranged in a tree.  If a header is its own parent, grandparent, etc, this can cause some reports to infinitely run until resources are exhausted in which the system recovers (usually after disk space is exhausted and then restored).  Known impacted reports include the PNL and Balance Sheet.

If you run into this problem it is simple to fix simply by resetting the heading parents.  If you have difficulty with this, please feel free to enquire on the -devel list or seek professional assistance (but the problem does not take significant time to resolve).

The problem cannot happen on 1.4.12 (currently in release candidate version) and later.

--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Andrew Dent | 6 Jun 08:22 2015
Picon

public.person__list_salutations

Hi 

I'm trying to get started with LedgerSMB. 
This morning in HyperV, I've created a VM running Ubuntu Server 14.04 (latest ISO from Ubuntu website), selected only openssh server in the task list, and applied all available updates. 

Then I installed LedgerSMB using 
apt-get install ledgersmb (which seems to have installed version 1.3.25 of ledgersmb)

The install succeeded but I had some problems getting the ledgersmb/setup.pl to run in the browser. 
* cgi needed to be enabled in Apache. 
* the ledgersmb-httpd.conf needed modifying to allow access to /ledgersmb and to ledgersmb/css
* ledgersmb PostgreSQL user did not have createdb permission
* the contrib_dir value in /usr/share/ledgersmb/ledgersmb.conf was set for PostGreSQL 9.1 instead of 9.3 (which is the PostGreSQL version that "apt-get install ledgersmb" installed.

I have overcome the above, but I cannot figure out how to get past the following error in the apache logs


>DBD::Pg::st execute failed: ERROR:  function public.person__list_salutations() does not exist
>LINE 1: SELECT * FROM "public"."person__list_salutations"()
>                      ^
>HINT:  No function matches the given name and argument types. You might need to add explicit type >casts. at LedgerSMB.pm line 834.


This occurs during the setup process immediately after General.sql has been selected. 

Via Google, I've found others as well having this problem over the years, but I cannot see the solution. 

Please help. 

Regards

Andrew

------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Robert James Clay | 4 Jun 09:49 2015
Picon

LedgerSMB for Debian 8

All,

   A package for LedgerSMB v1.3.46 on Debian 8 ('Jessie')  has been uploaded  
and is available in the jessie-backport distribution as package version 
1.3.46-1~bpo8+1 . If you are not already familiar with backports in Debian, 
more information can be found at http://backports.debian.org/Instructions.

  Note also that I am considering a backport of the v1.3.46 package to Debian 
7 ('wheezy') as well.

RJ Clay
jame@...

------------------------------------------------------------------------------
Geordie | 5 May 01:32 2015
Picon

Debian LSMB 1.4.11 install

Good day
I thought I would give Ledgersmb 1.4.11 a spin
Fresh install of Debian testing in a LXC container

Here are the following errors

http:/x.x.x.x/ledgersmb/setup.pl
Error!

Base schema failed to load at LedgerSMB/Database.pm line 614.

dbversion: 1.4.11, company:

/var/log/postgresql/postgresql-9.4-main.log

 ledgersmb <at> postgres ERROR:  function public.setting_get(unknown) does
 not exist at character 15 2015-05-04 19:04:26 EDT [197-2]
 ledgersmb <at> postgres HINT:  No function matches the given name and
 argument types. You might need to add explicit type casts. 2015-05-04
 19:04:26 EDT [197-3] ledgersmb <at> postgres STATEMENT:  SELECT * FROM
 "public"."setting_get"('ignore_version') 2015-05-04 19:04:27 EDT
 [200-1] ledgersmb <at> try2 FATAL:  database "try2" does not exist
 2015-05-04 19:04:27 EDT [201-1] ledgersmb <at> try2 FATAL:  database "try2"
 does not exist 2015-05-04 19:04:27 EDT [204-1] ledgersmb <at> try2 FATAL:
 database "try2" does not exist 2015-05-04 19:04:41 EDT [216-1]
 ledgersmb <at> try2 ERROR:  language "plpgsql" already exists 2015-05-04
 19:04:41 EDT [216-2] ledgersmb <at> try2 STATEMENT:  CREATE LANGUAGE plpgsql

Apache2 error
[Mon May 04 19:06:25.464716 2015] [authz_core:debug] [pid 88:tid
140567434426112] mod_authz_core.c(809): [client 10.0.0.13:39880]
AH01626: authorization result of Require ip 127.0.0.1: denied, referer

I did not try  Initializing a company database
from Install readme.  

 $ make test - had no errors

Any suggestions
Geordie

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y

Gmane