Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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  
[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 

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.



Not what you were looking for? View more on this topic or Ask a question