Skip to Content
0
Jun 14, 2011 at 06:09 AM

Query Check

35 Views

Dear Experts..

Plz check this query. I created UDF for TAX details in Reports for Accounts. UDF are running well. Then created Report for same. But the UDF VAlue is not retrieving in Report.

*SELECT T0.[DocNum], T0.[CardCode] As 'Vendor Code',T0.[CardName] As 'Vendor Name', T0.[NumAtCard] As 'Vendor Ref. No.', T0.[DocDate], T0.[TaxDate], T0.[DocTotal] - T0.[VatSum] As 'Basic Value of Goods', T0.[U_CENVAT] As 'CENVAT', T0.[U_ECess], T0.[U_HSCess], T0.[U_VAT_4], T0.[U_Add_VAT1], T0.[U_VAT_12],

T0.[U_Add_VAT2], T0.[U_CST2], T0.[U_CST4], T0.[U_CST5], T0.[U_Service_Tax], T0.[U_ST_ECess], T0.[U_ST_HSCess],T0.[TotalExpns] As 'Others',T0.[DocTotal] - T0.[VATSUM] As 'Total' FROM OPCH T0 WHERE T0.[docType] = 'I' and T0.[TaxDate] Between [%0] And [%1]*

Plz make changes in query if need.

Thanks in Advance.

Regards,

Ravi