Skip to Content
0
Former Member
Dec 31, 2015 at 11:48 AM

Error in Purchase tax Query Report

17 Views

Hi Experts ,

i have written the follwing query for purchase tax report, in this cst tax is not linking with the G/L ACCOUNT .please find the solution.The folowing is the query

/* SELECT FROM dbo.OPCH T4 */ DECLARE @FDate AS datetime /* WHERE */ SET @FDate= /* T4.DocDate */ '[%4]' /* SELECT FROM dbo.OPCH T5 */ DECLARE @TDate AS datetime /* WHERE */ SET @TDate= /* T5.DocDate */ '[%5]'

EXEC PURCHASE_TAXDETAILS_V2 @FDate,@TDate

Thank in advance