Find current InventDim record

This question is answered

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?

Verified Answer
  • 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.

All Replies
  • By current WMSLocation, do you mean the warehouse location where inventory happens to be located?  What makes a location "current"?

  • Brandon,

     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.

  • Brandon,

     Thank you for the suggestions.  This should at least help me find records that have a current value.

    Tom T.