Hello again,
Receving a different error on this bill import, even though I haven't changed a thing from the last few I imported. What does this mean? I have attached the import log and sample csv file I'm tyring to import.
Thank you
Mazzii
Hi Mazzii1,
Thanks for reaching out.
Generally, the error logs show the error code and why the import has failed. I checked both files that you've attached. The error said that the "item is not bought". I would suggest opening your AccountRight and checking if the items that are involved in this transaction are being bought.
Here is the helpful article Import error log. This would help you understand and read the import logs.
Let us know if you require any further assistance with this. We're happy to help.
Cheers,
Genreve
Hi Genreve,
Thank you kindly for your response. Yes I already checked that and I've used these items before on a previous bill. So I don't know why these are not importing in. It's got me baffled.
Cheers.
Hi again Genreve_S
I can't seem to get my head around the issue. I tried removing things like Billed, and Received, I tried creating a new Item number. None of them worked.
Attached is the most recent import log and the issue seems to be around the top 10 lines there. The lines where there is a 2 1 2... etc on the left side of the description. If that is how we're meant to read the log file!?
Thanks,
Mazzii
Hi Mazzii1
Suggest you spend some time reading here:
There is nothing intuitive here - you must follow the rules. My guess is your previous imports that worked did not include Item GPS+UTS - attach a screenshot of profile tab.
The best advice one can give with learning how to import into MYOB is to first manually enter into MYOB 2 or 3 typical Invoices or Bills you are wanting to import. Export those 2-3 Invoice/Bills. This export file becomes your import template - showing format layout and order MYOB is expecting for the import. Do not deviate until all imports are successful. Then you can experiment with changes. Also practise locally on a copy of your file. Imports cannot be 'undone'.
Regards
Gavin
Hi gavin12345
Thank you for responding.
I have read through these and definitley used the same template from the first sucessful one. Obvsiouly the item numbers change as they are specific to each supplier. Hence why I set them up that way.
Thank you for pointing that out. I updated the items with symbols in MYOB and the imports and that seems to be working.
The other issue that I don't get is, the Billed and Received amounts are not importing. Do you know why that is? I've changed all the columns to General because I read that the files will only import that way. Just tried and changed the heading to Quantity - that caused an error. Changed back to Billed then formatted to Number with 2 decimals - still didn't work.
Any suggestions are appreciated.
Cheers,
Mazzii
Hi Mazzii1
What 'exactly' are you importing - type and quantity? Also provide a list of the exact steps in your import process, starting from File > Import/Export Assistant - what are you selecting on each screen. Provide also screenshot of the import result screen showing all imported correctly, as well as a screenshot of the open invoice/bill which shows all of the imported data but not the Billed and Received amounts. I suspect you are missing a key step or going about something the wrong way. So I don't want to assume anything.
Regards
Gavin
Hi Mazzii1,
Thanks for the information given so far and I'm glad that your previous imports worked.
For your other import issues. I would suggest sending more information regarding the concern just as gavin12345 has suggested. Any import error logs and additional information would help us understand what we are missing on our import file.
We look forward to your response.
Cheers,
Genreve
