run scripts

Question

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 similar situation"

this is for "a script in which can run over company files that are showing unusually long decimal place or N/A inventory values or a negative inventory message "

so please repeat this

Our file is online - Serial # (last 4) 9812

company file id: 1

Thanks

Daniel Jackson

princess_r · Accepted Answer

Hi DJAF,
&nbsp;
I hope you've had a good day! I wanted to follow up regarding whether you're still encountering issues with your inventory items. Please let me know if you still need assistance with this. I'm here to assist you and ensure that your concerns are addressed thoroughly.&nbsp;

earl_hd · Answer

Hi DJAF,Thank you so much for your detailed post and my apologies for the late response.&nbsp;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

djaf · Answer

yes please can you run the scripts

earl_hd · Answer

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,Earl

djaf · Answer

Thanks&nbsp;Earl_HD&nbsp;this run scripts seems to have created an issue with 1 x inventory line?ML Almond 1L x 8In 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.&nbsp;The old lineML 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&nbsp;&nbsp;AccountRight Application Error Report=====================================Application Version: 2023.11.1.6Application File Version: 2023.11.1.7Incident Id: 39c8dd27-4f00-47b6-80c2-ee9021eb62b7Time: 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,...,...) ---&gt; 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) +0x27at mscorlib!0x0600586d!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&amp; msgData, Int32 type) +0x1b3at 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) +0x0at Huxley.UI.Decorators!0x06002c8e!MYOB.Huxley.UI.Decorators.Services.DecoratorServiceMYOBHuxleyApplicationServicesContainerAPIIItemContainerService.MYOB.Huxley.ApplicationServices.Container.API.IObjectContainerBusinessService&lt;MYOB.Huxley.ApplicationServices.Container.API.IItemContainer&gt;.GetCompositeObjectById(IEnumerable`1 objectSetVersions, Int32 id) +0x52at Huxley.UI.Model!0x060040f3!MYOB.Huxley.UI.Model.Context.Base.UIContextBusinessContainer`2.&lt;&gt;c__DisplayClass2_0.&lt;GetContainerObject&gt;b__0() +0x0at Huxley.UI.Model!0x06003ad6!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x60at Huxley.UI.Model!0x06003ad0!MYOB.Huxley.UI.Model.Context.Base.UIContextBusinessContainer`2.GetContainerObject(Int32 id) +0x2dat Huxley.UI.Controllers!0x060005cb!MYOB.Huxley.UI.Controllers.InventoryItems.InventoryItemController.GetDataObject() +0x12at Huxley.UI.Controllers!0x0600117e!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33at Huxley.UI.Forms!0x06001468!MYOB.Huxley.UI.Forms.InventoryItems.InventoryItemDetailContainer.SetTabPageVisibility() +0x8fat Huxley.UI.Forms!0x06001457!MYOB.Huxley.UI.Forms.InventoryItems.InventoryItemDetailContainer.SetupContainer() +0x8at Huxley.UI.Forms!0x060022ea!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1e9at Huxley.UI.Forms!0x06002343!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x228at Huxley.UI.Forms!0x0600233f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xaat 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) +0x122at Huxley.UI.Framework!0x06000175!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x88at 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) +0xaaat 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) +0xa3at Huxley.UI.Forms!0x06001599!MYOB.Huxley.UI.Forms.InventoryItems.ListGridItems.LaunchDetails(UIItemSummary editItem) +0x40at Huxley.UI.Forms!0x0600159b!MYOB.Huxley.UI.Forms.InventoryItems.ListGridItems.grdvItemsList_DrillDownClicked(Object sender, DrilldownClickedArgs e) +0x0at Huxley.UI.Controls!0x0600047e!MYOB.Huxley.UI.Controls.External.ExtGridView.InvokeDrillDownClicked(Object row) +0x21at Huxley.UI.Controls!0x06000479!MYOB.Huxley.UI.Controls.External.ExtGridView.ExtGridView_DoubleClick(Object sender, EventArgs e) +0x56at DevExpress.XtraGrid.v17.1!0x060004a6!DevExpress.XtraGrid.Views.Base.BaseView.RaiseDoubleClick(EventArgs e) +0x19at DevExpress.XtraGrid.v17.1!0x06000118!DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnDoubleClick(MouseEventArgs ev) +0x7at DevExpress.Utils.v17.1!0x06002738!DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args) +0x9fat DevExpress.XtraGrid.v17.1!0x060000e8!DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args) +0x22at DevExpress.XtraGrid.v17.1!0x0600216e!DevExpress.XtraGrid.GridControl.OnDoubleClick(EventArgs ev) +0xb3at System.Windows.Forms!0x06001250!System.Windows.Forms.Control.WmMouseUp(Message&amp; m, MouseButtons button, Int32 clicks) +0x13cat System.Windows.Forms!0x06001260!System.Windows.Forms.Control.WndProc(Message&amp; m) +0x49fat DevExpress.XtraEditors.v17.1!0x06001445!DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message&amp; m) +0x67at DevExpress.XtraGrid.v17.1!0x0600214e!DevExpress.XtraGrid.GridControl.WndProc(Message&amp; m) +0xbbat System.Windows.Forms!0x060063eb!System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp; m) +0x0at System.Windows.Forms!0x060063ee!System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp; m) +0x8eat System.Windows.Forms!0x0600314d!System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) +0x25==========MODULE: DevExpress.Utils.v17.1 =&gt; DevExpress.Utils.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:b8c34c059b804930811d5f6d50999b6c; A:1MODULE: DevExpress.XtraEditors.v17.1 =&gt; DevExpress.XtraEditors.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6df94e55f5bd4444b910d4b2a37076a4; A:1MODULE: DevExpress.XtraGrid.v17.1 =&gt; DevExpress.XtraGrid.v17.1, Version=17.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a; G:6a6f2858c181409aa7c4eb6bd501ac5f; A:1MODULE: Huxley.Service.Gateway =&gt; Huxley.Service.Gateway, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:f9cbe21c20d3443d9d2babe4c6243f06; A:1MODULE: Huxley.Service.Proxy =&gt; Huxley.Service.Proxy, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:46aa9df2cd034f5eb09168ce31464fc8; A:1MODULE: Huxley.UI.Controllers =&gt; Huxley.UI.Controllers, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:46d10a09c5ee408e84c2651bc2b7b083; A:1MODULE: Huxley.UI.Controls =&gt; Huxley.UI.Controls, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:c4439b205add4faf97c688425b8317a7; A:1MODULE: Huxley.UI.Decorators =&gt; Huxley.UI.Decorators, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:8ac9e1a74ff54898866bbc424b8fb4a5; A:1MODULE: Huxley.UI.Forms =&gt; Huxley.UI.Forms, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:93ca19cc5825453fbb5cafb9bacad1d7; A:1MODULE: Huxley.UI.Framework =&gt; Huxley.UI.Framework, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:5a1797428bca4a0e8b999e188f9f622f; A:1MODULE: Huxley.UI.Model =&gt; Huxley.UI.Model, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:e7da28a935124333bc8e2e0b6911822d; A:1MODULE: mscorlib =&gt; mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:6124afa4bc7342b581f1f084ae850486; A:2MODULE: System.Windows.Forms =&gt; 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) +0x27at mscorlib!0x0600586d!System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&amp; msgData, Int32 type) +0x1b3at 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) +0x0at Huxley.UI.Decorators!0x06002c8e!MYOB.Huxley.UI.Decorators.Services.DecoratorServiceMYOBHuxleyApplicationServicesContainerAPIIItemContainerService.MYOB.Huxley.ApplicationServices.Container.API.IObjectContainerBusinessService&lt;MYOB.Huxley.ApplicationServices.Container.API.IItemContainer&gt;.GetCompositeObjectById(IEnumerable`1 objectSetVersions, Int32 id) +0x52at Huxley.UI.Model!0x060040f3!MYOB.Huxley.UI.Model.Context.Base.UIContextBusinessContainer`2.&lt;&gt;c__DisplayClass2_0.&lt;GetContainerObject&gt;b__0() +0x0at Huxley.UI.Model!0x06003ad6!MYOB.Huxley.UI.Model.Context.Base.UIContextContainer`2.InvokeContainerGet(Func`1 getFunction, Boolean force) +0x60at Huxley.UI.Model!0x06003ad0!MYOB.Huxley.UI.Model.Context.Base.UIContextBusinessContainer`2.GetContainerObject(Int32 id) +0x2dat Huxley.UI.Controllers!0x060005cb!MYOB.Huxley.UI.Controllers.InventoryItems.InventoryItemController.GetDataObject() +0x12at Huxley.UI.Controllers!0x0600117e!MYOB.Huxley.UI.Controllers.Base.BaseControllerBusinessObject`5.get_DataRecord() +0x33at Huxley.UI.Forms!0x06001468!MYOB.Huxley.UI.Forms.InventoryItems.InventoryItemDetailContainer.SetTabPageVisibility() +0x8fat Huxley.UI.Forms!0x06001457!MYOB.Huxley.UI.Forms.InventoryItems.InventoryItemDetailContainer.SetupContainer() +0x8at Huxley.UI.Forms!0x060022ea!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.InitializeContainer(IUIViewPresenter uiPresenter, IController parentController, IUIContext context, EntityInfo eInfo) +0x1e9at Huxley.UI.Forms!0x06002343!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, String name, IController controller, IUIContext context, EntityInfo eInfo, Boolean visible) +0x228at Huxley.UI.Forms!0x0600233f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewContainer.DynamicContainerLoad(String resourceId, IUIContext context, EntityInfo eInfo) +0xaat 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) +0x122at Huxley.UI.Framework!0x06000175!MYOB.Huxley.UI.Framework.Presenter.UIViewFactory.GetForm(UIViewType viewType, EntityInfo eInfo, IUIViewPresenter presenter, Boolean showAsModal, BeginNotificationRefreshMethod refreshMethod) +0x88at 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) +0xaaat Huxley.UI.Framework!0x06000193!MYOB.Huxley.UI.Framework.Presenter.UIViewPresenter.ShowUIView(UIViewType uiViewType, EntityInfo entityInfo, BeginNotificationRefreshMethod refreshMethod) +0x4a==========MODULE: Huxley.Service.Gateway =&gt; Huxley.Service.Gateway, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:f9cbe21c20d3443d9d2babe4c6243f06; A:1MODULE: Huxley.Service.Proxy =&gt; Huxley.Service.Proxy, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:46aa9df2cd034f5eb09168ce31464fc8; A:1MODULE: Huxley.UI.Controllers =&gt; Huxley.UI.Controllers, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:46d10a09c5ee408e84c2651bc2b7b083; A:1MODULE: Huxley.UI.Decorators =&gt; Huxley.UI.Decorators, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:8ac9e1a74ff54898866bbc424b8fb4a5; A:1MODULE: Huxley.UI.Forms =&gt; Huxley.UI.Forms, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:93ca19cc5825453fbb5cafb9bacad1d7; A:1MODULE: Huxley.UI.Framework =&gt; Huxley.UI.Framework, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:5a1797428bca4a0e8b999e188f9f622f; A:1MODULE: Huxley.UI.Model =&gt; Huxley.UI.Model, Version=2023.11.1.6, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:e7da28a935124333bc8e2e0b6911822d; A:1MODULE: mscorlib =&gt; mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:6124afa4bc7342b581f1f084ae850486; A:2----------------------------------------&nbsp;&nbsp;&nbsp;&nbsp;

earl_hd · Answer

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:
&nbsp;
1.&nbsp;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.
&nbsp;
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

Forum Discussion

run scripts

10 Replies

Related content

Run Payroll Script

Inventory Script Run

Script run - Inventory issues

INVENTORY - SCRIPT RUN

Inventory Script

Script Error

Script Error - Need Script Run over Employee Files

Inventory Script