#1068 Sales Invoice missing from search

[John Locke]

Ok. Not quite sure what's up, but an invoice I just created does not appear in a search. Here's what I did:

1. Open an existing sales order.
2. Put in a partial amount in the "ship" column, click "Sales Invoice." This appeared to generate the correct sales invoice, with the qty entered, notes and other fields populated.
3. I clicked Save.
4. I clicked "Post as saved." Got a confirmation message, but not the invoice -- so I could not go to the email step.
5. Checked the original sales order, and it was correctly re-saved with the remaining qty available.
6. Searched for the new sales invoice, but it did not come up in a search, by vendor, open or closed, or invoice number.

Invoice is in the database, at least in acc_trans and ar. I opened the transaction by direct URL - is.pl?action=edit&id= (trans_id found in the db). Invoice looks correct, except that the "Notes" field is now empty.

[John Locke]

I can reach the invoice by going to General Journal -> Chart of Accounts -> Accounts Receivable. This invoice does show up twice -- once with the balance, and once with zero -- it looks to me like the invoice includes a blank line item that's also getting logged in AR.

Also the "period" selection on GL reports are ignored.

[John Locke]

After comparing the row in AR with others, I noticed that the "person_id" column was null. Setting that to a valid person_id made the invoice show up in search results.

[John Locke]

This issue also affects new sales invoices without going through the "ship" process.

[Chris Travers]

svn 6868