You’re offline. This is a read only version of the page.
Announcements
135
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.
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
Hi Sean The Michael,
If this one click is too much then take a look at the field and the method in the on-hand view and how this is implemented.
You should be able to 'borrow' from the code that is already there.
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,186
Super User 2024 Season 2
#2
Martin Dráb
227,996
Super User 2024 Season 2
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (