AP Check selection displays duplicate phantom invoice

SOLVED

Sage 100 2021 PU3 Advanced.

After selecting vendor invoices for payment, then going into the check maintenance window, duplicate invoices display. However, the invoices are only entered / posted once. If the phantom invoice is not removed from the check maintenance screen, the total of the check is the sum of all invoices including the phantom invoice. Therefore, double paying vendors.

After removing the phantom invoice and going into the vendor inquiry, the "duplicate" (phantom) invoice is not found. The duplication only happens at the time of payment selection and are seen in the maintenance window.

Has anyone experienced this?

We are not sure if it is a bug or a corrupt table / file. 

Note: This was also happening on 2021 PU2.

Thank you!

  • 0

    Are they always the same invoices?  have you cleared invoice payment selection and then looked in the file via DFDM to make sure their are not still records?

  • 0 in reply to Bvulliamy

    Thank you for your response. Before running a payment selection, I checked to be sure the check files were empty. I ran a selection, but could not get it to duplicate. Client states this is random. Its never the same vendor nor invoice(s). I have requested that the next time this happens, they need to get me on their system.

    Hoping this isn't some kind of virus or malware on the server.

  • 0 in reply to WDGorski

    I'd consider rebuilding key files for AP... and querying AP_OpenInvoice for bad data.

  • +1
    verified answer

    A defect similar to what you described has been fixed recently.

    After checks are generated by payment selection, bring up a check entry in check maintenance.  Click a detail row in the grid that has an invoice number.  Then click the Select Invoice button to add a new invoice to the check. The invoice number on the selected row in the grid is duplicated on a new line.  The invoice selected from the pop-up window is added to another new row.

    The fix will be included in 2021 PU4.

    Do you sometimes use the Select Invoice button to add invoice to a check?