Help with transaction journal import

Willmo1 · March

Hi, we have recently moved to Employment Hero for our payroll and i am having major problems importing the file from their system. Can anyone help if i send the file privately?

Willmo1 · a month ago

hello can anyone help?

Princess_R · a month ago

Hi @Willmo1,

Thanks for your post and your patience in waiting for a response.

If you're looking to import MYOB files into Employment Hero, it would be best to reach out to Employment Hero's support team for assistance. On the other hand, if you're aiming to import a journal from Employment Hero to MYOB, I'd suggest checking their page to ensure the data is imported correctly into MYOB. There's also a resolved post that might be helpful, as it discusses some common issues encountered during journal import.

Please feel free to create a new post again if you require further assistance.

Cheers,

Princess

Willmo1 · a month ago

I am wanting to import into MYOB can i send you the txt data for you to look at?

Princess_R · a month ago

Hi @Willmo1,

Thank you for your response.

Absolutely! If you encounter any errors during the import process, please feel free to send us the data for further assistance. Our Help article, Importing and Exporting Data, has lists and instructions on how to import journals, which could assist you.

On the other hand, you can also reach out to our virtual assistant, MOCA, on our website, or you can request support via my account at myob.com.

Please feel free to create a new post again if you need further help.

If my response has answered your inquiry, please click "Accept as Solution" to help other users find this information.

Cheers,

Princess

Willmo1 · a month ago

Thanks - Ive attached the txt report that comes out of Employment Hero,

Princess_R · a month ago

Hi @Willmo1,

Thank you for your response.

Since I'm unable to identify the specific cause of the issue without an error log, I suggest following the steps outlined in our Help article: Importing and exporting data - Using an import template. This article provides instructions on how to export the data template, open it in Excel, and edit or replace its contents with the data you intend to import. Once you've made the necessary changes, you can then import the data into MYOB using this template.

Please feel free to create a new post if you require further assistance.

If my response has answered your inquiry, please click "Accept as Solution" to help other users find this information.

Cheers,

Princess

Willmo1 · a month ago

AccountRight Application Error Report
=====================================
Application Version: 2024.2.1.3
Application File Version: 2024.2.1.3
Incident Id: 50c3922e-65ff-42a7-84eb-3deddaed9e57
Time: Thursday, 21 March 2024 7:23:36 AM

Code:
System.InvalidOperationException

Message:
Sequence contains more than one matching element

Stack Trace
----------------------------------------
1 : System.InvalidOperationException
----------------------------------------
System.InvalidOperationException: Sequence contains more than one matching element
at System.Core!0x06000b8c!System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate) +0x11
at Huxley.UI.Controllers!0x0600306d!MYOB.Huxley.UI.Controllers.ImportExport.ImportValidationExtensions.<>c__DisplayClass8_0.<GetMappedHeaders>b__0(Int32 i) +0x24
at System.Core!0x06001bcc!System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext() +0x4d
at mscorlib!0x06003b05!System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +0x77
at System.Core!0x06000b6f!System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) +0xe
at Huxley.UI.Controllers!0x06001ebc!MYOB.Huxley.UI.Controllers.ImportExport.ImportValidationExtensions.GetMappedHeaders(IImportExportSettings settings) +0x2f
at Huxley.UI.Controllers!0x06001f46!MYOB.Huxley.UI.Controllers.ImportExport.ImportExportController.ValidateMappings(IImportExportSettings settings) +0x0
at Huxley.UI.Controllers!0x06001f47!MYOB.Huxley.UI.Controllers.ImportExport.ImportExportController.ValidateImportMappings(List`1& validationCodes) +0xd
at Huxley.UI.Forms!0x060017a1!MYOB.Huxley.UI.Forms.ImportExportWizard.ImportExportWizard.OnCustomRight1Clicked(ButtonClickedArgs args) +0x170
at Huxley.UI.Forms!0x0600242f!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.CallButtonClicked(Action`1 execute, ButtonClickedArgs args, String buttonText) +0x12
at Huxley.UI.Forms!0x060023ab!MYOB.Huxley.UI.Forms.BaseForms.BaseViewForm.btnCustom1_Click(Object sender, EventArgs e) +0x30
at System.Windows.Forms!0x06001169!System.Windows.Forms.Control.OnClick(EventArgs e) +0x19
at DevExpress.XtraEditors.v17.1!0x06000d4f!DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e) +0x2e
at DevExpress.XtraEditors.v17.1!0x06000d48!DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e) +0x1d
at System.Windows.Forms!0x06001250!System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) +0x184
at System.Windows.Forms!0x06001260!System.Windows.Forms.Control.WndProc(Message& m) +0x49f
at DevExpress.Utils.v17.1!0x06002708!DevExpress.Utils.Controls.ControlBase.WndProc(Message& m) +0x2e
at DevExpress.XtraEditors.v17.1!0x06000256!DevExpress.XtraEditors.BaseControl.WndProc(Message& msg) +0x0
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: Huxley.UI.Controllers => Huxley.UI.Controllers, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:20971d0ee6c140cdb9cbe7614dd6ff4c; A:1
MODULE: Huxley.UI.Forms => Huxley.UI.Forms, Version=2024.2.1.3, Culture=neutral, PublicKeyToken=947f70fecdd4159f; G:221a66c1577647d988c8d366fb1b6d68; A:1
MODULE: mscorlib => mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:6124afa4bc7342b581f1f084ae850486; A:2
MODULE: System.Core => System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:8b33701d55b2465ca4f7dd0a85c2707f; A:2
MODULE: System.Windows.Forms => System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089; G:4f38ceb21d204c87b3ee28d3e54c7dcb; A:1

Princess_R · a month ago

Hi @Willmo1,

Thanks for providing the error log.

I have implemented a few changes on our side that should assist in resolving the issue. Kindly sign out and clear your AccountRight cache, then log back in before you try to import data again.

Should the problem continue, please duplicate the column you wish to link in the import file and assign it a new name. This will allow you to link the two different names and proceed with the import.

Feel free to create a new post again if you need further assistance.

If my response has answered your inquiry, please click "Accept as Solution" to help other users find this information.

Cheers,

Princess