Skip to Content
0
Former Member
Nov 29, 2008 at 06:53 AM

Queries Report For Last Purchased Price

164 Views

Dear All,

Can someone helps me to get queries report for last purchased price vs new purchase price that recently being enter on purchased order.

Trigger by purchased order document posting and we can choose % variance

Report by order :

No. Document PO ; Vendor code ; Vendor Name ; Doc Posting Date ; Item code ; Item Name : New Purchased price ; Last Purchased Price; Variance; Buyer Name

i will used it on alert management.. each time there % variance automaticaly sending an email with those report.

Thanks