Total Pageviews

October 23, 2017

10/23/2017 02:07:00 PM
Oracle Payables Form


How to get AP Invoice amount from total lines value?


to get the Total invoice header amount from the lines entered in the oracle payables invoice window once on clicking on  the save button.

Ex:

1.     $100    Account 1
2.     $200    Account 2
3.     $400    Account 3
after clicking save button  the invoice header amount to be changed from $0 to $700 (Lines total) automatically

Condition
Trigger Event->WHEN-VALIDATE-RECORD
Trigger Object->D_SUM_FOLDER
Condition->:INV_SUM_FOLDER.INVOICE_AMOUNT_DSP <> :INV_SUM_FOLDER.D_SUM_DIST_TOTAL

Actions
Type->Property

Object Type->Item
Target Object->INV_SUM_FOLDER.INVOICE_AMOUNT
Property Name->VALUE
Value->=:INV_SUM_FOLDER.D_SUM_DIST_TOTAL


 
Related Posts Plugin for WordPress, Blogger...