New Query Report: Purchase Order to Receive


Looks like it is some time to give back to the community, I have started to work on the new query reports and I am adding these reports to my system and at the same time I would be posting the same on the forums so that the developers could add those reports into the main product (if needed) and they could also check if the report does not create much troubles with the system.

Btw the below mentioned report has some problem as the width of the last column is not coming as per expected lines.

I would also like to ask here, that is there a way to add these options of query to the static type of reports, where the data is not downloaded on the browser but is fetched from the server. I am asking this because the loading of data on the browser is a great thing for small reports but for big reports like Stock Ledgers etc we should have the static reports only since the data is too big.

 tabPurchase as “PO No:Link/Purchase Order:120”,
 tabPurchase Order.transaction_date as “PO Date”,
 tabPurchase Order.supplier as “Supplier:Link/Supplier:180”,
 tabPurchase Order Item.item_code as “Item Code:Link/Item:150”,
 tabPurchase Order Item.qty as “Qty:Decimal:10”,
 tabPurchase Order Item.received_qty as “Received Qty:Decimal:10”,
 tabPurchase Order Item.uom as “UoM:10”,
 tabPurchase Order Item.import_rate as “Price:20”,
 tabPurchase Order Item.description as “Description:300”

 tabPurchase Order, tabPurchase Order Item
 tabPurchase Order Item.parent = tabPurchase
 and tabPurchase Order.status = “Submitted”
 and tabPurchase Order.transaction_date <= curdate()
 and ifnull(tabPurchase Order Item.received_qty,0) < ifnull(tabPurchase Order Item.qty,0)
order by tabPurchase Order.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

To unsubscribe from this group, send email to

To view this discussion on the web visit

For more options, visit