Can I use table IM_ItemWarehouse to trigger script?

Question

Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this field isn't on the table ? or maybe I should use other method to obtain inventory?

BigLouie · Answer

Available is a calculated based on settings in Inventory Setup Options.

Kevin M · Answer

When working with a new business object, I often test the triggers to see when they fire. I'm not sure how IM_ItemWarehouse works with scripting. I expect changing QoH would fire a PreWrite script, but something like OnSO / OnPO might not. 
 As BigLouie indicates, Available is a calculation based on different IM_IW columns (depending on setup options).

Sage 100

Can I use table IM_ItemWarehouse to trigger script?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING