Bill Appelbe | 30 Sep 12:01 2014
Picon

Tax calculation

Hi
I have LedgerSMB 1.4.2 installed, I have a test company with a few products entered.
I am seeing what I think is a regression of a bug that seems to have been fixed in 1.3.40 (or maybe I am understanding it incorrectly)

I set up a product with a selling price of 1.10, I have set it up with a VAT rate of 23% (Irish VAT rate). If I do a sales order for 12 of these products the Subtotal is 13.20 and the VAT is 2.99.
VAT of 2.99 would be correct for 13.00 not 13.20 so there appears to be rounding before the tax is calculated.

Am I setting something up incorrectly or is it a bug?

thanks

Bill
------------------------------------------------------------------------------
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://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Louis | 29 Sep 19:31 2014

1.3.43 to 1.3.44 problem


I'm running psql (9.4beta2)

1.3.43 works fine. unpack the 1.3.44 tarball over 1.3.43.

Try login.pl and get:

Error!

Database is not the expected version. Was 1.3.43, expected 1.3.44. Please 
re-run setup.pl against this database to correct.setup.pl

as expected.

click into setup.pl, log in as superuser

and get in browser:

Error!

Cannot find Contrib script tablefunc.sql in 
/usr/share/postgresql/9.4/extension/.
Please point your contrib_dir directive in your ledgersmb.conf to the 
appropriate location

and get in apache log:

[Mon Sep 29 11:28:37.869976 2014] [cgi:error] [pid 20609] [client 
::1:52722] AH01215: Died at LedgerSMB.pm line 954., referer: 
http://localhost/hethcotefin/setup.pl
[Mon Sep 29 11:28:37.870057 2014] [cgi:error] [pid 20609] [client 
::1:52722] AH01215: Compilation failed in require at 
/usr/local/hethcotefin/setup.pl line 8., referer: 
http://localhost/hethcotefin/setup.pl
[Mon Sep 29 11:28:37.913316 2014] [autoindex:error] [pid 20609] [client 
::1:52722] AH01276: Cannot serve directory /usr/local/hethcotefin/css/: No 
matching DirectoryIndex 
(index.html,index.cgi,index.pl,index.php,index.xhtml,index.htm) found, and 
server-generated directory index forbidden by Options directive, referer: 
http://localhost/hethcotefin/setup.pl

Help

Louis

------------------------------------------------------------------------------
Slashdot TV.  Videos for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
Michael Richardson | 29 Sep 19:21 2014
X-Face
Picon

multiple deposit receipt


lsmb 1.2 had the "receipts" tab under cash that permitted one to mark
multiple customers as having been paid.  The total would match the
bank deposit slip, but annoyingly did not record the summary for
reconciliation purposes.

There is nothing in 1.3, I think, so I will be creating a "To Deposit"
asset account and receive multiple items into that account, and then
reconcile that into the checquing account with a general ledger entry.

Is there anything in 1.4 for this?  Should I contemplate running 1.4?

------------------------------------------------------------------------------
Slashdot TV.  Videos for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
Lee Olivares | 24 Sep 04:45 2014
Picon

Problem with fresh setup of 1.4.1

New LSMB user here, riding on the fresh high of getting 1.3 series running on MacOS X 10.9, I seem to have completely borked things moving to 1.4 series. All because I wanted CRM, darn.

Did my best to blow everything out fresh, /usr/localledgersmb, Perl files, and Postgres DBs but when creating a new DB <at> setup.pl I get this:

Error!

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

dbversion: 1.4.1, company:

Seems to create a "dead" db and I have to drop it and try again, getting the same thing.

Saw a previous note here about possible permissions issue on /tmp/ledgersmb so I chmod 777 that as a test, but no dice, set back to 755.

Where am I going wrong?
------------------------------------------------------------------------------
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://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Louis | 23 Sep 18:34 2014

Export/Import migration 1.3.x to 1.4.x


I have a fairly messed up database with my 1.3.x lsmb. It has data going 
back to 1997 which has been migrated from QuickBooks to SQL-Ledger to 
LedgerSMB 1.2 to LedgerSMB 1.3 (which exposed many of these issues).

Rather than trying to upgrade the data in-place, I suspect it would be 
better to export from 1.3 and import into 1.4 to help get a cleaner 
database.

It may also be useful to roll up the detail from say, 1997 to 12/31/2009.

Are there tools available for this, am I looking at a consulting gig, or 
maybe writing it for myself?

Sign me as, "beginning to sweat"

Louis

------------------------------------------------------------------------------
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://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
Max van Biezen | 23 Sep 15:40 2014
Picon

1.4.1 cannot access LSMB

Hi,

I have converted the 1.3.40 database to 1.4.1 and I updated an entry
using menu cash/voucher/receipt. After that I approved the batch and
also immediately updated the reconciliation (not using custom script).
There no errors reported in the logs. Then I logged off. When logging
on again I get the result below complaining about the action of
yesterday

Not sure what I can do here as this is about the first action I took
after converting from 1.3.40 to 1.4.1

Max

2014/09/23 15:31:14 - DEBUG - LedgerSMB::_db_init LedgerSMB.pm (744) -- end
DBD::Pg::st execute failed: ERROR:  update or delete on table "batch"
violates foreign key constraint "voucher_batch_id_fkey" on table
"voucher"
DETAIL:  Key (id)=(47) is still referenced from table "voucher". at
LedgerSMB/Session.pm line 190.
2014/09/23 15:31:14 - ERROR - LedgerSMB::dberror LedgerSMB.pm (772) --
Logging SQL State 23503, error 7, string ERROR:  update or delete on
table "batch" violates foreign key constraint "voucher_batch_id_fkey"
on table "voucher"
DETAIL:  Key (id)=(47) is still referenced from table "voucher".
23503:ERROR:  update or delete on table "batch" violates foreign key
constraint "voucher_batch_id_fkey" on table "voucher"
DETAIL:  Key (id)=(47) is still referenced from table "voucher". at
LedgerSMB.pm line 781.
Compilation failed in require at /usr/local/lsmb14/login.pl line 8.
[Tue Sep 23 15:31:14 2014] [error] [client 10.28.45.106] Premature end
of script headers: login.pl, referer:
http://srv2.int/ledgersmb/login.pl

------------------------------------------------------------------------------
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://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
Max van Biezen | 21 Sep 21:19 2014
Picon

description field empty in PDF invoice

Hi,

The next one in the Latex / PDF saga. Using 1.4.0 release. When I
generate an invoice as PDF then the column "Description" is empty.
Apart from this the PDF looks correct and nicely formatted.

In the error.log I get

Use of uninitialized value $vars in substitution (s///) at
LedgerSMB/Template/LaTeX.pm line 111.
Use of uninitialized value $vars in substitution (s///) at
LedgerSMB/Template/LaTeX.pm line 112.
.
.
Use of uninitialized value $vars in substitution (s///) at
LedgerSMB/Template/LaTeX.pm line 114.
Use of uninitialized value $sign in numeric lt (<) at
/usr/share/perl5/Number/Format.pm line 542.
Use of uninitialized value $sign in numeric lt (<) at
/usr/share/perl5/Number/Format.pm line 490.
Use of uninitialized value $sign in numeric lt (<) at
/usr/share/perl5/Number/Format.pm line 590.
Use of uninitialized value $vars in substitution (s///) at
LedgerSMB/Template/LaTeX.pm line 111.
Use of uninitialized value $vars in substitution (s///) at
LedgerSMB/Template/LaTeX.pm line 114.
Use of uninitialized value in lc at /usr/share/perl5/LaTeX/Driver.pm line 137.
2014/09/21 21:09:10 - DEBUG - LedgerSMB::Template::render
LedgerSMB/Template.pm (357) -- before self output
2014/09/21 21:09:10 - DEBUG - LedgerSMB::Template::render
LedgerSMB/Template.pm (359) -- after self output,but does not seem to
return here!

In the invoice.tex I use the line (from templates/demo_with_image):

\begin{longtable}{ <at> {\extracolsep{\fill}}r|llcrr|r}

  \textbf{<?lsmb text('Item') ?>}
  & \textbf{<?lsmb text('Number') ?>}
  & \textbf{<?lsmb text('Description') ?>}
  & \textbf{<?lsmb text('Qty') ?>}
  & \textbf{<?lsmb text('Price') ?>}
  &  \textbf{<?lsmb text('Disc %') ?>}
  & \textbf{<?lsmb text('Amount') ?>}
\endhead
<?lsmb FOREACH number ?>
<?lsmb lc = loop.count - 1 ?>
  <?lsmb runningnumber.${lc} ?> &
  <?lsmb number.${lc} ?> &
  <?lsmb INCLUDE multiline string = description.${lc} ?> &
  <?lsmb qty.${lc} ?> &
  <?lsmb sellprice.${lc} ?> &
  <?lsmb discountrate.${lc} ?> &
  <?lsmb linetotal.${lc} ?> \\
<?lsmb END ?>

There is no difference when I change this to: <?lsmb description.${lc} ?> &

The database I am using is converted from a 1.3.40 DB converted to
1.4.0. How to debug this to get more information on why this field is
empty in de PDF?

Regards,

Max

------------------------------------------------------------------------------
Slashdot TV.  Video for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
Max van Biezen | 21 Sep 17:17 2014
Picon

lsmb 1.4.0 gui edit latex template permission denied

Hi,

I am trying to figure out the the latex differences between the
templates I used in 1.3 and now fail in 1.4.

In order to do some trial&error debugging I want to edit the
system/Latex templates/invoice, however when I want to save then it is
denied. I have set the option "edit template" for the user, though
that made no difference.

What sql statement do I need to make to manually set the permission so
I can edit and save the latex templates in the GUI?

question on the side: how relate an invoice.tex file to a language? It
is not a problem but LSMB complains it is not set to a language and I
wonder how I could correct that.

from error.log:
2014/09/21 17:07:58 - DEBUG - LedgerSMB::new LedgerSMB.pm (199) --
Begin called from $filename=lsmb-request.pl $line=51 $type=LedgerSMB
$argstr= ref argstr=
2014/09/21 17:07:58 - DEBUG - LedgerSMB::new LedgerSMB.pm (227) --
params=$VAR1 = {
          'template_name' => 'invoice',
          'template' => '<?lsmb FILTER latex -?>
.
.
.
\\end{document}
<?lsmb END ?>
'
               }, 'LedgerSMB::DBObject' );
DBD::Pg::st execute failed: ERROR:  permission denied for relation template
CONTEXT:  SQL statement "UPDATE template SET template = in_template
    WHERE template_name = in_template_name AND format = in_format AND
          language_code IS NOT DISTINCT FROM in_language_code"
PL/pgSQL function "template__save" line 4 at SQL statement at
LedgerSMB.pm line 583.
2014/09/21 17:07:58 - ERROR - LedgerSMB::dberror LedgerSMB.pm (770) --
Logging SQL State 42501, error 7, string ERROR:  permission denied for
relation template
CONTEXT:  SQL statement "UPDATE template SET template = in_template
    WHERE template_name = in_template_name AND format = in_format AND
          language_code IS NOT DISTINCT FROM in_language_code"
PL/pgSQL function "template__save" line 4 at SQL statement
2014/09/21 17:07:58 - ERROR - LedgerSMB::_error LedgerSMB.pm (647) --
Access Denied
More information has been reported in the error logs at LedgerSMB.pm line 773.
2014/09/21 17:07:58 - ERROR - LedgerSMB::_error LedgerSMB.pm (648) --
dbversion: 1.4.0, company: company_name
Died at LedgerSMB.pm line 661.
Compilation failed in require at /usr/local/lsmb14/template.pl line 8.

------------------------------------------------------------------------------
Slashdot TV.  Video for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
Chris Travers | 20 Sep 09:27 2014
Picon

Proposed change: Removing Batch Printing

Hi everyone;

I would like to propose removing the current batch printing functionality in future 1.4 and 1.5 releases.  I am happy to write a more robust and secure addon if there is interest (commissioning would be welcome) but my sense is that nobody uses the current functionality and as a result it is not well tested or maintained.

Is there any objection to removing the functionality in 1.4.2?

--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
------------------------------------------------------------------------------
Slashdot TV.  Video for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Michael Richardson | 19 Sep 16:35 2014
X-Face
Picon

precision of a service


Where is the precision (rounding) for a service specified?
We have an item which we buy, which our vendor calculates.
It seems to have a precision set of 1, which causes "24.18"
to become "24.2" which is wrong.  Looking at the HTML, I noticed:
"precision_4" has a value of "1", which for all other items was "2".

<td><input name="description_4"  size=48 value="maintenance
telephonique"></td>
<td align=right class="qty"><input name="qty_4" title="0" size="5"
value="1"></td>
<td class="unit"><input name="unit_4" size=5 value=""></td>
<td class="onhand">0</td>
<td align=right class="sellprice"><input name="sellprice_4" size="9"
value="24.2"></td>
<td align=right class="discount"><input name="discount_4" size="3"
value=""></td>
<td align=right class="linetotal">24.18</td>
<td class="taxform"><input type="checkbox" name="taxformcheck_4" value="1"
></td>
        </tr>
<input type=hidden name="oldqty_4" value="1">
<input type="hidden" name="image_4" value="" />
<input type="hidden" name="orderitems_id_4" value="" />
<input type="hidden" name="id_4" value="12356" />
<input type="hidden" name="bin_4" value="" />
<input type="hidden" name="weight_4" value="0" />
<input type="hidden" name="listprice_4" value="" />
<input type="hidden" name="lastcost_4" value="" />
<input type="hidden" name="taxaccounts_4" value="2320 2310 2311" />
<input type="hidden" name="pricematrix_4" value="" />
<input type="hidden" name="sku_4" value="pbx" />
<input type="hidden" name="onhand_4" value="0" />
<input type="hidden" name="assembly_4" value="" />
<input type="hidden" name="inventory_accno_id_4" value="" />
<input type="hidden" name="income_accno_id_4" value="21" />
<input type="hidden" name="expense_accno_id_4" value="26" />
<input type="hidden" name="invoice_id_4" value="2404" />
<input type="hidden" name="precision_4" value="1" />

        <tr valign=top class="ext2">

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

------------------------------------------------------------------------------
Slashdot TV.  Video for Nerds.  Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
R. Ransbottom | 17 Sep 17:00 2014
Picon
Picon

1.4 cookie_name?

On a fresh install of 1.4.0.

Should the config var

cookie_name = LedgerSMB-1.3

be changed?

Thanks,
rir

------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk

Gmane