Displaying Outstanding Report

[Former Member]

Sir,

Plz give me suggestion for displaying outstanding report i.e

1. Balance due of A/p or A/r invoice and

2. Unreconcile (Payment on account) Amount of Payment/Receipt

Both should be display in single report

Regards

Rajesh B K

[Former Member]

Thank u it solved

[Former Member]

You may try this one for AP Outstanding Report:

SELECT T0.DocNum, T0.DocDate, T0.CardName, T0.DocTotal As 'Opening Amount',

T0.PaidToDate, (T0.DocTotal-T0.PaidToDate) As 'Pending Amount', T0.DocDueDate,

Datediff(dd,T0.DocDueDate,GetDate()) As 'OverDue Days'

FROM dbo.OPCH T0 Where Datediff(dd,T0.DocDueDate,GetDate()) > 0 and T0.DocTotal>T0.PaidToDate

AND T0.Canceled = 'N'

Just change the table name to OINV, you may get AR Outstanding Report too.

Thanks,

Gordon

[Former Member]

Hi Rajesh..........

Once reconcilled means there is no outstanding. But if partial reconciliation done then in such case you can refer the General Ledger. There you have options like fully reconciled, half reconiled, unreconciled etc.

Just refer it........

Regards,

[Former Member]

Sir,

But i need bill wise Balance Due also

[Former Member]

Ok...........

Then You should use the Query Report..........

Please Try this......

SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], T0.[DocTotal] As 'Opening Amount',

T0.[PaidToDate], (T0.[DocTotal]-T0.[PaidToDate]) As 'Pending Amount', T0.[DocDueDate],

datediff(day,(select convert( datetime,(select T0.[DocDueDate]),3)),

(select convert( datetime,(select GetDate()),3))) As 'OverDue Days'

FROM OPCH T0 Where T0.DOcDueDate<GetDate()

Regards,