Forum Discussion

RodSha's avatar
RodSha
Experienced User
4 years ago

Import of revised Hourly Rate did not work

We have an annual pay increase, I exported the card date, updated the payrates and some information in Custom Field 2   Prior to doing it on the online file I did it on a backup copy of the company...
  • Komal_S's avatar
    Komal_S
    4 years ago

    Hi RodSha 

    Thanks for providing additional details.


    I've gone through your import files and the pay rate is not getting updated because there is no column to specify whether the rate is salary-based or hourly. I've attached a sample of the amended import file with the column for Pay basis and using that figures will update as expected.


    Let me know if you have additional questions on this. 

Komal_S's avatar
Komal_S
MYOB Staff
4 years ago

Hi RodSha 

 

I've replicated the situation in some of our sample files and the hourly rate was imported as expected. As it did not update for you correctly the first time, can you try the import again but just to update the pay rate as the custom fields have already been imported.


You also mentioned that the import worked without any issues in the backup copy, therefore, can you try turning off antivirus and firewall, and try the process again. This will rule out any interference caused due to third party apps.

If it does not work, please attach the import file here after removing all the sensitive employee data so we can investigate further. 

  • RodSha's avatar
    RodSha
    Experienced User
    4 years ago

    Part two of email

     

    Attached is the upload file with bank details less personal information

     

    Also attached is the export post upload

     

    Please note that staff who are on $25.20 had no increase in salary, so to compare upload to post export you will need to select other pay rates.

     

    Thanks for any help ytouy can provide

    • Komal_S's avatar
      Komal_S
      MYOB Staff
      4 years ago

      Hi RodSha 

      Thanks for providing additional details.


      I've gone through your import files and the pay rate is not getting updated because there is no column to specify whether the rate is salary-based or hourly. I've attached a sample of the amended import file with the column for Pay basis and using that figures will update as expected.


      Let me know if you have additional questions on this. 

    • RodSha's avatar
      RodSha
      Experienced User
      4 years ago

      Komal

       

      Thank you very much i added "Pay Basis" in and it worked.  I had orignally taken it out of the upload file I wasnt changing or altering the pay basis, i didnt realise that it you include Rate you must also include basis.

       

      Than you for your help

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.