Import error 4077
Hi, we're having trouble uploading item data to populate pricing changes. The import log refers to error 4077 'you have sales for this item'. Can you please assist? Files are stored locally Last...
Forum Discussion
Hi TPC1
As the company files are stored locally, I've sent you a private message on this Forum which outlines a tool that can be run over the company file to aid in that message.
Do let us know how you get on with that.
Thanks, seems to have done the trick.
Another quick query. When we export / import our item file, if we just wanted to modify the 'selling price' and 'inactive item' fields could we just export-update-import those particular fields (plus the item code) and not affect all the other existing item fields (ie just want to make sure we wouldn't lose or over-write the other field data). Or do we need to include all fields in the exercise?
Cheers
Hi, just checking to ensure that if we were to update a select subset of item data fields (eg selling price, inactive item) via bulk export-import that we wouldn't lose the existing item data within the other fields not updated. ie would this over-write the unselected fields with blanks? Just trying to streamline the process given the large number of records involved.
Cheers
Hi TPC1
Great to hear that has done the trick for you.
Generally speaking, users can export only the fields they want to import along with a required identified field like item number, update those records and import them back in ensuring that Update existing records being enabled. Although, with items, exporting out all the fields is something I would recommend as I've seen some cases of records not updating when all fields are not being imported.
Hi Steven I have the same error message are you able to assist me with that?
Hi NerakNaneek
So we can offer assistance with that enquiry can you confirm the following information:
- Where the company file is stored i.e. online or local
- What the LAST FOUR DIGITS of the serial number is - Setup>>Company Information
- What is the company file ID - Help>>About AccountRight
Hi Steven
File is Local
4302 last 4 digits
Company ID 5
Thanks
