Sage Intacct Real Time – Formula Error Reference
The Finance (Real Time) and Budget (Real Time) data models work differently from other data models in the Excel Add-in. Instead of calculating instantly, your formulas wait for data to finish loading in the background before returning a value. This keeps your workbook responsive and prevents your connection to Sage Intacct from being overloaded.
When that loading process is interrupted or a formula is not configured correctly, your cells show an error message instead of a value. This page lists every error you might encounter, explains what triggered it, and tells you exactly what to do next.
Cause: Your formula and its reference share no common dimension.
Solution: Open the References Configuration dialog and make sure at least one dimension matches a filter in your formula. Account is usually a good place to start.
Cause: A loading error occurred. The message tells you exactly what happened, whether it comes from Sage Intacct or from Nectari.
Solution: Read the full error message to understand what needs fixing. If it mentions enddate, a date filter is likely missing from your formula.
Cause: List and Dynamic List formulas do not work with Sage Intacct.
Solution: Use a data extraction instead.
Cause: The background data did not finish loading within the 60-second limit.
Solution: Select Refresh Formulas to try again. If this keeps happening, increase the CacheWaitTimeoutSeconds value in your Excel.exe.config file.