Import items error 4065

Question

I need to update 3000 inventory items but I am getting and error:

Error -4065: You have sales on file for this item

I do this every year and haven't had this error before.

Please help asap.

Online

3410

Company File ID 27

Leneth_A · Answer

Hi @Jasmine_Zoom,

You're most welcome. Thank you as well for your patience. We are thankful for your effort in finding a solution to your concern and we are happy to hear that it was fixed. Feel free to come back to the Community Forum if you have any more questions, we are more than happy to assist.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Cheers,

Leneth

Jasmine_Zoom · Answer

Thanks for your reply,

I worked out that I needed to change my numbers to have four decimal places, and not just rounded but actually use a formula to replace the numbers with a four decimal number. It worked after that.

Leneth_A · Answer

Hi @Jasmine_Zoom, 
 
Thanks for your post and welcome here to the Community Forum. Thank you for confirming the exact error you are getting and thank you for providing some details of your concern. We apologize for any inconvenience this has caused. 
 
Generally, import error 4065 is caused for items that have been inventoried at some stage but are no longer. In saying that, we do have a tool (script) that we can arrange to run over the company file that has helped other users with that import error. 
 
I have checked the email address associated with your account, however, it's a different product serial number. So we can arrange for the script to be run, would you mind confirming the following information in a private message?

* Where the company file is stored i.e. online or local 
* What is the product serial number - Setup>>Company Information

Please let me know if you have any problems with this. 
 
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information. 
 
Cheers, 
Leneth