Geordie | 28 Mar 14:29 2015
Picon

Debian LXC Apache connection Issues

Good Day

Iceweasel
http://10.0.0.15/ledgersmb/setup.pl

You have chosen to open
setup.pl

So how did I get here
ledgersmb:
  Installed: 1.3.40-1
apache2:
  Installed: 2.4.10-10
postgresql:
   Installed: 9.4+166
Kernel: 3.16.0-4-amd64 x86_64 
lxc:
  Installed: 1:1.0.7-1
iceweasel:
  Installed: 37.0~b1-1

I was originally going to ask for the best practices in setting up
Apache2 for Ledgersmb, however, right now I would just like to have it
open. Ledgersmb is installed in a Debian Unstable LXC container on a
Debian Unstable host. As for the install it was relatively painless
there was a problem however

apache2_invoke ledgersmb.conf: already enabled
apache2_reload: Your configuration is broken. Not reloading Apache 2
apache2_reload: AH00526: Syntax error on line 9
(Continue reading)

Bill Appelbe | 25 Feb 18:17 2015
Picon

Type of business

Hi
probably something simple that I can't see:

I have added a "Type of Business" with a discount.
How do I edit a customer so that he is this type of business?

Bill

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Mikkel Høgh | 21 Feb 06:16 2015

SQL errors galore when trying to upgrade to 1.4

Hi there,

I'm having a devil of a time trying to upgrade from 1.3.56 to 1.4.10.1. 
I've tried different machines, different older copies of the database, 
different OS'es, different versions of 1.4, both browser-based, and the 
CLI version, but all to no avail.

I simply can't figure out how to get a working upgrade.

Here's how the output from reload_modules.sh looks:

http://pastebin.com/M7L540bE

Any clue what I can do to get a proper upgrade done?

--
Kind regards,

Mikkel Høgh <mikkel <at> hoegh.org>

------------------------------------------------------------------------------
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=190641631&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Nick Prater | 16 Feb 23:30 2015

Exchange Rates

Am I right in thinking that ledgersmb 1.4 and earlier store exchange rates
globally (in the exchangerate table), rather than per-transaction? So once
an exchange rate is set, that rate is assumed for all other transactions
on that date?

If so, that assumption seems broken in that:

* I have accounts with different banks, each sets their own exchange rate
* A bank may set a different rate for different methods of payment
* Rates may change several times during a day, not just at midnight in my
timezone

I note that it is possible to alter the exchange rate for a particular
date by saving (not even posting) another invoice. But that seems to
jeopardise the consistency of transactions posted earlier in the day.
Perhaps this is a bug?

Ideally, it seems that exchange rates should instead be stored on a
per-transaction basis. Or do I have this wrong?

I'd appreciate a more knowledgeable opinion!

Many thanks,

Nick

------------------------------------------------------------------------------
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=190641631&iu=/4140/ostg.clktrk
Michael Richardson | 7 Feb 23:05 2015
X-Face
Picon

upgrade from 1.3 to 1.4.10.1


I believe that I previously posted about problems with an upgrade from 1.3 to
1.4. I can't find that outgoing email, so perhaps it was my imagination that
I had reported the issue.

A major source of problems was that I had the debian ledgersmb package
installed, and so there were LedgerSMB modules installed into
/usr/share/perl.  (I really dislike having application-specific modules
installed system-wide.  It makes it extremely difficult to install multiple
versions, debug things, etc.  This may be more of a problem with the debian
packaging than anything else, although I run into this problem with Catalyst
based system I deal with)

I found this, removed the package, and then found more in /usr/local/share/perl.
I re-ran perl Makefile.PL, etc. again, and found that the strange errors went
away; but I still can not seem to save a new AP Transaction.
(I did go back and re-run the setup.pl just to be sure.  If re-loading
my 1.3 saved SQL file is useful, I could do that)

I click on Update, and all is good.  I click on Save, and I get:
  Action: post, ID:

no number at the top, and the form does not change to include Post-As-Saved,
etc.

As an aside, I looked through the list of un-approved transaction, wondering
if it had made it into that list, and it did not.  I did find one from
last August which should go away, and I selected "Delete" and got an error:

2015/02/07 21:54:32 - ERROR - LedgerSMB::_error LedgerSMB.pm (650) -- 23503:ERROR:  update or delete on
table "acc_trans" violates foreign key constraint "business_unit_ac_entry_id_fkey" on table "business_unit_ac"
DETAIL:  Key (entry_id)=(24190) is still referenced from table "business_unit_ac".
CONTEXT:  SQL statement "DELETE FROM acc_trans WHERE trans_id = in_id"
PL/pgSQL function "draft_delete" line 9 at SQL statement at LedgerSMB.pm line 782.
2015/02/07 21:54:32 - ERROR - LedgerSMB::_error LedgerSMB.pm (651) -- dbversion: 1.4.10, company: sswbooks
Died at LedgerSMB.pm line 664.

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

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Nick Prater | 23 Jan 14:48 2015

1.4.x : no transactions report

I'm in the process of moving from 1.3.40 to 1.4.10 but have hit a block.

I am a UK limited company, registered for VAT.

1.3.x has two reports that I use for completing my quarterly VAT return:
  Sales->Reports->Transactions
  Purchases->Reports->Transactions

These reports allowed me to list all transactions for a given time period,
with their associated tax amounts. I see no way to do this in 1.4.x.

Is there any equivalent to these reports in 1.4.10?

Many thanks,

Nick

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
Louis | 20 Jan 02:54 2015

Voided sales invoice not reversing payment?


I have an issue, which maybe should be a bug. I messed up a sales invoice 
#1285 and then voided it. It looks to me like there is a missing pair of
entries.

What I have is:

For Account #1201 (AR)

Ref        |Debit |Credit
-----------+------+-----
1285       | 12   |  0
1285       |  0   | 15
1285-VOID  |  0   | 12
1286       | 15   |  0
1286       |  0   | 15

For Account #4020 (Sales)

Ref        |Debit |Credit
-----------+------+-----
1285       |  0   |  12
1285-VOID  | 12   |   0
1286       |  0   |  12

For Account #1601 (Bank)

Ref        |Debit |Credit
-----------+------+-----
1285       | 15   |  0
1286       | 15   |  0

However, should there not also be:

For Account #1201 (AR)

Ref        |Debit |Credit
-----------+------+-----
1285-VOID  | 15   |  0

and

For Account #1601 (Bank)

Ref        |Debit |Credit
-----------+------+-----
1285-VOID  |  0   | 15

??

If I just need to plan on making the appropriate JE, that I can do, but it 
seems to me like the [VOID] button processing missed something.

Louis

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
Louis | 16 Jan 20:24 2015

Bookstore part handling


We have a tiny little book business.

We ONLY have one of each part. If we sell a book, buy the same book back, 
it will have a new number. Collectibles aren't like widgets in that 
regard.

Historically the workflow was: obtain book, accession it, add purchase 
information to ledgersmb and add the new book as a new part using the 
accession number as the partnumber.

We need to improve our inventory handling.

Basically, we need to be able to enter a book and purchase information, 
mark the book as _on order_ or _recieved_. When the book is described and 
accessioned in the bibliography system, we need to mark the book as 
inventory, attach the accession number and the author/title information to 
the book for future sales invoices. The COGS needs to apply to just that 
one book.

Has anyone else got a similar part-workflow? Or ideas on how to best use 
ledgersmb for this workflow?

Louis

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
Peter van Bussel | 9 Jan 00:25 2015
Picon

Bug #1264 resurrection?

BUMP.

 

Dear All,

I get the error below when adding a new item to an existing sales order. Has Bug #1264 resurrected?

Regards,

Peter

Error!

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

dbversion: 1.4.9, company: bus004

------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Louis | 7 Jan 21:05 2015

cornderlogo


Probable typo in

UI/menu/expanding.html

  and

UI/lib/dojo/dojox/widget/Loader.js.uncompressed.js

with cornder in place of corner.

css/gnome.css:.cornderlogo {
css/gnome2.css:.cornderlogo {

are the only two css files with cornder

Louis

------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
bill Ott | 7 Jan 17:48 2015

Duplicate invoice entry

Hi, I am running version 1.30.3. I went to close out the year and 
discovered I had a AP draft transaction awaiting approval (which blocked 
the year end closure).  I approved it, only to discover that the invoice 
in question had been already processed and paid.  My approval created a 
second entry for the same invoice. I used a journal entry to back the 
second entry out, making all of the accounts correct. with one minor 
problem. When I look at the out standing AP, the errant payment is 
listed. The good news is that it does not appear in the AP account in 
the GL or the Balance sheet, so I am good to go for tax purposes.

The question is how do I remove the errant entry from the AP outstanding 
report?

--

-- 
Regards,
Bill Ott

Home: 919-363-0031
Cell: 919-434-7589
Email: Mailto:billott@...
Website: http://www.theotts.org
Profile: http://www.linkedin.com/in/wbott

------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net

Gmane