#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

    John Locke - 2014-02-13

    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

    John Locke - 2014-02-13

    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

    John Locke - 2014-02-13

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

    Last edit: John Locke 2014-02-13
  • Chris Travers

    Chris Travers - 2014-02-17
    • status: open --> closed-fixed
  • Chris Travers

    Chris Travers - 2014-02-17

    svn 6868


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks