Reg: Query Problem for New Posting Period

Hi Xperts,

While I try to Map the A/P Invoices with their respective Outgoing Payment,

I used the following Query and it's Query Printlayout

SELECT T0.DocNum [Payment#], T0.DocDate [Payment Date], 
T0.CardCode, T0.CardName, T1.InvoiceId, T2.DocNum [AP Inv#], 
T2.NumatCard [Bill No.], T2.DocDate [Bill Date], T1.selfInv, 
T1.SumApplied, T1.WtAppld, T0.NoDocsum  
FROM  [dbo].[OVPM] T0  INNER  JOIN 
[dbo].[VPM2] T1  ON  T1.[DocNum] = T0.DocNum 
INNER  JOIN [dbo].[OPCH] T2  ON  T2.[DocEntry] = T1.DocEntry
 WHERE T0.Cardname='[%0]' and T0.DocDate='[%1]' and 
T0.DocNum='[%2]'

I got the above query from our Expert Mr.Sambath only.

Now what is the problem is the query is retrieving the payment details of old Posting Period only and not the current posting period.

In detail, I used 'Primary' Series for FY08-09, Period indicator 'Default'

Now I'm using 'Primary1' Series for FY09-10, Period indicator '0910'

Thanx in adv.

Regards,

Bala