ERROR - 2025-09-01 11:24:46 --> Severity: Notice --> Undefined variable: tStaVatBuy C:\WebServer\Apache24\htdocs\AdaPos5.0-LeonianSit\application\modules\common\views\wFooter.php 462
ERROR - 2025-09-01 11:24:46 --> Severity: Notice --> Undefined variable: tStaVat C:\WebServer\Apache24\htdocs\AdaPos5.0-LeonianSit\application\modules\common\views\wFooter.php 463
ERROR - 2025-09-01 11:24:46 --> Severity: Notice --> Undefined variable: nStaAddOrEdit C:\WebServer\Apache24\htdocs\AdaPos5.0-LeonianSit\application\modules\common\views\wFooter.php 464
ERROR - 2025-09-01 11:31:44 --> Query error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'CSTCR'. - Invalid query: 
            SELECT 
                CSTCR.*,
                (CSTCR.FCCstCrBalExt - CSTCR.FCCstCrAmtBuffer - CSTCR.FCCstCrLeft) AS FCCstCrBalLeft
            FROM (
                SELECT TOP 30
                    CST.FTCstCode,
                    CSTL.FTCstName,
                    CRD.FTCstStaApv,    
                    ISNULL(CRD.FCCstCrLimit,0.0)    AS FCCstCrLimit,
                    ISNULL(CRD.FCCstCrBuffer,0.0) 	AS FCCstCrBuffer,
                    ((ISNULL(CRD.FCCstCrLimit,0.0) * ISNULL(CRD.FCCstCrBuffer, 0.0))/100)   AS FCCstCrAmtBuffer,
                    ISNULL(FCCstCrBalExt,0)         AS FCCstCrBalExt,
                    ISNULL(HDSAL.FCXshLeft,0)       AS FCCstCrLeft,
                    CST.FDCreateOn
                FROM TCNMCst CST WITH(NOLOCK)
                LEFT JOIN TCNMCst_L CSTL WITH(NOLOCK) ON CST.FTCstCode = CSTL.FTCstCode AND CSTL.FNLngID = '1'
                LEFT JOIN TCNMCstCredit CRD WITH(NOLOCK) ON CST.FTCstCode = CRD.FTCstCode
                LEFT JOIN (
                    SELECT HD.FTCstCode,SUM(HD.FCXshLeft) AS FCXshLeft
                    FROM TPSTSalHD HD WITH(NOLOCK)
                    WHERE ISNULL(HD.FTCstCode,'') <> '' AND HD.FCXshLeft > 0
                    GROUP BY HD.FTCstCode
                ) HDSAL ON CST.FTCstCode = HDSAL.FTCstCode
                WHERE CST.FDCreateOn <> ''
         AND ( ISNULL(CST.FTAgnCode,'')='' OR CST.FTAgnCode = '00001'  ) CSTCR ORDER BY CSTCR.FDCreateOn DESC
ERROR - 2025-09-01 12:00:52 --> Query error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'CSTCR'. - Invalid query: 
            SELECT 
                CSTCR.*,
                (CSTCR.FCCstCrBalExt - CSTCR.FCCstCrAmtBuffer - CSTCR.FCCstCrLeft) AS FCCstCrBalLeft
            FROM (
                SELECT TOP 30
                    CST.FTCstCode,
                    CSTL.FTCstName,
                    CRD.FTCstStaApv,    
                    ISNULL(CRD.FCCstCrLimit,0.0)    AS FCCstCrLimit,
                    ISNULL(CRD.FCCstCrBuffer,0.0) 	AS FCCstCrBuffer,
                    ((ISNULL(CRD.FCCstCrLimit,0.0) * ISNULL(CRD.FCCstCrBuffer, 0.0))/100)   AS FCCstCrAmtBuffer,
                    ISNULL(FCCstCrBalExt,0)         AS FCCstCrBalExt,
                    ISNULL(HDSAL.FCXshLeft,0)       AS FCCstCrLeft,
                    CST.FDCreateOn
                FROM TCNMCst CST WITH(NOLOCK)
                LEFT JOIN TCNMCst_L CSTL WITH(NOLOCK) ON CST.FTCstCode = CSTL.FTCstCode AND CSTL.FNLngID = '1'
                LEFT JOIN TCNMCstCredit CRD WITH(NOLOCK) ON CST.FTCstCode = CRD.FTCstCode
                LEFT JOIN (
                    SELECT HD.FTCstCode,SUM(HD.FCXshLeft) AS FCXshLeft
                    FROM TPSTSalHD HD WITH(NOLOCK)
                    WHERE ISNULL(HD.FTCstCode,'') <> '' AND HD.FCXshLeft > 0
                    GROUP BY HD.FTCstCode
                ) HDSAL ON CST.FTCstCode = HDSAL.FTCstCode
                WHERE CST.FDCreateOn <> ''
         AND ( ISNULL(CST.FTAgnCode,'')='' OR CST.FTAgnCode = '00001'  ) CSTCR ORDER BY CSTCR.FDCreateOn DESC
ERROR - 2025-09-01 12:01:10 --> Query error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'CSTCR'. - Invalid query: 
            SELECT 
                CSTCR.*,
                (CSTCR.FCCstCrBalExt - CSTCR.FCCstCrAmtBuffer - CSTCR.FCCstCrLeft) AS FCCstCrBalLeft
            FROM (
                SELECT TOP 30
                    CST.FTCstCode,
                    CSTL.FTCstName,
                    CRD.FTCstStaApv,    
                    ISNULL(CRD.FCCstCrLimit,0.0)    AS FCCstCrLimit,
                    ISNULL(CRD.FCCstCrBuffer,0.0) 	AS FCCstCrBuffer,
                    ((ISNULL(CRD.FCCstCrLimit,0.0) * ISNULL(CRD.FCCstCrBuffer, 0.0))/100)   AS FCCstCrAmtBuffer,
                    ISNULL(FCCstCrBalExt,0)         AS FCCstCrBalExt,
                    ISNULL(HDSAL.FCXshLeft,0)       AS FCCstCrLeft,
                    CST.FDCreateOn
                FROM TCNMCst CST WITH(NOLOCK)
                LEFT JOIN TCNMCst_L CSTL WITH(NOLOCK) ON CST.FTCstCode = CSTL.FTCstCode AND CSTL.FNLngID = '1'
                LEFT JOIN TCNMCstCredit CRD WITH(NOLOCK) ON CST.FTCstCode = CRD.FTCstCode
                LEFT JOIN (
                    SELECT HD.FTCstCode,SUM(HD.FCXshLeft) AS FCXshLeft
                    FROM TPSTSalHD HD WITH(NOLOCK)
                    WHERE ISNULL(HD.FTCstCode,'') <> '' AND HD.FCXshLeft > 0
                    GROUP BY HD.FTCstCode
                ) HDSAL ON CST.FTCstCode = HDSAL.FTCstCode
                WHERE CST.FDCreateOn <> ''
         AND ( ISNULL(CST.FTAgnCode,'')='' OR CST.FTAgnCode = '00001'  ) CSTCR ORDER BY CSTCR.FDCreateOn DESC