21-11-2025 08:14:11 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 08:14:11 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 08:32:20 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 08:32:20 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 08:53:24 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 08:53:49 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 08:53:49 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 08:55:09 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 08:58:06 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 09:48:50 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 09:48:50 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 10:46:55 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 10:46:55 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 11:20:26 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 11:20:26 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 11:51:06 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 11:51:06 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 11:51:10 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 11:51:36 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 12:03:49 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 12:03:49 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 12:20:31 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 12:20:31 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 12:20:40 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 12:22:08 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 12:23:28 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 12:30:01 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 12:32:13 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 12:33:28 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 13:39:16 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 13:39:16 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 14:45:42 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 14:45:42 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 14:55:57 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 14:55:57 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 14:57:51 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 14:57:51 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 15:13:42 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 15:24:37 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 15:24:37 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 15:27:54 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 15:28:22 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 15:39:12 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 15:39:12 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 15:41:24 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 15:41:58 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 15:41:58 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 15:55:08 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 15:55:08 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 16:31:18 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 16:32:20 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 16:33:40 ## Exception ## Unable to connect to the remote server ## FABUtilityService.UploadFileOnFTP ## ## FTP File Load Error **** Unable to connect to the remote server 21-11-2025 16:35:36 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'e62e00b3-b87c-4827-8e79-a09bba3559df', I.id, '', 'dfdaa50d-7dd0-42c8-affa-bd25c521b4f4', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'e62e00b3-b87c-4827-8e79-a09bba3559df', I.id, '', '', 'dfdaa50d-7dd0-42c8-affa-bd25c521b4f4', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2025-11-21 00:00:00' and r.company_id = 'e62e00b3-b87c-4827-8e79-a09bba3559df' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('e62e00b3-b87c-4827-8e79-a09bba3559df', '') and I.id = '3b7c4316-e982-4efc-a077-1fcbba27254a' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 16:37:07 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'e62e00b3-b87c-4827-8e79-a09bba3559df', I.id, '', 'dfdaa50d-7dd0-42c8-affa-bd25c521b4f4', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', 'e62e00b3-b87c-4827-8e79-a09bba3559df', I.id, '', '', 'dfdaa50d-7dd0-42c8-affa-bd25c521b4f4', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 = '00000000-0000-0000-0000-000000000000' and r.effective_from <= '2025-11-21 00:00:00' and r.company_id = 'e62e00b3-b87c-4827-8e79-a09bba3559df' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('e62e00b3-b87c-4827-8e79-a09bba3559df', '') and I.id = '3b7c4316-e982-4efc-a077-1fcbba27254a' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 16:56:31 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '4291409c-058c-4eec-b12b-b8733d9cde7a', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '4291409c-058c-4eec-b12b-b8733d9cde7a', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '4291409c-058c-4eec-b12b-b8733d9cde7a' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('4291409c-058c-4eec-b12b-b8733d9cde7a', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = 'f32f8aeb-94ba-4bb7-a757-3eacbacd57df' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 16:58: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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2b2dc402-5d2f-4246-9589-0dadc2828adf', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2b2dc402-5d2f-4246-9589-0dadc2828adf', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '2b2dc402-5d2f-4246-9589-0dadc2828adf' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('2b2dc402-5d2f-4246-9589-0dadc2828adf', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '27908f81-2217-4ab7-8bb4-07837ad4c94e' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 16:59:09 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2b2dc402-5d2f-4246-9589-0dadc2828adf', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2b2dc402-5d2f-4246-9589-0dadc2828adf', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '2b2dc402-5d2f-4246-9589-0dadc2828adf' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('2b2dc402-5d2f-4246-9589-0dadc2828adf', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '27908f81-2217-4ab7-8bb4-07837ad4c94e' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 16:59:58 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '4291409c-058c-4eec-b12b-b8733d9cde7a', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '4291409c-058c-4eec-b12b-b8733d9cde7a', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '4291409c-058c-4eec-b12b-b8733d9cde7a' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('4291409c-058c-4eec-b12b-b8733d9cde7a', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = 'f32f8aeb-94ba-4bb7-a757-3eacbacd57df' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 17:00: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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2b2dc402-5d2f-4246-9589-0dadc2828adf', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '2b2dc402-5d2f-4246-9589-0dadc2828adf', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '2b2dc402-5d2f-4246-9589-0dadc2828adf' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('2b2dc402-5d2f-4246-9589-0dadc2828adf', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = '27908f81-2217-4ab7-8bb4-07837ad4c94e' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 17:07:14 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = 'c6d4d207-730a-42d6-9fb8-271f98c7ab44' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 17:08: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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = 'c6d4d207-730a-42d6-9fb8-271f98c7ab44' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 17:09:14 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 17:09:14 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 17:10:05 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = 'c6d4d207-730a-42d6-9fb8-271f98c7ab44' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 17:11:07 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = 'c6d4d207-730a-42d6-9fb8-271f98c7ab44' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 17:12:56 ## 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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = 'c6d4d207-730a-42d6-9fb8-271f98c7ab44' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop 21-11-2025 17:17:29 ## Exception ## Table 'support.enterprise_stats' doesn't exist ## DataAccess.SetData ## ## Exception in query: UpdateLoginCount update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Table 'support.enterprise_stats' doesn't exist update enterprise_stats set dsk_log_count = ifnull(dsk_log_count, 0) + 1 where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3'; Inner Exception: NULL Source: MySql.Data Platform: Desktop 21-11-2025 17:17:29 ## Exception ## Table 'support.feedback' doesn't exist ## DataAccess.GetData ## ## GetMisc Select * from feedback where enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and ifnull(rating, 0) <> 0 and ifnull(rating_web, 0) = 0 order by updated_at desc limit 1 Inner Exception: NULL Error: Table 'support.feedback' doesn't exist Source: MySql.Data 21-11-2025 17:18: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('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '00000000-0000-0000-0000-000000000000', '2025-11-21 00:00:00') as item_balance, GetStockValuationFinal('f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3', '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', I.id, '', '', '', '', 0, '00000000-0000-0000-0000-000000000000', '2025-11-21 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 <= '2025-11-21 00:00:00' and r.company_id = '3eb17f78-be3d-4a90-84ec-421bf4a2c7bb' order by branch_id desc, effective_from desc limit 1) Where I.enterprise_id = 'f1c5aa05-c5f9-4f0b-a3ec-f2ed78e77bf3' and I.company_id IN ('3eb17f78-be3d-4a90-84ec-421bf4a2c7bb', 'e62e00b3-b87c-4827-8e79-a09bba3559df') and I.id = 'c6d4d207-730a-42d6-9fb8-271f98c7ab44' Inner Exception: NULL Error: FUNCTION maindb001.GetStockValuationFinal does not exist Source: MySql.Data ## ClientType: Desktop