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

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

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
Louis | 16 Sep 19:26 2014

database copy tool


Is there a tool for copying a production lsmb db into a fresh development 
db.

Or does:
pg_dump --format=tar proddb > ./proddb.pg
pg_restore --clean --create --format=tar --dbname=testdb ./proddb.pg

do the trick

------------------------------------------------------------------------------
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
Louis | 15 Sep 21:46 2014

Observations on the install of 1.4.0, request for help


Did the preliminaries and was able to get setup.pl but when asked to 
create database I got:

|  Error!
| 
|  Base schema failed to load at LedgerSMB/Database.pm line 614.
| 
|  dbversion: 1.4.0, company:

It seems that changing permissions on /tmp/ledgersmb got past that

As I going through the setup pages, a little more info would help to make 
selections. Which templates to load? xedemo, demo_with_images, demo? 
which, what, why?

When creating users, knowing which fields are required would help. I don't 
normally need my ssn for LedgerSMB. It failed because I hadn't put in an 
ssn. There after I was unable to add myself because I was entering a 
duplicate. I didn't see anything in the users, user_preference, entity, 
person, entity_employee, or entity_other_name tables. So this one is a 
puzzlement.

I dropped the database and started again.

and

Error!

Error from Function:
ERROR: Duplicate user More information has been reported in the error logs 
at LedgerSMB.pm line 773.

dbversion: 1.4.0, company:

Now I need help.

Help,

Louis

------------------------------------------------------------------------------
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
R. Ransbottom | 9 Sep 03:28 2014
Picon
Picon

Entity usage?


Hello,

FYI, my sql is underdeveloped and rusty.

A SQL comment suggests entities exist as a place to map contacts.

Two questions:

Is this to implement the security given by roles (through the
many link tables)?  If not, I don't see much point in the extra layer
of indirection.  And I'm trying to get a handle on the schema.

As a user, what are the trade-offs amongst: auto-generated entity
keys; having the type record (i.e. customer) and entity have matching
keys; or something else (eg. suffix on entity for entities with
multiple types?

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
Pongrácz István | 1 Sep 14:26 2014
Picon

1.3 - how to reverse a payment - accidentally all open invoices paid

Hi,

I run into a situation with the payment for vendor:

I went to Cash / Payment form, selected a  Vendor, the form brought up all open invoices.

I write the refererence and posted the form and instead of one invoice, it closed all of them as paid.

In other words:  

  • 10 invoices open, each of them are 1000,-  (10 x 1000 in total)
  • I wanted to register only one invoice ( 1 x 1000), but as I saved, I found that, all of them registered as paid in one date

My question, what is the proper way to change/reverse these payments and start registering again one by one?

Thank you!

István

 

------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Bill Ott | 30 Aug 17:06 2014

Errant overpayment

Having entered a customer over-payment, I now want to cut the customer a 
check for the over-payment amount. How do I get rid of the AR 
over-payment amount?

I am running 1.3.30.

--

-- 
Regards,
Bill Ott

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

------------------------------------------------------------------------------
Slashdot TV.  
Video for Nerds.  Stuff that matters.
http://tv.slashdot.org/
Pongrácz István | 7 Aug 10:16 2014
Picon

Re: LedgerSMB Virtual Appliance


 Hi,

The disk image moved to the Sourceforge.

Please visit the following link:

https://sourceforge.net/projects/ledger-smb/files/Virtual%20Appliance/

Bye,

István

 

 

----------------eredeti üzenet-----------------
Feladó: "Pongrácz István" <pongracz.istvan-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Címzett: "Ledger-smb-users lists.sourceforge.net" <Ledger-smb-users <at> lists.sourceforge.net>
Dátum: Fri, 1 Aug 2014 11:04:18 +0200
----------------------------------------------------------


Hi,

I prepared a LedgerSMB Virtual Machine Appliance for those, who would like to evaluate or use the stock 1.3 / 1.4.

The system built in Virtualbox, the downloadable disk image is in VMDK format -> so, expert users can convert to other full virtualization images, such as KVM, Qemu, Xen, Vmware, Microsoft whatever etc.

The system has autologin and all necessary documentation included right on the Desktop. Please read before ask. There are contact information, too inside the system.

So, the links:

Video quick intro on Youtube: http://youtu.be/BsVxS7mvvHI
Download: http://www.startit.hu/Letoltesek/ledgersmb

Enjoy, share :)

Bye,

István

 

 

 

 

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Gmane