Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5210

	People Online:
	Visitors: 167
	Members: 0
	Total: 167

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

Add Ins Query of Open Checks

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Beth

New Member

Posts: 3

9/21/2011 5:55 PM

This seems to me it would be a simple query, but I can't pull all of the info that I need. I want a simple list of any open checks for a particular cash code, along with the vendor Name and address for mailing due diligence letters. Does anyone have any suggestions?

Sam Simpson

Veteran Member

Posts: 239

9/21/2011 7:14 PM

If you are using CBCHECK then the REC-STATUS is 2 and the REC-STATUS in CBTRANS = 1. Of course yoiu have to relate cbcheck with cbtrans using trans-ident and bank-inst-code.