Who's On?

	Membership:
	Latest: navav4
	Past 24 Hours: 2
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 417
	Members: 1
	Total: 418

	Online Now:
	Joel Tooley

New Topics

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

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: 3362

New Poster

Engaged Reader

Avid Reader

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.