Forum Discussion

MIA2017's avatar
MIA2017
Contributing User
2 years ago

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

Hi. I am having an issue with importing from third party software into MYOB Accountright. Importing procedure i follow is:- Import as TRANSACTION JOURNAL. Data is seperated by TAB First line of ...
Princess_R's avatar
Princess_R
MYOB Moderator

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

MIA2017's avatar
MIA2017
Contributing User
2 years ago

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

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    2 years ago

    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

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    2 years ago

    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

    • MIA2017's avatar
      MIA2017
      Contributing User
      2 years ago

      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

      • Princess_R's avatar
        Princess_R
        MYOB Moderator
        2 years ago

        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

         

         

         

         

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.