Scripting

  • 1.  v2015.3 Is a Script possible for the following?

    Posted 03-01-2016 13:26
    v2015.3 Is a Script possible for the following? Client uses Auto-generation of PO's from S/O (via Generate button on S/O Entry>Totals screen). They have a S/O line item UDF for Unit Cost that they manually populate at time of S/O Entry. They just upgraded from 4.30 where they had Ext Sol PO-1020 'Purchase Orders Created from Sales Orders', _**which provided the ability to have the UDF Unit Cost data populate the PO**_, rather than the PO just picking up the item unit costs based on standard Sage 100 programmatic logic. Can a Script be created to replicate this?


  • 2.  RE: v2015.3 Is a Script possible for the following?

    Posted 03-01-2016 13:45
    Yes - I have done something very similar for a customer. You need to populate the unitcost field on the sales order item, and then make sure you have your settings on the PO creation sides set properly so it takes that info from the SO.


  • 3.  RE: v2015.3 Is a Script possible for the following?

    Posted 03-01-2016 16:06
      |   view attached
    I solved this by creating a UDF on PODetail and sourcing it from the ""create from Sales Order"" UDF on SO Detail. I then created a script on the PO Detail PreWrite to replace Unit Cost with this UDF. Works great.


  • 4.  RE: v2015.3 Is a Script possible for the following?

    Posted 03-02-2016 14:38
    Pretty sure this is standard, per Phil's suggestion.