UDS on IM_ItemWarehouse Table_Post-Write doesn't get triggered?

SOLVED

Hi everyone, could someone please tell me if a different object is processing IM_ItemWarehouse?   I was testing out copying QuanaityOnHand of a certain warehouse to a UDF in CI_ITEM but it appears the script attached to Table_post-Write wasn't even firing.  I was a bit skeptical of this approach since the script would run only during update except for updating fields like Bin Location or Reorder point stuff, and now that I think about it it kind of makes sense why the script shouldn't run.  But I wanted to make sure this is a dead-end approach.  Thanks!

Kentaro

  • 0

    I have been scripting for a couple years now but i haven't found a task/process that will trigger a table UDS on IM_ItemWarehouse yet. I believe this is by design as most updates to it are done without the BOI to minimize overhead. That may change going forward with new versions but i can't remember the last time i tried and the version it was on. Someone else may have had better luck than i have though. 

    If you share what your end goal is, someone may have an alternative way to achieve it.

  • 0 in reply to David Speck

    Thanks David.  That's what i was leaning toward.  Basically, I was exploring ways to show warehouse specific QuantityOnHand on the ALE lookup in Item inquiry.  

  • +1 in reply to Kentaro
    verified answer

    If you only want a specific warehouse or the item's default warehouse's quantities than this might work for you but you will have to define the Links yourself via Visual Integrator > Main > Export Job Maintenance. Refer to this pdf for more details.

    Add Table Link for Advanced Lookups.pdf

      

      

    The important thing to note here is the linked tables primary key and what fields make up the key. In the case of IM_ItemWarehouse, it is the ItemCode+WarehouseCode.

    Now since the item inquiry is only intended to return a single record per item, you have to create a link that will satisfy IM_ItemWarehouse's primary key so the Key Expression would be ItemCode+"000" if you wanted to hardcode a warehouse code (where "000" is your desired warehouse code) into it or you could use ItemCode+DefaultWarehouseCode.

     

     

    Once you create the link, you can then modify the Item List lookup and include the desired fields from IM_ItemWarehouse.

      

    In the below example, i did up using ItemCode+DefaultWarehouseCode for the Key Expression in the link.

  • 0 in reply to David Speck

    Wow, thanks David!  This is going to be very useful!