We have an aging report for one of our clients. It includes calculated fields for each of several 30 day increments so that the outstanding balance shows in the appropriate column. These fields are unstored as the outstanding calculation references related line items and payments.
The fields calculate correctly. However, when the open aging report is long, about 6,000 records, and we export to excel with a script, we get a chunk of about 300 in the middle of the report that don't show the calculated breakdown. We have checked those specific records and the calculations do resolve correctly when viewed in data viewer.
It appears as though FIleMaker is not resolving the unstored calc for these few records in time for the export. Has anyone else seen this behavior? If so, any fixes or workarounds?