Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 68
	Members: 0
	Total: 68

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

Best method to write Process Flow that puts invoices on hold

6 Replies

0 Subscribed to this topic

52 Subscribed to this forum

Sort:

Author

Messages

Stephen Robertson

Basic Member

Posts: 4

6/14/2010 7:19 PM

I am writing a new process flow, that does the following:
When an invoice is entered onto AP20, the purchase order linked to it is looked up in POLINE, each POLINE is evaluated if an ITEM-TYPE of S is found, then a hold flag of Y is placed in APPAYMENT and a HLD-CODE of APAP is placed in APHLDINV. Someone will be emailed with the ability to approve or deny the invoice. If they choose approve, the Hold Flag will be removed and the HLD-CODE will be removed as well. What is the best way to do this, via an AGS off of AP20, or should I use the SQL Query and SQL Update nodes?

David Williams

Veteran Member

Posts: 1127

New Poster

6/14/2010 7:54 PM

When you use the delivered setup and trigger then you don't have to put the invoice on hold. It can't process until approved.

Stephen Robertson

Basic Member

Posts: 4

6/14/2010 8:22 PM

Correct, but we are only wanting to put invoices on hold that tie back to Purchase Orders that have an Item-Type of S on them. If we have one like this, then we want to put the Invoice on hold, until it is approved.

David Williams

Veteran Member

Posts: 1127

New Poster

6/14/2010 8:36 PM

If you use Lawson's trigger all invoices will go through ProcessFlow. You will have to auto-approve the invoices you don't want to route for approval.

David Williams

Veteran Member

Posts: 1127

New Poster

6/14/2010 8:40 PM

If you are creating a custom process, then use an AGS call. "Never" use a SQL update.

Stephen Robertson

Basic Member

Posts: 4

6/14/2010 8:41 PM

Ahh, Following what you are saying, I think, so I can just modify the default approval process to auto approve all of them except for the ones that have an Item Type of S on the Actual PO... Correct.?

David Williams

Veteran Member

Posts: 1127

New Poster

6/14/2010 8:49 PM

Yes.