Who's On?

	Membership:
	Latest: Rich Cowie
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5255

	People Online:
	Visitors: 65
	Members: 0
	Total: 65

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

APINVOICE

4 Replies

0 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

Chesca

Veteran Member Send Private Message

Posts: 490

8/14/2014 1:48 PM

How do I get a list of all invoices that have been paid from certain date? I need to provide auditors with a crystal report

Mark F. Hardy

Veteran Member Send Private Message

Posts: 45

8/14/2014 3:46 PM

Try AP270.

Cindy

Advanced Member Send Private Message

Posts: 29

8/14/2014 5:17 PM

APVENMAST has the vendor information. APPAYMENT has the payment information. On this website look under the TECH tab at data dictionary - tabels and you can find the file relationships to know where the data you need resides.

Chesca

Veteran Member Send Private Message

Posts: 490

6/17/2015 12:49 PM

Thanks Cindy! How do I get to list only AP invoices/payments in certain zip codes? I tried adding the APADDRESS file but it duplicated the records.

JonA

Veteran Member Send Private Message

Posts: 1163

6/22/2015 7:18 PM

APVENADDR should get you what you need.