Sage 100

 View Only
Expand all | Collapse all

UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

  • 1.  UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-13-2023 13:31

    Sage 100 2022.2 Premium.  UDF on CI_Item, used only on msic items and charges, is set to come over into SO_SalesOrderDetail.  Sometimes it does, sometimes it does  not.  It is not specific to any one item.

    HAs anyone seen this (mis)behavior/have any idea how to correct?



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------


  • 2.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-13-2023 13:34

    If you are using a Copy From function, those events don't work the same way.  Check tab 3 of the UDF setup to make sure you set it up for those sources...



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



  • 3.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-13-2023 13:35

    Hi - if the sourcing is not right, it may not come over when an order is copied, etc.

    Jeff



    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------



  • 4.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-13-2023 13:39
    --

    Friendly Systems, Inc.

    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free.www.avg.com





  • 5.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-13-2023 14:53

    Thanks All.  I think that is it.  Need to wait until everyone goes home tonight to actually fix it.

    Phil



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------



  • 6.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-13-2023 14:54

    This can be moved out of urgent



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------



  • 7.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-14-2023 09:39

    Unfortunately not solved  the copy is now checked, but there were two more orders where the UDF did not come through as it should this morning.

    Any other ideas?



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------



  • 8.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-14-2023 09:53

    Does this happen for all new orders, or can you narrow it down to a few orders and see how they were created?



    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 9.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-14-2023 10:55

    Was the UDF resized by any chance?  Perhaps some values won't "fit" into the SO field, if only the CI_Item field was made bigger.



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



  • 10.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-14-2023 13:02

    UDF is Y/N.  So far today it only went wrong on 2 out of 60 (there were mote than 10 yesterday morning) but it should be 0...



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------



  • 11.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-14-2023 13:14

    Is the UDF in CI_item populated for Y?N for all misc items?



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 12.  RE: UDF from CI_Item (sometimes) not coming through to SO_SalesOrderDetail

    Posted 04-14-2023 15:04

    Yes it is populated for all



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------