Forum Discussion

BronwynMCC's avatar
BronwynMCC
3 years ago

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.

Yanike_S's avatar
Yanike_S
MYOB Staff
3 years ago

Hi BronwynMCC 

 

Sorry that nobody has offered their assistance with regards to your query yet. Please let us know if you still need assistance with this. 

  • BronwynMCC's avatar
    BronwynMCC
    3 years ago

    Hi

     

    Yes I still need assistance with this problem as nothing has changed.

     

     

    Bronwyn

    • CloverQ's avatar
      CloverQ
      Former Staff
      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.

      • BronwynMCC's avatar
        BronwynMCC
        3 years ago

        Hi Clover

         

        Thanks for your help - it solved my issue.

         

         

        Bronwyn

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.