Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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).

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos


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


Answers (0)