Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
June 2020
June 2020
Hello,
1. I am importing Service Sales, that must be No Tax. But the import wizard requestes the GST incl Amount as a compolsory field.
2. also - getting "25 Error - invalid amount".
Please help, how I can avoid this.
Thank you.
Anastasia
Solved! Go to Solution.
June 2020
June 2020
The best way to troubleshoot this would be entering one of these sales manually in the software and then exporting it using Import/Export Assistant. Once you export one of the sales, you would get a sample import file, which can then be imported in the software to test if that works or not. If it does not get imported, please attach that file here so we can investigate the issue further.
Kind regards,
Komal
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
June 2020
June 2020
Hi @AnastasiaBostan , assuming you have included a field with 0 for the dollar GST value, and that you have so far used the normal GST code, have you also tried using a GST code set at a zero rate?
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 Komal,
Sorry for the late reply.
Thank you for the advice yes it did work....
1. but as I did have couple of same surnames - I got the error message .....attachment "Book11"// tab "Importing report"
2. so I just copied the working sheet in a new tab ..... " .... same surname"...you can see it in the attachment "Book11"
* deleted the records that been successfully imported
* amended the Client’s Cards surnames by adding the "/ " to some ...also updated it in MYOB
* processed the import as per usual.....but....it did not work - please see the importlog report attached :
a) my confusion regarding the report:
*I had only 9 records to be imported .....but the importlog report states "63 records skipped"
* " Error -25: Invalid amount." .......why .......i use the same spreadsheet, same columns, same amounts as in my first attempt, I only deleted the records that been successfully imported in he first attempt.
Could you please help me with this , what have i missed or did wrong ...I am doing it for the first time ....you advice it will be greatly appreciated.
Thank you
Anastasia
July 2020
July 2020
Hi @AnastasiaBostan , if I may comment, the text file has a large number of lines below the data which contain nothing except multiple tab characters. The import errors refer to these rows. You may have deleted the contents of the rows, but you need to delete all the rows in your spreadsheet below the actual data, down as far as the shaded rows, then save the file as a text file.
To delete rows, highlight the row number/s and right-click, select Delete.
I think the actual data imported successfully?
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,
thnak yuo for the reply.
this is what I did ....please see atatched ---the text file and the importlog eport ...still says error 25
July 2020
July 2020
Hi @AnastasiaBostan , the text file has a numeric value on each blank line, equal to the record ID +1, preceded by numerous tab characters. If you make these lines completely blank, those errors should stop.
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...)
1
|
199
|
|||
4
|
553
|
|||
4
|
721
|
|||
by
Hcbp
September
8
1730
|
8
|
1730
|
||
3
|
514
|