Forum Discussion

_Conrad's avatar
_Conrad
Contributing User
5 years ago

Bulk import of item codes

HI,   When i try to bulk import description changes to the item codes I get the below message. Can you please advise workaround?    Error -4077: You have sales for this item.   It will not let ...
  • Steven_M's avatar
    Steven_M
    5 years ago

    Hi _Conrad 

     

    Just testing the export and import of items having the Item Description being updated as part of that import. With my AccountRight 2019.4 company file it did work as expected and updated those records.

     

    The only thing that I know that would make the item description not import would be if the field contained non-alpha-numeric characters. 

Steven_M's avatar
Steven_M
Former Staff

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

_Conrad's avatar
_Conrad
Contributing User
5 years ago

t  Account Right Plus AU 2019.4.0

  • Steven_M's avatar
    Steven_M
    Former Staff
    5 years ago

    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.

    • _Conrad's avatar
      _Conrad
      Contributing User
      5 years ago

      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

      • _Conrad's avatar
        _Conrad
        Contributing User
        5 years ago

        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?

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.