RE: Track inventory movements per location
Hello,
We need to update the inventory of an external system,
We are looking for a way to track all the movements of all the items within a location,
What is the best way to do that?
ideally, we will update the external system in real time.
For now, we have a user event script that is triggered each time a sales order is created, but it slows the process, the screen takes 5 sec to be closed.
Do a search that uses that uses a filter on the Last Quantity Available Change
date to detect when the quantity available changes. It won’t be realtime if you use a map/reduce or scheduled script, but it will be more reliable. Expect to store the date time you last exported inventory in a custom record or script parameter.
As per my tests, the
Last Quantity Available Changeis not linked to the inventory location, it shows the last date for the all system
Its specific to each particular item. The date reflects all inventory locations for that particular item.
yes, that is what I mean, what we need is a trigger each time an item is added or removed from one particular inventory location or BIN
You can try copying the behavior of that field by using the transaction join and trying to calculate the last quantity available change date for a particular inventory location. Its hard enough to do that you probably want to clearly define what good enough is.