PO Reports Methods

Hi all,

I am facing problem in feching the value in the reports for particular item

  1. right know it is showing the item from the purch line (Qty & unit of measurement) in the reports

i need to fetch the (Qty & unit of measurement) for that particular it which has been converted in the item master for the same item

ex: for the 0001 item they have selected the itemunit as : Nos & Purch Unit as : KG

right know it is showing in the repors for that 0001 item qty = 12000 and unit = kg

i need for that 0001 item what is the conversion item unit for qty = 12000 and unit = kg.

Thanks in advance.

Hi Mohammed,

What you are explaning is both cases

right know it is showing in the repors for that 0001 item qty = 12000 and unit = kg

i need for that 0001 item what is the conversion item unit for qty = 12000 and unit = kg it showing kg right…what you to diaplay actually…

Naresh Kolli

Hi naresh,

for that particular item 0001 item qty = 12000 and unit = kg it is displaying in purch line item

for this item 0001 in iventory management in setup tab inventory unit = nos and in reference tab purchase unit = kg so, they have done the convertion from nos to kg in unit convertion

in report it is displaying the Qty = 12000 and unit = kg

i need to display along with this the converted qty and unit for item 0001

example qty = 12000 and unit = kg (this is displaying already)

qty = 10 and and unit = nos ( this i want to display in report)

so how to write the display method in the standard purchpurchase order report

thanks in advance

Hi Mohammed,

Try this it may help you out…

display UnitId getUnitId()
{
;
return InventTableModule::find(ItemId,ModuleInventPurchSales::Invent).UnitId;
}

Naresh Kolli