Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
May 2020
May 2020
Hi
I have been having trouble importing a payroll costing journal for the last 3 months now. Everytime I try to do it it comes up with an error and tells me that it has to close. Not sure why this is happening. I have attached the error report in case needed.
Can anyone suggest a fix as it take for ever doing it manually.
Thanks
Lisa
Solved! Go to Solution.
May 2020
May 2020
Hi @Webb1
We've seen some similar cases in AccountRight 2020.1 and later of this particular message occurring. You typically see it generated if you have more than one field in the import file being matched to multiple AccountRight fields. For example, in your import file, you have the field invoice number and attempt to match this field to both the invoice number and journal memo in the import process. This has been something that has been flagged with the required team for further investigation.
In the meantime, the recommendation would be to update the import file to include two separate fields; one for each of the import field and then match those fields respectively when importing into AccountRight.
June 2020
June 2020
Hi
Thanks for the below response, but the only thing in this file that doubles up is the Dr & Cr entries if you know what I mean. I have tried just putting in one dr & cr but it requires 2. I will have a look at anything else that is doubling up but I don't think there is anything. Do you have any other suggestions what it might be.
Thanks
Lisa
June 2020
June 2020
Hi @Webb1
So we can investigate further can you provide a copy of the import file that you are using. In addition to that getting a list of what fields in the import file you are matching to what AccountRight field would be ideal (or a screenshot of the Match window when importing would be sufficient).
June 2020
June 2020
Hi Steven
Sorry its been so long, please find attached files as per your request.
I just don't understand it as I have always done exactly the same thing, but for the last few months it no longer works.
Kind regards
Lisa
June 2020
June 2020
Hi @Webb1
The error typically occurs when the same import field is being matched to multiple AccountRight fields. So in your case, you have the Debit column in the import file being matched to both the Debit Ex-Tax Amount and Debit Inc-Tax Amount field.
What you want to do to get around this error and have those transactions imported is to add two extra columns to the import file, can be duplications of the Debit and Credit columns with different names. For example:
When you are importing you then want to match those fields to the respective AccountRight field i.e. Debit can be matched to the Debit Ex-Tax Amount and the Debit Tax Inc (added column) will need to be matched to Debit Inc-Tax Amount field. This would be the same for the Credit side.
June 2020
June 2020
Hi Steven
I will give it a go, but can I ask has something changed in this screen as I have never had to do this prior to this occuring.
I will let you know if it works
Thanks
Lisa
June 2020
June 2020
Hi @Webb1
Ensuring that you aren't linking the same import field to multiple AccountRight fields is something that we have seen in appearing in reach versions. From memory, with AccountRight 2020.1 and onwards, having those import fields matched to multiple AccountRight fields would generate the error you are experiencing.
June 2020
June 2020
Hi Steven
Fixed up the import journal as you suggested and all works fine.
Thanks for the help
Regards Lisa
4
|
703
|
|||
3
|
505
|
|||
1
|
1827
|
|||
13
|
2089
|
|||
29
|
1622
|