Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
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?
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.
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.
Thank you for the suggestions. This should at least help me find records that have a current value.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics