Forum Discussion

tfaccounts's avatar
tfaccounts
Contributing User
2 years ago

Import Error 4077

Hello, 

 

We are having issues updating our prices on existing items on AccountRight. The import log is showing The import error 4077 'you have sales for this item'

Could you please assist?

10 Replies

Replies have been turned off for this discussion
  • Hi

     

    We are having the exact same errors, cannot get price changes to take correctly in our company file from supplier price lists no matter how much we try.
    Export items, create a "template" auto match, manual match - JUST DOES NOT WORK.

    So, I just did a test from the sample file, exported the items, less than 40 lines.
    Then just changed the prices and tried to import the same file back, automatching all fields and the same error on at least 7 items !!!!

    0 records imported without errors.
    28 records imported with warnings.
    7 records skipped.

    Summary of errors
    Error -4077: You have sales for this item.
    Warning 74: #Items per buying unit may only be specified for items that are bought and inventoried
    Warning 75: #Items per selling unit may only be specified for items that are sold and inventoried
    Warning 240: Price Level A, Quantity Break 1 not equal to Base Selling Price; Bases Selling Price substituted.

     

    Q. If we cannot do a basic export/import on the tiny sample file, what hope is there for adding over 10,000 items each price sheet, and at least 3 suppliers most items will have sales, thats the point of doing price changes in the first place... 


    This is so frustrating and is such a bloody waste of time, there has to be a better way to simply update price lists.
    As a IT tech using csv's and import export is almost a daily chore - but not with AccountRight.

    I'm happy to pay someone or get a 3rd party provider involved as the customer is loosing so much money in sales due to the inability to bring price changes in via supplier feed.
    The next option will be to ditch myob, this is costing far too much in sales and time trying to work it out.

    We allways managed proir to AR cloud, Prem 19.6 was easy, backup, get excel file, import, match fileds needed, and bingo "just worked".

    Any help for this ??

    mcfproservices

     

    • Mike_James's avatar
      Mike_James
      Ultimate Partner

      Hi mcfproservices and tfaccounts , welcome to the forum. Error 4077 on import is a well-known issue, and MYOB moderators will run a script over your files if they are online. 

       

      To do this they typically need to know:

      - the last 4 digits of your serial number

      - the file ID (via Help, About...)

      - location of file (ie online or not)

       

      You could post that information here in anticipation. 

      If they need more info, they will ask you to send it in a private message.

      • tfaccounts's avatar
        tfaccounts
        Contributing User

        Here are the details Mike_James 

         

        - the last 4 digits of your serial number - 0269

        - the file ID (via Help, About...) - 1

        - location of file (ie online or not) - Online