Is there a configuration or any possible way to create a single interest note that has a sum of all the interest generated by the date range that is specified at the time the customer interest note is generated?
I had a large 10 month range of orders that qualified for the interest calculation. Even though they shared the same interest note number they all had different sales order invoice numbers. When I went to the customer transactions it shows each individual interest calculation by sales invoice but shows the interest note id in the invoice column. We only want to show 1 instance with a total of all the invoice interests in that note.
How can I sum all the interest that share the interest note id?