Sage 100

 View Only

  • 1.  v2019/2021 ADV AP Invoice Selection Panel for payments

    Posted 02-18-2022 01:04

    When using the AP selection register, client has one vendor that will NOT display ANY invoices to be paid.  Paid today flag in open invoice table is set to N.  I am displaying invoice to be paid based on due date.  There is no other filter in the selection process.  I am selecting invoice due to paid by 2/17/2029.  KB 110976 discusses vendor numbers having special characters.  The fix was to renumber the vendor.  This did not resolve the issue.  I copied data to their test v2021 install and converted.  Still an issue.  I entered a new invoice for the vendor via AP entry,  The new one did not appear on the selection list.  The invoices DO appear via the check payment maintenance.  I have rebuilt the sort keys, rebuilt the key files.

    Thoughts?

    TIA

     



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: v2019/2021 ADV AP Invoice Selection Panel for payments

    Posted 02-18-2022 07:40

    What about the "hold payments" flag in vendor maintenance?

     

     

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     






  • 3.  RE: v2019/2021 ADV AP Invoice Selection Panel for payments

    Posted 02-18-2022 10:28
    Good thought.  I failed to mention above that the hold flag was clear.  Client has resorted to manual check payments (not sure they are aware that check maintenance is a workaround as well.  Still looking for the root cause.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 4.  RE: v2019/2021 ADV AP Invoice Selection Panel for payments

    Posted 02-20-2022 22:30
    Check the invoice and due dates. I just had the same issue. In looking at the dates, a digit was missing, 02/10/202. Corrected in DFDM and it’s good again.

    ---------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ---------------------------------



    Original Message


  • 5.  RE: v2019/2021 ADV AP Invoice Selection Panel for payments

    Posted 02-21-2022 10:45
    Don't know if this will be of any assistance but maybe run Checkdate just for the heck of it.

    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    http://www.s-consult.com
    Schulz Consulting
    860-516-8990
    Moodus, CT
    ------------------------------

    Original Message


  • 6.  RE: v2019/2021 ADV AP Invoice Selection Panel for payments

    Posted 02-22-2022 20:43
    @David Overholt had the winning suggestion but probably not he envisioned.  After staring at the vendor table and open invoice table via and Excel Query export, it dawned on me that the value of the hold fields for a few records was a null (blank).  There were four vendor records with a null value and several open invoice records with a null record.

    Turns out, the filter in the selection panel is looking for an "N" in the hold payment field before displaying invoices for selection.  Change the value to the requisite N and all is well with selection.

    Have no clue how these fields had a null entry.​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content