Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 1
	Overall: 5205

	People Online:
	Visitors: 356
	Members: 1
	Total: 357

	Online Now:
	Ragu Raghavan

New Topics

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
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

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

Posts: 44

8/14/2014 3:46 PM

Try AP270.

Cindy

Advanced Member

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

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

Posts: 1163

6/22/2015 7:18 PM

APVENADDR should get you what you need.