Hi Mazzii1 , don't post sensitive information, because the forum sends posts out immediately to anyone who has that setting in their notifications.
Importing has its peculiarities, and there's a learning curve that comes with it.
I understand you are importing an item sale and an item purchase. There is a process in the sale window where you can create a purchase from the sale, but there may be issues with how complete that is. It may also work correctly in the browser.
If you prepared the files for import in Excel and saved them as text files, don't those files show you what you did?
One way to proceed is to create an example of the transactions you want to import, and then export them to a file and open those in Excel. Then add the information for the new transactions, but don't delete any columns. The invalid amoutn error can be triggered by haveing columns in the wrong order.
Each separate transaction needs to have a blank line after it. But start small, ie one transaction of each kind.
Hi Mike_James
Thank you for your response. That's right re: sensitive info hence why I didn't want to upload it. As I don't know who uses this forum from the same industry.
So the import log shows me the error -25 - invalid amount, then in the fields that i'm trying to import, I'm not really understanding what the issue is. I have changed all the fields with numbers to ensure they are General or Numbers (down to 2 decimals), I've made sure the data follows what is listed in the import information section on the MYOB website. What I haven't done is re-order the columns to the same order as Item layout for Bills. However, the one successful text file I did upload, I didn't change the columns for this either. But I realised I was missing information that I didn't want to have to retype all over again. It's becoming tedious. With every invoice I create for the month, there is at least 20-30 daily dockets. Half of our invoices are subcontractors which means I have bills for them. I enter all dockets into Time Billing so I have to use the desktop app, not the browser, then i export the sales and try to reconfigre the names of the columns and info to match what i would want to import into an Item bill, so that I'm not completely retyping every docket for every bill.
I hope that makes sense. I just want my job to be easier especially because I do all the bookwork myself and trying to manage other personal affairs on-top, it's been a work-around to get MYOB working for me, and not against me.
Regards,
Mazzii
