Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Hi Good morning to All,
I faced some issues in MYOB import part please give me any solution how to solve this issue. Now i am using MYOB V16.
0 records imported without errors.
1 records skipped.
0 records imported with warnings.
Error -90: Ex-Tax Amount and Inc-Tax Amount are invalid or blank.
What exactly are you importing? Sales or journals? There was a change in the older versions where both the inclusive and exclusive GSt amount had to be included in the import.
I would go into Clearwater (the sample data file) and export out what you are trying to import, and it will give you the fields required.
June 2015 - last edited June 2015
Thank You for your reply Jennie Kingma,
I importing the purchase-> Item Purchase. Here i attached My Import file sample please find that.
Thank you for providing that import file you are using.
Firstly I notice that the currency symbol in the file is set to be Malaysian Ringgit (RM) so I would make sure that your currency settings within Windows is set to be RM.
Secondly for AccountRight to import data correctly the price and information needs to be correct. For example the file you are importing you have said that you want to import 50 items, the price of those items is showing as 24,272.00 This does mean that the total field would need to be calculated correctly so 1,312,600 (50 x 24270).
Thirdly you are showing as having a Tax Code of N-T, which is generally 0%. This does mean that you need the tax amount to be 0.00, Also import duty is only used if you have an Import tax code.
I would recommend entering the transaction or similar transaction in the company file. Once that transaction has been entered, you would export it out via File>>Export Data and follow through the process. This will produce a text file which you can use as a template for importing data into your program.
For more information into exporting and importing please see Support Note: Importing and exporting - troubleshooting