Sage 100

 View Only
  • 1.  Inserting a UDF into the product line file, then l

    Posted 03-25-2013 13:08
    Inserting a UDF into the product line file, then linking to the CI_item table. Has anyone tried this successfully. I am trying to pull values that differ by product line into the item master. Will be a project for tonight.....


  • 2.  RE: Inserting a UDF into the product line file, then l

    Posted 03-25-2013 13:39
    Use a table - that worked.


  • 3.  RE: Inserting a UDF into the product line file, then l

    Posted 03-25-2013 14:28
    Are you saying use a table in item master and select when setting up a new item.


  • 4.  RE: Inserting a UDF into the product line file, then l

    Posted 03-25-2013 14:33
    I don't understand the question. You say you are trying to pull values into the item master by putting a UDF into Product Line. Huh?


  • 5.  RE: Inserting a UDF into the product line file, then l

    Posted 03-25-2013 14:42
    I can't say it any clearer then you..... Will the value of the UDF in the product line populate the item master when a new item is entered and the product line is selected to populate the other default values from the product line?


  • 6.  RE: Inserting a UDF into the product line file, then l

    Posted 03-25-2013 15:05
      |   view attached
    Yes, if it's sourced from the product line file. See the attached image


  • 7.  RE: Inserting a UDF into the product line file, then l

    Posted 03-25-2013 15:20
    I tried it that way @MichaelNottoli and it did not populate the field in CI _Item. So what I am saying is create a UDT for the prod line and then pass it to the item. That worked for me.