Liam98
Contributing User
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: Sales import file only picking up first line/sale
Hi Gavin Thank you for your response. I just gave it a go and it worked, however when I tried it with other data I started getting the -27 error message that a non-zero amount required an account. When I went back to my original file that worked the first time, I started getting the -27 error on that too although it definitely worked before. I've attached the file with the blank lines between each invoice (the one that worked before but for some reason isn't now). I tried adding new dummy income account numbers and changing them in the file however it hasn't made any difference, and I exported the services sales data already in MYOB to check the formatting and it appears to be the same as my file so I'm not sure what I've done to get it to stop working again.389Views0likes1CommentSales import file only picking up first line/sale
Hi there I'm trying to get some additional sales data imported into a company on AccountRight. I'm using the Import Assistant and loading the file as a service (the data technically involves the sale of an item however they don't keep the item as an inventory/COGS so I thought it'd be easier to bring it in as sale of a service). My practice file works for the first line item however it doesn't work for any of the sales below this. I'm not getting any error messages for these sales either. I've attached the dummy file that I'm using. If someone could please check my file and see if anything stands out that could be causing the other lines to not import it'd be much appreciated. CheersSolved450Views0likes3CommentsRe: Issues with Importing Data into Dummy Company
Thank you so much, the import was successful once I did this! I will mark this response as a solution but I had one other question; I noticed that after adding in the {}'s, I no longer had the GST-Inc Total come up as a field upon importing, is this because this field was from the legacy system? Thanks again, your prompt response earlier was much appreciated. I will hopefully be able to use this file to bring in my actual data now.Issues with Importing Data into Dummy Company
Hi there I'm having some issues importing a file containing item sales data into MYOB AccountRight. As I've never done this before, I decided to play around with the Clearwater dummy company to get the hang of it however I still get error messages when trying to import. This is the process I have taken: 1. Using the Import/Export Assistant, I selected export data. 2. I chose 'Sales' and then 'Item Sales' from the two drop-down boxes in step 2. 3. I chose to separate data using commas, and included field headers. 4. I added all fields for exporting. 5. I exported the file as a .txt and then in Excel, converted this to a .csv file. 6. I removed all sales with the exception of one. I changed the invoice number and the item number (ensuring the item number still matched an actual item in the dummy company) but kept the rest of the data the same as it was upon exporting from the dummy company. After this, I followed the import data process with this new .csv file: 1. Selected import data in the Import/Export Assistant. 2. Selected Sales and Item Sales in the drop-down boxes in step 2. 3. Selected my .csv file to import. 4. I separated data by commas, and allowed the first line of the file to contain headers. I also matched cards using their Co./Last Name. 5. I automatched most of the fields in step 4 of the import assistant, and matched the rest. The only one I wasn't certain about was the compulsory Inc-GST Total field on the right, which I matched to the Total field on the left. I left the Total field itself unmatched as I didn't want to risk an error by doubling up fields. When I do this, I get error 4346: an unbalanced transaction may not be recorded. I thought just testing it with one transaction line would make it work but haven't had any joy so far! If someone could please tell me what I'm doing wrong it'd be much appreciated. When it comes to importing the actual data from Xero, I thought I'd use the dummy export file from MYOB (once I've got the correct format worked out) as my template and I'd add it in there to the actual company. I've also attached my dummy .csv file that is giving me the error. Thank you! Kind regards LiamSolved