PDA

View Full Version : Add Custom field to the invoice table



Fonix
09-05-06, 09:12 PM
I would like to request a custom field in the invoice table to save special a invoice ID that we need print on the invoices before we send the invoice to the customer.

The customers are using this special invoice ID as reference when they pay the invoice through their bank.

At the end of the day we get a special transcript file from our bank. This data file shows all payments that have been made to our account, the payments are referenced by the invoice ID that we put on the invoices. By importing this file into our accounting system we are able to mark all these invoces as paid in one single batch.

Is it possible to add an extra field in to the invoices table, so people who need this feature might want to use it?

We can not use one of the existing numbers becuase we need to add a verification digit at the end of the number using mod 10 or mod 11.

There are many other countries in Europe who has similar systems for collecting payments.

Matt
09-05-06, 10:03 PM
Hi,

You can do this by creating your own payment gateway. You can then calculate a reference number based on the invoice id using PHP coding. Email [email protected] for the bank transfer gateway to use as a template.

Matt