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
wheretabProduction 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.