Forum Discussion

BronwynMCC's avatar
3 years ago
Solved

Partial Imports

Hi   I have been importing supplier invoices since October 2021 - apart from teething problems, it worked perfectly.   For February and March 2022 it has not been so good - a number of invoices a...
  • CloverQ's avatar
    CloverQ
    3 years ago

    Hi BronwynMCC 

     

    Thanks for the update and apologies for the delayed response. 

     

    I was able to replicate the problem using your test import file, and with further tests I found that it's the 'Record ID' field being the cause. I chose 'Matching cards using their Co./Last Name' during the import, and removing the data from the 'Record ID' field allowed the import to go through successfully.

     

    So if you are also matching cards by their Co./Last Name during import, I'd suggest open the import file in Excel, remove all data from the 'Record ID' column but keep this column as this is a required field for the import. Additionally, the import file you attached isn't the AccountRight v20xx's import format, it requires the first line of the text file to be a specific format, I've attached a screenshot below, please add the {} symbols as indicated:

     

    With the above all updated, save the changes to the text file then import again. I hope this helps.