Skip to main content
Question

Sales Tax -Error -Inserting AP Trans actions record raised at lease one error. Please review the errors "Project cannot be empty

  • April 17, 2026
  • 3 replies
  • 27 views

Forum|alt.badge.img

As i was releasing tax report this error popped up. see attached

3 replies

Forum|alt.badge.img
  • Jr Varsity I
  • April 24, 2026

Hi ​@gracef can you please share the trace?


  • Freshman I
  • June 19, 2026
PX.Data.PXNotSupportedException2026-06-19 18:49:37 UTC
Exception Type:
PX.Data.PXNotSupportedException
Message:
LINQ fallback! Consider rewriting your query.Graph: PX.Objects.TX.ReportTaxReviewLINQ Model: from PXResult`1 row in value(PX.Data.SQLTree.SQLQueryable`1[PX.Data.PXResult`1[PX.Objects.TX.TaxReportLine]]) where (Convert([row]).TaxReportRevisionID == 1) where value(PX.Objects.TX.ReportTaxReview).ShowTaxReportLine([row].GetItem(), "202604") select [row]Base BQL: Select5<TaxReportLine, LeftJoin<TaxHistory, On<TaxHistory.vendorID, Equal<TaxReportLine.vendorID>, And<TaxHistory.lineNbr, Equal<TaxReportLine.lineNbr>, And<TaxHistory.taxPeriodID, Equal<Current<TaxPeriodFilter.taxPeriodID>>, And2<Where<Current<TaxPeriodFilter.showDifference>, NotEqual<boolTrue>, Or<TaxHistory.revisionID, Equal<Current<TaxPeriodFilter.revisionId>>>>, And<Where<Current<TaxPeriodFilter.showDifference>, Equal<boolTrue>, Or<TaxHistory.revisionID, LessEqual<Current<TaxPeriodFilter.revisionId>>>>>>>>>>, Where<TaxReportLine.vendorID, Equal<Current<TaxPeriodFilter.vendorID>>, And<TaxReportLine.tempLine, Equal<False>, And2<Where<TaxReportLine.tempLineNbr, IsNull, Or<TaxHistory.vendorID, IsNotNull>>, And<Where<TaxReportLine.hideReportLine, IsNull, Or<TaxReportLine.hideReportLine, Equal<False>>>>>>>, Aggregate<GroupBy<TaxReportLine.taxReportRevisionID, GroupBy<TaxReportLine.lineNbr, Sum<TaxHistory.filedAmt, Sum<TaxHistory.reportFiledAmt>>>>>, OrderBy<Asc<TaxReportLine.vendorID, Asc<TaxReportLine.taxReportRevisionID, Asc<TaxReportLine.lineNbr>>>>>   at Remotion.Linq.Clauses.StreamedData.StreamedSequenceInfo.ExecuteQueryModel(QueryModel queryModel, IQueryExecutor executor)   at Remotion.Linq.QueryProviderBase.System.Linq.IQueryProvider.Execute[TResult](Expression expression)   at Remotion.Linq.QueryableBase`1.System.Collections.IEnumerable.GetEnumerator()   at System.Linq.Enumerable.<OfTypeIterator>d__95`1.MoveNext()   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)   at _CustomMethod(Object , Object[] )   at PX.Data.PXView.InvokeDelegate(Object[] parameters)   at PX.Data.PXView.Select(Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows, String[] sortAsImplicitColumns)   at PX.Data.PXView.Select(Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows)   at PX.Data.PXGraph.ExecuteSelect(String viewName, Object[] currents, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows, Boolean skipHints)   at PX.Data.PXGraph.ExecuteSelect(String viewName, Object[] parameters, Object[] searches, String[] sortcolumns, Boolean[] descendings, PXFilterRow[] filters, Int32& startRow, Int32 maximumRows, Int32& totalRows)   at PX.Api.TSBasedScreen.Services.GridCommonService.SynchronizePositionWithParameters(IActiveDataRow queryParams, PXGraph graph, Object[] parameters, Boolean allowDropCurrent)   at PX.Api.TSBasedScreen.Services.GridCommonService.SynchronizePosition(IActiveDataRow queryParams, PXGraph graph, Boolean allowDropCurrent)   at PX.Api.TSBasedScreen.Services.GridDataHandler.GetData(GridQueryParams queryParams, PXGraph graph, IBasePathProvider basePathProvider, PXViewDescription viewDescription, Boolean syncPosition)   at PX.Api.TSBasedScreen.Services.GridDataHandler.GetControlData(String screenId, PXGraph graph, PXViewDescriptionList views, IUIControlParams uiControlParams, Nullable`1 cancellationToken, IBasePathProvider basePathProvider)   at PX.Api.TSBasedScreen.Models.BaseScreenStructure.BaseScreenStructureBuilder`1.ProcessViewAsControl(String viewName, IUIControlParams controlParams, ScreenDataServiceContext context)   at PX.Api.TSBasedScreen.Models.BaseScreenStructure.BaseScreenStructureBuilder`1.ProcessSelectedView(PXViewDescription viewDescription, Type graphType, Boolean overrideData)   at PX.Api.TSBasedScreen.Models.BaseScreenStructure.BaseScreenStructureBuilder`1.ProcessSelectedViews()   at PX.Api.TSBasedScreen.Services.FormService`1.ProcessScreenBuilding[TResult](BaseScreenStructureBuilder`1 builder, T id, PXGraph graph, CancellationToken cancellationToken, ScreenDataServiceContext context)   at PX.Api.TSBasedScreen.Services.FormService`1.PX.Api.TSBasedScreen.Interfaces.IFormService<T>.GetScreenData(T id, PXGraph graph, ScreenDataServiceContext context, CancellationToken cancellationToken)   at PX.Api.TSBasedScreen.Controllers.FormController`1.UpdateRecords(TFormId formId, CallbackData callback, Nullable`1 popupPanelMode, CancellationToken cancellationToken)   at lambda_method(Closure , Object , Object[] )   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeActionMethodAsync>d__12.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__13.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextExceptionFilterAsync>d__24.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextExceptionFilterAsync()   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextExceptionFilterAsync>d__24.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextExceptionFilterAsync()   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextResourceFilter>d__23.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextResourceFilter>d__23.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextResourceFilter>d__23.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeFilterPipelineAsync>d__18.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeAsync>d__16.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>d__3.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext)   at Microsoft.AspNetCore.Builder.StackOverflowGuardApplicationBuilderExtensions.<>c.<<UseAsyncStackOverflowGuard>b__0_0>d.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Builder.StackOverflowGuardApplicationBuilderExtensions.<>c.<UseAsyncStackOverflowGuard>b__0_0(HttpContext httpContext, Func`1 next)   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.<Invoke>d__3.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)   at PX.AspNetCore.Owin.ApplicationBuilderExtensions.<>c.<<UseScreenIdFromRequest>b__2_0>d.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at PX.AspNetCore.Owin.ApplicationBuilderExtensions.<>c.<UseScreenIdFromRequest>b__2_0(HttpContext context, Func`1 next)   at PX.AspNetCore.Owin.ApplicationBuilderExtensions.<>c.<<UseRouteConstraintValidation>b__1_0>d.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at PX.AspNetCore.Owin.ApplicationBuilderExtensions.<>c.<UseRouteConstraintValidation>b__1_0(HttpContext context, Func`1 next)   at Microsoft.AspNetCore.Builder.ApplicationBuilderExtensions.<>c.<<UseSessionContextFactory>b__7_0>d.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.AspNetCore.Builder.ApplicationBuilderExtensions.<>c.<UseSessionContextFactory>b__7_0(ISessionContextFactory sessionContextFactory, HttpContext httpContext, Func`1 next)   at PX.Api.TSBasedScreen.ModernUIContainerBuilderExtensions.ModernUIOwinRegistration.<PreHandlerExecute>d__3.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at PX.Api.TSBasedScreen.ModernUIContainerBuilderExtensions.ModernUIOwinRegistration.PreHandlerExecute(HttpContext context, Func`1 next)   at PX.Telemetry.TelemetryOwinRegistration.<PreRequestHandlerExecute>d__6.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at PX.Telemetry.TelemetryOwinRegistration.PreRequestHandlerExecute(HttpContext context, Func`1 next)   at Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.IntegratedPipelineContextStage.<RunApp>d__7.MoveNext()   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)   at Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.IntegratedPipelineContextStage.RunApp(Func`2 entryPoint, IDictionary`2 environment, TaskCompletionSource`1 tcs, StageAsyncResult result)   at Microsoft.Owin.Host.SystemWeb.IntegratedPipeline.IntegratedPipelineContextStage.BeginEvent(Object sender, EventArgs e, AsyncCallback cb, Object extradata)   at System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()   at System.Web.HttpApplication.<>c__DisplayClass285_0.<ExecuteStepImpl>b__0()   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)   at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)   at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)   at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)   at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

  • Freshman I
  • June 19, 2026

Hi ​@gracef can you please share the trace?

I’ve attached our Trace can you see the issue?