Sage 100

 View Only
  • 1.  Script to copy required date from another sales order

    Posted 03-21-2026 11:56

    Hi Folks
        I need to write a script to copy the Ship/Expire Date from an existing Sales Order to a new sales order.   The Copy function in Sales Order does not copy that value and the client needs it to be the same as the original order.  I am not sure how to go about searching for the Sales Order to copy from. I have been trying to use the "CopyFromOrder" but I am not getting the order # using it in order to find the original order.   Client is on 2024 Advanced 32bit

        I believe I am overthinking this somehow so any thoughts would be appreciated. 

    Thanks much!



    ------------------------------
    Bob Osborn
    Senior Consultant
    DSD
    7142645278
    ------------------------------


  • 2.  RE: Script to copy required date from another sales order

    Posted 03-21-2026 19:42

    Hi All,  @Jim Woodhead got me pointed in the right direction.   Created a date UDF that is sourced from the ShipExpiredate from the order when it is copied.  Then setup a pretotals script to populate the ShipExpireDate in the new order with the value from the UDF.



    ------------------------------
    Bob Osborn
    Senior Consultant
    DSD
    7142645278
    ------------------------------