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

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... / Error linking G/L acco...
Small and medium business | Business Central, N...
Suggested Answer

Error linking G/L accounts to category

(0) ShareShare
ReportReport
Posted on by Eduardo Acuna 20

Hello,

After linking G/L accounts to a category, I got this error message and I've tried to revert changes but it doesn't work. Does anyone know what should I do?

Note that I can't see any categories now.

Annotation-2019_2D00_12_2D00_06-155255.png

Error Text: 

The filter "'102.01'..'102.02'|'103.01'..'103.03'|'104.01'|'105.01'..'105.04'|'106.01'..'106.1'|'107.01'..'107.05'|'108.01'..'108.04'|'109.01'..'109.23'|'110.01'|'111.01'|'112.01'|'113.01'..'113.08'|'114.01'|'115.01'..'115.07'|'116.01'|'117.01'|'118.01'..'118.04" is not valid for the G/L Account No. field on the G/L Entry table. An single quote (') is missing.
Error Code:
Filter:CSide
Error Callstack:
570(Table 570).GetBalance line 25 - Base Application by Microsoft
"G/L Account Category"(Table 570).GetBalance line 13 - Base Application by Microsoft
Error Object:
Microsoft.Dynamics.Nav.Types.Exceptions.NavFilterException: The filter "'102.01'..'102.02'|'103.01'..'103.03'|'104.01'|'105.01'..'105.04'|'106.01'..'106.1'|'107.01'..'107.05'|'108.01'..'108.04'|'109.01'..'109.23'|'110.01'|'111.01'|'112.01'|'113.01'..'113.08'|'114.01'|'115.01'..'115.07'|'116.01'|'117.01'|'118.01'..'118.04" is not valid for the G/L Account No. field on the G/L Entry table. An single quote (') is missing. ---> Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException: The filter "'102.01'..'102.02'|'103.01'..'103.03'|'104.01'|'105.01'..'105.04'|'106.01'..'106.1'|'107.01'..'107.05'|'108.01'..'108.04'|'109.01'..'109.23'|'110.01'|'111.01'|'112.01'|'113.01'..'113.08'|'114.01'|'115.01'..'115.07'|'116.01'|'117.01'|'118.01'..'118.04" is not valid for the G/L Account No. field on the G/L Entry table. An single quote (') is missing. ---> Microsoft.Dynamics.Nav.Types.Exceptions.NavInvalidFilterExpressionException: An single quote (') is missing.
at Microsoft.Dynamics.Nav.Runtime.FilterExpressionTokenizer.GetTokens(String input) in s:
repo
src
Platform
Server
Prod.Ncl
FilterExpressions
FilterExpressionTokenizer.cs:line 138
at Microsoft.Dynamics.Nav.Runtime.FilterExpressionParser.ParseWithoutBalancing(String expression, FilterExpressionContext expressionContext, Func`3 customVariableResolver, Int32 unknownVariableResolverDepth, NavValue[] values, Int32& expressionLeafCount, Boolean& hasVariables, Boolean cultureInvariant, DataError dataError) in s:
repo
src
Platform
Server
Prod.Ncl
FilterExpressions
FilterExpressionParser.cs:line 223
at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.SetFieldFilter(NCLMetaField metaField, String expression, NavValue[] values) in s:
repo
src
Platform
Server
Prod.Ncl
Data
RecordImplementation.cs:line 4156
--- End of inner exception stack trace ---
at Microsoft.Dynamics.Nav.Runtime.RecordImplementationHelper.GetInvalidFilterException(NavRecord parentRecord, NCLMetaField metaField, String expression, Exception innerException) in s:
repo
src
Platform
Server
Prod.Ncl
Data
RecordImplementationHelper.cs:line 313
at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.SetFieldFilter(NCLMetaField metaField, String expression, NavValue[] values) in s:
repo
src
Platform
Server
Prod.Ncl
Data
RecordImplementation.cs:line 4161
at Microsoft.Dynamics.Nav.Runtime.NavRecord.SetFilter(NCLMetaField metaField, String expression, NavValue[] values) in s:
repo
src
Platform
Server
Prod.Ncl
Runtime
NavRecord.cs:line 3269
--- End of inner exception stack trace ---
at Microsoft.Dynamics.Nav.Runtime.NavRecord.SetFilter(NCLMetaField metaField, String expression, NavValue[] values) in s:
repo
src
Platform
Server
Prod.Ncl
Runtime
NavRecord.cs:line 3273
at Microsoft.Dynamics.Nav.BusinessApplication.Record570.GetBalance_Scope_641635239.OnRun()
at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
repo
src
Platform
Server
Prod.Ncl
Runtime
NavMethodScope.cs:line 456
at Microsoft.Dynamics.Nav.BusinessApplication.Record570.GetBalance()
at Microsoft.Dynamics.Nav.BusinessApplication.Record570.OnInvoke(Int32 memberId, Object[] args)
at Microsoft.Dynamics.Nav.BusinessApplication.Record570.GetBalance_Scope_641635239.OnRun()
at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
repo
src
Platform
Server
Prod.Ncl
Runtime
NavMethodScope.cs:line 456
at Microsoft.Dynamics.Nav.BusinessApplication.Record570.GetBalance()
at Microsoft.Dynamics.Nav.BusinessApplication.Record570.OnInvoke(Int32 memberId, Object[] args)
at Microsoft.Dynamics.Nav.BusinessApplication.Page790.<OnMetadataLoaded>b__13_4()
at Microsoft.Dynamics.Nav.Runtime.NavFormSourceExpression.TryExecuteAndHandleExceptionMappingSourceExpressionGetter(NavFormSourceExpressionGetter getter) in s:
repo
src
Platform
Server
Prod.Ncl
Runtime
NavFormSourceExpression.cs:line 170
at Microsoft.Dynamics.Nav.Service.NSRecordBase.SetCLRCellFromSourceExpression(NavDataRow dataRow, NavFormSourceExpression expression) in s:
repo
src
Platform
Server
Prod.Service
NSRecordBase.cs:line 217
at Microsoft.Dynamics.Nav.Service.NSRecordBase.PopulateCLRTable(NavDataTable dataTable, NsDataAccess recDataAccess, NavDataRow dataRow) in s:
repo
src
Platform
Server
Prod.Service
NSRecordBase.cs:line 69
at Microsoft.Dynamics.Nav.Service.NSPage.PopulateOneRow(NsDataAccess recDataAccess, NavDataTable dataTable) in s:
repo
src
Platform
Server
Prod.Service
NSPage.cs:line 228
at Microsoft.Dynamics.Nav.Service.NSPage.PopulateSpecificPage(NavDataSet dataSet, NsDataAccess recDataAccess, Boolean& moreDataInReadDirection, Boolean& moreDataInOppositeDirection) in s:
repo
src
Platform
Server
Prod.Service
NSPage.cs:line 824
at Microsoft.Dynamics.Nav.Service.NSPage.<>c__DisplayClass14_0.<PopulateCLRDataSet>b__0() in s:
repo
src
Platform
Server
Prod.Service
NSPage.cs:line 754
at Microsoft.Dynamics.Nav.Runtime.ApplicationObjectRootScope.AddApplicationObjectRootScope(NavApplicationObjectBase applicationObject, Action action) in s:
repo
src
Platform
Server
Prod.Ncl
Runtime
ApplicationObjectRootScope.cs:line 76
at Microsoft.Dynamics.Nav.Service.NSPage.PopulateCLRDataSet(NavDataSet dataSet, NsDataAccess recDataAccess, Boolean& moreDataInReadDirection, Boolean& moreDataInOppositeDirection) in s:
repo
src
Platform
Server
Prod.Service
NSPage.cs:line 790
at Microsoft.Dynamics.Nav.Service.NSPage.GetPageData(NavSession session) in s:
repo
src
Platform
Server
Prod.Service
NSPage.cs:line 177
at Microsoft.Dynamics.Nav.Service.NSPage.GetPage(NavSession session) in s:
repo
src
Platform
Server
Prod.Service
NSPage.cs:line 94
at Microsoft.Dynamics.Nav.Service.NSService.Microsoft.Dynamics.Nav.Types.INavService.GetPage(PageRequestDefinition pageRequestDefinition, NavRecordState state) in s:
repo
src
Platform
Server
Prod.Service
NSService.cs:line 825
at SyncInvokeGetPage(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.RunInTransactionCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, MethodBase syncMethod, Object[] inputs, Object[]& outputs) in s:
repo
src
Platform
Server
Prod.Service
ServiceOperationInvoker.cs:line 348
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.<>c__DisplayClass28_1.<Combine>b__1(NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs) in s:
repo
src
Platform
Server
Prod.Service
ServiceOperationInvoker.cs:line 729
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.TransientErrorRetryCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, MethodBase syncMethod, Object[] inputs, Object[]& outputs) in s:
repo
src
Platform
Server
Prod.Service
ServiceOperationInvoker.cs:line 369
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.<>c__DisplayClass28_1.<Combine>b__1(NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs) in s:
repo
src
Platform
Server
Prod.Service
ServiceOperationInvoker.cs:line 729
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.ErrorMappingCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, MethodBase syncMethod, Object[] inputs, Object[]& outputs) in s:
repo
src
Platform
Server
Prod.Service
ServiceOperationInvoker.cs:line 314
  • Suggested answer
    Renato Fajdiga Profile Picture
    Renato Fajdiga 1,855 on at

    Hi,

    as it says, you are missing ' behind the last G/L account '118.04". If you take a look at first G/L account you have "'102.01' so " and ', but after the last G/L account you are missing '

    This could be a possible bug in BC when parsing the filter or try with G/L accounts which do not have special characters in code.

    Best regards,

    Renato

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 740 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 570 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 291 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans