BambooInvoice Forums

Quotation / Invoice

2010-03-07T04:11:28-05:00

Hi,
It would be useful to be able to classify the documents as quotes or invoices, If created as a quote, have the option to convert to invoice. Is there an easy way i could achieve this now by modifying the template?

Keep up the good work!

Removing the invoice name limit

2010-03-10T14:21:44-05:00

Is there a line I missed?

Currently Ive been saving them as 01 then editing the invoice title i will need for my paperwork, which normally looks like

07_05-16-2009_to_05-24-2009_CBHD

invoice number, start date, end date, business code for records searching.

Obviously it doesn’t fit the 12 or so character limit

Help! sudden database error

2010-03-10T13:40:16-05:00

Today I suddenly have the following error when I click “Invoice summary”

A Database Error Occurred

Error Number: 1030

Got error 28 from storage engine

SELECT bamboo_invoices.*, bamboo_clients.name, (SELECT SUM(amount_paid) FROM bamboo_invoice_payments WHERE invoice_id=bamboo_invoices.id) AS amount_paid, TO_DAYS(bamboo_invoices.dateIssued) - TO_DAYS(curdate()) AS daysOverdue, ROUND((SELECT SUM(bamboo_invoice_items.amount * bamboo_invoice_items.quantity + (bamboo_invoice_items.amount * bamboo_invoice_items.quantity * (bamboo_invoices.tax1_rate/100 + bamboo_invoices.tax2_rate/100) * bamboo_invoice_items.taxable)) FROM bamboo_invoice_items WHERE bamboo_invoice_items.invoice_id=bamboo_invoices.id), 2) AS subtotal FROM (bamboo_invoices) JOIN bamboo_clients ON bamboo_invoices.client_id = bamboo_clients.id LEFT JOIN bamboo_invoice_items ON bamboo_invoices.id = bamboo_invoice_items.invoice_id LEFT JOIN bamboo_invoice_payments ON bamboo_invoices.id = bamboo_invoice_payments.invoice_id WHERE `client_id` IS NOT NULL GROUP BY bamboo_invoices.id HAVING (ROUND(amount_paid, 2) < ROUND(subtotal, 2) or amount_paid is null) ORDER BY dateIssued desc, invoice_number desc LIMIT 5000

Bamboo for Hebrew users (Right to Left)

2010-03-10T09:28:50-05:00

Hello,

I think this is a great tool, thanks Derek.

I would like to use it with Hebrew language, and I need to:
1. make invoices and PDF’s horizontal mirrored (Hebrew is written Right to Left so exact mirror need to be done)
2. translate bamboo
3. add “Original” on originals invoices and “Copy” on copy invoices (customer get original and I keep copy).

I would like to have some help on what should I edit to achieve this,
(I added “direction:rtl;” under body tag in bamboo.css and the invoice looks good on screen but it not changed when covert to PDF.

Thx,
G

Rounding

2009-12-02T08:39:47-05:00

Hey,

First of all great program Derek, just spent a while looking around the forum and installing everything and running tests invoices.

I am running the program in GBP £ with a tax rate of 15% currently (VAT). Was there ever a fix for the rounding problems when working out VAT? For example if you were to run the settings above and create an invoice for:

3 items at £21.99 = £65.97
3 items at £16.99 = £50.97

The total will be £116.94
VAT will be £17.54

Therefore you would think that the combined total of these would be £134.48 however it is £134.49 on the actual invoice.

On the invoice summary page it does show as £134.48 though…

If I am honest I am not concerned about whether the script rounds up or down as long as it is consistent but how can one area of the program have a total of £134.48 (invoice summary page) and another have it as £134.49 (on the invoice view page)?

Also if the total on the invoice shows as £134.49 (which it does) then is it not possible to show the VAT with the extra 1p (i.e. £17.55 instead of £17.54) So that the totals tie up? But then the total on the invoice summary page would also need to match the actual invoice total too…

Does anyone know of any other ways around this problem other than not using calculations i.e. just basically entering one line per invoice with a quantity of 1???

All answers appreciated.

Thanks.

GET to /bambooinvoice/index.php/login not supported.

2010-03-09T22:58:53-05:00

Method Not Implemented

GET to /bambooinvoice/index.php/login not supported.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

X_x I just did like five new invoices and this happened

————————-

Edit: Problem on the hosts side, somehow the www became detached from my domain

Email subject - how do I include name of Client

2010-03-07T21:48:50-05:00

I would like to include the name of the client in the email subject. Right now the subject says “Email 1”. I would like it to say “Email 1 Client [Name]. What do I need to change in the script?

Thanks.

Installation error ;; controllers/install.php

2010-03-09T06:23:27-05:00

i have posted this earlier ,but no responce from anybody.

kindly help me…

I was trying to install a new version 089, but i am getting this as error:

A PHP Error was encountered

Severity: Notice

Message: Undefined property: Install::$validation

Filename: controllers/install.php

Line Number: 38

Fatal error: Call to a member function set_rules() on a non-object in C:wampwwwbambooinvoicebamboo_system_filesapplicationcontrollersinstall.php on line 38

your help is very much appreciated.
thank you

Support problem

2010-02-26T07:36:07-05:00

Hello everyone,

can any one tell me about the integration of bambooinvoice f it support http/XML (SOAP) based interface for integrations.
am waiting for the reply kindly help me in this regard.

thanks,
Farooq

Ticket System

2009-11-16T04:54:27-05:00

Hi Derek.

I would like to request a feature..

Ticket system built into BambooInvoice. Client section has been built already for BambooInvoice so it should be possible to add some sort of support ticket system.

I’m not sure the direction you see BambooInvoice heading but this would be a great addition to this incredible software.

Thanks again Derek for all your hard work.
Regards
Bryce