Hello everyone,
At sales invoice creation process, Business Central indicates date formula error (described below).
@Business Central Development Team, please revert this question as soon as possible
Error Text
"The date formula '1' should include a time unit. Time units can be: D,WD,W,M,Q, or Y. C, meaning current time unit based on date, can be specified as a prefix to the time unit."
Error Code
NSValidateField:Evaluate
Error Callstack
"Sales Header Hook"(CodeUnit 52113125).OnAfterValidatePaymentTermsCode line 9
"Sales Header"(Table 36)."Bill-to Customer No. - OnValidate"(Trigger) line 46
"Sales Header"(Table 36)."Sell-to Customer No. - OnValidate"(Trigger) line 82
"Sales Header"(Table 36)."Sell-to Customer Name - OnValidate"(Trigger) line 2
Error Object
Microsoft.Dynamics.Nav.Types.Exceptions.NavNSValidateFieldException: The date formula '1' should include a time unit.
Time units can be: D,WD,W,M,Q, or Y.
C, meaning current time unit based on date, can be specified as a prefix to the time unit. ---> Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLEvaluateException: The date formula '1' should include a time unit.
Time units can be: D,WD,W,M,Q, or Y.
C, meaning current time unit based on date, can be specified as a prefix to the time unit.
at Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLEvaluateException.CreateDateFormulaShouldIncludeQuantor(CultureInfo culture, String source)
at Microsoft.Dynamics.Nav.Runtime.NavDateFormulaEvaluator.InternalEvaluator.Term(Char sign)
at Microsoft.Dynamics.Nav.Runtime.NavDateFormulaEvaluator.InternalEvaluator.Statement()
at Microsoft.Dynamics.Nav.Runtime.NavDateFormulaEvaluator.InternalEvaluator.Parse(Int32 formatNumber)
at Microsoft.Dynamics.Nav.Runtime.ALSystemDate.ALCalcDate(String dateExpression, NavDate dateValue)
at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit52113125.OnAfterValidatePaymentTermsCode_Scope.OnRun()
at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run()
at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit52113125.OnAfterValidatePaymentTermsCode(INavRecordHandle rec, INavRecordHandle xRec, Int32 currFieldNo)
at Microsoft.Dynamics.Nav.BusinessApplication.Codeunit52113125.OnInvoke(Int32 memberId, Object[] args)
at Microsoft.Dynamics.Nav.EventSubscription.NavEventScope.CallEventSubscriberInternal(NavEventSubscription subscriber, NavApplicationObjectBase subscriberInstance, Object[] parameters)
at Microsoft.Dynamics.Nav.EventSubscription.NavEventScope.CallEventSubscriber(NavApplicationObjectBase callingApplicationObject, NavEventSubscription subscriber, NavApplicationObjectBase subscriberInstance, Object[] parameters)
at Microsoft.Dynamics.Nav.EventSubscription.NavEventScope.ProcessCallToTypeAndManualSubscriptions(NavApplicationObjectBase callerApplicationObject, NavEventSubscription[] subscriptions, PrepareParametersCallBack prepareParameters)
at Microsoft.Dynamics.Nav.EventSubscription.NavEventScope.CheckAndFireTriggerEvents(NavApplicationObjectBase triggerApplicationObject, Func`2 parameterResolver)
at Microsoft.Dynamics.Nav.EventSubscription.NavTableTriggerEventHandler.FireOnValidateEvent(NavTriggerEventType triggerEventType, INavRecordHandle rec, NCLMetaField metaField)
at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(FieldTriggerHandler`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput, List`1 beforeHandlers, List`1 afterHandlers)
at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput)
at Microsoft.Dynamics.Nav.BusinessApplication.Record36.Billa45to_Customer_Noa46_a45_OnValidate_Scope.OnRun()
at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run()
at Microsoft.Dynamics.Nav.BusinessApplication.Record36.Billa45to_Customer_Noa46_a45_OnValidate()
at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(FieldTriggerHandler`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput, List`1 beforeHandlers, List`1 afterHandlers)
at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput)
at Microsoft.Dynamics.Nav.BusinessApplication.Record36.Sella45to_Customer_Noa46_a45_OnValidate_Scope.OnRun()
at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run()
at Microsoft.Dynamics.Nav.BusinessApplication.Record36.Sella45to_Customer_Noa46_a45_OnValidate()
at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(FieldTriggerHandler`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput, List`1 beforeHandlers, List`1 afterHandlers)
at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput)
at Microsoft.Dynamics.Nav.BusinessApplication.Record36.Sella45to_Customer_Name_a45_OnValidate_Scope.OnRun()
at Microsoft.Dynamics.Nav.Runtime.NavMethodScope.Run()
at Microsoft.Dynamics.Nav.BusinessApplication.Record36.Sella45to_Customer_Name_a45_OnValidate()
at Microsoft.Dynamics.Nav.Runtime.NavRecord.ValidateField(FieldTriggerHandler`1 fieldEvent, NCLMetaField metaField, Boolean isUserInput, List`1 beforeHandlers, List`1 afterHandlers)
at Microsoft.Dynamics.Nav.Runtime.NavRecord.Validate(NCLMetaField metaField, NavValue newValue, NavRecord callerRecord, Boolean isUserInput)
at Microsoft.Dynamics.Nav.Service.NsDataAccess.Validate(Int32 fieldId)
at Microsoft.Dynamics.Nav.Service.NSField.ValidateField(NavSession session)
at Microsoft.Dynamics.Nav.Service.NSField.Validate(NavSession session)
--- End of inner exception stack trace ---
at Microsoft.Dynamics.Nav.Service.NSField.Validate(NavSession session)
at SyncInvokeValidateField(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)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.<>c__DisplayClass28_1.<Combine>b__1(NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.TransientErrorRetryCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, MethodBase syncMethod, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.<>c__DisplayClass28_1.<Combine>b__1(NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs)
at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.ErrorMappingCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, MethodBase syncMethod, Object[] inputs, Object[]& outputs)
