Reg: Query Problem for New Posting Period
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.