Error when choosing and saving products

Support
1

Hello.
I hope someone will be able to help me with this. I am a long-time InvocePlane user and this is first time I encounter error.

The error started in version 1.6.1. and after updating to 1.6.2, the error still exists.
When I create an invoice, I go to the list of previously entered products. I chose a few products, and when I try to SAVE it, I get an error, and the invoice is not saved.

Thank you in advance for your help.

1 Like
2

Hi @Vedran_Hasanagic, welcome.

This is the error in the log:

Query error: Column 'item_tax_rate_id' cannot be null - 
Invalid query: 
INSERT INTO `ip_invoice_items` (
`invoice_id`, `item_product_id`, `item_name`, `item_quantity`,
`item_price`, `item_discount_amount`, `item_tax_rate_id`,
`item_description`, `item_product_unit_id`, `item_order`, 
`item_product_unit`, `item_date_added`
) VALUES (
'redacted', 'redacted', 'redacted',
'redacted', 'redacted', NULL,
**NULL**, 'redacted', NULL,
redacted, NULL, 'redacted'
)

Can you see if you accidentally have forgotten to fill the tax rate for your invoice?

3

Hello.

This installation of InvoicePlane is for a small business where tax is already included in the final price, so there are no tax rates. It was set like this for almost a year without a problem.
However, I think I solved the problem of changing the language to English and then back to Croatian, under the General Tab in System settings.
Looks like all is OK now.

Thank you for helping. I will report if the error comes back.

Great software by the way. We have been using it for more than 10 years in two separate installations.

2 Likes