customer outstanding weekly report query

[Former Member]

i need customer outsatanding weekly query report

for u reference.  see below.

#	Bp/Account Code	CardName	SlpName	Customer	GroupName	Doc. Number	Total	Current	31-60 Days	61-90 Days	91-120 Days	121-150 Days	151-180 Days	181-365 Days	361-730 Days	731+ Days
32	138	PowerPC Engineers Pvt Ltd	ravi Kumar	PowerPC Engineers Pvt Ltd	south	50246	311720	311720	0	0	0	0	0	0	0	0
76	719	DigitalPvt.Ltd.	virkram	Digital Pvt.Ltd.	north	54168	367500	0	0	0	367500	0	0	0	0	0
320	520	plastic pvt	Christian	plastic pvt	east	84568	475333	0	0	0	0	0	0	475333	0	0

[former_member212181 · Accepted solution]

Hi Vekadaswaran,

Please try below query

Select OINV.CardCode, OCRD.CardName, OSLP.SlpName, OCRG.GroupName, OINV.DocNum, OINV.DocTotal, OINV.DocTotal - OINV.PaidToDate [Current Balance]

from OINV

  Inner Join INV1 on OINV.DocEntry = INV1.DocEntry

  Inner Join OSLP on OINV.SlpCode = OSLP.SlpCode

  Inner Join OCRD on OINV.CardCode = OCRD.CardCode

  Inner Join OCRG on OCRD.GroupCode = OCRG.GroupCode

Where OINV.Canceled = 'N'

  and OINV.DocDate >=[%0]

  and OINV.DocDate <=[%1]

Thanks

Unnikrishnan