How to display Item Net Weight

(0) Share

Report

Posted on by Community Member

Hi All,

I am trying to display Item Net weight on a delivery Note. For that I am trying to write a method. Not sure what wrong I am doing

//BP Deviation documented
display ItemNetWeight NetWeight()
{
;

return ItemNetWeight.inventTable().ItemNetWeight;

Can anyone help?

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Rohin 4,624 on at

Like (0)

Report

Hello ,

Where are writing this code ? on Report ?

your code is like that :

return ItemNetWeight.inventTable().ItemNetWeight;

what is "ItemNetWeight"(showing Bold) ?

could you please specify ?

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Visvash,

Yes, I am writing this code for a report. I want to display Net Weight for an Item in inventory Module on this report.

Not sure if you work on AX but if you do and look up in Invent Table, there is field called Net Weight.

Hope this explains!

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

Hello Parz,

I think you don't understand my comment. sorry for that.

I know NetWeight is field in InventTable. My question is how do you get InventTable() method from ItemNetWeignt (bold in my above comment) ? what is That Bold "ItemNetWeight " is it Report control Field?

is this SSRS Report ? could you specify the Name of Report ?

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am not sure if I still understand your question!! Sorry about that !!But I am trying to add this field to SalesPackagingSlip!!

Was this reply helpful? Yes No
Suggested answer

Rohin 4,624 on at

Like (0)

Report

I am sorry , i havn't see that you are working on Ax2009 . I was thinking that you are working on AX 2012 so i was asking acc. to that. No issue .

You have two options to display your field on Report :

1. Write Display Method on Table (DataSource of Your Report)

2. Write Display Method on Report (as you are doing)

but you have to write first Select statement in display method with your DataSource Table (Report DataSource) with InventTable and then you can get only Your Field from InventTable .

I hope you understand now . Please tell if you need more explanation.

Thanks.

Was this reply helpful? Yes No
Verified answer

Rohin 4,624 on at

Like (1)

Report

You can try this code on report :

display ItemNetWeight ItemNetWeight()

{

InventTable inventtable;

;

select inventtable where inventtable.ItemId == custpackingsliptrans.ItemId;

return inventtable.NetWeight;

}

this works for me .

thanks.

Was this reply helpful? Yes No
Suggested answer

Faqruddin 1,883 on at

Like (1)

Report

Hello Parz,

Write below code on CustPackingSlipTrans table and call in your report.

public ItemNetWeight itemNetweight()

{

InventTable inventTable;

select NetWeight from inventTable where inventTable.ItemId == this.ItemId

&& inventTable.dataAreaId == this.dataAreaId;

return inventTable.NetWeight;

}

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

You are a genius!!! Thank you so much it worked for me too!! Thanks so much for all your help.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Thanks you

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

Hi Parz,

If your issue is solved you can mark answer that helped you as verified to close this thread.

Many Congrats!

Thanks.

Was this reply helpful? Yes No