Partner Zone

import journal

Sarahalexander
3 Posts
User

3Posts

0Kudos

0Solutions

Solved: Go to Solution

import journal

I have followed the "using an import template" instruction from your website, after export the template from test company, then I try to import into MYOB, which showing the error-17 : Invalid credit amount.

i have use export data and only change the date, so if the export data from test company which already exist in MYOB, how come when I try to import and showing the error message? below is the error message.

records imported without errors.
0 records imported with warnings.
1 records skipped.

Summary of errors
Error -17: Invalid credit amount.

-17       249 "$3,266.00" P 1/10/2021 N 0 Y Accrue ACC to budget
            711 "$3,266.00" P 1/10/2021 N 0 N Accrue ACC to budget

1 REPLY 1
Mike_James
Ultimate Partner
4,965 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,965Posts

2,230Kudos

651Solutions

Accepted Solution Solved

Re: import journal

Hi @Sarahalexander , welcome to the forum. Looks like you prepared the text file in Excel first, then saved it as a text file. Excel has added quotes around the fields with commas, ie the amounts over 1,000. Try formatting the amount fields as general, then save as text file.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post