139
I am fairly new to Microsoft AX, and I would like to ask if it is possible to add an Available physical item, for example on the Lines tab of the Transfer Orders whenever you add an Item, the available physical column would show up and display the available physical inventory for the selected item.
*This post is locked for comments
Thanks for the input sir.
Me neither, I was just asked to add a new column to show the physical values even though there is already an On-hand button that can be easily clicked.
Check first if there is a button called Inventory dimensions on the journal. That exists on many forms where inventory dimensions are used. With that you can select which inventory dimensions you want to see on the grid.
If there is no such button, you can add the fields yourself from InventDim table (join with InventDimId / ToInventDimId depending on which one you need.
I don't fully understand why would you want to filter these records to find out the on hand for different warehouses. It anyway shows only those warehouses that you already created as journal lines. On the standard On hand form you would get much more information.
I have finally made the Available Inventory of the item appear, for I have added a Method inside the InventTransferLine and created a new RealEdit at the Grid Design that calls the method.
public display InventQtyAvailPhysical availPhysicalCalculated()
{
InventSum inventorySum;
select sum(AvailPhysical) from inventorySum
where this.ItemId == inventorySum.ItemId;
return (inventorySum.AvailPhysical);
}
It displayed the proper Available Physical Total for the item, but my problem now is that I could not filter the Available Physical Inventory for the specific warehouse and site because there is no fields within InventTransferLine that specifies the warehouse or site, is there any workaround for this?
Will do, thanks for the input sir.
The issue could be that the record is not refreshed after you have put in item id and inventdim settings. If you click F5, does it help?
What if you debug it? Do you have ItemId and InventDim and InventDimParm going in to the InventOnhand::newParameters call?
What if you create a job that calls the on hand query with same parameters that your display method - does it return anything?
I have done that, yet it is still not working for me.
Thank you sirs for all the input, but I am still trying to resolve this because even though I have successfully created the column, the data does not show the output, even after setting the Data Source and Data Fields
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
