Sage 100

 View Only
  • 1.  Price Lookup Script

    Posted 05-03-2023 10:28

    I am trying to create a script on the Item Price Lookup screen but can't seem to attach it anywhere that will work.
    The script looks at the Customer No & if that customer is on Credit Hold, displays a warning.
    However, I've tried a UI Script on the dPriceLookup panel, but there is not enough info yet when it loads to fire accurate info. My debugging shows blank data because it fires before I can key in the Customer No.
    I tried using the IM_PriceCode table, but there is no Customer No field to do a column post-validate. I tried other events on this table, but nothing kicks it off.

    I need to be able to kick it off after keying in the Customer No. Or, they would settle for after keying in the quantity. I can't seem to get to anything that will help.
    This seems to be a tricky place. Any suggestions?



    ------------------------------
    Dana Young
    Lehman Wesley & Associates
    ------------------------------


  • 2.  RE: Price Lookup Script

    Posted 05-04-2023 08:02

    Bummer, I don't see a way to trigger a UDS from those fields either. Could they live with a button script?



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 3.  RE: Price Lookup Script

    Posted 05-04-2023 11:32

    Table pre-write, with a Yes/No prompt to continue with the save?  (No >> SetError).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------