Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Welcome to the MYOB Community Forum, I hope you find it a wealth of knowledge. If you do have enquires don't hesitate to post them so the MYOB Community can assist.
Looking into the error log file (i.e. MYOBLOG file) that have uploaded it appears that you have 3 errors within the import information.
Error -10: Invalid date.
Error -11: Transactions dated before the beginning of your financial year may not be imported.
Error -190: Customer not found. Sale invoice not imported
When you imported the data I assume you went to File>>Import Data>>Sales>>Item Sales. What did you have selected as the "First Record is"?
Looking at the import file it looks like you have selected that to be Data Record rather than Header Record. This has added first line of the import file "Co./Last Name First Name Addr 1 - Line 1 ....." as data. So basically it has thought that the line was data in which you wanted to enter rather than the headings of the columns. I would be selecting the Header record in the box marked "First Record is". This is going to get around the first error as its reading the word "Date" as the date you are trying to import therefore it is invalid.
You also have the error "Transactions dated before the beginning of your financial year may not be imported." The date of the earliest transaction in your import file is showing as 24/01/2014, you will need to make sure that the date of the financial year is before this date. The current financial year can be checked via Setup>>Company Information>>Financial year. Please note that this is the year that financial year ends for example 2015 would be 01/07/2014 - 30/06/2015 financial year. You would need to make sure that the transactions dated in the import file are date on or after the start of the financial year.
Finally the last error is "Customer not found. Sale invoice not imported". This means that the Customer's card is not setup in the file and would need to be done before the import. To setup a card go to Card File>>Cards Lists>>Customer>>New. The customers that need to be added from the import are "Manboom Signage Partnership Pty Ltd". "Scentre Design & Construction Pty Ltd", "Be Digital International Pty Ltd", "Ultimate Sign Installations P/L", "Magic Door Industries Pty Ltd", "Mitsubishi Electric Australia Pty Ltd" and "A W Edwards Pty Limited"
For more information into errors logs and how to check them please see Support Note: Importing and exporting - troubleshooting
Thanks Steven, I have imported customers cards and then imported Sale Invoice. However, I still got "Error -190: Customer not found. Sale invoice not imported", I really do not know what's wrong with this. Can you please help me? Thanks
When you are importing the cards are you selecting to Match All fields and then selecting to import? If so when you select to Match All, scroll through the list of matched fields and unmatch the Card ID and Record ID fields. To unmatch the fields select the field name in the far right hand column. Once completed the Import Data window will look like this:
By doing this it doesn't import that information. As Record ID is the record that is uses in the database, by importing that record it may not correspond the Record ID in the new file.
Please note that this assumes that the cards can be found in Card File>>Cards Lists>>Customers and also that you are not identifying customers by Card ID or Record ID (which is very rare).