Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
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... / Vendor template defaul...
Small and medium business | Business Central, N...
Suggested answer

Vendor template default tax area

(0) ShareShare
ReportReport
Posted on by RTIBobV 125

When adding a new B2B vendor, we are now seeing the following error. The vendor template does not allow us to set the default tax area, and we have never had a value of ATLANTA, GA.  Is there a mechanism to edit "hidden" fields of the vendor template?

"The field Tax Area Code of table Vendor contains a value (ATLANTA, GA) that cannot be found in the related table (Tax Area)."

  • RTIBobV Profile Picture
    RTIBobV 125 on at
    RE: Vendor template default tax area

    This issue has arisen again.  The Tax Area Code does not include the value ATLANTA, GA.  The Vendor template does not allow us to set a default value.  How do we eliminate the error without creating the nonsensical Tax Area Code?

    Error Code: DB:PrimRecordNotFound

    "Config. Validate Management"(CodeUnit 8617).ValidateFieldValue line 34 - Base Application by Microsoft
    "Config. Template Management"(CodeUnit 8612).ModifyRecordWithField line 4 - Base Application by Microsoft
    "Config. Template Management"(CodeUnit 8612).InsertTemplate line 21 - Base Application by Microsoft
    "Config. Template Management"(CodeUnit 8612).UpdateRecordWithSkipFields line 3 - Base Application by Microsoft
    "Config. Template Management"(CodeUnit 8612).UpdateRecord line 6 - Base Application by Microsoft
    "Mini Vendor Template"(Table 1303).InsertVendorFromTemplate line 10 - Base Application by Microsoft
    "Mini Vendor Template"(Table 1303).NewVendorFromTemplate line 22 - Base Application by Microsoft
    "Vendor Card"(Page 26).CreateVendorFromTemplate line 12 - Base Application by Microsoft
    "Vendor Card"(Page 26).OnAfterGetCurrRecord(Trigger) line 2 - Base Application by Microsoft

    Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideValidateTableRelationException: The field Tax Area Code of table Vendor contains a value (ATLANTA, GA) that cannot be found in the related table (Tax Area). ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideValidateTableRelationException: The field Tax Area Code of table Vendor contains a value (ATLANTA, GA) that cannot be found in the related table (Tax Area).
    at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.ValidateNonFlowField(NCLMetaField field, Boolean isUserInput) in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Data
    RecordImplementation.cs:line 2241
    at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(FieldTriggerHandler`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput, List`1 beforeHandlers, List`1 afterHandlers) in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavRecord.cs:line 683
    at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput) in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavRecord.cs:line 2962
    at Microsoft.Dynamics.Nav.Runtime.NavFieldRef.ALValidateSafe(NavValue newValue) in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    AL
    ALFieldRef.cs:line 584
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8617.ValidateFieldValue_Scope__2031195772.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8617.ValidateFieldValue(ByRef`1 recRef, ByRef`1 fieldRef, NavText value, Boolean skipValidation, Int32 languageID)
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8617.OnInvoke(Int32 memberId, Object[] args)
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.ModifyRecordWithField_Scope__338842758.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.ModifyRecordWithField(ByRef`1 recRef, NavFieldRef fieldRef, NavText value, Int32 languageID)
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.InsertTemplate_Scope__558532372.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.InsertTemplate(ByRef`1 recRef, INavRecordHandle configTemplateHeader, Boolean skipFields, INavRecordHandle tempSkipField)
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.UpdateRecordWithSkipFields_Scope_1033286979.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.UpdateRecordWithSkipFields(INavRecordHandle configTemplateHeader, ByRef`1 recRef, Boolean skipFields, INavRecordHandle tempSkipFields)
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.UpdateRecord_Scope_185092293.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.UpdateRecord(INavRecordHandle configTemplateHeader, ByRef`1 recRef)
    at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit8612.OnInvoke(Int32 memberId, Object[] args)
    at Microsoft.Dynamics.Nav.BusinessApplication.Record1303.InsertVendorFromTemplate_Scope_748734818.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Record1303.InsertVendorFromTemplate(INavRecordHandle configTemplateHeader, INavRecordHandle vendor)
    at Microsoft.Dynamics.Nav.BusinessApplication.Record1303.NewVendorFromTemplate_Scope__256226874.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Record1303.NewVendorFromTemplate(INavRecordHandle vendor)
    at Microsoft.Dynamics.Nav.BusinessApplication.Record1303.OnInvoke(Int32 memberId, Object[] args)
    at Microsoft.Dynamics.Nav.BusinessApplication.Page26.CreateVendorFromTemplate_Scope_1600648553.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Page26.CreateVendorFromTemplate()
    at Microsoft.Dynamics.Nav.BusinessApplication.Page26.OnAfterGetCurrRecord_Scope.OnRun()
    at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavMethodScope.cs:line 514
    at Microsoft.Dynamics.Nav.BusinessApplication.Page26.OnAfterGetCurrRecord()
    at Microsoft.Dynamics.Nav.Runtime.NavForm.RaiseOnAfterGetCurrRecord() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavForm.cs:line 608
    at Microsoft.Dynamics.Nav.Runtime.NavForm.AfterGetCurrRecord() in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavForm.cs:line 2507
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
    at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at Microsoft.Dynamics.Nav.Runtime.NavApplicationMethod.InvokeMethod(ITreeObject obj, String methodName, Object[] args, Boolean resolveHandler, Boolean throwOnNotFound) in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavApplicationMethod.cs:line 54
    --- End of inner exception stack trace ---
    at Microsoft.Dynamics.Nav.Runtime.NavApplicationMethod.InvokeMethod(ITreeObject obj, String methodName, Object[] args, Boolean resolveHandler, Boolean throwOnNotFound) in s:
    repo
    src
    Platform
    Server
    Prod.Ncl
    Runtime
    NavApplicationMethod.cs:line 105
    at Microsoft.Dynamics.Nav.Service.NSFormApplicationCode.Invoke(NavSession session) in s:
    repo
    src
    Platform
    Server
    Prod.Service
    NSFormApplicationCode.cs:line 156
    at SyncInvokeInvokeApplicationMethod(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 353
    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 734
    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 374
    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 734
    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 319

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Vendor template default tax area

    Hello,

    This value does exist in the demo data of CRONUS US. Did you adjust the B2B Vendor template as the field Tax Area Code is not part of the template. Another option you have is to add the missing value in the related table.

    Hope it does help.

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

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,169

#2
YUN ZHU Profile Picture

YUN ZHU 1,006 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 830

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans