Daily Invoice Posting Summary Query
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?
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.