Forum Discussion

kiwivideo1's avatar
kiwivideo1
Contributing User
2 years ago

Error Importing Item Sales - The given key is not present in the Dictionary

I note that others have had this error, which they say can be fixed by running a script.  I am using AR OFFLINE, as a single user

.

What CAUSES this error?  I need to know so we can prevent it in the future.  I am still waiting for a response from a previous request.

 

Error even occurs when I use a record EXPORTED from AR as the FIRST record in the file to be re-imported.  The key it is looking for is clearly the Record ID, because changing the sequence of records to be imported shows a change in the error reported in ImportLog.txt.  i.e. the error shows the Record ID of the first record in the IMPORT .txt file.

 

Since there appears to be no other way of obtaining this, I obtained the Record IDs by using FGH MYOX Utility.  This reads the Company file and reports and exports selected data, including Card IDs showing CardID and Record ID.

 

Please advise ASAP.  Thanks

  • Hi kiwivideo1 

     

    I suggest you first manually enter 2 typical invoices like you are trying to import. Export those 2 invoices. Use the export file as your import template. Follow this exactly.

     

    Not sure what RecordID you are referring to. The Sales Items import RecordID is for the Customer Record ID only, however this is not a required field and if you don't have it, don't use it. Use Co./Last Name or CardID to match the customer cards instead. Don't use all 3, use one only, unless you have customers with same name.

     

    If the customer card does not exist, the import will fail. Items are identified by Item Number, not Record ID.

     

    Regards

    Gavin

    • kiwivideo1's avatar
      kiwivideo1
      Contributing User

      Many thanks for your quick reply, Gavin.  Sorry MINE was delayed!  I had in fact been doing that after I posted the question and before your reply came in.  Issue resolved. It was actually the Item Number field which was missing - because they were dummy records being imported for other purposes, and weren't created through the normal process. However, it's great to know there IS somewhere in the MYOB universe where quick responses can be received.  Again, much appreciated!