Sage 100

 View Only

  • 1.  BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-26-2021 13:00
    Client want to create a Lot # description during BOM production Entry that will flow to the IM_ItemCost table (and beyond).  I've created a UDF in the production entry header (where lot number originates) and have created subsequent UDF's that I thought would result in an entry in the IM Cost table.  Tested by doing a production entry for lot item, added test to the UDF and completed/updated.  The hoped fol data did not appear.

    I could not find a UDF mapping for BOM production UDF to IM_ItemCost.  I think I am missing the second UDF flow (transaction Udate table??) but nothing appears obvious.  BOM production update use IM transaction update table?

    TIA​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-26-2021 13:17
    As a general strategy I start with the destination, and work backwards through the business objects to see if the data flow path I want is available.

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



  • 3.  RE: BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-26-2021 17:57
    @Jeff Schwenk we have a client on v4.5 for whom a set of UDFs were built for Expiration Dates.  The problem we ran into was when an expiration date UDF was populated for an item that was then used as a component in a parent BOM, the component UDF value was wiped out.  It required custom programming to solve the problem of updating both the Parent Lot# (Header) and Detail UDF (Component).  The data source for updating IM_ItemCost and IM_LotSerialTransactionHistory is BM_ProductionTierDistribution.  Let me know if you'd like additional details.​

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


  • 4.  RE: BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-26-2021 18:12
      |   view attached
    @Kevin Moyes - Good idea, but did not produce the desired results.  See attached PDF for screen shot​.  Any chance IM transaction update might be involved???  Or am I just pulling from wrong tables.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Attachment(s)

    pdf
    Lot Sn description UDF mapping.pdf   88 KB 1 version
    Original Message


  • 5.  RE: BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-26-2021 19:05
    Ignore the register work table... that only matters for the printout, not the data flow.
    Look at the drop down in IM_ItemCost for the BM production business object.  You can see a different option listed as data source.

    Looking at IM_TransactionPosting, there is a data flow from the BM production header.  Try this as a middle step.


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

    Original Message


  • 6.  RE: BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-26-2021 20:06
    Success!  As I suspected and @Kevin Moyes confirmed, bill of material production entry update uses the Im_transaction posting table to flow information to IM_itemcost.  Looking at the big picture, this would seem to make sense, but you can't stay focused on the BM tables entirely. 
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 7.  RE: BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-27-2021 05:14
    Once you get into the definition of the UDF, you can select to map the values from many different sources if needed, on the Data Sources tab.

    ------------------------------
    Amber Prayfrock, Blytheco
    ------------------------------

    Original Message


  • 8.  RE: BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-28-2021 10:07
    After getting the UDF to appear in the item cost table, the next challenge is to display the data in a comment like window.  Would this be possible with a script?  Highlight the line in question, then click a script button to open the comment.  The information needs to appear as separate line as a cntl enter line break code was entered in the UDF.



    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 9.  RE: BOM Production Entry Header Lot # description UDF flowing to IM_ItemCost table v2021

    Posted 08-29-2021 09:55
    It is possible with a button script.  You can use the oSession's UI object's MessageBox method to display multiple lines of text.  The method will line break on the SEP character, backslash, and regular CR+LF.  You'll need to parse the contents of the currently selected row in the list box though.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


Related Content