transaction journal error - job codes not coming through in import.

Hi MIA2017,

Just want to follow up if you're still having this issue after updating to the latest version? If so, feel free to post again and one of us will be happy to help.

Regards,
Earl

Hi MIA2017,

Thank you for your post. I'd like to extend you a warm welcome to the Community Forum. I hope you find it a valuable resource.

Regarding your concern with the error message, kindly check the following:

• Tick "Warn if jobs are not assigned to all transactions" under Setup menu >> Preferences >> System.
• When you open the import file in Excel, the job field cells should be formatted to General. This is an important step, as if the cells for this column are formatted to text or numbers, the job will be ignored in the final import regardless of any other setting.

Please let me know if you require any further assistance with this. I'm happy to assist.

Cheers,

Princess

Hi Princess R (MYOB Moderator),

Firstly thank you for responding so promptly.

I have check out settings - preferences  and yes Warn if jobs are not assigned to all transaction is tick.

I then went into Excel and opened the file I wish to import into MYOB. I formatted the  job field cells too General saved and closed file. I opened “Convert GL to MYOB Macrio.xlsm and clicked on Create MYOB File. I am now getting an error message that reads  RUN TIME ERROR “5” INVALID PROCEDURE CALL OR ARGUMENT. See attached snap shot message from trying to debug.

Please advice what the next step is.

Thanks and Kind regards

Hi MIA2017,

Thank you for your response. May I know when and where this error message appeared? Is it when you import the files again to MYOB?

Cheers,

Princess

Hi MIA2017,

I hope you're doing well. I would like to check back with you regarding your concern with importing journal to see if this issue has been resolved. Please let me know if you require further assistance with this. I'm more than happy to assist.

Cheers,

Princess

Hi Princess,

Issue has not been resolved to date and MYOB are not getting back to me. I have placed at least 6 phone calls with them for someone to call back and discuss / look into the issue and no response.

The issue is happening when i import files.

Thanks nad kInd Regards

MIA Admin

Hi MIA2017,

Thank you for your response.

I'm sorry to hear about your experience. I've further checked your case, and I can see that someone from the support team has called you. I've discussed this with the relevant team. They will be looking into your account now to investigate. Please bear with us, as this needs further investigation. Rest assured that our team is looking into it.

Please feel free to create a new post or reply to this thread if you require any further assistance with this. I'm happy to look into this for you.

Cheers,

Princess

How long is this going to take.

It feels like we are held at ransom. This is an ongoing issue that we have and it is now nearly a week from last correspondence we received from MYOB.

Unless this issue is rectified we are unable to work.

Please advice time frame.

Cheers

MIA Admin

Hi MIA2017,

Thank you for your response. I understand how frustrating it must be not being able to work, and I know that this has affected your business. I apologize for this inconvenience. I just discussed this with the relevant team, and I'd ask them to call you back again since your case hasn't been resolved yet. There's no timeframe for when this will be fixed yet, but I can assure you that they're looking into this one.

Thank you for your patience and understanding regarding this matter.

Cheers,

Princess

Hi MIA2017 , are you able to post the top 10 lines or so of the txt file that you are importing to MYOB, plus the import log? This information might help us find your problem.

Note that this is a public forum.