Query Report: Pending Purchase Request

ERPNext Reports
1

Hi,

I am trying to make this query report but I am unable to get the report to run. Please let me know where am I wrong on this one:

select
 tabPurchase Request.name as “Indent No”,
 tabPurchase Request.transaction_date as “Indent Date”,
 tabPurchase Request Item.item_code as “Item Code”,
 tabPurchase Request Item.description as “Description”,
 tabPurchase Request Item.qty as “Qty”,
 tabPurchase Request Item.uom as "UoM",<br>&nbsp;tabPurchase Request Item.ordered_qty as "Ordered"<br><br>from<br>&nbsp;tabPurchase Request,tabPurchase Request Item<br>where<br>&nbsp;tabPurchase Request Item.parent=tabPurchase Request.name<br>&nbsp;and tabPurchase Request.status = "Submitted"<br>&nbsp;and tabPurchase Request.transaction_date &lt;= curdate()<br>&nbsp;and ifnull(tabPurchase Request Item.ordered_qty,0) &lt; ifnull(tabPurchase Request Item.qty,0)<br>&nbsp;and tabPurchase Request.status = "Submitted"<br>order by tabPurchase Request.transaction_date` desc

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/6Y3wQYtPxEMJ.

For more options, visit https://groups.google.com/groups/opt_out.