Forum Discussion

GunveenSingh's avatar
GunveenSingh
Experienced User
4 years ago
Solved

Unable to update ITEM details via Import/Export

Hi MYOB Team,

I'm unable to update the prices under Custom List 2. When I recently tried to update all the price feilds using the Import/Export Assistant the prices under Custom List 2 did not update and got a warning "Warning 227: Custom List entry not found; entry ignored."


Attaching the import file. Tried both CSV and Tab delimited files but it did not work. Is this a know bug in MYOB AccountRight? Looking for a quick resolution as it is impacting my business. Attaching import and error files.

  • gavin12345's avatar
    gavin12345
    4 years ago

    Hi GunveenSingh 

     

    Does the new entry you are wanting to use currently exist in your Custom List?

     

    Open an Item from the Items List and select the Item Details tab. Notice the Custom Lists fields (ones on the left) have a drop down arrow - this means only List entries you have already added can be used. Click 2nd drop down arrow and try to select one of those you are trying to import. If it is not there, the import will fail. First update the List under Lists > Custom Lists > Items. Then try import again.

     

    Regards

    Gavin

2 Replies

Sort By
Replies have been turned off for this discussion
  • gavin12345's avatar
    gavin12345
    Ultimate User
    4 years ago

    Hi GunveenSingh 

     

    Does the new entry you are wanting to use currently exist in your Custom List?

     

    Open an Item from the Items List and select the Item Details tab. Notice the Custom Lists fields (ones on the left) have a drop down arrow - this means only List entries you have already added can be used. Click 2nd drop down arrow and try to select one of those you are trying to import. If it is not there, the import will fail. First update the List under Lists > Custom Lists > Items. Then try import again.

     

    Regards

    Gavin