Skip to Content

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

Daily Invoice Posting Summary Query

Hello --

Question about this Query below:

SELECT T1.RefDate, SUM(T0.Debit - T0.Credit) as 'Net Balance'

from JDT1 T0

Inner Join OJDT T1 ON T1.TransId = T0.TransID and

(T1.TransType = '13' or T1.TransType = '14')

Inner Join OCRD T2 ON T2.CardCode = T0.ShortName

Where T1.RefDate Between '[%0]' and '[%1]' and T2.CardType = 'C'

Group by T1.RefDate

Order By T1.RefDate

This Query allows us to view a summary of the invoices and credit memo's posted for a specified time frame.

I noticed that in the initial pop up window when we select this Query, it allows us to select the date range. Today the date range ended with 10/1 -- today's date.

However, after we select this range, the results show only up to 9/30 as the last date.

The results page is correct as the Invoices we have processed only apply up to 9/30 -- we have not invoiced for 10/1 yet. Why does the selection period show up to 10/1 and not 9/30?

Thanks!!

Mike

replied

Mike,

I am using only the Invoice date for the Selecting criteria. I would be able to use only one date of either document and I chose Invoice Date.

Suda

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