*******Date*****2026 - 07 - 16 15: 46:11***********Table 'srmdiagnostics.pmr_mst_tvendortype' doesn't exist*****Query****Select vendortype_gid,vendortype_name from pmr_mst_tvendortype Order by vendortype_name asc*******Apiref********
*******Date*****2026 - 07 - 16 15: 46:21***********Table 'srmdiagnostics.acp_mst_tvendor2product' doesn't exist*****Query****select a.product_gid,concat(product_code,'','/','',a.product_name) as product_name from pmr_mst_tproduct a  where product_gid not in (select product_gid from acp_mst_tvendor2product b where b.vendor_gid='PVRR26061370') group by a.product_gid order by a.product_name asc*******Apiref********
*******Date*****2026 - 07 - 16 15: 46:42***********Table 'srmdiagnostics.acp_mst_tvendor2product' doesn't exist*****Query****select a.product_gid,concat(product_code,'','/','',a.product_name) as product_name from pmr_mst_tproduct a  where product_gid not in (select product_gid from acp_mst_tvendor2product b where b.vendor_gid='PVRR26061370') group by a.product_gid order by a.product_name asc*******Apiref********
*******Date*****2026 - 07 - 16 15: 47:18***********Table 'srmdiagnostics.acp_mst_tvendor2product' doesn't exist*****Query****select a.product_gid,concat(product_code,'','/','',a.product_name) as product_name from pmr_mst_tproduct a  where product_gid not in (select product_gid from acp_mst_tvendor2product b where b.vendor_gid='PVRR26061370') group by a.product_gid order by a.product_name asc*******Apiref********
*******Date*****2026 - 07 - 16 15: 48:45***********Table 'srmdiagnostics.acp_mst_tvendor2product' doesn't exist*****Query****select a.product_gid,concat(product_code,'','/','',a.product_name) as product_name from pmr_mst_tproduct a  where product_gid not in (select product_gid from acp_mst_tvendor2product b where b.vendor_gid='PVRR26061370') group by a.product_gid order by a.product_name asc*******Apiref********
*******Date*****2026 - 07 - 16 15: 51:05***********Table 'srmdiagnostics.pmr_mst_tvendortype' doesn't exist*****Query****Select vendortype_gid,vendortype_name from pmr_mst_tvendortype Order by vendortype_name asc*******Apiref********
*******Date*****2026 - 07 - 16 15: 54:23***********Table 'srmdiagnostics.pmr_mst_tvendortype' doesn't exist*****Query****Select vendortype_gid,vendortype_name from pmr_mst_tvendortype Order by vendortype_name asc*******Apiref********
*******Date*****2026 - 07 - 16 16: 02:36***********Table 'srmdiagnostics.pmr_mst_tvendortype' doesn't exist*****Query****Select vendortype_gid,vendortype_name from pmr_mst_tvendortype Order by vendortype_name asc*******Apiref********
*******Date*****2026 - 07 - 16 17: 38:29***********Table 'srmdiagnostics.acp_mst_tvendor2product' doesn't exist*****Query**** SELECT  GROUP_CONCAT(a.purchaserequisitiondtl_gid) AS purchaserequisitiondtl_gid, GROUP_CONCAT(a.purchaserequisition_gid) AS purchaserequisition_gid,  GROUP_CONCAT(a.costcenter_gid) AS costcenter_gid, GROUP_CONCAT(a.materialrequisitiondtl_gid) AS materialrequisitiondtl_gid, a.product_gid,a.user_gid, a. display_field, a.product_code, a.product_name,d.productuom_gid, a.productuom_name, a.productgroup_gid,e.productuomclass_name,  a.productgroup_name,  SUM(a.qty_requested - a.qty_ordered) AS qty_requested, SUM(a.qty_ordered) AS qty_ordered, SUM(CASE WHEN a.qty_approved IS NOT NULL AND a.qty_approved <> 0 THEN a.qty_approved ELSE a.pr_originalqty END) AS qty_approved,SUM(a.pr_originalqty) AS pr_originalqty, COALESCE(NULLIF(MAX(v.product_price),''), NULLIF(MAX(b.cost_price),''), 0) AS product_price  FROM pmr_trn_tpurchaserequisitiondtl a  LEFT JOIN pmr_mst_tproduct b ON a.product_gid = b.product_gid  LEFT JOIN pmr_mst_tproductgroup c ON c.productgroup_gid = a.productgroup_gid  LEFT JOIN pmr_mst_tproductuom d ON d.productuom_gid = a.uom_gid  LEFT JOIN adm_mst_tuser y on y.user_gid = a.created_by  left join pmr_mst_tproductuomclass e on e.productuomclass_gid = d.productuomclass_gid  left join acp_mst_tvendor2product v on v.product_gid = b.product_gid and v.vendor_gid = ''  WHERE a.purchaserequisition_gid IN ('SRM/C/26-27/0264')  AND a.pr_originalqty <> a.qty_ordered and a.pr_originalqty > a.qty_ordered  GROUP BY  a.product_gid,a.product_code,a.product_name, d.productuom_gid, a.productuom_name,a.productgroup_gid, a.productgroup_name;*******Apiref********
*******Date*****2026 - 07 - 16 17: 39:37***********Unknown column 'k.consumed_qty_uom' in 'field list'*****Query**** SELECT IFNULL(SUM(a.qty_issued), 0.00) as quantity,  a.reference_gid as grn_gid, format(MAX(i.unit_price), 2) as product_price, a.product_gid, format(SUM(i.unit_price * a.qty_issued),2) as total_price, FORMAT(MAX(i.unit_price) * (IFNULL(SUM(a.qty_issued),0) - IFNULL(SUM(k.consumed_qty),0)), 2) as balance_total_price,h.branch_name,  a.productuom_gid, c.product_code, c.product_name, d.productgroup_name, g.productuom_name,a.branch_gid,i.display_field,  e.productuomclass_name,  IFNULL(SUM(k.consumed_qty), 0.00) as consumed_qty,  IFNULL(SUM(k.consumed_qty_uom), 0.00) as consumed_qty_uom,  IFNULL(SUM(a.qty_issued), 0.00) - IFNULL(SUM(k.consumed_qty), 0.00) as balance_qty  FROM ims_trn_tstocktracker a  left join ims_trn_tstock i on i.product_gid = a.product_gid  left join pmr_mst_tproduct c on a.product_gid = c.product_gid  left join pmr_mst_tproductgroup d on d.productgroup_gid = c.productgroup_gid  left join pmr_mst_tproductuom g on a.productuom_gid = g.productuom_gid  left join pmr_mst_tproductuomclass e on e.productuomclass_gid = c.productuomclass_gid  left join hrm_mst_tbranch h on a.branch_gid = h.branch_gid  left join ims_trn_tnominalregister j on j.materialrequisitiondtl_gid = a.mrdtl_gid left join ims_trn_tnominalregisterdtl k on k.nominal_gid = j.nominal_gid  where 0=0  GROUP BY a.product_gid, h.branch_name, a.productuom_gid,c.product_code, c.product_name, d.productgroup_name, g.productuom_name, e.productuomclass_name, a.branch_gid  order by d.productgroup_name asc *******Apiref********
*******Date*****2026 - 07 - 16 17: 40:11***********Unknown column 'k.consumed_qty_uom' in 'field list'*****Query**** SELECT IFNULL(SUM(a.qty_issued), 0.00) as quantity,  a.reference_gid as grn_gid, format(MAX(i.unit_price), 2) as product_price, a.product_gid, format(SUM(i.unit_price * a.qty_issued),2) as total_price, FORMAT(MAX(i.unit_price) * (IFNULL(SUM(a.qty_issued),0) - IFNULL(SUM(k.consumed_qty),0)), 2) as balance_total_price,h.branch_name,  a.productuom_gid, c.product_code, c.product_name, d.productgroup_name, g.productuom_name,a.branch_gid,i.display_field,  e.productuomclass_name,  IFNULL(SUM(k.consumed_qty), 0.00) as consumed_qty,  IFNULL(SUM(k.consumed_qty_uom), 0.00) as consumed_qty_uom,  IFNULL(SUM(a.qty_issued), 0.00) - IFNULL(SUM(k.consumed_qty), 0.00) as balance_qty  FROM ims_trn_tstocktracker a  left join ims_trn_tstock i on i.product_gid = a.product_gid  left join pmr_mst_tproduct c on a.product_gid = c.product_gid  left join pmr_mst_tproductgroup d on d.productgroup_gid = c.productgroup_gid  left join pmr_mst_tproductuom g on a.productuom_gid = g.productuom_gid  left join pmr_mst_tproductuomclass e on e.productuomclass_gid = c.productuomclass_gid  left join hrm_mst_tbranch h on a.branch_gid = h.branch_gid  left join ims_trn_tnominalregister j on j.materialrequisitiondtl_gid = a.mrdtl_gid left join ims_trn_tnominalregisterdtl k on k.nominal_gid = j.nominal_gid  where 0=0  GROUP BY a.product_gid, h.branch_name, a.productuom_gid,c.product_code, c.product_name, d.productgroup_name, g.productuom_name, e.productuomclass_name, a.branch_gid  order by d.productgroup_name asc *******Apiref********
*******Date*****2026 - 07 - 16 17: 47:11***********Unknown column 'k.consumed_qty_uom' in 'field list'*****Query**** SELECT IFNULL(SUM(a.qty_issued), 0.00) as quantity,  a.reference_gid as grn_gid, format(MAX(i.unit_price), 2) as product_price, a.product_gid, format(SUM(i.unit_price * a.qty_issued),2) as total_price, FORMAT(MAX(i.unit_price) * (IFNULL(SUM(a.qty_issued),0) - IFNULL(SUM(k.consumed_qty),0)), 2) as balance_total_price,h.branch_name,  a.productuom_gid, c.product_code, c.product_name, d.productgroup_name, g.productuom_name,a.branch_gid,i.display_field,  e.productuomclass_name,  IFNULL(SUM(k.consumed_qty), 0.00) as consumed_qty,  IFNULL(SUM(k.consumed_qty_uom), 0.00) as consumed_qty_uom,  IFNULL(SUM(a.qty_issued), 0.00) - IFNULL(SUM(k.consumed_qty), 0.00) as balance_qty  FROM ims_trn_tstocktracker a  left join ims_trn_tstock i on i.product_gid = a.product_gid  left join pmr_mst_tproduct c on a.product_gid = c.product_gid  left join pmr_mst_tproductgroup d on d.productgroup_gid = c.productgroup_gid  left join pmr_mst_tproductuom g on a.productuom_gid = g.productuom_gid  left join pmr_mst_tproductuomclass e on e.productuomclass_gid = c.productuomclass_gid  left join hrm_mst_tbranch h on a.branch_gid = h.branch_gid  left join ims_trn_tnominalregister j on j.materialrequisitiondtl_gid = a.mrdtl_gid left join ims_trn_tnominalregisterdtl k on k.nominal_gid = j.nominal_gid  where 0=0  GROUP BY a.product_gid, h.branch_name, a.productuom_gid,c.product_code, c.product_name, d.productgroup_name, g.productuom_name, e.productuomclass_name, a.branch_gid  order by d.productgroup_name asc *******Apiref********
*******Date*****2026 - 07 - 16 17: 53:30***********Unknown column 'k.consumed_qty_uom' in 'field list'*****Query**** SELECT IFNULL(SUM(a.qty_issued), 0.00) as quantity,  a.reference_gid as grn_gid, format(MAX(i.unit_price), 2) as product_price, a.product_gid, format(SUM(i.unit_price * a.qty_issued),2) as total_price, FORMAT(MAX(i.unit_price) * (IFNULL(SUM(a.qty_issued),0) - IFNULL(SUM(k.consumed_qty),0)), 2) as balance_total_price,h.branch_name,  a.productuom_gid, c.product_code, c.product_name, d.productgroup_name, g.productuom_name,a.branch_gid,i.display_field,  e.productuomclass_name,  IFNULL(SUM(k.consumed_qty), 0.00) as consumed_qty,  IFNULL(SUM(k.consumed_qty_uom), 0.00) as consumed_qty_uom,  IFNULL(SUM(a.qty_issued), 0.00) - IFNULL(SUM(k.consumed_qty), 0.00) as balance_qty  FROM ims_trn_tstocktracker a  left join ims_trn_tstock i on i.product_gid = a.product_gid  left join pmr_mst_tproduct c on a.product_gid = c.product_gid  left join pmr_mst_tproductgroup d on d.productgroup_gid = c.productgroup_gid  left join pmr_mst_tproductuom g on a.productuom_gid = g.productuom_gid  left join pmr_mst_tproductuomclass e on e.productuomclass_gid = c.productuomclass_gid  left join hrm_mst_tbranch h on a.branch_gid = h.branch_gid  left join ims_trn_tnominalregister j on j.materialrequisitiondtl_gid = a.mrdtl_gid left join ims_trn_tnominalregisterdtl k on k.nominal_gid = j.nominal_gid  where 0=0  GROUP BY a.product_gid, h.branch_name, a.productuom_gid,c.product_code, c.product_name, d.productgroup_name, g.productuom_name, e.productuomclass_name, a.branch_gid  order by d.productgroup_name asc *******Apiref********
*******Date*****2026 - 07 - 16 18: 03:51***********Unknown column 'all_branch' in 'field list'*****Query****SELECT all_branch FROM adm_mst_tuser WHERE user_gid = 'SUSM2505300008'*******Apiref********
*******Date*****2026 - 07 - 16 18: 04:13***********Unknown column 'product_flag' in 'field list'*****Query****select product_flag from hrm_mst_tbranch where branch_gid = 'HBHM1602090049'*******Apiref********
*******Date*****2026 - 07 - 16 18: 04:34***********Unknown column 'product_flag' in 'field list'*****Query****select product_flag from hrm_mst_tbranch where branch_gid = 'HBHM1602090049'*******Apiref********
*******Date*****2026 - 07 - 16 18: 04:35***********Unknown column 'product_flag' in 'field list'*****Query****select product_flag from hrm_mst_tbranch where branch_gid = 'HBHM1602090049'*******Apiref********
*******Date*****2026 - 07 - 16 18: 04:50***********Duplicate entry 'E' for key 'PRIMARY'*****Query**** Insert into ims_trn_tmaterialrequisition  (materialrequisition_gid,  branch_gid,  materialrequisition_date,  materialrequisition_remarks,  materialrequisition_reference,  user_gid,  created_by,  created_date,  materialrequisition_status,  product_count,  materialrequisition_type,  material_status,  priority,  expected_date,  priority_remarks,  costcenter_gid )  values ('E', '','2026-07-16 18:04:50', '', '', 'SUSM2505300008', 'SUSM2505300008', '2026-07-16 18:04:50', 'Pending', '1', 'PT00010001204' , 'PR Not Raised', 'N', '2026-07-16 18:04:50', 'Null', NULL)*******Apiref********
*******Date*****2026 - 07 - 16 18: 05:03***********Unknown column 'all_branch' in 'field list'*****Query****SELECT all_branch FROM adm_mst_tuser WHERE user_gid = 'SUSM2505300008'*******Apiref********