Forum Discussion

Rose8mary's avatar
Rose8mary
Experienced Cover User
5 years ago

Customer card not found

Hi I know there are other messages on this topic but none that help me and I have called MYOB twice now about this issue. 2/3 of the timeslips of one of our staff members' timeslips when imported (as txt) do not import - says Customer Card not found.  Some of the entries for the same Customer do import! (We do not use id numbers.)  Other staff using the same Customer Names do not have this issue.  The Customer is not a Supplier so only has the one card.

I have tried these things without success:

- copying the customer card name from MYOB into the Excel file which is then converted into txt but the same result

- copying the Excel data onto a new Excel file as thought there might be something in the cells corrupting the data

- MYOB got me to save a new template (txt) & used that.  (I didn't think this would work as it's not the headings that are not working.)

I've had this problem for months and have had to manually enter all the missing timeslips but really need this resolved so any ideas gratefully accepted,

Rosemary

  • Komal_S's avatar
    Komal_S
    5 years ago

    Hi Rose8mary 

     

    I have tried to import the file you attached and received the same Error -66 : Customer card not found, until I checked the card file for each customer.

     

    If in the Profile of the customer card,  their Designation is set to Company, then you would receive the above mentioned error. However, if we change the Designation to Individual with the company name in Last Name, the file is imported successfully.


    Please try doing so and let me know how you go on. 

  • Hi Rose8mary 

     

    Could you please attach the import file and screenshot of the Import/Export assistant where you match the fields so we can investigate the issue further? Once you attach the file, please also let us know the name of the customer for whom all the entries are not getting imported.

    • Rose8mary's avatar
      Rose8mary
      Experienced Cover User

      Hi Komal

      Info as requested attached.

      The names of the Customers whose cards are not imported are in the import log (also attached.

      NB, McMichael & Associates timeslips sometimes imported.

      Other employees with same customers do not have this problem except in minor instances(eg 3 timeslips)

      We thought it might be something in the formatting of the cells in the Excel sheet but cannot find anything.

      Thanks for your help,

      Rosemary

      • Komal_S's avatar
        Komal_S
        MYOB Staff

        Hi Rose8mary 

         

        I have tried to import the file you attached and received the same Error -66 : Customer card not found, until I checked the card file for each customer.

         

        If in the Profile of the customer card,  their Designation is set to Company, then you would receive the above mentioned error. However, if we change the Designation to Individual with the company name in Last Name, the file is imported successfully.


        Please try doing so and let me know how you go on.