Pending Production Order Report

[Aditya Duggal]

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

[Aditya Duggal]

Please ignore, I found the error.