Invoice Report written in Open Source (iReport or like) w MySQL Backend

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Other - Software Development Posted 2 years ago

Fixed Price

Delivery by July 24, 2014




BACKGROUND: I am a small IT Service Provider. I have created my own PSA with a MySQL Database database with webfront end using Maestro PHP Generator and WP.  This works seamlessly.

MY NEED: I need to have an invoice report created with "Open Source" software such as iReport Designer by Jaspersoft Reports .  I do not need a report server but simply some way to generate the report and export as PDF or Excel. I have played around with iReport and been able to create some small reports but don't have the time to learn it or create professional looking invoice. If you know of a better Open Source solution we can talk about that as well.

INVOICE REPORT:  My MySQL structure is as follows-  

Tables:   Invoices, Tickets, Labor, Expenses.
Relations:  Invoices contain Tickets which contain Labor & Expenses.

The Invoice report will contain all Tickets linked to that invoice and the labor & expenses linked to those tickets along with a total.

The Invoice will look like:

Company Logo  & Info

Client Info

Invoice #                         Invoice Description

    Ticket # 1
         Expense # 1              Description             Amount (calculated)
         Expense # 2             Description             Amount (calculated)
         Labor # 1              Description             Amount (calculated)
         Labor # 2               Description             Amount (calculated)
    Ticket # 2
         Expense # 1              Description             Amount (calculated)
         Expense # 2               Description             Amount (calculated)
         Labor # 1              Description             Amount (calculated)
         Labor # 2              Description             Amount (calculated)

                                                   TOTAL INVOICE AMOUNT     XXX

The only parameter needed is "InvoiceName".

About the Client

(5.00) 12 reviews

United States
Garden City 04:53 PM

29 Jobs Posted
69% Hire Rate, 1 Open Job

$3,105 Total Spent
20 Hires, 0 Active

$18.61/hr Avg Hourly Rate Paid
103 Hours

Member Since Jan 22, 2013