seeded form Personalization
I want to personalize the invoice form in payables;
When record in distributions is validated, the invoice amount should be updated to the sum of the distributions amount .
So the trigger is when record is validated
and the action is property set the item's (invoice amount) value.
The value is my problem, I put :block_name.item_name but an error happens because of wrong format
this problem is solved by calling to_number function to correctly format it
Now another error is raised :
When record in distributions is validated, the invoice amount should be updated to the sum of the distributions amount .
So the trigger is when record is validated
and the action is property set the item's (invoice amount) value.
The value is my problem, I put :block_name.item_name but an error happens because of wrong format
this problem is solved by calling to_number function to correctly format it
Now another error is raised :
FRM-40831: truncation occurred: value too long for field
invoice_amount_dsp
TRUNC(TO_NUMBER(:LINE_SUM_FOLDER.D_SUM_DIST_TOTAL,2)
0