Unitconversion in SSRS

(0) Share

Report

Posted on by D365 beginner

636

Hi All,

I need to display the Sales Unit and Onahand quantity in sales unit in report. I have created those fields in the temptable and below code is being used to store the sales unit.

While Select UnitId from InventTableModule where TmpinventTrans.ItemId == InventTableModule.ItemId
&& ModuleInventPurchSales::Sales
{
TmpinventTrans.SalesUnit = InventTableModule.UnitId;
}

how can I show the quantity in the sales unit after applying unit conversion if available.

I am using a method to have on-hand value and storing as TmpInventTrans.onhandphysical. just need the code for applying unit conversion and to display the data as TmpinventTrans.salesqty.

If( SalesUnit!= 'Kg')

{

------------ ?

}

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can call UnitOfMeasureConverter::convert to do the conversion.

Was this reply helpful? Yes No
D365 beginner 636 on at

Like (0)

Report
Copy link

Link copied!

Thanks Mr. Nikolaos,

Can you please explain how the syntax should be as per the above details since i have tried the same already but didn't work.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,735 Moderator on at

Like (0)

Report
Copy link

Link copied!

Take a look at below link for example

community.dynamics.com/.../get-unit-conversion-value-of-item-in-ax-2012

msdn.microsoft.com/.../unitofmeasureconverter.convert.aspx

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!
it should be like

qty = UnitOfMeasureConverter::convert(tmpInventTrans.onhandphysical,
UnitOfMeasure::unitOfMeasureIdBySymbol('Your invetory unit'),
UnitOfMeasure::unitOfMeasureIdBySymbol(InventTableModule.UnitId), //sales unit
NoYes::Yes,
InventTable::itemProduct(tmpInventTrans.ItemId));

Was this reply helpful? Yes No