Who's On?

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

	People Online:
	Visitors: 118
	Members: 0
	Total: 118

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

HOLD CODE Query Assistance

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Katfra

Advanced Member

Posts: 30

5/9/2012 12:27 PM

Hello,

Could someone give me a little assistance in writing a query in AP that would give me HOLD CODES? I've tried different combinations with tables to achieve this but failed each time. I'm trying to produce a query that give me the following:

Company, Invoice, Invoice DTE, Invoice Description, Process Level, Vendor, Vendor-Vname, Vendor Group, Tran Inv Amt.

I've used the APINVOICE and APPAYMENT tables and was able to pull in the HOLD CODE fields due to relationships but each time i have no results for that field.
If i run an AP240 report which shows hold codes for invoices, i receive results. The reason i don't use the AP240 is i have to enter each company and we have 50 companies. If I can create a query, this would eliminate a lot of time.

Thank you,

Frank

JonA

Veteran Member

Posts: 1163

5/18/2012 10:47 AM

How about starting with the APHLDINV table? That will get you Company, Invoice, Process Level, Vendor, Vendor Group and also the Hold Code. Then relate to APINVOICE for Invoice DTE, Invoice Description and Tran Inv Amt; and relate to APVENMAST for the Vendor Name. I did attempt this with addins and was not able to get all the information from the related tables though. But when I tried the same query in Crystal (ODBC) the data was correct.