Statement of CST Sales for the Month.....

[Former Member]

Hi All,

I have to make a report named "Statement of CST Sales for the Month....." for one of my client. This report contains the fields CST Payable and CST Paid (invoice wise). Please help me by telling where can I get CST Paid per invoice (Table Name, Field Name).

[former_member187989 · Accepted solution]

hi,

You can get it from TaxSum from Table PCH4 with staType for CST.

Try this query

SELECT T0.DocNum as 'Ap INV. No.', T0.DocDate, T0.CardName as 'Vendor Name',
T1.TaxSum AS 'CST on Purchase'
FROM [dbo].[Opch]  T0 INNER JOIN pch4 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.staType = 4

Jeyakanthan