(pdo-mysql): INSERT INTO sc_log (inserted_date, username, application, creator, ip_user, action, description) VALUES ('2026-08-26 06:22:41', '', 'grid_cbvinvdetails_daily_cheque_bouncing_report', 'Scriptcase', '192.168.0.21', 'access', '')

(pdo-mysql): select count(*) from (SELECT inv.SlDivCd, vch.LocCd, cust.CustName, cust.City, vch.SubLdCd AS CustCd, vch.VchId, vch.VchDate, vch.ChequeNo, vch.ChequeDate, inv.IGpId, inv.InvDt, vch.CbvRsn, inv.InvAmt, 'Selected Period' AS Period FROM cbvinvdetails inv JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid JOIN .custmst cust ON cust.CustCd=vch.SubLdCd WHERE ( '' IS NULL OR '' = '' OR inv.SlDivCd = '' ) AND vch.ChequeDate IS NOT NULL AND vch.VchDate BETWEEN '' AND '' UNION ALL SELECT inv.SlDivCd, NULL AS LocCd, NULL AS CustName, NULL AS City, NULL AS CustCd, NULL AS VchId, NULL AS VchDate, NULL AS ChequeNo, NULL AS ChequeDate, NULL AS IGpId, NULL AS InvDt, NULL AS CbvRsn, SUM(inv.InvAmt) AS InvAmt, 'Selected Period Subtotal' AS Period FROM cbvinvdetails inv JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid WHERE ( '' IS NULL OR '' = '' OR inv.SlDivCd = '' ) AND vch.VchDate IS NOT NULL AND vch.VchDate BETWEEN '' AND '' GROUP BY inv.SlDivCd UNION ALL SELECT inv.SlDivCd, NULL AS LocCd, NULL AS CustName, NULL AS City, NULL AS CustCd, NULL AS VchId, NULL AS VchDate, NULL AS ChequeNo, NULL AS ChequeDate, NULL AS IGpId, NULL AS InvDt, NULL AS CbvRsn, SUM(inv.InvAmt) AS InvAmt, 'MTD Subtotal' AS Period FROM cbvinvdetails inv JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid WHERE ( '' IS NULL OR '' = '' OR inv.SlDivCd = '' ) AND vch.VchDate IS NOT NULL AND vch.VchDate BETWEEN DATE_FORMAT('', '%Y-%m-01') AND '' GROUP BY inv.SlDivCd ORDER BY SlDivCd, FIELD(Period, 'Selected Period', 'Selected Period Subtotal', 'MTD Subtotal')) nm_sel_esp

1146: Table 'yashutilitty.custmst' doesn't exist

            ADOConnection._Execute(select count(*) from (SELECT     inv.SlDivCd,     vch.LocCd,     cust.CustName,     cust.City,     vch.SubLdCd AS CustCd,     vc..., false) % line 1206, file: adodb.inc.php
         ADOConnection.Execute(select count(*) from (SELECT     inv.SlDivCd,     vch.LocCd,     cust.CustName,     cust.City,     vch.SubLdCd AS CustCd,     vc...) % line   70, file: grid_cbvinvdetails_daily_cheque_bouncing_report_total.class.php
      grid_cbvinvdetails_daily_cheque_bouncing_report_total.quebra_geral_sc_free_total() % line  914, file: grid_cbvinvdetails_daily_cheque_bouncing_report_grid.class.php
   grid_cbvinvdetails_daily_cheque_bouncing_report_grid.inicializa() % line  157, file: grid_cbvinvdetails_daily_cheque_bouncing_report_grid.class.php
grid_cbvinvdetails_daily_cheque_bouncing_report_grid.monta_grid(0) % line 4197, file: index.php

Warning

Error while accessing the database
Table 'yashutilitty.custmst' doesn't exist
select count(*) from (SELECT inv.SlDivCd, vch.LocCd, cust.CustName, cust.City, vch.SubLdCd AS CustCd, vch.VchId, vch.VchDate, vch.ChequeNo, vch.ChequeDate, inv.IGpId, inv.InvDt, vch.CbvRsn, inv.InvAmt, 'Selected Period' AS Period FROM cbvinvdetails inv JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid JOIN .custmst cust ON cust.CustCd=vch.SubLdCd WHERE ( '' IS NULL OR '' = '' OR inv.SlDivCd = '' ) AND vch.ChequeDate IS NOT NULL AND vch.VchDate BETWEEN '' AND '' UNION ALL SELECT inv.SlDivCd, NULL AS LocCd, NULL AS CustName, NULL AS City, NULL AS CustCd, NULL AS VchId, NULL AS VchDate, NULL AS ChequeNo, NULL AS ChequeDate, NULL AS IGpId, NULL AS InvDt, NULL AS CbvRsn, SUM(inv.InvAmt) AS InvAmt, 'Selected Period Subtotal' AS Period FROM cbvinvdetails inv JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid WHERE ( '' IS NULL OR '' = '' OR inv.SlDivCd = '' ) AND vch.VchDate IS NOT NULL AND vch.VchDate BETWEEN '' AND '' GROUP BY inv.SlDivCd UNION ALL SELECT inv.SlDivCd, NULL AS LocCd, NULL AS CustName, NULL AS City, NULL AS CustCd, NULL AS VchId, NULL AS VchDate, NULL AS ChequeNo, NULL AS ChequeDate, NULL AS IGpId, NULL AS InvDt, NULL AS CbvRsn, SUM(inv.InvAmt) AS InvAmt, 'MTD Subtotal' AS Period FROM cbvinvdetails inv JOIN cbvvoucher vch ON inv.cbvvoucherid = vch.cbvvoucherid WHERE ( '' IS NULL OR '' = '' OR inv.SlDivCd = '' ) AND vch.VchDate IS NOT NULL AND vch.VchDate BETWEEN DATE_FORMAT('', '%Y-%m-01') AND '' GROUP BY inv.SlDivCd ORDER BY SlDivCd, FIELD(Period, 'Selected Period', 'Selected Period Subtotal', 'MTD Subtotal')) nm_sel_esp

Script: /var/www/html/yperputility/grid_cbvinvdetails_daily_cheque_bouncing_report/grid_cbvinvdetails_daily_cheque_bouncing_report_total.class.php (72)