web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Row Definition error w...
Small and medium business | Business Central, N...
Suggested Answer

Row Definition error will not allow me to correct the error.

(5) ShareShare
ReportReport
Posted on by Community member 10
 
I built a row definition for a P&L report.  It was working as I built the row definition for a day and a half.  It is 90 rows long.
Then yesterday, I made an error and Dynamics let me know about the error.  This has happened many times.  This time, it lets me know of the error, but will NOT allow me to go back in and correct the error.
The error message: The filter /AC610..AC650/ is not valid for the Entry No. field on the G/L Account Category table. The value /AC610/ can't be evaluated into type Integer.
I was changing /Totaling Type/ from /Formula/ to /Account Category/.  I clicked out of the row before I updated the old formula from /AC610..AC650/ to the Account category of /Operations and Maintenance/.  I have made errors like this before and go back and correct the errors.
This time, Dynamics will not allow me to get back to the row to correct the error.  The below is what I get and cannot get back to correct the row.
How do I get access to the row definition view to make the correction?
Clicking the /X/ on the error message does not help.  I looked through all the other commands and none of them bring me back to the Row Definition view.
Thanks
 
I have the same question (0)
  • Community member Profile Picture
    Community member 3 on at
    Same issue here. The only solutions I have seen so far are outside of Business Central. There has got to be a way to fix this without manipulating the code.
  • Community member Profile Picture
    Community member 2 on at
    I also got the same issue. Did you find the solution?

  • Angely Profile Picture
    Angely 2 on at
    Do you have more specific details about the software and version you're using?
    Regards
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    Hello,

    Thanks for sharing the details of your issue.

    The error you're encountering is due to the filter format '/AC610..AC650/', which is being applied to a field expecting integer values, not text codes. The Entry No. field on the G/L Account Category table is numeric, so it cannot interpret values like /AC610/.

    To resolve this:

    • Review the Row Definition and ensure that the filters applied to numeric fields use valid integer ranges, such as 610..650 (without the /AC prefix).
    • If /AC610/ refers to a G/L Account, consider applying the filter to the G/L Account No. field instead, which accepts text values.
    • You can access the Row Definition view via the Account Schedules page, then select the relevant schedule and choose Edit Row Definitions.

    Let me know if this helps!

    Was this response helpful? Feel free to mark it as such or reply with more details if needed.

    Best regards,
    Daniele

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,917

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,161 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans