20-04-2026 09:07:55 ## Exception ## Table 'support.ab_survey_24_nov' doesn't exist ## DataAccess.GetData ## ## GetMisc Select cu.survey_index, (select count(*) from ab_survey_24_nov where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ifnull(survey_index, 0) = 4) as enterprise_count from ab_survey_24_nov cu where cu.user_id = '6511ab24-5862-49c9-96af-0813cd2f3003' Inner Exception: NULL Error: Table 'support.ab_survey_24_nov' doesn't exist Source: MySql.Data 20-04-2026 09:09:35 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:09:35 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 09:15:29 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-01 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-01 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 8 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2026-04-01 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '18fde49c-29d8-4e6a-883a-ec13f550a2ae' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:17:38 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 09:17:56 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 09:32:28 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 8 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2026-04-19 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = 'e673c532-6990-4cf7-8e22-9b778647b41f' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:36:54 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 8 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2026-04-19 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = 'e673c532-6990-4cf7-8e22-9b778647b41f' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:41:26 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:41:26 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 09:41:43 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 09:42:37 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 8 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2026-04-19 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = 'e673c532-6990-4cf7-8e22-9b778647b41f' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:42:47 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 8 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2026-04-19 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = 'e673c532-6990-4cf7-8e22-9b778647b41f' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:52:12 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-18 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-18 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-18 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:53:35 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-18 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-18 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-18 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:53:46 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 09:54:44 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 09:57:35 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-18 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-18 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:57:35 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 09:57:59 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-17 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-17 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 09:57:59 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 10:10:53 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select v.name as header_view_name, v.title as view_title, v.print_company_name, v.print_date_time, v.print_user_name, v.print_page_no, c.* from con_report_view v left outer join con_report_view_column c on c.view_id = v.id where v.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and v.report_type = 4280 order by c.view_id, c.sequence Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:10:53 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select name, col_expression, col_type from con_report_calculative_column where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4280 order by seq Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:10:53 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select view_id From con_report_view_default Where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4280 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:10:53 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_MonthWiseLedger Select A.*, (case when A.month_name = ' Opening' then (Case When Net >= 0 then Net else 0 end) else A.Debit1 end) as Debit, (case when A.month_name = ' Opening' then (Case When Net < 0 then - 1 * Net else 0 end) else A.Credit1 end) as Credit, 0.1 as Balance from ( Select L.ID, L.name, (Case when TM.vdate < '2026-04-01 00:00:00' then '' else concat(month(TM.vdate), '|', year(TM.vdate)) end) as voucher_id, (Case when TM.vdate < '2026-04-01 00:00:00' then 0 When l.cash_bank_type = 1 then 4102 When l.cash_bank_type = 2 then 4278 Else 4026 End) as ZoomType, (Case when TM.vdate < '2026-04-01 00:00:00' then ' Opening' else GetMonth(TM.vdate) end) as month_name, Sum(Case When TM.Debit_Credit = 0 then TM.Amount else -TM.Amount end) as Net, Sum(Case When TM.Debit_Credit = 0 then TM.Amount else 0 end) as Debit1, Sum(Case When TM.Debit_Credit = 1 then TM.Amount else 0 end) as Credit1 From et_transaction_master TM LEFT OUTER JOIN mst_ledger L ON L.id = TM.gl_id Where TM.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' And TM.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and TM.approval_status = 1 And TM.vdate <= '2026-04-17 23:59:59' And TM.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And L.id IN ('5f0e67f7-353f-4733-91b6-416d05d4f8f2') Group By L.ID, L.name, (Case when TM.vdate < '2026-04-01 00:00:00' then '' else concat(month(TM.vdate), '|', year(TM.vdate)) end), (Case when TM.vdate < '2026-04-01 00:00:00' then 0 When l.cash_bank_type = 1 then 4102 When l.cash_bank_type = 2 then 4278 Else 4026 End), (Case when TM.vdate < '2026-04-01 00:00:00' then ' Opening' else GetMonth(TM.vdate) end) ) as A Order By name, month_name Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:10:53 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_MonthWiseLedger ## ClientType: Desktop 20-04-2026 10:11:05 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select v.name as header_view_name, v.title as view_title, v.print_company_name, v.print_date_time, v.print_user_name, v.print_page_no, c.* from con_report_view v left outer join con_report_view_column c on c.view_id = v.id where v.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and v.report_type = 4280 order by c.view_id, c.sequence Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:05 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select name, col_expression, col_type from con_report_calculative_column where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4280 order by seq Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:05 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select view_id From con_report_view_default Where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4280 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:05 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_MonthWiseLedger Select A.*, (case when A.month_name = ' Opening' then (Case When Net >= 0 then Net else 0 end) else A.Debit1 end) as Debit, (case when A.month_name = ' Opening' then (Case When Net < 0 then - 1 * Net else 0 end) else A.Credit1 end) as Credit, 0.1 as Balance from ( Select L.ID, L.name, (Case when TM.vdate < '2026-04-01 00:00:00' then '' else concat(month(TM.vdate), '|', year(TM.vdate)) end) as voucher_id, (Case when TM.vdate < '2026-04-01 00:00:00' then 0 When l.cash_bank_type = 1 then 4102 When l.cash_bank_type = 2 then 4278 Else 4026 End) as ZoomType, (Case when TM.vdate < '2026-04-01 00:00:00' then ' Opening' else GetMonth(TM.vdate) end) as month_name, Sum(Case When TM.Debit_Credit = 0 then TM.Amount else -TM.Amount end) as Net, Sum(Case When TM.Debit_Credit = 0 then TM.Amount else 0 end) as Debit1, Sum(Case When TM.Debit_Credit = 1 then TM.Amount else 0 end) as Credit1 From et_transaction_master TM LEFT OUTER JOIN mst_ledger L ON L.id = TM.gl_id Where TM.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' And TM.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and TM.approval_status = 1 And TM.vdate <= '2026-04-17 23:59:59' And TM.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And L.id IN ('32a60f7b-1322-4c35-b901-c24dff9740cd') Group By L.ID, L.name, (Case when TM.vdate < '2026-04-01 00:00:00' then '' else concat(month(TM.vdate), '|', year(TM.vdate)) end), (Case when TM.vdate < '2026-04-01 00:00:00' then 0 When l.cash_bank_type = 1 then 4102 When l.cash_bank_type = 2 then 4278 Else 4026 End), (Case when TM.vdate < '2026-04-01 00:00:00' then ' Opening' else GetMonth(TM.vdate) end) ) as A Order By name, month_name Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:05 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_MonthWiseLedger ## ClientType: Desktop 20-04-2026 10:11:22 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select v.name as header_view_name, v.title as view_title, v.print_company_name, v.print_date_time, v.print_user_name, v.print_page_no, c.* from con_report_view v left outer join con_report_view_column c on c.view_id = v.id where v.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and v.report_type = 4280 order by c.view_id, c.sequence Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:22 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select name, col_expression, col_type from con_report_calculative_column where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4280 order by seq Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:22 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select view_id From con_report_view_default Where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4280 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:22 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_MonthWiseLedger Select A.*, (case when A.month_name = ' Opening' then (Case When Net >= 0 then Net else 0 end) else A.Debit1 end) as Debit, (case when A.month_name = ' Opening' then (Case When Net < 0 then - 1 * Net else 0 end) else A.Credit1 end) as Credit, 0.1 as Balance from ( Select L.ID, L.name, (Case when TM.vdate < '2026-04-01 00:00:00' then '' else concat(month(TM.vdate), '|', year(TM.vdate)) end) as voucher_id, (Case when TM.vdate < '2026-04-01 00:00:00' then 0 When l.cash_bank_type = 1 then 4102 When l.cash_bank_type = 2 then 4278 Else 4026 End) as ZoomType, (Case when TM.vdate < '2026-04-01 00:00:00' then ' Opening' else GetMonth(TM.vdate) end) as month_name, Sum(Case When TM.Debit_Credit = 0 then TM.Amount else -TM.Amount end) as Net, Sum(Case When TM.Debit_Credit = 0 then TM.Amount else 0 end) as Debit1, Sum(Case When TM.Debit_Credit = 1 then TM.Amount else 0 end) as Credit1 From et_transaction_master TM LEFT OUTER JOIN mst_ledger L ON L.id = TM.gl_id Where TM.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' And TM.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and TM.approval_status = 1 And TM.vdate <= '2026-04-17 23:59:59' And TM.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And L.id IN ('5f0e67f7-353f-4733-91b6-416d05d4f8f2') Group By L.ID, L.name, (Case when TM.vdate < '2026-04-01 00:00:00' then '' else concat(month(TM.vdate), '|', year(TM.vdate)) end), (Case when TM.vdate < '2026-04-01 00:00:00' then 0 When l.cash_bank_type = 1 then 4102 When l.cash_bank_type = 2 then 4278 Else 4026 End), (Case when TM.vdate < '2026-04-01 00:00:00' then ' Opening' else GetMonth(TM.vdate) end) ) as A Order By name, month_name Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:22 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_MonthWiseLedger ## ClientType: Desktop 20-04-2026 10:11:41 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_BalanceSheet Select * from (Select coa_view.name, coa_view.code, coa_view.master_type, coa_view.main_parent_code, mp.id as main_parent_id, coa_view.parent_id, (case when 0 = 1 then 4279 when g.nature_type = 2 then 4033 when g.nature_type = 5 then 4047 when l.cash_bank_type = 1 then (Case When 1 = 1 then 4280 else 4102 end) when l.cash_bank_type = 2 then (Case When 1 = 1 then 4280 else 4278 end) when ifnull(l.is_parent, 0) = 1 then 4024 else (Case When 1 = 1 then 4280 else 4026 end) end) AS ZoomType, coa_view.id as voucher_id, Round(IFNULL(Closing, 0), 3) as Closing, 0.1 as Closing_1, 0.1 as Closing_2, 0.1 as Closing_3, 0.1 as Closing_4, 0.1 as Closing_5, 0.1 as Closing_6, 0.1 as Closing_7, 0.1 as Closing_8, 0.1 as Closing_9, 0.1 as Closing_10, 0.1 as Closing_11, 0.1 as Closing_12 From ( (SELECT g.id AS id, g.parent_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(g.code_prefix)), g.name) AS CHAR(255) CHARSET UTF8) AS name, g.code AS code, g.master_type AS master_type, g.enterprise_id AS enterprise_id, g.company_id AS company_id, g.main_parent_code AS main_parent_code, 0 AS is_subledger, 0 AS is_ar_ap, 0 AS ZoomType, 0 as Closing FROM mst_ledger_group g WHERE g.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) UNION ALL (SELECT l.id AS id, l.under_ledger_group_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(l.code_prefix)), l.name) AS CHAR(255) CHARSET UTF8) AS name, l.code AS code, l.master_type AS master_type, l.enterprise_id AS enterprise_id, l.company_id AS company_id, l.main_parent_code AS main_parent_code, l.is_subledger AS is_subledger, (CASE WHEN p1.nature_type IN (2 , 5) THEN 1 ELSE 0 END) AS is_ar_ap, (CASE WHEN p1.nature_type = 2 THEN 4033 WHEN p1.nature_type = 5 THEN 4047 WHEN l.cash_bank_type <> 0 THEN 4102 WHEN EXISTS(SELECT mst_ledger.id FROM mst_ledger WHERE mst_ledger.under_ledger_id IS NOT NULL AND mst_ledger.under_ledger_id = l.id) THEN 4024 ELSE 4026 END) AS ZoomType, tm_closing.amount as Closing FROM mst_ledger l LEFT JOIN mst_ledger_group p1 ON p1.id = l.under_ledger_group_id LEFT OUTER JOIN (Select tm.gl_id, Sum(Case When debit_credit = (Case when L.main_parent_code in ('10000000', '30000000') then 1 else 0 end) then amount else -amount end) as Amount from et_transaction_master tm LEFT OUTER JOIN mst_ledger L ON L.id = tm.gl_id where tm.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and tm.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311') and tm.approval_status = 1 and vdate <= '2026-04-30 23:59:59' And tm.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And (ifnull(tm.sub_type, 0) Not In (2, 1) OR tm.vdate <= '') group by tm.gl_id) as tm_closing on tm_closing.gl_id = l.id WHERE l.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) ORDER BY code) coa_view LEFT OUTER JOIN mst_ledger_group mp on (mp.code = coa_view.main_parent_code and mp.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and coa_view.master_type = 2104) LEFT OUTER JOIN mst_ledger l on l.id = coa_view.id LEFT OUTER JOIN mst_ledger_group g on g.id = l.under_ledger_group_id where coa_view.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and coa_view.main_parent_code in ('10000000', '20000000' , '20000000') and ifnull(coa_view.is_subledger,0) = 0 ) as A Where 1=1 and (master_type = 2028 OR voucher_id in ('e8c5d8b4-3f23-4fda-b6b7-42adb4aa925a', 'e9bee73f-5377-45b7-897b-73fec63a3fe4', '76b84d7e-04c7-4114-815d-83607a545a39', '8647040a-9005-42f1-965e-4b3d27a5fd2f', 'd7cf30a5-d998-480f-b7d4-c741a3e6ccd1') OR Not (Closing = 0) ) order by code Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:41 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_BalanceSheet_Horizontal ## ClientType: Desktop 20-04-2026 10:11:57 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select v.name as header_view_name, v.title as view_title, v.print_company_name, v.print_date_time, v.print_user_name, v.print_page_no, c.* from con_report_view v left outer join con_report_view_column c on c.view_id = v.id where v.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and v.report_type = 4095 order by c.view_id, c.sequence Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:57 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select name, col_expression, col_type from con_report_calculative_column where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4095 order by seq Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:57 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select view_id From con_report_view_default Where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4095 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:57 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_BalanceSheet Select * from (Select coa_view.name, coa_view.code, coa_view.master_type, coa_view.main_parent_code, mp.id as main_parent_id, coa_view.parent_id, (case when 0 = 1 then 4279 when g.nature_type = 2 then 4033 when g.nature_type = 5 then 4047 when l.cash_bank_type = 1 then (Case When 1 = 1 then 4280 else 4102 end) when l.cash_bank_type = 2 then (Case When 1 = 1 then 4280 else 4278 end) when ifnull(l.is_parent, 0) = 1 then 4024 else (Case When 1 = 1 then 4280 else 4026 end) end) AS ZoomType, coa_view.id as voucher_id, Round(IFNULL(Closing, 0), 3) as Closing, 0.1 as Closing_1, 0.1 as Closing_2, 0.1 as Closing_3, 0.1 as Closing_4, 0.1 as Closing_5, 0.1 as Closing_6, 0.1 as Closing_7, 0.1 as Closing_8, 0.1 as Closing_9, 0.1 as Closing_10, 0.1 as Closing_11, 0.1 as Closing_12 From ( (SELECT g.id AS id, g.parent_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(g.code_prefix)), g.name) AS CHAR(255) CHARSET UTF8) AS name, g.code AS code, g.master_type AS master_type, g.enterprise_id AS enterprise_id, g.company_id AS company_id, g.main_parent_code AS main_parent_code, 0 AS is_subledger, 0 AS is_ar_ap, 0 AS ZoomType, 0 as Closing FROM mst_ledger_group g WHERE g.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) UNION ALL (SELECT l.id AS id, l.under_ledger_group_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(l.code_prefix)), l.name) AS CHAR(255) CHARSET UTF8) AS name, l.code AS code, l.master_type AS master_type, l.enterprise_id AS enterprise_id, l.company_id AS company_id, l.main_parent_code AS main_parent_code, l.is_subledger AS is_subledger, (CASE WHEN p1.nature_type IN (2 , 5) THEN 1 ELSE 0 END) AS is_ar_ap, (CASE WHEN p1.nature_type = 2 THEN 4033 WHEN p1.nature_type = 5 THEN 4047 WHEN l.cash_bank_type <> 0 THEN 4102 WHEN EXISTS(SELECT mst_ledger.id FROM mst_ledger WHERE mst_ledger.under_ledger_id IS NOT NULL AND mst_ledger.under_ledger_id = l.id) THEN 4024 ELSE 4026 END) AS ZoomType, tm_closing.amount as Closing FROM mst_ledger l LEFT JOIN mst_ledger_group p1 ON p1.id = l.under_ledger_group_id LEFT OUTER JOIN (Select tm.gl_id, Sum(Case When debit_credit = (Case when L.main_parent_code in ('10000000', '30000000') then 1 else 0 end) then amount else -amount end) as Amount from et_transaction_master tm LEFT OUTER JOIN mst_ledger L ON L.id = tm.gl_id where tm.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and tm.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311') and tm.approval_status = 1 and vdate <= '2026-04-17 23:59:59' And tm.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And (ifnull(tm.sub_type, 0) Not In (2, 1) OR tm.vdate <= '') group by tm.gl_id) as tm_closing on tm_closing.gl_id = l.id WHERE l.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) ORDER BY code) coa_view LEFT OUTER JOIN mst_ledger_group mp on (mp.code = coa_view.main_parent_code and mp.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and coa_view.master_type = 2104) LEFT OUTER JOIN mst_ledger l on l.id = coa_view.id LEFT OUTER JOIN mst_ledger_group g on g.id = l.under_ledger_group_id where coa_view.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and coa_view.main_parent_code in ('10000000', '20000000' , '20000000') and ifnull(coa_view.is_subledger,0) = 0 ) as A Where 1=1 and (master_type = 2028 OR voucher_id in ('e8c5d8b4-3f23-4fda-b6b7-42adb4aa925a', 'e9bee73f-5377-45b7-897b-73fec63a3fe4', '76b84d7e-04c7-4114-815d-83607a545a39', '8647040a-9005-42f1-965e-4b3d27a5fd2f', 'd7cf30a5-d998-480f-b7d4-c741a3e6ccd1') OR Not (Closing = 0) ) order by code Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:11:57 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_BalanceSheet_Horizontal ## ClientType: Desktop 20-04-2026 10:12:15 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select v.name as header_view_name, v.title as view_title, v.print_company_name, v.print_date_time, v.print_user_name, v.print_page_no, c.* from con_report_view v left outer join con_report_view_column c on c.view_id = v.id where v.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and v.report_type = 4095 order by c.view_id, c.sequence Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:15 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select name, col_expression, col_type from con_report_calculative_column where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4095 order by seq Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:15 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select view_id From con_report_view_default Where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4095 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:15 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_BalanceSheet Select * from (Select coa_view.name, coa_view.code, coa_view.master_type, coa_view.main_parent_code, mp.id as main_parent_id, coa_view.parent_id, (case when 0 = 1 then 4279 when g.nature_type = 2 then 4033 when g.nature_type = 5 then 4047 when l.cash_bank_type = 1 then (Case When 1 = 1 then 4280 else 4102 end) when l.cash_bank_type = 2 then (Case When 1 = 1 then 4280 else 4278 end) when ifnull(l.is_parent, 0) = 1 then 4024 else (Case When 1 = 1 then 4280 else 4026 end) end) AS ZoomType, coa_view.id as voucher_id, Round(IFNULL(Closing, 0), 3) as Closing, 0.1 as Closing_1, 0.1 as Closing_2, 0.1 as Closing_3, 0.1 as Closing_4, 0.1 as Closing_5, 0.1 as Closing_6, 0.1 as Closing_7, 0.1 as Closing_8, 0.1 as Closing_9, 0.1 as Closing_10, 0.1 as Closing_11, 0.1 as Closing_12 From ( (SELECT g.id AS id, g.parent_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(g.code_prefix)), g.name) AS CHAR(255) CHARSET UTF8) AS name, g.code AS code, g.master_type AS master_type, g.enterprise_id AS enterprise_id, g.company_id AS company_id, g.main_parent_code AS main_parent_code, 0 AS is_subledger, 0 AS is_ar_ap, 0 AS ZoomType, 0 as Closing FROM mst_ledger_group g WHERE g.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) UNION ALL (SELECT l.id AS id, l.under_ledger_group_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(l.code_prefix)), l.name) AS CHAR(255) CHARSET UTF8) AS name, l.code AS code, l.master_type AS master_type, l.enterprise_id AS enterprise_id, l.company_id AS company_id, l.main_parent_code AS main_parent_code, l.is_subledger AS is_subledger, (CASE WHEN p1.nature_type IN (2 , 5) THEN 1 ELSE 0 END) AS is_ar_ap, (CASE WHEN p1.nature_type = 2 THEN 4033 WHEN p1.nature_type = 5 THEN 4047 WHEN l.cash_bank_type <> 0 THEN 4102 WHEN EXISTS(SELECT mst_ledger.id FROM mst_ledger WHERE mst_ledger.under_ledger_id IS NOT NULL AND mst_ledger.under_ledger_id = l.id) THEN 4024 ELSE 4026 END) AS ZoomType, tm_closing.amount as Closing FROM mst_ledger l LEFT JOIN mst_ledger_group p1 ON p1.id = l.under_ledger_group_id LEFT OUTER JOIN (Select tm.gl_id, Sum(Case When debit_credit = (Case when L.main_parent_code in ('10000000', '30000000') then 1 else 0 end) then amount else -amount end) as Amount from et_transaction_master tm LEFT OUTER JOIN mst_ledger L ON L.id = tm.gl_id where tm.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and tm.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311') and tm.approval_status = 1 and vdate <= '2026-04-17 23:59:59' And tm.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And (ifnull(tm.sub_type, 0) Not In (2, 1) OR tm.vdate <= '') group by tm.gl_id) as tm_closing on tm_closing.gl_id = l.id WHERE l.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) ORDER BY code) coa_view LEFT OUTER JOIN mst_ledger_group mp on (mp.code = coa_view.main_parent_code and mp.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and coa_view.master_type = 2104) LEFT OUTER JOIN mst_ledger l on l.id = coa_view.id LEFT OUTER JOIN mst_ledger_group g on g.id = l.under_ledger_group_id where coa_view.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and coa_view.main_parent_code in ('10000000', '20000000' , '20000000') and ifnull(coa_view.is_subledger,0) = 0 ) as A Where 1=1 and (master_type = 2028 OR voucher_id in ('e8c5d8b4-3f23-4fda-b6b7-42adb4aa925a', 'e9bee73f-5377-45b7-897b-73fec63a3fe4', '76b84d7e-04c7-4114-815d-83607a545a39', '8647040a-9005-42f1-965e-4b3d27a5fd2f', 'd7cf30a5-d998-480f-b7d4-c741a3e6ccd1') OR Not (Closing = 0) ) order by code Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:15 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_BalanceSheet_Horizontal ## ClientType: Desktop 20-04-2026 10:12:41 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select v.name as header_view_name, v.title as view_title, v.print_company_name, v.print_date_time, v.print_user_name, v.print_page_no, c.* from con_report_view v left outer join con_report_view_column c on c.view_id = v.id where v.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and v.report_type = 4093 order by c.view_id, c.sequence Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:41 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select name, col_expression, col_type from con_report_calculative_column where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4093 order by seq Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:41 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select view_id From con_report_view_default Where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4093 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:41 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_BalanceSheet Select * from (Select coa_view.name, coa_view.code, coa_view.master_type, coa_view.main_parent_code, mp.id as main_parent_id, coa_view.parent_id, (case when 0 = 1 then 4279 when g.nature_type = 2 then 4033 when g.nature_type = 5 then 4047 when l.cash_bank_type = 1 then (Case When 0 = 1 then 4280 else 4102 end) when l.cash_bank_type = 2 then (Case When 0 = 1 then 4280 else 4278 end) when ifnull(l.is_parent, 0) = 1 then 4024 else (Case When 0 = 1 then 4280 else 4026 end) end) AS ZoomType, coa_view.id as voucher_id, Round(IFNULL(Closing, 0), 3) as Closing, 0.1 as Closing_1, 0.1 as Closing_2, 0.1 as Closing_3, 0.1 as Closing_4, 0.1 as Closing_5, 0.1 as Closing_6, 0.1 as Closing_7, 0.1 as Closing_8, 0.1 as Closing_9, 0.1 as Closing_10, 0.1 as Closing_11, 0.1 as Closing_12 From ( (SELECT g.id AS id, g.parent_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(g.code_prefix)), g.name) AS CHAR(255) CHARSET UTF8) AS name, g.code AS code, g.master_type AS master_type, g.enterprise_id AS enterprise_id, g.company_id AS company_id, g.main_parent_code AS main_parent_code, 0 AS is_subledger, 0 AS is_ar_ap, 0 AS ZoomType, 0 as Closing FROM mst_ledger_group g WHERE g.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) UNION ALL (SELECT l.id AS id, l.under_ledger_group_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(l.code_prefix)), l.name) AS CHAR(255) CHARSET UTF8) AS name, l.code AS code, l.master_type AS master_type, l.enterprise_id AS enterprise_id, l.company_id AS company_id, l.main_parent_code AS main_parent_code, l.is_subledger AS is_subledger, (CASE WHEN p1.nature_type IN (2 , 5) THEN 1 ELSE 0 END) AS is_ar_ap, (CASE WHEN p1.nature_type = 2 THEN 4033 WHEN p1.nature_type = 5 THEN 4047 WHEN l.cash_bank_type <> 0 THEN 4102 WHEN EXISTS(SELECT mst_ledger.id FROM mst_ledger WHERE mst_ledger.under_ledger_id IS NOT NULL AND mst_ledger.under_ledger_id = l.id) THEN 4024 ELSE 4026 END) AS ZoomType, tm_closing.amount as Closing FROM mst_ledger l LEFT JOIN mst_ledger_group p1 ON p1.id = l.under_ledger_group_id LEFT OUTER JOIN (Select tm.gl_id, Sum(Case When debit_credit = (Case when L.main_parent_code in ('10000000', '30000000') then 1 else 0 end) then amount else -amount end) as Amount from et_transaction_master tm LEFT OUTER JOIN mst_ledger L ON L.id = tm.gl_id where tm.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and tm.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311') and tm.approval_status = 1 and vdate <= '2026-04-17 23:59:59' And tm.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And tm.vdate >= '2026-04-01 00:00:00' And (ifnull(tm.sub_type, 0) Not In (2, 1) OR tm.vdate <= '2026-04-01 00:00:00') group by tm.gl_id) as tm_closing on tm_closing.gl_id = l.id WHERE l.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) ORDER BY code) coa_view LEFT OUTER JOIN mst_ledger_group mp on (mp.code = coa_view.main_parent_code and mp.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and coa_view.master_type = 2104) LEFT OUTER JOIN mst_ledger l on l.id = coa_view.id LEFT OUTER JOIN mst_ledger_group g on g.id = l.under_ledger_group_id where coa_view.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and coa_view.main_parent_code in ('30000000', '40000000', '50000000') and ifnull(coa_view.is_subledger,0) = 0 ) as A Where 1=1 and (master_type = 2028 OR voucher_id in ('e8c5d8b4-3f23-4fda-b6b7-42adb4aa925a', 'e9bee73f-5377-45b7-897b-73fec63a3fe4', '76b84d7e-04c7-4114-815d-83607a545a39', '8647040a-9005-42f1-965e-4b3d27a5fd2f', 'd7cf30a5-d998-480f-b7d4-c741a3e6ccd1') OR Not (Closing = 0) ) order by code Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:41 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_ProfitLossStatement_Horizontal ## ClientType: Desktop 20-04-2026 10:12:51 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## fltLedgerGroup Select G.id, G.name, G.code, G.parent_id, G.nature_type, G.inactive, G.predefined, Parent.Name as UnderGroup from mst_ledger_group G LEFT OUTER JOIN mst_ledger_group Parent ON Parent.ID = G.parent_id Where G.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' And G.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and G.main_parent_code in ('30000000', '40000000') order by G.code Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:59 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_BalanceSheet Select * from (Select coa_view.name, coa_view.code, coa_view.master_type, coa_view.main_parent_code, mp.id as main_parent_id, coa_view.parent_id, (case when 0 = 1 then 4279 when g.nature_type = 2 then 4033 when g.nature_type = 5 then 4047 when l.cash_bank_type = 1 then (Case When 0 = 1 then 4280 else 4102 end) when l.cash_bank_type = 2 then (Case When 0 = 1 then 4280 else 4278 end) when ifnull(l.is_parent, 0) = 1 then 4024 else (Case When 0 = 1 then 4280 else 4026 end) end) AS ZoomType, coa_view.id as voucher_id, Round(IFNULL(Closing, 0), 3) as Closing, 0.1 as Closing_1, 0.1 as Closing_2, 0.1 as Closing_3, 0.1 as Closing_4, 0.1 as Closing_5, 0.1 as Closing_6, 0.1 as Closing_7, 0.1 as Closing_8, 0.1 as Closing_9, 0.1 as Closing_10, 0.1 as Closing_11, 0.1 as Closing_12 From ( (SELECT g.id AS id, g.parent_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(g.code_prefix)), g.name) AS CHAR(255) CHARSET UTF8) AS name, g.code AS code, g.master_type AS master_type, g.enterprise_id AS enterprise_id, g.company_id AS company_id, g.main_parent_code AS main_parent_code, 0 AS is_subledger, 0 AS is_ar_ap, 0 AS ZoomType, 0 as Closing FROM mst_ledger_group g WHERE g.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) UNION ALL (SELECT l.id AS id, l.under_ledger_group_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(l.code_prefix)), l.name) AS CHAR(255) CHARSET UTF8) AS name, l.code AS code, l.master_type AS master_type, l.enterprise_id AS enterprise_id, l.company_id AS company_id, l.main_parent_code AS main_parent_code, l.is_subledger AS is_subledger, (CASE WHEN p1.nature_type IN (2 , 5) THEN 1 ELSE 0 END) AS is_ar_ap, (CASE WHEN p1.nature_type = 2 THEN 4033 WHEN p1.nature_type = 5 THEN 4047 WHEN l.cash_bank_type <> 0 THEN 4102 WHEN EXISTS(SELECT mst_ledger.id FROM mst_ledger WHERE mst_ledger.under_ledger_id IS NOT NULL AND mst_ledger.under_ledger_id = l.id) THEN 4024 ELSE 4026 END) AS ZoomType, tm_closing.amount as Closing FROM mst_ledger l LEFT JOIN mst_ledger_group p1 ON p1.id = l.under_ledger_group_id LEFT OUTER JOIN (Select tm.gl_id, Sum(Case When debit_credit = (Case when L.main_parent_code in ('10000000', '30000000') then 1 else 0 end) then amount else -amount end) as Amount from et_transaction_master tm LEFT OUTER JOIN mst_ledger L ON L.id = tm.gl_id where tm.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and tm.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311') and tm.approval_status = 1 and vdate <= '2026-04-30 23:59:59' And tm.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And tm.vdate >= '2026-04-01 00:00:00' And (ifnull(tm.sub_type, 0) Not In (2, 1) OR tm.vdate <= '2026-04-01 00:00:00') group by tm.gl_id) as tm_closing on tm_closing.gl_id = l.id WHERE l.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) ORDER BY code) coa_view LEFT OUTER JOIN mst_ledger_group mp on (mp.code = coa_view.main_parent_code and mp.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and coa_view.master_type = 2104) LEFT OUTER JOIN mst_ledger l on l.id = coa_view.id LEFT OUTER JOIN mst_ledger_group g on g.id = l.under_ledger_group_id where coa_view.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and coa_view.main_parent_code in ('30000000', '40000000', '50000000') and ifnull(coa_view.is_subledger,0) = 0 ) as A Where 1=1 and (master_type = 2028 OR voucher_id in ('e8c5d8b4-3f23-4fda-b6b7-42adb4aa925a', 'e9bee73f-5377-45b7-897b-73fec63a3fe4', '76b84d7e-04c7-4114-815d-83607a545a39', '8647040a-9005-42f1-965e-4b3d27a5fd2f', 'd7cf30a5-d998-480f-b7d4-c741a3e6ccd1') OR Not (Closing = 0) ) order by code Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:12:59 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_ProfitLossStatement_Horizontal ## ClientType: Desktop 20-04-2026 10:13:17 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc Select id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003' and type = 10 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:17 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## EditList_Invoice Select i.id, i.vno, i.vdate, i.ref_no, i.ref_date, mst_party.name as party_name, i.bill_amount as amount_lc, i.bill_amount / i.conv_rate as amount_fc, i.currency_code, i.ref_vno, (Case IFNULL(i.approval_status,0) when 0 then 'Pending' when 1 then 'Approved' when 2 then 'Rejected' else '' end) as approval_status, (Case IFNULL(i.document_status,0) when 0 then 'Open' when 1 then 'Cancelled' when 4 then 'Hold' else '' end) as document_status, (select count(*) from log_print where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and vid = i.id) as print_count, (Case IFNULL(i.type,0) when 0 then 'Cash' when 1 then 'Credit' else '' end) as invoice_type, mst_cb_ledger.name as cash_bank_gl_name, (Case When ifnull( (case when i.vtype in (4, 5, 6, 8) and i.gst_type = 3 then i.e_comm_party_gst else mst_party.gst end), '') = '' then 'B2C' when (mst_party.gst_effective_from is not null and i.vdate < mst_party.gst_effective_from) then 'B2C' when gsp_resp.cancel_dt is not null then 'eInv Cancel' when ifnull(gsp_resp.Irn, '') <> '' and ifnull(i.eway_bill_no, '') <> '' then 'eInvoice / eWay' when ifnull(gsp_resp.Irn, '') <> '' then 'eInvoice' when i.eway_cancel_date is not null then 'eWay Cancel' when ifnull(i.eway_bill_no, '') <> '' then 'eWay' else 'Pending' end) as estatus, i.tax_amount_total from tr_invoice i left outer join mst_party on mst_party.id = i.party_id left outer join tr_invoice_gsp_response gsp_resp on gsp_resp.bill_id = i.id left outer join mst_ledger mst_cb_ledger on (mst_cb_ledger.id = i.cash_bank_gl_id and i.type=0) where i.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and i.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and i.vtype = 4 And i.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc' and i.vdate >= '2026-04-20 00:00:00' and i.vdate <= '2026-04-20 00:00:00' order by i.vdate, i.vno, mst_party.name, i.ref_no Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:19 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc Select id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003' and type = 10 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:19 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## EditList_Invoice Select i.id, i.vno, i.vdate, i.ref_no, i.ref_date, mst_party.name as party_name, i.bill_amount as amount_lc, i.bill_amount / i.conv_rate as amount_fc, i.currency_code, i.ref_vno, (Case IFNULL(i.approval_status,0) when 0 then 'Pending' when 1 then 'Approved' when 2 then 'Rejected' else '' end) as approval_status, (Case IFNULL(i.document_status,0) when 0 then 'Open' when 1 then 'Cancelled' when 4 then 'Hold' else '' end) as document_status, (select count(*) from log_print where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and vid = i.id) as print_count, (Case IFNULL(i.type,0) when 0 then 'Cash' when 1 then 'Credit' else '' end) as invoice_type, mst_cb_ledger.name as cash_bank_gl_name, (Case When ifnull( (case when i.vtype in (4, 5, 6, 8) and i.gst_type = 3 then i.e_comm_party_gst else mst_party.gst end), '') = '' then 'B2C' when (mst_party.gst_effective_from is not null and i.vdate < mst_party.gst_effective_from) then 'B2C' when gsp_resp.cancel_dt is not null then 'eInv Cancel' when ifnull(gsp_resp.Irn, '') <> '' and ifnull(i.eway_bill_no, '') <> '' then 'eInvoice / eWay' when ifnull(gsp_resp.Irn, '') <> '' then 'eInvoice' when i.eway_cancel_date is not null then 'eWay Cancel' when ifnull(i.eway_bill_no, '') <> '' then 'eWay' else 'Pending' end) as estatus, i.tax_amount_total from tr_invoice i left outer join mst_party on mst_party.id = i.party_id left outer join tr_invoice_gsp_response gsp_resp on gsp_resp.bill_id = i.id left outer join mst_ledger mst_cb_ledger on (mst_cb_ledger.id = i.cash_bank_gl_id and i.type=0) where i.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and i.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and i.vtype = 4 And i.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc' and i.vdate >= '2026-04-01 00:00:00' and i.vdate <= '2026-04-20 00:00:00' order by i.vdate, i.vno, mst_party.name, i.ref_no Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:26 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetVoucherNumber Select Max(num) as max_num From log_transaction where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and vtype = 4 and trim(prefix) = '' and suffix = '26-27' and vid <> '00000000-0000-0000-0000-000000000000' Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:37 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select v.name as header_view_name, v.title as view_title, v.print_company_name, v.print_date_time, v.print_user_name, v.print_page_no, c.* from con_report_view v left outer join con_report_view_column c on c.view_id = v.id where v.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and v.report_type = 4095 order by c.view_id, c.sequence Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:37 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select name, col_expression, col_type from con_report_calculative_column where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4095 order by seq Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:37 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select view_id From con_report_view_default Where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4095 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:37 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_BalanceSheet Select * from (Select coa_view.name, coa_view.code, coa_view.master_type, coa_view.main_parent_code, mp.id as main_parent_id, coa_view.parent_id, (case when 0 = 1 then 4279 when g.nature_type = 2 then 4033 when g.nature_type = 5 then 4047 when l.cash_bank_type = 1 then (Case When 1 = 1 then 4280 else 4102 end) when l.cash_bank_type = 2 then (Case When 1 = 1 then 4280 else 4278 end) when ifnull(l.is_parent, 0) = 1 then 4024 else (Case When 1 = 1 then 4280 else 4026 end) end) AS ZoomType, coa_view.id as voucher_id, Round(IFNULL(Closing, 0), 3) as Closing, 0.1 as Closing_1, 0.1 as Closing_2, 0.1 as Closing_3, 0.1 as Closing_4, 0.1 as Closing_5, 0.1 as Closing_6, 0.1 as Closing_7, 0.1 as Closing_8, 0.1 as Closing_9, 0.1 as Closing_10, 0.1 as Closing_11, 0.1 as Closing_12 From ( (SELECT g.id AS id, g.parent_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(g.code_prefix)), g.name) AS CHAR(255) CHARSET UTF8) AS name, g.code AS code, g.master_type AS master_type, g.enterprise_id AS enterprise_id, g.company_id AS company_id, g.main_parent_code AS main_parent_code, 0 AS is_subledger, 0 AS is_ar_ap, 0 AS ZoomType, 0 as Closing FROM mst_ledger_group g WHERE g.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) UNION ALL (SELECT l.id AS id, l.under_ledger_group_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(l.code_prefix)), l.name) AS CHAR(255) CHARSET UTF8) AS name, l.code AS code, l.master_type AS master_type, l.enterprise_id AS enterprise_id, l.company_id AS company_id, l.main_parent_code AS main_parent_code, l.is_subledger AS is_subledger, (CASE WHEN p1.nature_type IN (2 , 5) THEN 1 ELSE 0 END) AS is_ar_ap, (CASE WHEN p1.nature_type = 2 THEN 4033 WHEN p1.nature_type = 5 THEN 4047 WHEN l.cash_bank_type <> 0 THEN 4102 WHEN EXISTS(SELECT mst_ledger.id FROM mst_ledger WHERE mst_ledger.under_ledger_id IS NOT NULL AND mst_ledger.under_ledger_id = l.id) THEN 4024 ELSE 4026 END) AS ZoomType, tm_closing.amount as Closing FROM mst_ledger l LEFT JOIN mst_ledger_group p1 ON p1.id = l.under_ledger_group_id LEFT OUTER JOIN (Select tm.gl_id, Sum(Case When debit_credit = (Case when L.main_parent_code in ('10000000', '30000000') then 1 else 0 end) then amount else -amount end) as Amount from et_transaction_master tm LEFT OUTER JOIN mst_ledger L ON L.id = tm.gl_id where tm.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and tm.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311') and tm.approval_status = 1 and vdate <= '2026-04-17 23:59:59' And tm.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And (ifnull(tm.sub_type, 0) Not In (2, 1) OR tm.vdate <= '') group by tm.gl_id) as tm_closing on tm_closing.gl_id = l.id WHERE l.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) ORDER BY code) coa_view LEFT OUTER JOIN mst_ledger_group mp on (mp.code = coa_view.main_parent_code and mp.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and coa_view.master_type = 2104) LEFT OUTER JOIN mst_ledger l on l.id = coa_view.id LEFT OUTER JOIN mst_ledger_group g on g.id = l.under_ledger_group_id where coa_view.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and coa_view.main_parent_code in ('10000000', '20000000' , '20000000') and ifnull(coa_view.is_subledger,0) = 0 ) as A Where 1=1 and (master_type = 2028 OR voucher_id in ('e8c5d8b4-3f23-4fda-b6b7-42adb4aa925a', 'e9bee73f-5377-45b7-897b-73fec63a3fe4', '76b84d7e-04c7-4114-815d-83607a545a39', '8647040a-9005-42f1-965e-4b3d27a5fd2f', 'd7cf30a5-d998-480f-b7d4-c741a3e6ccd1') OR Not (Closing = 0) ) order by code Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:13:37 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_BalanceSheet_Horizontal ## ClientType: Desktop 20-04-2026 10:14:16 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select v.name as header_view_name, v.title as view_title, v.print_company_name, v.print_date_time, v.print_user_name, v.print_page_no, c.* from con_report_view v left outer join con_report_view_column c on c.view_id = v.id where v.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and v.report_type = 4095 order by c.view_id, c.sequence Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:14:16 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select name, col_expression, col_type from con_report_calculative_column where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4095 order by seq Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:14:16 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## GetMisc select view_id From con_report_view_default Where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and report_type = 4095 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:14:16 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## Rpt_BalanceSheet Select * from (Select coa_view.name, coa_view.code, coa_view.master_type, coa_view.main_parent_code, mp.id as main_parent_id, coa_view.parent_id, (case when 0 = 1 then 4279 when g.nature_type = 2 then 4033 when g.nature_type = 5 then 4047 when l.cash_bank_type = 1 then (Case When 1 = 1 then 4280 else 4102 end) when l.cash_bank_type = 2 then (Case When 1 = 1 then 4280 else 4278 end) when ifnull(l.is_parent, 0) = 1 then 4024 else (Case When 1 = 1 then 4280 else 4026 end) end) AS ZoomType, coa_view.id as voucher_id, Round(IFNULL(Closing, 0), 3) as Closing, 0.1 as Closing_1, 0.1 as Closing_2, 0.1 as Closing_3, 0.1 as Closing_4, 0.1 as Closing_5, 0.1 as Closing_6, 0.1 as Closing_7, 0.1 as Closing_8, 0.1 as Closing_9, 0.1 as Closing_10, 0.1 as Closing_11, 0.1 as Closing_12 From ( (SELECT g.id AS id, g.parent_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(g.code_prefix)), g.name) AS CHAR(255) CHARSET UTF8) AS name, g.code AS code, g.master_type AS master_type, g.enterprise_id AS enterprise_id, g.company_id AS company_id, g.main_parent_code AS main_parent_code, 0 AS is_subledger, 0 AS is_ar_ap, 0 AS ZoomType, 0 as Closing FROM mst_ledger_group g WHERE g.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) UNION ALL (SELECT l.id AS id, l.under_ledger_group_id AS parent_id, CAST(CONCAT(REPEAT(' ', LENGTH(l.code_prefix)), l.name) AS CHAR(255) CHARSET UTF8) AS name, l.code AS code, l.master_type AS master_type, l.enterprise_id AS enterprise_id, l.company_id AS company_id, l.main_parent_code AS main_parent_code, l.is_subledger AS is_subledger, (CASE WHEN p1.nature_type IN (2 , 5) THEN 1 ELSE 0 END) AS is_ar_ap, (CASE WHEN p1.nature_type = 2 THEN 4033 WHEN p1.nature_type = 5 THEN 4047 WHEN l.cash_bank_type <> 0 THEN 4102 WHEN EXISTS(SELECT mst_ledger.id FROM mst_ledger WHERE mst_ledger.under_ledger_id IS NOT NULL AND mst_ledger.under_ledger_id = l.id) THEN 4024 ELSE 4026 END) AS ZoomType, tm_closing.amount as Closing FROM mst_ledger l LEFT JOIN mst_ledger_group p1 ON p1.id = l.under_ledger_group_id LEFT OUTER JOIN (Select tm.gl_id, Sum(Case When debit_credit = (Case when L.main_parent_code in ('10000000', '30000000') then 1 else 0 end) then amount else -amount end) as Amount from et_transaction_master tm LEFT OUTER JOIN mst_ledger L ON L.id = tm.gl_id where tm.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and tm.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311') and tm.approval_status = 1 and vdate <= '2026-04-17 23:59:59' And tm.branch_id IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And (ifnull(tm.sub_type, 0) Not In (2, 1) OR tm.vdate <= '') group by tm.gl_id) as tm_closing on tm_closing.gl_id = l.id WHERE l.company_id in ('da4ea374-92ca-42d7-81f5-91752c307311')) ORDER BY code) coa_view LEFT OUTER JOIN mst_ledger_group mp on (mp.code = coa_view.main_parent_code and mp.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and coa_view.master_type = 2104) LEFT OUTER JOIN mst_ledger l on l.id = coa_view.id LEFT OUTER JOIN mst_ledger_group g on g.id = l.under_ledger_group_id where coa_view.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and coa_view.main_parent_code in ('10000000', '20000000' , '20000000') and ifnull(coa_view.is_subledger,0) = 0 ) as A Where 1=1 and (master_type = 2028 OR voucher_id in ('e8c5d8b4-3f23-4fda-b6b7-42adb4aa925a', 'e9bee73f-5377-45b7-897b-73fec63a3fe4', '76b84d7e-04c7-4114-815d-83607a545a39', '8647040a-9005-42f1-965e-4b3d27a5fd2f', 'd7cf30a5-d998-480f-b7d4-c741a3e6ccd1') OR Not (Closing = 0) ) order by code Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data ## ClientType: Desktop 20-04-2026 10:14:16 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_BalanceSheet_Horizontal ## ClientType: Desktop 20-04-2026 10:18:00 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:18:05 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:18:13 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:18:28 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:19:41 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:21:26 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('c2cventurepvtltd@gmail.com') And binary P.password in ('c2c@12345', 'c2c'c2c@12345'2345') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:22:25 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('c2cventurepvtltd@gmail.com') And binary P.password in ('c2c@12345', 'c2c'c2c@12345'2345') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:23:37 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('Shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:27:57 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:28:01 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('c2cventurepvtltd@gmail.com') And binary P.password in ('c2c@12345', 'c2c'c2c@12345'2345') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:28:08 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:28:24 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('c2cventurepvtltd@gmail.com') And binary P.password in ('c2c@12345', 'c2c'c2c@12345'2345') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:31:39 ## Exception ## You must reset your password using ALTER USER statement before executing this statement. ## DataAccess.GetData ## ## LoginUserCompanyID Select U.id as user_id, (Select company_id From ent_user_company_mapping where user_id = U.ID and enterprise_id = U.enterprise_id order by is_default desc Limit 1) as DefCompanyID From ent_user U LEFT OUTER JOIN ent_user_password P ON P.ID = (Select ID From ent_user_password Where user_id = U.ID And effective_from <= Now() Order By effective_from Desc Limit 1) where ucase(U.login_name) = ucase('shanthi') And binary P.password in ('Sh@nthi@123', 'Sh@nthi'Sh@nthi@123'23') and ifnull(U.inactive,0) = 0 Inner Exception: NULL Error: You must reset your password using ALTER USER statement before executing this statement. Source: MySql.Data 20-04-2026 10:40:32 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:41:02 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:42:57 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:43:17 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:44:22 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:44:47 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:45:18 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:45:36 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:47:11 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:49:50 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:57:02 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 10:57:17 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:18:17 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:20:01 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:22:17 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:22:33 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:26:25 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:26:27 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:33:09 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:43:15 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:48:47 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:51:09 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:51:53 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:52:53 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:53:38 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 11:54:24 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:08:26 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:12:32 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:16:18 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:20:46 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:22:20 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:27:52 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:28:37 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:31:38 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:47:08 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 12:47:48 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 13:41:35 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 14:47:40 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 14:47:40 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 14:50:05 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 14:50:06 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 14:50:29 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 14:52:22 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 15:09:53 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'Alingbookwin2019.mshome.net' (using password: YES) ## DataAccess.GetConnection ## ## 20-04-2026 15:17:45 ## Exception ## Table 'support.ab_survey_24_nov' doesn't exist ## DataAccess.GetData ## ## GetMisc Select cu.survey_index, (select count(*) from ab_survey_24_nov where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ifnull(survey_index, 0) = 4) as enterprise_count from ab_survey_24_nov cu where cu.user_id = '85d820ad-e168-4c45-a07e-e919ae5ed336' Inner Exception: NULL Error: Table 'support.ab_survey_24_nov' doesn't exist Source: MySql.Data 20-04-2026 15:23:39 ## Exception ## Table 'support.ab_survey_24_nov' doesn't exist ## DataAccess.GetData ## ## GetMisc Select cu.survey_index, (select count(*) from ab_survey_24_nov where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ifnull(survey_index, 0) = 4) as enterprise_count from ab_survey_24_nov cu where cu.user_id = '6511ab24-5862-49c9-96af-0813cd2f3003' Inner Exception: NULL Error: Table 'support.ab_survey_24_nov' doesn't exist Source: MySql.Data 20-04-2026 15:24:26 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 15:24:26 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 15:28:47 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 15:30:13 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 15:34:40 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-19 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 15:35:26 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 15:38:37 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-19 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-19 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 15:39:18 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 15:44:15 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 15:45:12 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 15:45:41 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 15:46:29 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 15:56:13 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 15:57:02 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 16:00:10 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:01:27 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 16:01:39 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:02:37 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 16:08:06 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:09:18 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 16:09:27 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:10:29 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 16:10:48 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:11:39 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 16:11:49 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:11:49 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 16:12:13 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 8 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-01 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-01 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 8 = 7 then 2201 else 2202 end) and r.price_category_id = '' and r.effective_from <= '2026-04-01 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '8fb5df02-6e24-4360-a1c7-c0685acdc4fb' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:13:47 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 16:15:59 ## Exception ## Table 'support.ab_survey_24_nov' doesn't exist ## DataAccess.GetData ## ## GetMisc Select cu.survey_index, (select count(*) from ab_survey_24_nov where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ifnull(survey_index, 0) = 4) as enterprise_count from ab_survey_24_nov cu where cu.user_id = '6511ab24-5862-49c9-96af-0813cd2f3003' Inner Exception: NULL Error: Table 'support.ab_survey_24_nov' doesn't exist Source: MySql.Data 20-04-2026 16:32:17 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:33:03 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:33:03 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 16:33:18 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 16:57:35 ## Exception ## Table 'support.ab_survey_24_nov' doesn't exist ## DataAccess.GetData ## ## GetMisc Select cu.survey_index, (select count(*) from ab_survey_24_nov where enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ifnull(survey_index, 0) = 4) as enterprise_count from ab_survey_24_nov cu where cu.user_id = '85d820ad-e168-4c45-a07e-e919ae5ed336' Inner Exception: NULL Error: Table 'support.ab_survey_24_nov' doesn't exist Source: MySql.Data 20-04-2026 16:58:07 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '85d820ad-e168-4c45-a07e-e919ae5ed336')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:58:07 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 16:58:07 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-03-31 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-03-31 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '85d820ad-e168-4c45-a07e-e919ae5ed336')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:58:07 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 16:58:25 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '85d820ad-e168-4c45-a07e-e919ae5ed336')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 16:58:25 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 17:00:11 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '85d820ad-e168-4c45-a07e-e919ae5ed336')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 17:00:11 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 17:00:12 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-03-31 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-03-31 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '85d820ad-e168-4c45-a07e-e919ae5ed336')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 17:00:12 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 17:00:33 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 17:01:45 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 17:01:47 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## GetItemInfo Select I.company_id, I.ID, mst_rate.master_id as rate_master_id, (Case when mst_rate.id is null then I.mrp else mst_rate.mrp end) as mrp, (Case when mst_rate.id is null then I.wholesale_rate else mst_rate.wholesale_rate end) as wholesale_rate, (Case when mst_rate.id is null then I.dealer_rate else mst_rate.dealer_rate end) as dealer_rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_rate else I.purchase_rate end) else mst_rate.rate end) as rate, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_1 else I.purchase_misc_1 end) else mst_rate.misc1 end) as misc1, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_2 else I.purchase_misc_2 end) else mst_rate.misc2 end) as misc2, (Case when mst_rate.id is null then(case when 7 = 7 then I.sales_misc_3 else I.purchase_misc_3 end) else mst_rate.misc3 end) as misc3, (Case when mst_rate.id is null then I.min_rate else mst_rate.min_rate end) as min_rate, GetItemBalance('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00') as item_balance, GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', I.id, '', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', '', '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 00:00:00', 0, 0, 0) as StockValuation From mst_item I LEFT OUTER JOIN mst_rate on mst_rate.id = (select id from mst_rate r where r.item_id = I.id and r.master_type = (case when 7 = 7 then 2201 else 2202 end) and r.price_category_id = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2026-04-20 00:00:00' and r.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and (r.branch_id is null or r.branch_id = 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc') order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and I.company_id IN ('da4ea374-92ca-42d7-81f5-91752c307311', '') and I.id = '4eb3d55c-e4d4-41c1-af36-feaa900d0066' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 17:02:43 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 17:02:43 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop 20-04-2026 17:02:48 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 20-04-2026 17:03:16 ## Exception ## FUNCTION maindb001.GetStockValuationFinal does not exist ## DataAccess.GetData ## ## Rpt_StockValuation Select * from( Select 4060 as ZoomType, group_id, item_id as voucher_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, gst_classification_id, stock_vs_pack, rate_per, rack_box, item_type, item_id, group_name, category_name, unit_name, Sum(closing_stk_qty) as closing_qty, Sum(closing_pack_qty) as closing_pack_qty, Sum(closing_stk_qty * rate_valuation) as amount, (case when Sum(closing_stk_qty) <> 0 then (Sum(closing_stk_qty * rate_valuation) / Sum(closing_stk_qty)) * rate_per else 0 end) as rate from ( Select A.*, ifnull(GetStockValuationFinal('6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', A.item_id, '', A.branch_id, A.warehouse_id, '', 0, '00000000-0000-0000-0000-000000000000', '2026-04-20 23:59:59', 0, 0, A.closing_stk_qty), 0) as rate_valuation from ( Select mst_item.group_id, mst_item.name as item_name, mst_item.code as item_code, mst_item.sales_description, mst_brand.name as brand_name, mst_item.udf1 as item_master_udf1, mst_item.udf2 as item_master_udf2, mst_item.udf3 as item_master_udf3, mst_item.udf4 as item_master_udf4, mst_item.udf5 as item_master_udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rate_per, mst_item.rack_box, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) as item_type, ST.item_id as item_id, mst_item_group.name as group_name, mst_item_category.name as category_name, mst_item_unit.name as unit_name, mst_location.name as location_name, ST.branch_id, ST.warehouse_id, mst_warehouse.name as warehouse_name, mst_gst_classification.name as hsn_code, sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) as closing_stk_qty, sum(case when ST.ri_tag = 0 then ST.pack_qty else -ST.pack_qty end) as closing_pack_qty from et_stock ST LEFT OUTER JOIN mst_item ON mst_item.id = ST.item_id LEFT OUTER JOIN mst_item_group ON mst_item_group.id = mst_item.group_id LEFT OUTER JOIN mst_item_category ON mst_item_category.id = mst_item.item_category_id left outer join mst_brand on mst_brand.id = mst_item.brand_id LEFT OUTER JOIN mst_item_unit ON mst_item_unit.id = mst_item.stock_unit_id LEFT OUTER JOIN mst_location ON mst_location.id = ST.branch_id LEFT OUTER JOIN mst_warehouse ON mst_warehouse.id = ST.warehouse_id LEFT OUTER JOIN mst_gst_classification ON mst_gst_classification.id = mst_item.gst_classification_id Where ST.enterprise_id = '6700a7e5-5008-4d8c-9671-26fe90448bce' and ST.company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and ST.VDate <= '2026-04-20 23:59:59' and ifnull(ST.approval_status, 0) = 1 And ST.branch_ID IN (Select id from mst_location where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and id not in(select master_id from con_user_permission_data_skip where company_id = 'da4ea374-92ca-42d7-81f5-91752c307311' and type = 1 and user_id = '6511ab24-5862-49c9-96af-0813cd2f3003')) And ifnull(ST.with_jobber,0) = 0 Group by mst_item.group_id, mst_item.name, mst_item.code, mst_item.sales_description, mst_brand.name, mst_item.udf1, mst_item.udf2, mst_item.udf3, mst_item.udf4, mst_item.udf5, mst_item.barcode, mst_item.sales_rate, mst_item.gst_classification_id, mst_item.stock_vs_pack, mst_item.rack_box, mst_item.rate_per, (Case IFNULL(mst_item.type,0) when 0 then 'FinishProduct' when 1 then 'Consumable' when 2 then 'RawMaterial' when 3 then 'PackingMaterial' when 4 then 'Scrap' when 5 then 'Service' when 6 then 'Asset' when 7 then 'Rental' when 8 then 'SemiFinish' when 9 then 'TradeGoods' when 10 then 'ImportedAsset' when 11 then 'ServiceWithBOQ' when 12 then 'BOMBasedItem' else '' end) , ST.item_id, mst_item_group.name, mst_item_category.name, mst_location.name, ST.branch_id, ST.warehouse_id, mst_warehouse.name, mst_item_unit.name, mst_gst_classification.name having sum(case when ST.ri_tag = 0 then ST.qty else -ST.qty end) <> 0 ) as A ) as B Group by group_id, item_name, item_code, sales_description, brand_name, item_master_udf1, item_master_udf2, item_master_udf3, item_master_udf4, item_master_udf5, barcode, sales_rate, stock_vs_pack, rack_box, rate_per, item_type, item_id, group_name, category_name, unit_name, hsn_code ) C where 1=1 and closing_qty <> 0 order by item_name Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 20-04-2026 17:03:16 ## Exception ## Object reference not set to an instance of an object. ## FABReportService.GetReportData ## ## Object reference not set to an instance of an object. Report Type: Rpt_StockValuation ## ClientType: Desktop