Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 304
	Members: 0
	Total: 304

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Unapplied cash by day (AR)

2 Replies

0 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

Barry Ghotra

Veteran Member

Posts: 63

6/9/2008 2:07 PM

we are looking for a way to get the data out of AR for unpaplied cash by day (by customer, is possible) . Accounting folks want to find the variance and I have looked at the tables involved but can't seem to make any sense out of it. Has anyone ever had a need for this. Any pointers/help with SQL if it's possible to do. Don't know if lawson keeps the history or is there any way to figure this out based on the check/cash applied and distribution?

Thanks.

Barry Ghotra

Veteran Member

Posts: 63

6/10/2008 5:20 PM

John, Any pointers please ?

Thanks

John Henley

Posts: 3353

6/10/2008 5:33 PM

You would need to look at the ARPAYMENT, and ARAPPLIED tables in order to get that information.

I will tell you it is very difficult, if not impossible to go back in time to reconstruct if they are trying to see what was unapplied at a point in time.