Looking for PO line quantity column in Purchasing Subject Areas

Question

Hi,

I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real Time. But its showing blank. Then tried to calculate it with Line Amount/Price, but it will return zero if line price is 0.

May i know which column has to be used to fetch PO Line Quantity.

Thank you,

Regards,

Sudheer.

Sudheer YN · Answer

Thank you @Rich Merkel . I have created an SR and working with them. Its showing null because of 3 columns Requester, Project Number and Expenditure Organization columns. If i remove these columns from my report, its showing ordered qty.

Rich Merkel · Answer

Hi,

See if this works in your instance, you may need both line and distribution sequence for it to appear.

You also mentioned about blank, double check you currency settings from the catalog my account → preferences → currency.  In our instance I set to ledger currency.

Attached is the xml (you can go to advanced and replace what is in the analysis xml and click apply).  I have defaulted PO as a filter, so you can modify that as needed/etc.

Also attaching archive file that you could also unarchive in your instance.

Hope this helps/works.

PO Summary.catalog

PO advanced XML.txt

Sudheer YN · Answer

Thank you Gaurav. will do. Also i have created SR.