I have a need to find the current AX2012 R2 InventDim record using InventBatch, InventSerial and InventLocation fields. Is there a way for finding the most current InventDim record (which would contain the current WMSLocation) using those three values?
By current WMSLocation, do you mean the warehouse location where inventory happens to be located? What makes a location "current"?
Exactly, the item might have a InventBatchId of 'R0001' and a InventSerialId of 'A-1'. As it is moved around the shop floor, the WMSlocation will keep changing. The InventDim table just adds a new record every time the wmslocation changes. I need to find out which InventDim record is the current one so I can find its current location.
Then I believe what you want is to find the InventSum record that represents that inventory. Find the InventSum record where ItemId equals your item of interest and PostedQty + Received - Deducted != 0, join that to InventDim on InventDimId == InventDimId, then filter on InventBatchId and InventSerialId of interest. Whatever InventSum/InventDim record combination you find will likely be what you want.
Thank you for the suggestions. This should at least help me find records that have a current value.