Who's On?

	Membership:
	Latest: Alanna
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5294

	People Online:
	Visitors: 408
	Members: 0
	Total: 408

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

AP Invoice Comments

3 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Meghan

New Member Send Private Message

Posts: 1

1/30/2009 7:34 PM

I am trying to set up a query that will pull down AP invoice information including any comments attached to the invoice. Since invoices are included as an attachment, is there any way to include them in the query?

JonA

Veteran Member Send Private Message

Posts: 1163

1/30/2009 8:30 PM

I've wanted to pull comments in a query on the PO side for a long time. The problem is that comments aren't stored in any table. The way I understand it is the comments are an XML attachment. Maybe somebody more fluent in XML/Database lingo can explain better. Suffice it to say, you can't use Addins to query comments.

TimF

Basic Member Send Private Message

Posts: 4

1/30/2009 8:56 PM

I believe you can link them using SQL or perhaps MS Access query common field is L_INDEX - link the AP invoice record to the same field in the L_DAPI table - - I had to do this to find some corrupt comment records awhile back and it worked.

John Henley

Posts: 3355

1/30/2009 10:56 PM

Here's an article on how comments/attachments work, with some SQL to show how to join--it's related to POs, but same concepts apply.
https://www.lawsonguru.co...ts-in-Lawson-v8.aspx