Forum Discussion

Webb1's avatar
Webb1
Experienced Cover User
4 years ago
Solved

Importing Journals

Hi I have been having trouble importing a payroll costing journal for the last 3 months now.  Everytime I try to do it it comes up with an error and tells me that it has to close.  Not sure why this...
  • Steven_M's avatar
    Steven_M
    4 years ago

    Hi Webb1 

     

    Ensuring that you aren't linking the same import field to multiple AccountRight fields is something that we have seen in appearing in reach versions. From memory, with AccountRight 2020.1 and onwards, having those import fields matched to multiple AccountRight fields would generate the error you are experiencing.

Webb1's avatar
Webb1
Experienced Cover User

Hi

Thanks for the below response, but the only thing in this file that doubles up is the Dr & Cr entries if you know what I mean.  I have tried just putting in one dr & cr but it requires 2.  I will have a look at anything else that is doubling up but I don't think there is anything.  Do you have any other suggestions what it might be.

 

Thanks

Lisa

Steven_M's avatar
Steven_M
Former Staff
4 years ago

Hi Webb1 

 

So we can investigate further can you provide a copy of the import file that you are using. In addition to that getting a list of what fields in the import file you are matching to what AccountRight field would be ideal (or a screenshot of the Match window when importing would be sufficient).

  • Webb1's avatar
    Webb1
    Experienced Cover User
    4 years ago

    Hi Steven

    Sorry its been so long, please find attached files as per your request.

    I just don't understand it as I have always done exactly the same thing, but for the last few months it no longer works.  

    Kind regards

    Lisa

    • Steven_M's avatar
      Steven_M
      Former Staff
      4 years ago

      Hi Webb1 

       

      The error typically occurs when the same import field is being matched to multiple AccountRight fields. So in your case, you have the Debit column in the import file being matched to both the Debit Ex-Tax Amount and Debit Inc-Tax Amount field.

       

      What you want to do to get around this error and have those transactions imported is to add two extra columns to the import file, can be duplications of the Debit and Credit columns with different names. For example:

       

      When you are importing you then want to match those fields to the respective AccountRight field i.e. Debit can be matched to the Debit Ex-Tax Amount and the Debit Tax Inc (added column) will need to be matched to Debit Inc-Tax Amount field. This would be the same for the Credit side.

      • Webb1's avatar
        Webb1
        Experienced Cover User
        4 years ago

        Hi Steven

        I will give it a go, but can I ask has something changed in this screen as I have never had to do this prior to this occuring.

        I will let you know if it works

        Thanks

        Lisa