Skip to Content
0
Former Member
Apr 26, 2014 at 07:19 AM

to display the opening balances of the customer in detail and A/R invoice open status document

34 Views

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'