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 as below :   Co./La...
Koksoon's avatar
Koksoon
Contributing User
2 years ago

Hi, Mr Mike,

 

May i know how to format the date column from the excel ? Appreciate you can let me know. Thanks a lot for your reply.

 

Regards

Kok Soon

Mike_James's avatar
Mike_James
Ultimate Cover User
2 years ago

Hi Koksoon , dd/mm/yyyy will work.

  • Koksoon's avatar
    Koksoon
    Contributing User
    2 years ago

    Hi, Mr Mike,

     

    Already tried to format all dates from the excel and import the data again,  result still the same, error on invalid date. For your information, the number you highlighted with red colour 44705 is purchase number. 

     

    Regards

    Koksoon

     

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

      Apologies, I wrote too soon. The date next to it (2 0 2 3 - 9 - 2 1) should be in dd/mm/yyyy format.

      • Koksoon's avatar
        Koksoon
        Contributing User
        2 years ago

        Hi, Mr Mike,

         

        i tried in dd/mm/yyyy format for the date, result from import data still the same, error with invalid date.

         

        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