Hi all, I have been digging into the DAX classes for a while now in search of a solution to my problem, just wondered if anyone of you could help...
I want to update a new field on the warehouse locations table (WMSLocation) whenever a physical transaction against a location record is posted. What I need is that whenever (from any Journal) the OnHand stock on a Location is updated (ordered, reserved, registered, picked...) the new field on the corresponding location record is updated accordingly. My original design was as follows: Calls on the insert/update methods on the InventSum table which update the location records. The problem lies in that DAX does not always call those methods when updating inventory levels, direct SQL statements which bypass my code are called! Any ideas on how to move on? I have been looking at the InventUpdate/InventMovement class trees, but I may be a bit lost now... Any help would be highly appreciated! John.
