Follow

Added Column to FR Report but the Column is not being calculated

Problem Details:

In General Ledger -> Financial Reporter -> Statement Designer, new columns have been inserted into a pre-existing report and have a valid selection formula applied, but in Excel when Add-In -> FR -> View is used the report ignores the the newly added columns.

 

Solution:

The named range SPEC needs to include the newly added columns. To do this in Excel go to formulas ribbon and select name manager. Look through the list and find the name SPEC for the worksheet in question. Edit the "Refers to:" field to include the newly added columns. Press close and save. Re-run the report and the newly added columns will be included. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk