Error - Multi Part Identifier could not be bound

Hi Ramco,

Its due to orderby you have use c.credit and you have given alias name into your select statement, As Tahir Ansari suggested you need to change in your order by clause, just change below line in your query, it should work,

ORDER BY [CREDIT(LC)]

SELECT *
FROM (
    SELECT 
        CASE WHEN ROW_NUMBER() OVER (PARTITION BY A.DOCNUM ORDER BY A.DOCNUM) = 1 THEN 'Payment' ELSE NULL END AS 'Type',
        CASE WHEN ROW_NUMBER() OVER (PARTITION BY A.DOCNUM ORDER BY A.DOCNUM) = 1 THEN a.DocDate ELSE NULL END AS [Posting Date],
        CASE WHEN ROW_NUMBER() OVER (PARTITION BY A.DOCNUM ORDER BY A.DOCNUM) = 1 THEN a.DocNum ELSE NULL END AS [Document No],
        CASE WHEN d.AcctName <> '' THEN d.AcctName ELSE e.CardName END AS 'Particulars',
        CASE WHEN c.Debit = 0.00 THEN NULL ELSE c.Debit END AS [DEBIT(LC)],
        CASE WHEN c.Credit = 0.00 THEN NULL ELSE c.Credit END AS [CREDIT(LC)],
        CASE WHEN c.FCDebit = 0.00 THEN NULL ELSE c.FCDebit END AS [DEBIT(FC)],
        CASE WHEN c.FCCredit = 0.00 THEN NULL ELSE c.FCCredit END AS [CREDIT(FC)]
    FROM OVPM a
    LEFT JOIN ojdt b ON b.TransId = a.TransId
    LEFT JOIN jdt1 c ON c.TransId = b.TransId
    LEFT JOIN oact d ON d.AcctCode = c.ShortName
    LEFT JOIN ocrd e ON e.CardCode = c.ShortName
    WHERE a.docdate = '2023/09/26' AND a.CANCELED = 'N'
) AS subquery
ORDER BY [CREDIT(LC)] -- Use the alias from the subquery