run scripts
Can you (MYOB) please run a script for inventory issues on my file last time you "arranged for a script to be run over the company file from the cloud that has been known to aid clients with a si...
Forum Discussion
Hi DJAF,
Thank you so much for your detailed post and my apologies for the late response.
Could you kindly confirm if you're still experiencing this issue? If you are, please don't hesitate to reach out, and we'll be more than happy to arrange the online script for you.
Looking forward to hearing from you soon!
Regards,
Earl
yes please can you run the scripts
Hi DJAF,
Thank you for your patience. I've executed the online script on your file to resolve this issue successfully. Please keep me updated on your experience with the solution.
Regards,
EarlThanks Earl_HD
this run scripts seems to have created an issue with 1 x inventory line?
ML Almond 1L x 8
In the meantime I have created a new line and called it ML ALMOND and removed stock from line not working and and added to this new inventory line so i can keep operating.
The old line
ML Almond 1L x 8- when i click on the inventory it comes up with an error as follows:
Can you please look into it? - Error follows
AccountRight Application Error Report
=====================================
Application Version: 2023.11.1.6
Application File Version: 2023.11.1.7
Incident Id: 39c8dd27-4f00-47b6-80c2-ee9021eb62b7
Time: Thursday, 21 December 2023 1:41:29 PMCode:
Unknown (0)
Message:
(Unknown): ShowUIView(InventoryItemDetail,...,...)
Stack Trace
----------------------------------------
1 : MYOB.Huxley.API.HuxleyApplicationException
----------------------------------------
MYOB.Huxley.API.HuxleyApplicationException: (Unknown): ShowUIView(InventoryItemDetail,...,...) ---> MYOB.Huxley.API.HuxleyDataException: (DataInvalid): More than one entry exists sharing the same Key.
at mscorlib!0x06005862!System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27
at mscorlib!0x0600586d!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1b3
at Huxley.Service.Gateway!0x06001a2b!MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at Huxley.Service.Proxy!0x06000c53!MYOB.Huxley.Service.Proxy.Services.ProxyItemContainerService.GetCompositeObjectById(IEnumerable`1 objectSetVersions, Int32 id) +0x0
at Huxley.UI.Decorators!0x06002c8e!MYOB.Huxley.UI.Decorators.Services.DecoratorServiceMYOBHuxleyApplicationServicesContainerAPIIItemContainerService.MYOB.Huxley.ApplicationServices.Container.API.IObjectContainerBusinessService<MYOB.Huxley.ApplicationServices.Container.API.IItemContainer>.GetCompositeObjectById(IEnumerable`1 objectSetVersions, Int32 id) +0x52
at Huxley.UI.Model!0x060040f3!MYOB.Huxley.UI.Model.Context.Base.UIContextBusinessContainer`2.<>c__DisplayClass2_0.<GetContainerObject>b__0() +0x0
at Huxley.UI.Model!0x06003ad6!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x60
at Huxley.UI.Model!0x06003ad0!MYOB.Huxley.UI.Model.Context.Base.UIContextBusinessContainer`2.GetContainerObject(Int32 id) +0x2d
at Huxley.UI.Controllers!0x060005cb!MYOB.Huxley.UI.Controllers.InventoryItems.InventoryItemController.GetDataObject() +0x12
at Huxley.UI.Controllers!0x0600117e!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33
at Huxley.UI.Forms!0x06001468!MYOB.Huxley.UI.Forms.InventoryItems.InventoryItemDetailContainer.SetTabPageVisibility() +0x8f
at Huxley.UI.Forms!0x06001457!MYOB.Huxley.UI.Forms.InventoryItems.InventoryItemDetailContainer.SetupContainer() +0x8
at Huxley.UI.Forms!0x060022ea!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1e9
at Huxley.UI.Forms!0x06002343!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x228
at Huxley.UI.Forms!0x0600233f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xa
at Huxley.UI.Forms!0x06001f7c!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.InitializeForm(UIViewType ViewType, IUIViewPresenter uiViewPresenter, String containerResourceID, IUICompanyFile companyFile, EntityInfo eInfo, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x122
at Huxley.UI.Framework!0x06000175!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x88
at Huxley.UI.Framework!0x06000174!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.Show(IUIViewPresenter presenter, UIViewType viewType, Boolean showDialog, EntityInfo eInfo, IUIContext context, Boolean visible, BeginNotificationRefreshMethod refreshMethod) +0xaa
at Huxley.UI.Framework!0x06000193!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x4a
--- End of inner exception stack trace ---
at Huxley.UI.Framework!0x06000193!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0xa3
at Huxley.UI.Forms!0x06001599!MYOB.Huxley.UI.Forms.InventoryItems.ListGridItems.LaunchDetails(UIItemSummary editItem) +0x40
at Huxley.UI.Forms!0x0600159b!MYOB.Huxley.UI.Forms.InventoryItems.ListGridItems.grdvItemsList_DrillDownClicked(Object sender, DrilldownClickedArgs e) +0x0
at Huxley.UI.Controls!0x0600047e!MYOB.Huxley.UI.Controls.External.ExtGridView.InvokeDrillDownClicked(Object row) +0x21
at Huxley.UI.Controls!0x06000479!MYOB.Huxley.UI.Controls.External.ExtGridView.ExtGridView_DoubleClick(Object sender, EventArgs e) +0x56
at DevExpress.XtraGrid.v17.1!0x060004a6!DevExpress.XtraGrid.Views.Base.BaseView.RaiseDoubleClick(EventArgs e) +0x19
at DevExpress.XtraGrid.v17.1!0x06000118!DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnDoubleClick(MouseEventArgs ev) +0x7
at DevExpress.Utils.v17.1!0x06002738!DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args) +0x9f
at DevExpress.XtraGrid.v17.1!0x060000e8!DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args) +0x22
at DevExpress.XtraGrid.v17.1!0x0600216e!DevExpress.XtraGrid.GridControl.OnDoubleClick(EventArgs ev) +0xb3
at System.Windows.Forms!0x06001250!System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) +0x13c
at System.Windows.Forms!0x06001260!System.Windows.Forms.Control.WndProc(Message& m) +0x49f
at DevExpress.XtraEditors.v17.1!0x06001445!DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m) +0x67
at DevExpress.XtraGrid.v17.1!0x0600214e!DevExpress.XtraGrid.GridControl.WndProc(Message& m) +0xbb
at System.Windows.Forms!0x060063eb!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) +0x0
at System.Windows.Forms!0x060063ee!System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) +0x8e
at System.Windows.Forms!0x0600314d!System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) +0x25
==========
MODULE: DevExpress.Utils.v17.1 => DevExpress.Utils.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:b8c34c059b804930811d5f6d50999b6c; A:1
MODULE: DevExpress.XtraEditors.v17.1 => DevExpress.XtraEditors.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6df94e55f5bd4444b910d4b2a37076a4; A:1
MODULE: DevExpress.XtraGrid.v17.1 => DevExpress.XtraGrid.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6a6f2858c181409aa7c4eb6bd501ac5f; A:1
MODULE: Huxley.Service.Gateway => Huxley.Service.Gateway, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:f9cbe21c20d3443d9d2babe4c6243f06; A:1
MODULE: Huxley.Service.Proxy => Huxley.Service.Proxy, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:46aa9df2cd034f5eb09168ce31464fc8; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:46d10a09c5ee408e84c2651bc2b7b083; A:1
MODULE: Huxley.UI.Controls => Huxley.UI.Controls, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:c4439b205add4faf97c688425b8317a7; A:1
MODULE: Huxley.UI.Decorators => Huxley.UI.Decorators, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:8ac9e1a74ff54898866bbc424b8fb4a5; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:93ca19cc5825453fbb5cafb9bacad1d7; A:1
MODULE: Huxley.UI.Framework => Huxley.UI.Framework, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:5a1797428bca4a0e8b999e188f9f622f; A:1
MODULE: Huxley.UI.Model => Huxley.UI.Model, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:e7da28a935124333bc8e2e0b6911822d; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:6124afa4bc7342b581f1f084ae850486; A:2
MODULE: System.Windows.Forms => System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:4f38ceb21d204c87b3ee28d3e54c7dcb; A:1----------------------------------------
2 : MYOB.Huxley.API.HuxleyDataException
----------------------------------------
MYOB.Huxley.API.HuxleyDataException: (DataInvalid): More than one entry exists sharing the same Key.
at mscorlib!0x06005862!System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +0x27
at mscorlib!0x0600586d!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +0x1b3
at Huxley.Service.Gateway!0x06001a2b!MYOB.Huxley.Service.Gateway.API.IGatewayService.Dispatch(String name, Object[] arguments)
at Huxley.Service.Proxy!0x06000c53!MYOB.Huxley.Service.Proxy.Services.ProxyItemContainerService.GetCompositeObjectById(IEnumerable`1 objectSetVersions, Int32 id) +0x0
at Huxley.UI.Decorators!0x06002c8e!MYOB.Huxley.UI.Decorators.Services.DecoratorServiceMYOBHuxleyApplicationServicesContainerAPIIItemContainerService.MYOB.Huxley.ApplicationServices.Container.API.IObjectContainerBusinessService<MYOB.Huxley.ApplicationServices.Container.API.IItemContainer>.GetCompositeObjectById(IEnumerable`1 objectSetVersions, Int32 id) +0x52
at Huxley.UI.Model!0x060040f3!MYOB.Huxley.UI.Model.Context.Base.UIContextBusinessContainer`2.<>c__DisplayClass2_0.<GetContainerObject>b__0() +0x0
at Huxley.UI.Model!0x06003ad6!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x60
at Huxley.UI.Model!0x06003ad0!MYOB.Huxley.UI.Model.Context.Base.UIContextBusinessContainer`2.GetContainerObject(Int32 id) +0x2d
at Huxley.UI.Controllers!0x060005cb!MYOB.Huxley.UI.Controllers.InventoryItems.InventoryItemController.GetDataObject() +0x12
at Huxley.UI.Controllers!0x0600117e!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33
at Huxley.UI.Forms!0x06001468!MYOB.Huxley.UI.Forms.InventoryItems.InventoryItemDetailContainer.SetTabPageVisibility() +0x8f
at Huxley.UI.Forms!0x06001457!MYOB.Huxley.UI.Forms.InventoryItems.InventoryItemDetailContainer.SetupContainer() +0x8
at Huxley.UI.Forms!0x060022ea!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1e9
at Huxley.UI.Forms!0x06002343!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x228
at Huxley.UI.Forms!0x0600233f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xa
at Huxley.UI.Forms!0x06001f7c!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.InitializeForm(UIViewType ViewType, IUIViewPresenter uiViewPresenter, String containerResourceID, IUICompanyFile companyFile, EntityInfo eInfo, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x122
at Huxley.UI.Framework!0x06000175!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x88
at Huxley.UI.Framework!0x06000174!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.Show(IUIViewPresenter presenter, UIViewType viewType, Boolean showDialog, EntityInfo eInfo, IUIContext context, Boolean visible, BeginNotificationRefreshMethod refreshMethod) +0xaa
at Huxley.UI.Framework!0x06000193!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x4a
==========
MODULE: Huxley.Service.Gateway => Huxley.Service.Gateway, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:f9cbe21c20d3443d9d2babe4c6243f06; A:1
MODULE: Huxley.Service.Proxy => Huxley.Service.Proxy, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:46aa9df2cd034f5eb09168ce31464fc8; A:1
MODULE: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:46d10a09c5ee408e84c2651bc2b7b083; A:1
MODULE: Huxley.UI.Decorators => Huxley.UI.Decorators, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:8ac9e1a74ff54898866bbc424b8fb4a5; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:93ca19cc5825453fbb5cafb9bacad1d7; A:1
MODULE: Huxley.UI.Framework => Huxley.UI.Framework, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:5a1797428bca4a0e8b999e188f9f622f; A:1
MODULE: Huxley.UI.Model => Huxley.UI.Model, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:e7da28a935124333bc8e2e0b6911822d; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:6124afa4bc7342b581f1f084ae850486; A:2----------------------------------------
Hi DJAF,
Thanks for your thorough response. To resolve this issue, I suggest clearing your AccountRight Cache as it might be the cause. To do so, follow these steps:1. Open your Start Menu
2. Type: %localappdata%
3. Open the %localappdata% folder:
4. Open the MYOB Folder.
5. Open the AccountRight Folder.
6. Open the Cache Folder.
7. Clear all files listed here.
The Cache files are files containing operational data within AccountRight to make some operations faster, if these files corrupt in any way this could lead to unexpected behavior in AccountRight.
Regards,
Earl
