Bulk import of item codes

Hi _Conrad 

We do have a script that we can run over the company file that has been known to aid with that import error. If you would like to confirm the following information we can look into arranging for the necessary script to be run:

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

t  Account Right Plus AU 2019.4.0

Hi _Conrad 

Thank you for confirming that information

I've arranged for the necessary script to be run over the company file. I do recommend closing down and reopening the company file before attempting that import again.

Do let us know how you get on and if you require further assistance.

Hi, I have rerun import and there are no errors. However none of the descriptions have changed as expected? So whilst import did work, the records did not update. 

I have selected "Updated existing Data" as well

When I import a file to include description changes, there are no changes to the item details. There are no errors upon import. Is there a bug with this feature? Are we able to change descriptions using the import function?

Hi _Conrad 

What exactly are you updating with that import? The reason I ask this is that some clients do get confused with Item Name and Description. Item Name being the value that appears in the Profile tab of the Item whereas the Description appears in the Item Details tab>>Notes section.

As such, if you have accidentally edited and imported the Description this would have updated the description of the item, not the Item Name. This does mean that when going to the Item Information window for that item the Item Name would not have updated whereas the Description has been updated. 

I am trying to update the item description (yes I am aware that this is on the Item Details tab. I have two columns, item number and item description. Once I import the file there are no errors, however no changes have been made to the item description

Hi It looks like it is working now

However the 4077 error is again appearing. I think it is now coming up against all new item codes created since you ran the last fix.

Can you please run again? Do we have to keep requesting for this to be run each time we create a new item?

Hi _Conrad 

I've arranged for the script to be run for you. Do ensure that you close down and reopen that file before attempting that import again.

Generally speaking, the script does impact previous items and thus new items should be able to be created successfully in the company file through the Items List.