invoice

What is the standard way to write a program to generate invoices?

Hi guys, I am building a billing system. The system needs to generate monthly invoices to Clients. What I am doing now is using a For loop to check all the clients their previous invoices and decide if it is the time to generate a invoice for the client. If there are huge number of clients in the database, I think it could be very ...

Submitting values of "jQuery Editable Invoice" into a MySQL DB using PHP

Hello Everyone, I am using this fantastic example of a jQuery editable invoice as a template for creating dynamic invoices for my users. It's working quite well and I am successfully generating the items but I now need to save the values entered into the various text fields and enter them into the MySQL database. I am confident in doi...

Best way or library to generate PDF format of invoices in Java

Hi guys, I am working on a project, one feature is to generate PDF format of invoices in Java. There seems to be many solutions, but I don't know which one is the best for invoices. Please advise, Thanks. ...

How to handle price fluctuations in an invoice application?

In an invoicing application, consider following: I have a products table that also contains the price of the product. And then I have an invoice and invoice_lines table and in each invoice line, I refer to the product id along with quantity. In this case, I am not storing the price of the product with the invoice line. Now few months l...

Database design for a small CRM/invoicing system

I'm currently developing a small customer relationship and invoice management system for my client. And I have run into some small issues which I would like do discuss. What is the best practice around orders, customers and products. Should my client be able to delete orders, customers and products? Currently I have designed my databas...

Magento: trying to add Coupon Name to PDF invoice

In basic PDF invoice, on only get discount total, no name in front. I got as far as to the coupon code showing, using: if($order->getCouponCode()!=""){ $this->y -=12; $page->drawText('Coupon Used: '.$order->getCouponCode(), 450, $this->y, 'UTF-8'); } but I can't find how to show coupon name. Also,...