Owing – Issue with invoices

SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › Owing – Issue with invoices

Tagged: 

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • November 2, 2022 at 4:50 am #1808
    xpuser8334
    Participant

    If I look at MONEY > INVOICES – every invoice has an “Owing” Value of 0.00
    Even if it is a new invoice.
    If the invoice is for a repeat customer, any “Owing” amounts will be seen at the bottom of the Quick View of the invoice, but not in the Print Preview or the invoice itself – including the table of invoices.
    However; I can ONLY process invoice payment by going to the Quick View of the Invoice and Processing Payment there – any other way of Processing the “Owning” amount brings the screen which shows the owning amount is 0.00.

    Other than this, I can use everything.. but I have to go into each invoice to see any owing amounts.
    Patch Levels I am running are in the XLSX file attached to this post.
    Thanks In Advance

    Attachments:
    1. SimpleInvoices.PatchLevels.xlsx
    November 3, 2022 at 10:21 am #1810
    RRowley
    Participant

    The most likely case is that the si_invoices owing field has been zeroed out. You can set this field to 1 in records to force SI to recalculate the owing field for display purposes. It will also allow you to do payments from the invoice manage screen.

    This slows down processing as the owing value is recalculated for all invoices; paid off or not. If you enter the edit screen for invoices with payments due and save them without making changes, the owing field will be properly set. If you does this for all invoices that are outstanding, you can then change all those with an owing value of 1 back to 0 so they no longer force the recalculation.

    You can use phpMyAdmin to set the owing field to 1:

    UPDATE si_invoices SET owing= 1 WHERE 1

    Later you can use phpMyAdmin to set the owing fields with a value of 1 back to 0:

    UPDATE si_invoices SET owing= 0 WHERE owing = 1

    • This reply was modified 2 years ago by RRowley.
    • This reply was modified 2 years ago by RRowley.
    • This reply was modified 2 years ago by RRowley.
    November 25, 2022 at 4:16 am #1828
    xpuser8334
    Participant

    Thank you… I will make the change.
    Question – Do I need to change it back, or can I leave it changed?

    November 25, 2022 at 4:22 am #1829
    xpuser8334
    Participant

    I made the change, but the Owning still shows Zero.

    November 25, 2022 at 4:42 am #1830
    xpuser8334
    Participant

    Just done some screenshots after making the change and editing / saving an invoice.

    Sadly. this customer is now saying “the invoice shows 0.00 owing”
    even though the paid shows zero too !!

    Attachments:

    1. owing-issues.jpg

    November 27, 2022 at 7:10 am #1832
    RRowley
    Participant

    Not sure what is going on. There are a few things I’d like you to update to the latest SI version and check again. Likely won’t change anything but then we are working from common code. Let me know either way. If the problem still occurs, I’ll put together some changes to display data to try and drill into what is going on.

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.