Is it possible to add the column "Available physical" to the Transfer Order lines?

(0) Share

Report

Posted on by Sean The Michael

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

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Sefa Duman 1,167 on at

Like (1)

Report

Hi Sean,

AX has classes and tables for calculating on hand inventory. It must be noted that inventory dimensions are vital in the inventory calculation. Firstly I recommend you to read this blog post to understand onhand calculation:

community.dynamics.com/.../ax2012-x-code-to-get-on-hand-on-an-item

You have to add new display method to your form for showing on hand and add a new field to your form. This method should be like this:

public display InventQty displayAvailPhysical()

{

InventOnhand inventOnhand;

InventDimParm inventDimParm;

inventDimParm.initFromInventDim(InventDim::find(this.InventDimId));

inventOnhand = InventOnhand::newParameters(this.ItemId, this.inventDim(), inventDimParm);

return inventOnHand.availPhysical();

}

Don't forget setting the datasource and datamethod property.

Best regars,

Sefa.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (2)

Report

Hello Sean The Michael,

Why is it necessary to display this info in the transfer order form?

Out of the box you can get this information with one click.

Simply select inventory - onhand and you can see the available physical qty.

Best regards,

Ludwig

Was this reply helpful? Yes No
Sean The Michael 139 on at

Like (0)

Report

Thank you for the information sir, I will review what you have posted, thank you.

Was this reply helpful? Yes No
Sean The Michael 139 on at

Like (0)

Report

Thank you for the input sir, but our instructor said that the available physical inventory must be displayed for checking of the inventory of the selected item.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sean The Michael 139 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You need to add the method to the data source of the form, or to the actual table. If you added it to the form level, it doesn't work.

Was this reply helpful? Yes No
Sean The Michael 139 on at

Like (0)

Report

I have done that, yet it is still not working for me.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Sean The Michael 139 on at

Like (0)

Report

Will do, thanks for the input sir.

Was this reply helpful? Yes No