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
