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

(Continue reading)

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.
(Continue reading)

Bill Appelbe | 7 Nov 13:22 2014
Picon

login problem

Hi
I have a strange problem and the solution is probably obvious -but I can't see it.
I can not login into LedgerSMB from the server machine but I can from other machines.
ie if I am using 127.0.0.1/ledgersmb I get the login screen - enter user, pass and company, another "Authentication Required" user,pass box opens, if I re-enter the user,pass it still will not let me in.
If I login from another machine then there is no problem.

I checked my .conf file and 127.0.0.1 is on the list of Require ip

what am I missing?

Bill


------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Max van Biezen | 2 Nov 20:50 2014
Picon

ERROR: date/time field value out of range: "31/10/2014"

Hi,

I want to execute an entry via cash/vouchers/reverse receipt. It fails
complaining about the date format. I am running 1.4.6RC2. How to tell
ledgersmb the date field is okay?

Max

DBD::Pg::st execute failed: ERROR:  date/time field value out of
range: "31/10/2014"
LINE 1: SELECT * FROM "public"."payment__reverse"(NULL, '31/10/2014'...
                                                        ^
HINT:  Perhaps you need a different "datestyle" setting. at
LedgerSMB.pm line 585.
2014/11/02 20:46:30 - ERROR - LedgerSMB::dberror LedgerSMB.pm (772) --
Logging SQL State 22008, error 7, string ERROR:  date/time field value
out of range: "31/10/2014"
LINE 1: SELECT * FROM "public"."payment__reverse"(NULL, '31/10/2014'...
                                                        ^
HINT:  Perhaps you need a different "datestyle" setting.
2014/11/02 20:46:30 - ERROR - LedgerSMB::_error LedgerSMB.pm (649) --
Invalid date/time entered
More information has been reported in the error logs at LedgerSMB.pm line 775.
2014/11/02 20:46:30 - ERROR - LedgerSMB::_error LedgerSMB.pm (650) --
dbversion: 1.4.6, company: <DB-name>
Died at LedgerSMB.pm line 663.
Compilation failed in require at /usr/local/lsmb14/payment.pl line 8.

------------------------------------------------------------------------------
Chris Travers | 25 Oct 03:14 2014
Picon

Re: error when adding item to sales order

Hi Bill, 

I have attached a patch to this ticket.  I don't know if the issue is actually with the problem you are describing or whether it is the fact that the update button no longer shows after saving (so it keeps creating new invoices), which is probably not what you want (you probably have a lot of approved drafts as a result).

I am fixing that latter issue first, and it may well fix your issue as well.  Please test the patch

Best Wishes,
Chris Travers

On Fri, Oct 24, 2014 at 7:44 AM, Bill Appelbe <bappelbe-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
#1264 created

Bill

On Fri, Oct 24, 2014 at 2:32 PM, Chris Travers <chris.travers <at> gmail.com> wrote:
I will try to reproduce this weekend.  So that I don't forget, could you file a bug report on SF?  Otherwise I can do it.

On Fri, Oct 24, 2014 at 5:29 AM, Bill Appelbe <bappelbe-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
hi
I have noticed a pattern!!
the error happens while entering the first item after a "save".
Not all saves cause it to happen but maybe the third or fourth save of an order (I press continue to overwrite an order).
As I am entering an order I press save occasionally as I am going along.

any ideas?

Bill


On Tue, Oct 21, 2014 at 5:15 PM, Bill Appelbe <bappelbe-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
Hi
using LedgerSMB 1.4.4.
I am getting an intermittent error.
I have a database set up with a lot of parts (>18,000).
I go to order entry - > sales order.
I enter items (using item number) and a quantity for each item.
This works well.
Occasionally I get an error as below.
I can use back arrow and save the order fine.
I cannot add any more items to this order (I can open a new order and work away). This does not happen at the same point in the order (one order I have 104 items before it happens others fewer).
I get the same error if I add an item by Description.

any pointers? I have been trying to find a non number in a numercal field but can't find one.


thanks

Bill

Error!

'LedgerSMB::PGNumber Invalid Number at LedgerSMB/PGNumber.pm line 167.
'

dbversion: 1.4.4, company: JelanTest




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

_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users




--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.

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

_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



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

_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users




--
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
Bill Appelbe | 21 Oct 18:15 2014
Picon

error when adding item to sales order

Hi
using LedgerSMB 1.4.4.
I am getting an intermittent error.
I have a database set up with a lot of parts (>18,000).
I go to order entry - > sales order.
I enter items (using item number) and a quantity for each item.
This works well.
Occasionally I get an error as below.
I can use back arrow and save the order fine.
I cannot add any more items to this order (I can open a new order and work away). This does not happen at the same point in the order (one order I have 104 items before it happens others fewer).
I get the same error if I add an item by Description.

any pointers? I have been trying to find a non number in a numercal field but can't find one.


thanks

Bill

Error!

'LedgerSMB::PGNumber Invalid Number at LedgerSMB/PGNumber.pm line 167.
'

dbversion: 1.4.4, company: JelanTest


------------------------------------------------------------------------------
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://p.sf.net/sfu/Zoho
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Peter van Bussel | 14 Oct 15:48 2014
Picon

LSMB 1.4.4 Goods and Services Search

Hi All,

 

Menu item Goods and Services > Search displays this error:

Error!

Unable to open script: LedgerSMB::Scripts::goods : No such file or directory: Can't locate namespace/autoclean.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 LedgerSMB/Report/Invoices/COGS.pm line 12.
BEGIN failed--compilation aborted at LedgerSMB/Report/Invoices/COGS.pm line 12. Compilation failed in require at LedgerSMB/Scripts/goods.pm line 9. BEGIN failed--compilation aborted at LedgerSMB/Scripts/goods.pm line 9. Compilation failed in require at (eval 1320) line 1.

dbversion: 1.4.4, company: test3

Any suggestions?

 

Regards,

 

Peter

 

------------------------------------------------------------------------------
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://p.sf.net/sfu/Zoho
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Kai Huuhko | 13 Oct 10:20 2014
Picon

Upgrading lsmb-1.2 database

Hi

I'm attempting to upgrade an old database backup that was created back
in 2011 using ledgersmb-1.2.

The pg_restore process completed successfully with just one trivial
error: could not execute query: ERROR:  language "plpgsql" already
exists

Trying to run the upgrade process using lsmb-1.4.4 it errored out
saying I should check the logs in /etc/ledgersmb but I have no such
directory.

With lsmb-1.3.44 the upgrade process completes but with 0 row counts
for all but users (1) and vendors (2). I get no actual data in the
company, even the chart of accounts is empty.

Attached is a syslog dump of entries logged by postgresql during the
upgrade process using lsmb-1.3.44.

Can anyone help me get the database upgraded completely?
Attachment (lsmb-upgrade-pg.log.tar.xz): application/x-xz, 18 KiB
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://p.sf.net/sfu/Zoho
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Peter van Bussel | 13 Oct 00:22 2014
Picon

journal.pl not found

Dear All,

 

After upgrading to 1.4.3 and applying starman, I can login with http://localhost:5000/login.pl, but I can’t get rid of error “The requested URL /journal.pl was not found on this server.”

 

Any suggestions?

 

Regards,

 

Peter

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://p.sf.net/sfu/Zoho
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Gmane