hi every one
i want a report
for the below code i am getting only the documents that are posted from 01/04/2014. But for some customers and vendors i have entered opening balances using J/E so in this report i want to display the detailed split of the BP Account Balance which i have entered in J/E
SELECT
T0.[CardName][Customer Name],
T0.[DocNum][Document Number],
T0.[DocStatus][Status],
T0.[DocDate][PostingDate],
T0.[DocDueDate][DueDate],
T0.[DocTotal][Total],
t1.SlpName,
DATEDIFF(DAY, T0.DocDueDate, GETDATE( )) AS 'Days Over Due'
FROM dbo.OINV T0 INNER JOIN OSLP T1 ON T0.[SlpCode] = T1.[SlpCode]
WHERE DocStatus = 'o'