Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
July 2020
July 2020
I have tried for hours to import new "item" into our AR 2020.2 file and constantly receive the error message "58" - income account invalid; item may not be sold.
I've made sure the file is a tab delimited file; I've exported all our existing items and used the same file to import, adding the new items and it still won't import the new items!
The error log shows the account number as 104 when it should be 41000!!
This is becoming increasingly frustrating given I have spent way too much time on this and shouldn't have to do 200+ new items manually!
MYOB - I need a solution and FAST.!!!!
Solved! Go to Solution.
July 2020
July 2020
Hi @HLGROUP , are you able to post the source text file that you are trying to import? (or part of it)
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
July 2020
July 2020
Hi Mike,
This is a sample of the file I have been trying to import.
Fiona
July 2020
July 2020
For imports to AccountRight 2020, if the import file does not have a pair of curly braces on line 1 like so: {} then the import will apply formatting rules for v19.
The account number has no formatting, which is a 2020 rule, so to get this through you should add a blank line at the top of the file with {} as the first 2 characters. (The v19 account number would be formatted like 1-1234).
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
July 2020
July 2020
Thanks Mike,
I'll try that and hopefully it will work for future imports.
Appreicate your help.
Fiona
August 2020
August 2020
thansk Mike,
I tried this and intially it didn't work. Then I exported all our inventory, saved that ITEM.txt, deleted the fields I didn't need, copy and pasted from my other txt file, saved and imported again.
It didn't import the selling prices, but all other fields. I then imported again just those missing fields. Finally it worked.
A lot of work around for something that should be a simple upload.
Clearly the AR programming for 2020.2 needs to be fixed for this process.
Appreciate your replies to my issue.
Fiona
August 2020
August 2020
Hi @HLGROUP , I'm glad to read that it finally worked. There is always a learning curve with importing to AccountRight. Ultimately you should be able to import a single file with all data.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
August 2020
August 2020
Thanks Mike,
We've been doing inventory set up via this import method for 7 years and this is the first time I've had to use the brackets at the top of the .txt file or import it twice as the first time doesn't import the complete file.
MYOB need to review this, as I'd like to hope it's not just me it's happening to......... thx, Fiona
by
Jodie-D
3 weeks ago
1
128
|
1
|
128
|
||
7
|
328
|
|||
by
![]()
18
1419
|
18
|
1419
|
||
13
|
704
|
|||
6
|
739
|