I developed a query to bring subinventory ,locator,onhand quantity and transactable quantity.This is working fine for few records ,but for few more records it is bringing locators of others items (incorrect data) . Can any one tell FROM WHICH TABLE , LOCATOR FIELD WILL BE FILLED IN ONHAND QUANTITY FORM in inventory module. when iam checking with Record history it is in disable mode and using diagonistics..examine also failed. Actually iam using mtl_item_locations_kfv to bring locators. But for some item records, the data coming from FRONT END FORM and the QUERY are not matching . what might be the reason.can any one plz help.
let me know for any clarification, plz help.