Sage 100

 View Only
  • 1.  Would like to create a UDF to store a ""vendor exte

    Posted 01-19-2016 13:34
    Would like to create a UDF to store a ""vendor extended item description"", which is a vendor -specific description that will be used on vendor POs. Ideally, the UDF gets pulled into PO Detail for editing, then printed on a PO. The problem is, I can't use either IM_AliasItem or IM_VendorItem as a data source for pulling data into a PO Detail UDF. Anyone have a solution? The magic of scripting perhaps?


  • 2.  RE: Would like to create a UDF to store a ""vendor exte

    Posted 01-19-2016 13:37
    Scripting would be the way to go. I have done something similar on the sales order side.


  • 3.  RE: Would like to create a UDF to store a ""vendor exte

    Posted 01-19-2016 14:24
    Scripting would work, but if it's only showing on the PO, could you join the IM_AliasItem table to the PO Wrk table? On the PO form itself, I mean.


  • 4.  RE: Would like to create a UDF to store a ""vendor exte

    Posted 01-19-2016 15:45
    I could do that. If they want to edit the extended description in PO Entry. We need to verify if they want to edit in PO Entry.


  • 5.  RE: Would like to create a UDF to store a ""vendor exte

    Posted 01-19-2016 16:19
    How many vendors per Item? If only one, perhaps you can simply create a CI_Item UDF.


  • 6.  RE: Would like to create a UDF to store a ""vendor exte

    Posted 01-20-2016 11:46
    For the moment, going with adding the UDF to the VendorItem table and adding the table to the PO form. Thanks for the input.