Rich Shepard | 7 Apr 00:40 2014

New User Questions: Printing Reports, Templates, Selecting Cash Basis

   I copied my LaTeX templates directory for invoices, checks, etc. from the
L123 subdirectory to /opt/ledgersmb/templates/rshepard. I assume that the
'default' template for each printable document is that defined in the
subdirectory above since I entered that in System -> Defaults and saved the
information.

   However, when I want to print an income statement or balance sheet all I
see is html code on the displayed page. What have I missed here?

   For the Income Statement, there is a radio-button for accrual accounting,
but no way to unselect that and select cash accounting instead. Looking in
ledgersmb.conf I do not see where I can specify that, nor do I see that
option under System -> Defaults. Where can I select cash basis rather than
accrual basis?

Rich

------------------------------------------------------------------------------
Rich Shepard | 6 Apr 23:22 2014

New User Questions: Cash->Payment

   I'm transitioning from Ledger123/SQL-Ledger which I've used for a decade.
I see major differences between the way I used to cut checks for vendors and
what seems to be the limitations under lsmb-1.3.39.

   I just entered an invoice for a vendor, updated, saved, and posted.

   Now I want to print a check to be mailed tomorrow. Navigating to Cash ->
Payment I get a blank form rather than one showing all account payable
invoices awaiting payment. When I enter the first few letters of the
vendor's name in the payee field and press [Enter] I get a centered
radio-button list of all vendors, and strangely, the one with the pending
payment is not on the list. Going back one page I enter the vendor's name
click 'Continue' and am presented with the pending invoice. Entering the
check number in 'source', I hesitate because after updating, I don't have an
option to print the check without also posting it.

   What if there's a paper jam or a mis-feed? How can I reprint the check
before posting the transaction? Also, I don't see my printers (as defined in
CUPS), but what appears to be a generic list; "Epson," "Laser2," "Laser".
Shrugging my shoulders, I select "PDF" and "Laser2" and up pops a page for
Payment Order Number. I have absolutely no use for this ... and there's no
control buttons on the page either. I expected to print the check, not see a
page saying that zero dollars will be paid to the account.

   I'm sure there must be a way to 1) see all pending vendor invoices with
a selected check box for each one (in case I don't want to print one now);
2) print the check as a separate step from posting the transaction; and 3)
seeing my network printers so I can select the one to use. Better yet, let
me set the system defaults to a defined printer name and 'screen' for those
that I want to save to disk as a PDF file.
(Continue reading)

Arne Hanssen | 6 Apr 19:35 2014
Picon

Error creating invoice LSMB 1.3.39.

After [Post]-ing a sales invoice I can't print the invoice from the next 
screen.  When I click [Print] I get this error:

Internal Server Error
The server encountered an internal error or misconfiguration and was 
unable to complete your request.

Apache log shows:
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] DBD::Pg::st 
execute failed: ERROR:  column "remark" does not exist, referer: 
http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] LINE 8: ... 
'' AS customertaxnumber, sic_code AS sic, iban, remark,, referer: 
http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] 
                                                 ^ at LedgerSMB/IS.pm 
line 909., referer: http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] DBD::Pg::st 
execute failed: ERROR:  current transaction is aborted, commands ignored 
until end of transaction block at LedgerSMB.pm line 834., referer: 
http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] 2014/04/06 
19:14:48 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1102) -- Logging SQL 
State 25P02, error 7, string ERROR:  current transaction is aborted, 
commands ignored until end of transaction block, referer: 
http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] Can't use string 
("LedgerSMB::Setting") as a HASH ref while "strict refs" in use at 
LedgerSMB.pm line 942., referer: http://ledgersmb.kingel.net/is.pl
[Sun Apr 06 19:14:48 2014] [error] [client 192.168.5.1] Compilation 
(Continue reading)

Benedict White | 5 Apr 23:20 2014
Picon

Problems searching contacts in LedgerSMB 1.4.0

I've added a contact to LedgerSMB, (Me, I want to pay some expenses) and I can't search under contacts.

I went to Contacts->Search and get:
Contact Search

Entity Class Name Control Code E-mail Phone Contact Only Users Notes
(Only for Employees)
Account Number Address City State/Province Zip/Postal Code Country Active
From
Date to


When I run a search I get I get:


Error!

Unable to open script: LedgerSMB::Scripts::contact_reports : : You cannot coerce an attribute (start_from) unless its type (LedgerSMB::DBObject::Date) has a coercion at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 37
Moose::Exception::_build_trace('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)') called at reader Moose::Exception::trace (defined at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 9) line 7 Moose::Exception::trace('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)') called at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 49 Moose::Exception::BUILD('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)', 'HASH(0x6a21398)') called at /usr/lib/perl5/vendor_perl/Class/MOP/Method.pm line 128 Class::MOP::Method::execute('Moose::Meta::Method=HASH(0x6a71a20)', 'Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)', 'HASH(0x6a21398)') called at /usr/lib/perl5/vendor_perl/Moose/Object.pm line 56 Moose::Object::BUILDALL('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x6a221c0)', 'HASH(0x6a21398)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 282 Moose::Meta::Class::new_object('Moose::Meta::Class=HASH(0x6a22010)', 'HASH(0x6a21398)') called at /usr/lib/perl5/vendor_perl/Moose/Object.pm line 27 Moose::Object::new('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion', 'attribute_name', 'start_from', 'type_name', 'LedgerSMB::DBObject::Date', 'params', 'HASH(0x2657940)') called at /usr/lib/perl5/vendor_perl/Moose/Util.pm line 51 Moose::Util::throw_exception('CannotCoerceAttributeWhichHasNoCoercion', 'attribute_name', 'start_from', 'type_name', 'LedgerSMB::DBObject::Date', 'params', 'HASH(0x2657940)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 393 Moose::Meta::Attribute::_process_coerce_option('Moose::Meta::Attribute', 'start_from', 'HASH(0x2657940)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 262 Moose::Meta::Attribute::_process_options('Moose::Meta::Attribute', 'start_from', 'HASH(0x2657940)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 53 Moose::Meta::Attribute::new('Moose::Meta::Attribute', 'start_from', 'isa', 'LedgerSMB::DBObject::Date', 'definition_context', 'HASH(0x6a0a8a0)', 'coerce', 1, 'is', 'ro') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 101 Moose::Meta::Attribute::interpolate_class_and_new('Moose::Meta::Attribute', 'start_from', 'definition_context', 'HASH(0x6a0a8a0)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 716 Moose::Meta::Class::_process_new_attribute('Moose::Meta::Class=HASH(0x46fe5d8)', 'start_from', 'definition_context', 'HASH(0x6a0a8a0)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 709 Moose::Meta::Class::_process_attribute('Moose::Meta::Class=HASH(0x46fe5d8)', 'start_from', 'definition_context', 'HASH(0x6a0a8a0)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 573 Moose::Meta::Class::add_attribute('Moose::Meta::Class=HASH(0x46fe5d8)', 'start_from', 'definition_context', 'HASH(0x6a0a8a0)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose.pm line 77 Moose::has('Moose::Meta::Class=HASH(0x46fe5d8)', 'start_from', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Exporter.pm line 405 Moose::has('start_from', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at LedgerSMB/Report/Contact/History.pm line 275 require LedgerSMB/Report/Contact/History.pm at LedgerSMB/Scripts/contact_reports.pm line 19 LedgerSMB::Scripts::contact_reports::BEGIN at LedgerSMB/Report/Contact/History.pm line 0 eval {...} at LedgerSMB/Report/Contact/History.pm line 0 require LedgerSMB/Scripts/contact_reports.pm at (eval 453) line 1 eval 'require LedgerSMB::Scripts::contact_reports;' at lsmb-request.pl line 103 LedgerSMB::Handler::try {...} at /usr/share/perl5/vendor_perl/Try/Tiny.pm line 81 eval {...} at /usr/share/perl5/vendor_perl/Try/Tiny.pm line 72 Try::Tiny::try('CODE(0x47031b0)', 'Try::Tiny::Catch=REF(0x467a2e8)') called at lsmb-request.pl line 120 LedgerSMB::Handler::call_script('contact_reports.pl', 'LedgerSMB=HASH(0x33d7df8)') called at lsmb-request.pl line 84 require lsmb-request.pl at /opt/ledgersmb/contact_reports.pl line 8 Compilation failed in require at LedgerSMB/Scripts/contact_reports.pm line 19. BEGIN failed--compilation aborted at LedgerSMB/Scripts/contact_reports.pm line 19. Compilation failed in require at (eval 453) line 1.

dbversion: 1.4.0, company: ChilliTronix

Can anyone help?

Kind regards

Benedict White

------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Paul Bolger | 1 Apr 23:37 2014
Picon

Install in Debian Mint via aptitude

I'd like to try Ledgersmb on my local Debian machine but I'm getting an error:

Setting up ledgersmb (1.3.25-1) ...
ERROR: Module rewrite does not exist!
dpkg: error processing ledgersmb (--configure):

mod_rewrite (in apache) is definitely there and enabled, so what could
be the problem?

------------------------------------------------------------------------------
Rich Shepard | 30 Mar 19:42 2014

Accounts List in G/L

   I've just started using ledgersmb. When I make a G/L entry I do not see a
drop-down list of accounts from which to select those for each side of the
transaction. Is there a way of displaying the CoA on each page when accounts
need to be entered?

Rich

------------------------------------------------------------------------------
Peter van Bussel | 28 Mar 00:11 2014
Picon

Re: Editing temlplates wih Lyx

Hi Chris,

 

Could you please be more specific. I commented out  <?lsmb FILTER latex -?> by putting a % before it but after importing the .tex file in Lyx  and view (alt+R) only errors come up. After that I also tried commenting <?lsmb- END- > and <?lsmb END> with no success. I am stuck…

 

Regards,

 

Peter

 

Van: Chris Travers [mailto:chris.travers-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Verzonden: vrijdag 21 maart 2014 16:47
Aan: Peter van Bussel
Onderwerp: R
e: [Ledger-smb-users] Editing temlplates wih Lyx

 

I suspect what is throwing LyX is the <?lsmb FILTER ?>.  You might try commenting it out in terms of LaTeX (%).

 

On Fri, Mar 21, 2014 at 8:44 AM, Peter van Bussel <info-XWgdn7zXDtBdSwzlDhyra2ZHpeb/A1Y/@public.gmane.org> wrote:

Hi Chris,

 

I want to edit the invoice.tex template. For this I import a .tex file from the demo folder and then I try “view”(alt+R) which results in an error (as all the other templates do): ! LaTeX Error: Missing \begin{document}.

 

In a former mail I attached the full Latex log which resulted in this message:

 

Your mail to 'Ledger-smb-users' with the subject

 

    Editing temlplates wih Lyx

 

Is being held until the list moderator can review it for approval.

 

The reason it is being held:

 

    Message body is too big: 49565 bytes with a limit of 40 KB

 

Either the message will get posted to the list, or you will receive notification of the moderator's decision.  If you would like to cancel this posting, please visit the following URL:

 

    https://lists.sourceforge.net/lists/confirm/ledger-smb-users/fa09ac3afa9150a4a87886b45da9a3257d677622

 

That’s why I trimmed the log of +/- 50 kB. How can I send the full log to the users list?

 

Regards,

 

Peter

 

Van: Chris Travers [mailto:chris.travers-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Verzonden: vrijdag 21 maart 2014 14:44
Aan: LedgerSMB Users
Onderwerp: Re: [Ledger-smb-users] Editing temlplates wih Lyx

 

 

On Fri, Mar 21, 2014 at 3:26 AM, Peter van Bussel <info-XWgdn7zXDtBdSwzlDhyra2ZHpeb/A1Y/@public.gmane.org> wrote:

Hi all,

 

I want to try to edit the templates with Lyx as recommended. After importing a .tex template and “view” (alt+R) I get a lot of errors (attachment, first half Lyx error log) and no view. What am I doing wrong?

 

Which template?  And which template set are you using as a base?

 

I looked through the attachment and I didn't see any errors, just the rather verbose notices that LaTeX seems to give.  Can you attach a full log file?

 

I have found that LyX sometimes changes some things when loading and saving.  As far as compatibility you will run into templates where underscores are used in variable names.  I can't think of any other cases where you will have significant problems however.  I would need to see a log for more info. 

 

Regards,

 

Peter

 


------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
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.



 

--

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
Peter van Bussel | 25 Mar 23:52 2014
Picon

System defaults

Hi all,

 

Even after creating a new database it is impossible to change the System > Defaults >  Sales Invoice/AR Transaction Number field. Is there a special reason for that? All the other fields can be adjusted.

 

Regards,

 

Peter

 

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Dave | 23 Mar 16:43 2014

Filing a Bug Report(s)

Hi All,
	I know I a luser :) but where and how do I file bug-reports. I finally
have time to dump all the issues we have found with 1.3.37

I went to the SourceForge pages, but nowhere do I see "File or Create a Bug report"

TIA
Dave

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Benedict White | 23 Mar 14:30 2014
Picon

Error searching for contacts

I've set up a test database, on a test system and added a contact. Now when I try to search for a contact I go to this screen:

Contact Search

Entity Class Name Control Code E-mail Phone Contact Only Users Notes
(Only for Employees)
Account Number Address City State/Province Zip/Postal Code Country Active
From
Date to


And just click search which gets me:


Error!

Unable to open script: LedgerSMB::Scripts::contact_reports : : You cannot coerce an attribute (start_from) unless its type (LedgerSMB::DBObject::Date) has a coercion at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 37
Moose::Exception::_build_trace('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x78da4c0)') called at reader Moose::Exception::trace (defined at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 9) line 7 Moose::Exception::trace('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x78da4c0)') called at /usr/lib/perl5/vendor_perl/Moose/Exception.pm line 49 Moose::Exception::BUILD('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x78da4c0)', 'HASH(0x78d0218)') called at /usr/lib/perl5/vendor_perl/Class/MOP/Method.pm line 128 Class::MOP::Method::execute('Moose::Meta::Method=HASH(0x7926708)', 'Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x78da4c0)', 'HASH(0x78d0218)') called at /usr/lib/perl5/vendor_perl/Moose/Object.pm line 56 Moose::Object::BUILDALL('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion=HASH(0x78da4c0)', 'HASH(0x78d0218)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 282 Moose::Meta::Class::new_object('Moose::Meta::Class=HASH(0x78da2b0)', 'HASH(0x78d0218)') called at /usr/lib/perl5/vendor_perl/Moose/Object.pm line 27 Moose::Object::new('Moose::Exception::CannotCoerceAttributeWhichHasNoCoercion', 'attribute_name', 'start_from', 'type_name', 'LedgerSMB::DBObject::Date', 'params', 'HASH(0x34eb9a0)') called at /usr/lib/perl5/vendor_perl/Moose/Util.pm line 51 Moose::Util::throw_exception('CannotCoerceAttributeWhichHasNoCoercion', 'attribute_name', 'start_from', 'type_name', 'LedgerSMB::DBObject::Date', 'params', 'HASH(0x34eb9a0)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 393 Moose::Meta::Attribute::_process_coerce_option('Moose::Meta::Attribute', 'start_from', 'HASH(0x34eb9a0)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 262 Moose::Meta::Attribute::_process_options('Moose::Meta::Attribute', 'start_from', 'HASH(0x34eb9a0)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 53 Moose::Meta::Attribute::new('Moose::Meta::Attribute', 'start_from', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date', 'definition_context', 'HASH(0x78d0338)') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Attribute.pm line 101 Moose::Meta::Attribute::interpolate_class_and_new('Moose::Meta::Attribute', 'start_from', 'definition_context', 'HASH(0x78d0338)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 716 Moose::Meta::Class::_process_new_attribute('Moose::Meta::Class=HASH(0x4682860)', 'start_from', 'definition_context', 'HASH(0x78d0338)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 709 Moose::Meta::Class::_process_attribute('Moose::Meta::Class=HASH(0x4682860)', 'start_from', 'definition_context', 'HASH(0x78d0338)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Meta/Class.pm line 573 Moose::Meta::Class::add_attribute('Moose::Meta::Class=HASH(0x4682860)', 'start_from', 'definition_context', 'HASH(0x78d0338)', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose.pm line 77 Moose::has('Moose::Meta::Class=HASH(0x4682860)', 'start_from', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at /usr/lib/perl5/vendor_perl/Moose/Exporter.pm line 405 Moose::has('start_from', 'is', 'ro', 'coerce', 1, 'isa', 'LedgerSMB::DBObject::Date') called at LedgerSMB/Report/Contact/History.pm line 275 require LedgerSMB/Report/Contact/History.pm at LedgerSMB/Scripts/contact_reports.pm line 19 LedgerSMB::Scripts::contact_reports::BEGIN at LedgerSMB/Report/Contact/History.pm line 0 eval {...} at LedgerSMB/Report/Contact/History.pm line 0 require LedgerSMB/Scripts/contact_reports.pm at (eval 453) line 1 eval 'require LedgerSMB::Scripts::contact_reports;' at lsmb-request.pl line 103 LedgerSMB::Handler::try {...} at /usr/share/perl5/vendor_perl/Try/Tiny.pm line 81 eval {...} at /usr/share/perl5/vendor_perl/Try/Tiny.pm line 72 Try::Tiny::try('CODE(0x467bb18)', 'Try::Tiny::Catch=REF(0x4426f40)') called at lsmb-request.pl line 120 LedgerSMB::Handler::call_script('contact_reports.pl', 'LedgerSMB=HASH(0x43b44e8)') called at lsmb-request.pl line 84 require lsmb-request.pl at /opt/ledgersmb/contact_reports.pl line 8 Compilation failed in require at LedgerSMB/Scripts/contact_reports.pm line 19. BEGIN failed--compilation aborted at LedgerSMB/Scripts/contact_reports.pm line 19. Compilation failed in require at (eval 453) line 1.

dbversion: 1.4.0, company: ChilliTronix

I've just downloaded from SVN.

Kind regards

Benedict White

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Max van Biezen | 23 Mar 12:15 2014
Picon

how to add/set company contact name and write to invoice

Hi,

On the invoice I want to have a line with "attention to" if it has a
value. In LSMB 1.2 this was fairly straightforward by adding a name in
the field contact of a company.

In LSMB 1.3.38 I have not managed yet to set a value on the printed invoice.

In the invoice.tex file there is:

<?lsmb IF contact ?>
   <?lsmb contact ?>
<?lsmb END ?>

Where is invoice.tex supposed to get value "contact" from?

I tried the following:
I added a "Billing contact" to table contact_class, and gave that
value some contact person in a company.  Then I have manually set:

INSERT INTO company_to_contact VALUES (7, 18, 'name of contact ',
'some description');

 Table "public.company_to_contact"
      Column      |  Type   | Modifiers
------------------+---------+-----------
 company_id       | integer | not null
 contact_class_id | integer | not null
 contact          | text    | not null
 description      | text    |

Yet when printing the invoice the contact name does not appear. I read
the manual but it only mentions contact_class. How to write/set value
of "contact" with a contact?

Regards,

Max

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech

Gmane