<![CDATA[FrontAccounting forum — delivery has been invoiced, but there is no invoice]]> https://frontaccounting.com/punbb/viewtopic.php?id=8316 Sat, 03 Aug 2019 00:23:24 +0000 PunBB <![CDATA[Re: delivery has been invoiced, but there is no invoice]]> https://frontaccounting.com/punbb/viewtopic.php?pid=35606#p35606 I voided the delivery note, that restored inventory.  I could/can not void or cancel the sales order, canceling the order says it cancels undelivered parts, but the whole order is still listed.  But redid the invoice as a direct invoice and it worked this time.  crisis averted.

]]> Sat, 03 Aug 2019 00:23:24 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=35606#p35606 <![CDATA[delivery has been invoiced, but there is no invoice]]> https://frontaccounting.com/punbb/viewtopic.php?pid=35603#p35603 Today I was creating a direct sales invoice.  I got an error 1406 or something about data too long, so I chased that down and updated the column field in the sales_orders table from tinytext to mediumtext.  when I processed the invoice, it actually came up to the sales order screen saying that the sales order had been processed.  So from there I decided to make a delivery, and got the same error which I fixed by changing the memo_ column in the comments table from tinytext to mediumtext.  After that I was able to process the dispatch, but when I went from there to generate the invoice I got the following error in the red bar:

Undefined index: debtor_no in file: /var/www/fa.computerisms.ca/sales/includes/sales_db.inc at line 282

along with the message

This delivery has all items invoiced. There is nothing to modify.

If I go to print the invoice it doesn't exist, if I go to customer payments, the invoice is not listed to be paid; there is no place I can find the invoice exists, but items have been removed from inventory.  Additionally, if I go to print the delivery, all I get is the comments, none of the items are listed. 

This particular invoice had about a dozen line items, but I sent out about a dozen of them prior that had one or two line items with no problems.

Does anyone have any idea how I can fix this without undoing the whole day's work by restoring from backup?

]]> Fri, 02 Aug 2019 22:15:27 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=35603#p35603