*******Date*****2026 - 07 - 16 15: 46:11***********DataAccess:DaGetvendortypedropdown  * **********Object reference not set to an instance of an object.***********Exception occured while getting Vendor Type!*****Query****Select vendortype_gid,vendortype_name from pmr_mst_tvendortype Order by vendortype_name asc*******Apiref********
*******Date*****2026 - 07 - 16 15: 46:21***********DataAccess: DaGetGetUnmappedproductCategories***********Object reference not set to an instance of an object.***********Exception occured while getting Nature of asset Summary!*****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***********DataAccess: DaGetGetUnmappedproductCategories***********Object reference not set to an instance of an object.***********Exception occured while getting Nature of asset Summary!*****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***********DataAccess: DaGetGetUnmappedproductCategories***********Object reference not set to an instance of an object.***********Exception occured while getting Nature of asset Summary!*****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***********DataAccess: DaGetGetUnmappedproductCategories***********Object reference not set to an instance of an object.***********Exception occured while getting Nature of asset Summary!*****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***********DataAccess:DaGetvendortypedropdown  * **********Object reference not set to an instance of an object.***********Exception occured while getting Vendor Type!*****Query****Select vendortype_gid,vendortype_name from pmr_mst_tvendortype Order by vendortype_name asc*******Apiref********
*******Date*****2026 - 07 - 16 15: 54:23***********DataAccess:DaGetvendortypedropdown  * **********Object reference not set to an instance of an object.***********Exception occured while getting Vendor Type!*****Query****Select vendortype_gid,vendortype_name from pmr_mst_tvendortype Order by vendortype_name asc*******Apiref********
*******Date*****2026 - 07 - 16 16: 02:36***********DataAccess:DaGetvendortypedropdown  * **********Object reference not set to an instance of an object.***********Exception occured while getting Vendor Type!*****Query****Select vendortype_gid,vendortype_name from pmr_mst_tvendortype Order by vendortype_name asc*******Apiref********
*******Date*****2026 - 07 - 16 17: 38:34***********DataAccess: DaGetPurchaseOrderSelectSummary***********Object reference not set to an instance of an object.***********Exception occured while getting PO summary!*****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:40***********DataAccess: DaImsRPTConsumptionRPTdetails***********Object reference not set to an instance of an object.***********Exception occured while getting Exchange product details!*****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: 43:19***********DataAccess: DaImsRPTConsumptionRPTdetails***********Object reference not set to an instance of an object.***********Exception occured while getting Exchange product details!*****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:13***********DataAccess: DaImsRPTConsumptionRPTdetails***********Object reference not set to an instance of an object.***********Exception occured while getting Exchange product details!*****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:46***********DataAccess: DaImsRPTConsumptionRPTdetails***********Object reference not set to an instance of an object.***********Exception occured while getting Exchange product details!*****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********