How to Calculate Credit and Debit Subtotals in NetSuite Without Scripting?

This method utilizes NetSuite saved searches and custom body fields to display credit and debit subtotals on Journal Entry records without requiring custom scripts. Follow these steps to implement the solution:

1. Create two separate saved searches: one to sum the amount(credit) and another to sum the amount(debit).

2. Create two custom body fields on the Journal Entry (JE) record. For each field, ensure 'Store Value' is unchecked. Set the respective saved search under the 'Validation & Defaulting' tab for each custom field.Advantages:No scripting is required.The subtotals will be visible on the record after it is saved.Limitations:The displayed values will not update dynamically as a user inputs transaction lines; they will only reflect the totals after the record is saved.Since the values are not stored, they cannot be directly pulled from other saved searches or reports.To store the value for reporting or other uses:If storing the value is necessary, create a workflow that triggers 'after submit' to pick the calculated value from the non-stored field and set it into a separate custom field configured to 'Store Value'.