Simple Invoices - Forum

Hey Prins,

there no way at the moment to do this - though i do have plans to make an optional timesheets module for Simple Invoices to do this type if thing

the only workaround i can think of is

1 - create products for each personnel (with appropriate charge out rate )
2 - create an itemised or consulting invoice
3 - select the company to bill
4 - select the personnel from the products drop down and enter the number of hours to bill

if you know PHP im sure theres a way to hack Simple Invoices to read the info from your system
- you could change products to point to your list of personnel and youd need to hack a new invoice screen to auto draw the number of hours based on person and customer selected

if you want to go ahead with hacking Simple Invoices to suit your needs feel free to post here for help etc..

let me know what you do - i would be interested in seeing if you can integrate Simple Invoices into your organisation

Cheers

Justin

Well Justin, thx for your answer. What you are saying I already thought about.

So what I wanted to do is set the table of my personnel into the itemised product screen. Then of course put in their rates. But the tricky stuff here is how to get my total week hours per employee and company in to that invoice screen. I have not looked in it to deep yet, but can you give me a start in what tables the info for proucts and companies is stored? are they depending on cross tables or are these standalone?
And the invoice screen ... is this also depending on something that I must be aware off?

I think this weekend I'm going to strip the script and play around with some things. Hoping that I can achieve my goal. You will certainly here from me when I get this far or need some help.

re tables
- there all pretty much standalone tables except for the invoices table which is split in 2
-- si invoices and si_invoice_items
- note: si_invoices which contains the main info for the invoice contains customer_id, biller_id etc so they have to match whatever you doing etc..

re invoice screen
- mainly just draws the info out of si_invoices, si_invoice_items, si_products(for the names etc.) and the biller and customer tables for names and address etc..

hope this helps!

Cheers

Justin

[quote=prins]
Hi there, I found this script and tested it out. It works perfect. Now what I like to know is that if it's possible to use data from another table to create the invoice. Let me explain my goal:
I have an application where companies log in and put in the working hours of my detached personel. This will give me a total of worked hours per week per company and per employee. These weekly totals I would like to bill in an easy way. So you guess what I want. I want the total week hours per employee and company to work together with this beautiful invoice script. Does anyone know if this is possible??? And when it is of course please tell me how...


I suppose if you import your data into the mysql database and then create a view to replace your tables your should be able to pull the data in, I often do this to migrate databases