Forum Discussion

EAH's avatar
EAH
Contributing Cover User
6 years ago

Error -14: Invalid account number.

Hi Support

 

We use an external payroll system and import the transaction journals.

 

This error code has appeared since we updated the locations in the external system. Note that this myob account is active, is not a header and in fact, seems to be ok for the other lines it is used within this same transaction?

  • Hi EAH 

     

    Suggest you open the Pay Journal file in excel (carefully - Account column should be imported as text) - Lines 53 and 59 have account as 6-2530.5-0110 and 2-1442.5-0110 respectively.

     

    As these are invalid, I would hazard a guess that these are the cause of your dramas. As this import is treated as one journal, if one line fails, all lines fail.

     

    Regards

    Gavin

  • Hi EAH 

     

    Suggest you open the Pay Journal file in excel (carefully - Account column should be imported as text) - Lines 53 and 59 have account as 6-2530.5-0110 and 2-1442.5-0110 respectively.

     

    As these are invalid, I would hazard a guess that these are the cause of your dramas. As this import is treated as one journal, if one line fails, all lines fail.

     

    Regards

    Gavin

    • EAH's avatar
      EAH
      Contributing Cover User

      Thanks for pointing me in the right direction!