RE: Track inventory movements per location


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.

komagain Rookie Asked on March 4, 2021 in Inventory.
Add Comment
2 Answers

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.

Advanced Answered on March 4, 2021.

As per my tests, the

Last Quantity Available Change
is not linked to the inventory location, it shows the last date for the all system

on March 5, 2021.

Its specific to each particular item. The date reflects all inventory locations for that particular item.

on March 5, 2021.

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

on March 5, 2021.

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.

on March 5, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.