Pending Production Order Report

Hi,

I am facing some problem with the below mentioned report code, also I am not getting any error in the console.

select
 tabProduction Order.priority as “Priority:10”, (CUSTOM FIELD)
 tabProduction Order.name as “PRD No:Link/Production Order:100”,
 tabProduction Order.production_order_date as “PRD Date”,
(CUSTOM FIELD)
 tabProduction Order.production_item as “Item Code:Link/Item:150”,

 tabProduction Order.item_description as “Item Description:250”,
(CUSTOM FIELD) 
 tabProduction Order.qty as “Qty:Decimal:40”,
 tabProduction Order.produced_qty as “Produced Qty:Decimal:40”,
 (ifnull(tabProduction Order.qty,0)- ifnull(tabProduction Order.produced_qty,0)) as “Pending Production:Decimal:40”,
 tabProduction Order.stock_uom as “UoM:10”,
 tabProduction Order.rm_description as “RM to Use:300”,
(CUSTOM FIELD)
 tabProduction Order.fg_warehouse as "For Warehouse:150"

from
 tabProduction Order
where
tabProduction Order.status = “Submitted”
 and tabProduction Order.transaction_date <= curdate()
 and ifnull(tabProduction Order.produced_qty,0) < ifnull(tabProduction Order.qty,0)
order by tabProduction Order.production_order_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/-/YKmGCa4ON3UJ.

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

 

 

Please ignore, I found the error.

On Saturday, December 22, 2012 6:24:51 PM UTC+5:30, Aditya Duggal wrote:

Hi,

I am facing some problem with the below mentioned report code, also I am not getting any error in the console.

select
 tabProduction Order.priority as “Priority:10”, (CUSTOM FIELD)
 tabProduction Order.name as “PRD No:Link/Production Order:100”,
 tabProduction Order.production_order_date as “PRD Date”,
(CUSTOM FIELD)
 tabProduction Order.production_item as “Item Code:Link/Item:150”,

 tabProduction Order.item_description as “Item Description:250”,
(CUSTOM FIELD) 
 tabProduction Order.qty as “Qty:Decimal:40”,
 tabProduction Order.produced_qty as “Produced Qty:Decimal:40”,
 (ifnull(tabProduction Order.qty,0)- ifnull(tabProduction Order.produced_qty,0)) as “Pending Production:Decimal:40”,
 tabProduction Order.stock_uom as “UoM:10”,
 tabProduction Order.rm_description as “RM to Use:300”,
(CUSTOM FIELD)
 tabProduction Order.fg_warehouse as "For Warehouse:150"

from
 tabProduction Order
where
tabProduction Order.status = “Submitted”
 and tabProduction Order.transaction_date <= curdate()
 and ifnull(tabProduction Order.produced_qty,0) < ifnull(tabProduction Order.qty,0)
order by tabProduction Order.production_order_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/-/cOS-YZECr9UJ.

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