On Wed, Sep 27, 2006 at 10:39:43AM -0500, Dirk Enrique Seiffert wrote:
> I would like to add a variable in the descriptive field invoices. Some
> examples:
>
> I charge a monthly fee for an internet connection. The service description
> would be: "Internet 1 month" - I would like to see on recurring
> transactions "Internet September", "Internet October" or "Internet
> 15/09/2006-14/10/2006", "Internet 15/10/2006-14/11/2006" etc.
>
> Another example: A cliente is buying a computer in monthly rates. I would
> like to se "Monthly rate Computer, 1 out of 12", "Monthly rate Computer,
> 2 out of 12" etc.
>
> Does anybody know how to do this? Can I put variables in the service
> descriptions?
We have the same need. Here's what I did:
- generate invoices for the month.
- run a sql statement to update invoice notes field on all
invoices with today's date, putting in the "For service
period starting ..." info specific to the invoicing period.
I originally wanted to put the date info in the line items, but
the above approach was much simpler. So line items would say
Basic Hosting (example.com) EA 3 $10.00
and then the notes field defines the service start date. This
way I avoid having to calculate service end dates, which vary
based on billing term customer has selected.
m
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sql-ledger-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
