Sage 100

 View Only
  • 1.  Lasy Purchase History Lookup not working in 2023/2024

    Posted 09-30-2024 09:13

    JUST had a new conversion report this this morning and I looked on Sage's website and they had an article - date Friday.  So close...

    Anyway, not working at all, even if you customize it.

    Looking at the SY1Q02 file there are some weird differences, but haven't tried making mods yet (why not, doesn't work anyway...)



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------


  • 2.  RE: Lasy Purchase History Lookup not working in 2023/2024

    Posted 09-30-2024 09:37

    Hmmm - working in mine...



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 3.  RE: Lasy Purchase History Lookup not working in 2023/2024

    Posted 09-30-2024 10:27
      |   view attached

    I KNEW this sounded familiar, so I went searching my old notes and found this from December of last year. I hope it helps. 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 4.  RE: Lasy Purchase History Lookup not working in 2023/2024

    Posted 09-30-2024 11:08

    Unfortunately, it's not quite the same.  They didn't start with a custom lookup - it's the standard one.  I tried creating a custom one, and still nothing.  Thinking about adding a UDF to the file tonight when they're off and seeing if that helps.  



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 5.  RE: Lasy Purchase History Lookup not working in 2023/2024

    Posted 09-30-2024 10:45

    x-reference to Sage KB ( 9/27/24) which doesn't contain a solution but notes the issue - Customer/Item Last Purchase History in Sales Order is blank after upgrading to Sage 100 2023 or 2024



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 6.  RE: Lasy Purchase History Lookup not working in 2023/2024

    Posted 09-30-2024 11:16

    Beth, 

    I assume you have looked at the SO_CustomerLastPurchaseHistory table and see records there?  When it happened to me, I did see records in it, but there is a way to repopulate the tables if it got wiped out, (I'm guessing you already know that though) 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 7.  RE: Lasy Purchase History Lookup not working in 2023/2024

    Posted 09-30-2024 11:48

    Yep, they've got records, and they've got record for this particular customer.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 8.  RE: Lasy Purchase History Lookup not working in 2023/2024

    Posted 09-30-2024 19:24

    So I reinstalled 2024 and .1 - still not working.

    Created a UDF and added it to an ALE I created using the CUSTOM button - still not working.

    Went to the User Lookup Wizard and created a custom lookup for EVERYONE and... it's working!!!!



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------