Forum Discussion

RodSha's avatar
RodSha
Experienced User
4 years ago
Solved

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 file to check everything would work and everything worked fine. 

 

The import on the online file stated 171 records imported zero errors

However all the Custom Field 2 changes have been  applied, but NONE of the pay rates have been updated with the new payrates, they still show the old rate

 

FDpoes anyone know why?

  • 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. 

5 Replies

Replies have been turned off for this discussion
  • 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

  • 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

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.