Sales Tax causes a negative?

[tkintenn]

Several invoices show a negative balance. These were paid invoices from Invoiceplane with sales tax items. The negative amounts are exactly the sales tax.

I can reimport again, is there a way to fix this though?

[tkintenn]

Also, it appears that lines with discounts don't work properly.
For instance I have an invoice where there is a line with 4 items at 125. I discounted each item by 125, effectively 0.
That invoice in invoiceninja shows the line properly, $125 count at 4. But the line total is -125???

The original invoice is paid, but in invoiceninja it imported only as sent.

[turbo124]

@tkintenn when i first wrote this tool, Invoice Ninja didn't support line discounts hence when you may be seeing an issue with this, i'll try an get around to putting in a fix for this

[tkintenn]

What's odd is i deleted the information in the line, re-typed it and had the same result. I'm guessing there is something i'm not seeing happening on the backend.

That would be awesome if you got a fix for it.

Any idea why the sales tax caused negative amounts?

[tkintenn]

update, the discounts look correct in the DB invoice_items table... they're populated correctly in the discount column.

[turbo124]

The sales tax issue may be due to the tax being inclusive vs exclusive of the line total... If you can send a sample data file to [email protected] , i'll try and see if i can fix this.

[tkintenn]

So the sales tax... it's because the line item sales tax didn't make it into the DB. It's been so long since i've looked at the invoiceplane DB not sure if it's even stored on each line item. However in invoiceninja db i looked at the lines for an invoice showing a negative. The balance is correct for the invoice but the line items all have nothing for tax_name1 and tax_rate1.

[tkintenn]

here's an example:
Screen shot is from Invoiceplane, code is json from export.
"product_key": "24in HD LED Monitor", "notes": "DVI HDMI VGA 250 Nit\n#D20042", "cost": "134.85", "qty": "2.00", "tax_name1": "", "tax_rate1": 0, "invoice_item_type_id": 1, "discount": 0

[turbo124]

@tkintenn if it isn't pulling in the taxes there must be something in the db structure that I haven't taken into account... as mentioned above, if you can provide a sample set of your db dump, i can load it locally and figure out exactly where the issue is.

[tkintenn]

@turbo124
How much of the dump do you need? It looks like the json creates a client and then subsequent invoices?