Sage 100

 View Only

  • 1.  Physical Count by Primary Vendo

    Posted 10-24-2019 10:50
    Customer wants to do a physical count by primary vendor, which isn't available in the Worksheet selection panel. It appears to include UDF's from CI_Item so I tried adding a Primary Vendor UDF feeding from IM_Item but while it showed up in the selection grid, it didn't work. Would I have to populate it with the CI_Item Primary Vendor or am I missing something? TIA!

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------


  • 2.  RE: Physical Count by Primary Vendo

    Posted 10-24-2019 22:00
    Are you adding the UDF to the physical inventory table or to the ci_item table pulling from the primary vendor (if this is possible)?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Physical Count by Primary Vendo

    Posted 10-25-2019 00:48
    This is weird, but I see the opposite of what Therese is seeing. (I tested in 2019) If the UDF in the Physical Inventory work file is populated from CI_Item, I DO NOT get it added to the Selection grid as she does (yes, I re-ran Update). But, it IS populated in the work file. Go figure.

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


  • 4.  RE: Physical Count by Primary Vendo

    Posted 10-25-2019 10:01
    You'd have to populate the UDFs for it to work.  ​​

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------



  • 5.  RE: Physical Count by Primary Vendo

    Posted 10-25-2019 14:08
    In my test with ABC company, UDF's were populated and displayed when placed on the report, but the field did not appear in the Selections grid.

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


  • 6.  RE: Physical Count by Primary Vendo

    Posted 10-25-2019 16:37
    If you put the UDF in the CI_Item table and populate it, it gets added to the grid and will select based on that field. If you set it up to use the business object, it will update the UDF automatically but not the initial population.

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------

    Original Message


Related Content