Error running financials

I would suggest going to Tools > Trace and review the last requests. I have used this in the past to determine where the issue was with the report. Example, I had the formula incorrect, and the trace pointed me to the row that was the issue. 

Hello,

The above error is typically seen when there is an error in calculations on a Total line.  Please click Trace to see if there is a specific line number shown.  Otherwise, check calculations in the Value column on all Total lines.

Show us a screen shot of your calculations, or export and post your report here so we may better assist you.

Thank you.

Laura

Hi Laura,  Thanks for the suggestions.  The trace logs only seems to refer to some customizations that are on our system.  See attached screenshot.

Also, attached are a screenshot of the calculations.  I was careful to copy the calculations of the other part of the balance sheet that I knew was working.  The current liabilities was working, but stopped showing up on the balance sheet after my journal entry and the long term liabilities section is what I added.

Thanks!

Hello,

Thank you for the extra details. I notice one thing out of place and that is a Caption that should be a Total line -- and missing apostrophe (‘) after 00590 in the formula on the same line.

Good catch.  I updated that, but am still getting the same error when trying to run a balance sheet.

See updated error trace log.

Thanks!

Hi,

Can you export the Row Set to Excel and attach it here? Or, in Report Definitions, use the Clipboard icon to Export the report to XML.  Export to XML will include the Row Definition, Column definition, and optional Unit Set for import to a demo environment for more detailed study - to help us answer.

I don’t know if this will cause any error… 00655 is a GL line with no apparent Data Source. Should 00655 be a Caption?

Thank you.

Laura 

Hi Laura,

I’m not sure on that GL line.  I noticed there was one above in the Asset area and copied it over.  As I mentioned this report used to work fine!

Please see attached XML export.

Thanks so much!

Sheila

Hi Laura,

Yes, that appears to be the issue! 

It’s working again.

Sorry for the oversight, but thank you much for your help!

Sheila

Hello Sheila,

I will give you an extra Hint:  this is how I check my typing on all financials that I create:  Filter the TYPE column to look at all the Totals together.  Possibly make the screen bigger with Control - + then look at the Value Column. 

Looking at all formulas together can make a missing character more obvious:

Then filter by Line, make sure the Line Style has been selected, etc. until you have checked all the different lines.

Laura