Sage 100

 View Only
  • 1.  Scripting Sage 100 Invoice Data Entry Details

    Posted 04-01-2020 14:44
    Edited by Marc Cregan 04-01-2020 14:44
      |   view attached
    Hi there,

    I have a site that wants to verify quantities on hand when the user ships/invoices an SO.  I am trying to figure out how to grab the quantities when you click the LINES tab of the Invoice Data Entry Screen and it asks if you want to ship the complete sales order.  I have my script firing on Column Post Validate Quantity Shipped.

      If I answer YES to ship the complete sales order, the script does not appear to fire. 

    If I click NO and then manually key quantities it works just fine. 

    Is there an event or way to do quantity checking when clicking YES to ship the complete sales order?

    Any ideas?

    Thank you, Marc

    ------------------------------
    Marc Cregan
    Technology Integrators
    ------------------------------


  • 2.  RE: Scripting Sage 100 Invoice Data Entry Details

    Posted 04-01-2020 14:54
    Table Pre-Write on the Detail object should fire off your script regardless whether you answer Yes or No. That should do it. I think you can also set the internal Ship Complete flag while you're on the Header or Address tab so you don't get prompted to begin with.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------