Analyse Sales (Item - FY comparison) - no information to display
Hi, I have this issue with a client's cloud file. Even selecting one item and 'include zero balances' gives the same result. I have cleared the cache, with no change.
Analyse Sales (Item) reports work correctly.
The diagnostic log includes these details:
2021-03-04 10:21:45.6063,MYOB.Huxley.RF.Core.Services.AppService.RFLogService,Error,1, : System.NullReferenceException: Object reference not set to an instance of an object.
Server stack trace:
at MYOB.Huxley.ServiceModel.ErrorHandling.ExceptionHandingClientMessageInspector.System.ServiceModel.Dispatcher.IClientMessageInspector.AfterReceiveReply(Message& reply, Object correlationState)
at System.ServiceModel.Dispatcher.ImmutableClientRuntime.AfterReceiveReply(ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at MYOB.Huxley.Service.Proxy.Services.ProxyPresentationSalesReportsService.GetItemAnalyseSalesFYComparison(DateTime fromDate, DateTime toDate, DateTime selectedFromDate, DateTime selectedFoDate)
at MYOB.Huxley.UI.Decorators.Services.DecoratorServiceMYOBHuxleyPresentationAPIIPresentationSalesReportsService.MYOB.Huxley.Presentation.API.IPresentationSalesReportsService.GetItemAnalyseSalesFYComparison(DateTime fromDate, DateTime toDate, DateTime selectedFromDate, DateTime selectedFoDate)
at MYOB.Huxley.RF.Data.Models.DataModelsService.RFDataViewModelRepository.GetItemAnalyseSalesFYComparisonViewModels(DateTime fromDate, DateTime toDate, DateTime selectedFromDate, DateTime selectedToDate)
at MYOB.Huxley.RF.Reports.Data.ViewModels.Sales.ItemAnalyseSalesFYComparisonDataViewModel.GetDataModels(RFDataParameterCollection dataParameters)
at MYOB.Huxley.RF.Reports.Data.ViewModels.Base.ReportDataViewModel`1.GetModels(RFDataParameterCollection dataParameters)
The client file serial number ends in 0992.
File ID is 10.
Version 2021.1, build 2021.1.24.2833
Can anything be done to resolve this?
Hi Mike_James
I've arranged for some inventory scripts to be run over the company file. In short, these tidy up some of the item's history and rounding issues. So do give that report a try now.
However, I do see that we are aware of an issue with some company files that those Analyse Sales [Item] based reports can show Nothing to display. This is something that we have been investigating and it does appear to be an issue with custom list entries for these files. While not feasible or an ideal workaround, removing the custom list entries for items has worked and allowed the report to be run for the majority of those cases.
