Use Formula Field To Sum Up Number Fields On The Child And Display On Top Object
Last updated on APRIL 20, 2016
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
I have a Formula number field in Sales Order custom object, and in Invoice child object there are couple of records where all have a value Invoice amount. Here I am trying to fetch the summation of all invoice value and update it in Sales order formula field.
Formula field in Sales Order object - TotalInvoice_c
Number field in Invoice child object - InvoiceAmount_c
def var_inv = InvoiceCollection_c
TotalInvoice_c= InvoiceAmount_c + InvoiceAmount_c + so on .i.e, it depends on the number of records in child object. when ever I create a new record in invoice, the Total invoice should get updated. if any of the invoice status is updated to cancelled, the Total invoice value should get updated.
The above code is not fetching any data
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms