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
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
Trigger Event->WHEN-VALIDATE-RECORD
Trigger Object->D_SUM_FOLDER
Condition->:INV_SUM_FOLDER.
Actions
Type->Property
Object Type->Item
Target Object->INV_SUM_FOLDER.
Property Name->VALUE
Value->=:INV_SUM_FOLDER.D_SUM_