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
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.