(Back to E-PU Purchasing AP Module SQL Posted to Wiki Listing - E-PU Purchasing AP Module SQL Posted to Wiki )
TYPE: Frequently Requested SQL
AUTHOR NAME: Neetu Dhami
PURPOSE AND BACKGROUND: This SQL was created in 2007A SP 01PL 08. Few Clients require to implement validation/approval process when invoice value is more than order value. You can achieve this with transaction notification script and approval based on query script.Create one user defined filed on marketing document header level as Approval with valida values Y/N. You might be able to use this script "as is" or add more data fields to this SQL, depending upon your own requirements.
Copy and Paste this SQL:
--E-PU Validation and approval when Invoice Value is more than order Ver 1 ND 26 Oct,2011
--DESCRIPTION: In a typical Client scenario, we need Validation/Approval to check if invoice value is more than order. The following is a sample which can be used as a basic outline for purchase transactions and modified per your requirements.
--Version 1 Neetu Dhami 26th Oct ,2011
Add below script in transaction notification procedure.
For approval base on query:Save below query in query manager and set approval based on Query