Forum Discussion

Koksoon's avatar
Koksoon
Contributing User
2 years ago

MYOB AccountRight Premier Version 19.16 - Import Data

Hi, i am using MYOB AccountRight Premier version 19.16 and trying to import data to purchases section. First of all, i am using export data template file from service purchases to insert the data for ...
  • Mike_James's avatar
    Mike_James
    2 years ago

    Hi Earl_HD , Koksoon , in this case, the issue relates to an invalid date in a text file being imported to AccountRight. Provided WPS Office can save data as a txt file, with the date in the correct format (most likely dd/mm/yyyy, eg 24/10/2023 or 01/09/2023), then there is no compatibility issue.

     

    AccountRight  uses OfficeLink to create reports in Excel, and for that, most likely only Microsoft Excel will be compatible.

     

    It's also possible that the text file has some other issue that leads to an "invalid date" message, so it would be useful to see a copy of the file being imported, and the log file created. 

Koksoon's avatar
Koksoon
Contributing User

Hi, Mr Earl,

 

Thanks for your reply.  May i know MYOB AccountRight Premier Version 19.16 can support WPS Office Excel ? or only can support Microsoft Excel ? Appreciate you can reply me.

 

Thanks & regards

 

Kok Soon

Earl_HD's avatar
Earl_HD
MYOB Moderator
2 years ago

Hi Koksoon,

Thanks for your reply and my apologies for the late response, MYOB AccountRight Premier Version 19.16 is designed to work with Microsoft Excel. It may not be fully compatible with WPS Office Excel, which is an alternative office suite that includes a spreadsheet application similar to Microsoft Excel. MYOB AccountRight Premier is often optimized to work seamlessly with Microsoft Office products, so it's recommended to use Microsoft Excel for the best compatibility and performance with this software. 

Feel free to post again, we're happy to help!
Regards,
Earl

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    2 years ago

    Hi Earl_HD , Koksoon , in this case, the issue relates to an invalid date in a text file being imported to AccountRight. Provided WPS Office can save data as a txt file, with the date in the correct format (most likely dd/mm/yyyy, eg 24/10/2023 or 01/09/2023), then there is no compatibility issue.

     

    AccountRight  uses OfficeLink to create reports in Excel, and for that, most likely only Microsoft Excel will be compatible.

     

    It's also possible that the text file has some other issue that leads to an "invalid date" message, so it would be useful to see a copy of the file being imported, and the log file created. 

    • Koksoon's avatar
      Koksoon
      Contributing User
      2 years ago

      Hi, Mike,

       

      Noted & thanks for your reply. 

       

      Thanks & regards

       

      Koksoon

    • Earl_HD's avatar
      Earl_HD
      MYOB Moderator
      2 years ago

      Hi Koksoon,

      You're very welcome. If you have any more questions in the future, please don't hesitate to reach out, and we'll be delighted to assist you.

      Thank you Mike_James providing a solution. 

      Regards,
      Earl

  • Koksoon's avatar
    Koksoon
    Contributing User
    2 years ago

    Hi, Earl,

     

    Noted and thanks for your reply.

     

    Thanks & regards

     

    Koksoon

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.

 

Related content