Sage 100

 View Only

  • 1.  Button script to grab all serial numbers on SO Invoice

    Posted 08-30-2023 16:04

    I need to create a button script to pull the serial numbers into a text field. I have the loop to grab the line items working, but when I try to loop through the lot/serial distribution, I get an error. Maybe I am not calling it out correctly. Is there a command like oBusObj.Lines to grab the tier distribution per line on my active record or do I have to call out the whole "SO_InvoiceTierDistribution_Bus" & set key values??

    The error I get once it gets to the tier loop is 

    but I am not doing any kind of numeric expression. 

    I am just trying to gather QuantityShipped & LotSerialNo.

    I have a message box after the Line data & then after the Tier data. It returns the Line data to the message box but errors before it gets to Tier data. 

    Any thoughts or help would be appreciated. Thx! 



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


  • 2.  RE: Button script to grab all serial numbers on SO Invoice

    Posted 08-30-2023 16:15

    https://www.sagecity.com/us/sage100/f/business-object-interface/93781/inventory-adjustment-header-script-to-update-udf-s-in-transaction-tier-distribution-table

    If you're already in a Lines object, you'd go straight to oBusObj.Distribution



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



  • 3.  RE: Button script to grab all serial numbers on SO Invoice

    Posted 08-31-2023 12:58

    That did it! Thank you so much, @Kevin Moyes!! 



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

    Original Message


Related Content