Sage 100

 View Only
Back to discussions
Expand all | Collapse all

UDFs and/or Scripts with DSD Multi-Bin Basic

  • 1.  UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-25-2025 16:35

    I have UDF values that are collected along with lot numbers. I've added the UDFs to all the various tables including the multi-bin tables (SO_InvoiceTierDist AND MB_SOInvoiceTierBinDist) for every single module. The UDF values are supposed to end up in IM_LotSerialTransactionHistory and for most of the modules they do.  All the UDFs are created the same and mapped the same but only UDF values from PO Receipt of Goods, Inventory Transaction Entry, and Bill of Materials successfully make it to the IM_LotSerialTransactionHistory. PO Return of Goods and SO Invoice don't make it. I can see in DFDM that for PO Return and SO Invoice the MB tables have the UDF values but the "normal" distribution tables don't. The UDFs in the "normal" distribution tables are supposed to get their values from the MB distribution table but for PO Return and SO Invoice it doesn't work. Has anyone seen this before?  In an effort to make the "normal" distribution table get its value from the MB table I've been experimenting with a script but trying to call MB_SOInvoiceTierBinDist_Bus isn't working for me. So maybe someone has scripted with the MB tables before? Thanks for any guidance anyone may have!



    ------------------------------
    Kate Krueger
    Consultant
    MicroAccounting
    214.800.5555x553
    ------------------------------


  • 2.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-25-2025 17:37

    You have the UDF value flowing into the transaction tier table, from the LotSerialNo (which should pull in the UDF value from IM_ItemCost)?



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



  • 3.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-25-2025 17:41

    Scripting tips here:

    https://community.90minds.com/discussion/anyone-see-scripting-conflicts-with-tier-distribution-using-scanforce-multi-bin



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

    Original Message


  • 4.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-25-2025 18:27

    I've never seen this before but when I click on the link you provided it shows me this:



    ------------------------------
    Kate Krueger
    Consultant
    MicroAccounting
    214.800.5555x553
    ------------------------------

    Original Message


  • 5.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 07:41

    I get the same message – You are not eligible to view this message

     

     

     

    **************

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

    A black background with white text Description automatically generated

     




    Original Message


  • 6.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 08:30

    @Anne Sawyer Can you see why we can not use this link Kevin provided:  https://community.90minds.com/discussion/anyone-see-scripting-conflicts-with-tier-distribution-using-scanforce-multi-bin

    Is it taking us to a community we have not been invited maybe?  I can't tell where this posting originated.  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 7.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 10:43
    Edited by Kevin Moyes 09-26-2025 10:45

    It's in Scripting...

    It doesn't look like many people have joined that community...



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

    Original Message


  • 8.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 12:15
    Edited by Eric Lunceford 09-26-2025 12:18

    Because we can't see a Scripting community. 

    That thread doesn't come up in search either. 

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------

    Original Message


  • 9.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 12:26

    Click Communities - All Communities...



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

    Original Message


  • 10.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 12:30

    I just message @Anne Sawyer on this @Kevin Moyes.  Many of us can't find the Scripting Community under "all communities" at this time so she will research and look to get it back for us.  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 11.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 12:35

    OK. 

    For me it shows as 2nd to last in the list.



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

    Original Message


  • 12.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 12:42

    Hi everyone - you all should see the Scripting Community now - but may need to request to join.  Thanks!



    ------------------------------
    Anne Sawyer
    Executive Director
    90 Minds Inc.
    Sunset Beach CA
    ------------------------------

    Original Message


  • 13.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 12:42

    Thank you @Anne Sawyer for tweaking and marking that community as available for everyone to see.  Just refresh your screen and use the "All Communities" to find the scripting group and choose the "request to join" button to be added to that community.  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 14.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 10:49

    The "gold" in that thread is a link to a post by David showing how to find object names within enhancements:

    https://communityhub.sage.com/us/sage100/f/business-object-interface/126277/is-there-any-way-to-use-the-boi-on-modules-not-created-directly-by-sage/336706#336706 



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

    Original Message


  • 15.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 11:23

    Thanks so much! the object is olines.tierbindistribution for anyone searching this in the future.  The next hurdle is the actual copying of the UDF value from the MB table to the normal Distribution table. Debugging shows that it correctly opens the MB table, gets the value and then it thinks it writes it to the normal distribution table. Retval=1 on the write and all should be sunshine but the value in the normal table is still 0. What's extra weird is if I save the invoice, go back in and trigger a change and save it the script runs and successfully updates the value on the normal table. So the script will work, just only for existing records and not new ones. I've messed with the execution points (pre-write, post-write, pre-delete, UI script, column post validate). This one makes my brain hurt all because the UDFs won't pass their values for two modules. 



    ------------------------------
    Kate Krueger
    Consultant
    MicroAccounting
    214.800.5555x553
    ------------------------------

    Original Message


  • 16.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-26-2025 11:51

    Make sure your objects are opened from oLines (which works for new / unsaved data), and not through a new object opened using the business object (which can only access data that is already saved).



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

    Original Message


  • 17.  RE: UDFs and/or Scripts with DSD Multi-Bin Basic

    Posted 09-25-2025 18:26

    Hi Kevin! The UDF is gathering data entry on the distribution screens where users choose which lot number and bin. It isn't sourced from the IM_ItemCost table. It can't source from IM_ItemCost because it could be different for each transaction relating to that lot. That's why I need it in IM_LotSerialTransactionHistory. 



    ------------------------------
    Kate Krueger
    Consultant
    MicroAccounting
    214.800.5555x553
    ------------------------------

    Original Message


Related Content