Deactivate suppliers in bulk

Chris XiaoChris Xiao Member Posts: 1
edited June 2020 in Accounts Hosted
I have to deactive 600+suppliers in Reckon Accounts Hosted R2 2019.

Instead of clicking 'make supplier inactive' 600+times, I have exported the Supplier List in IIF format and editted the HIDDED column, changing the content from N to Y. However the file could not be successfully imported to Reckon Hosted.

Would someone know what's the reason? And is there an alternative way to do this?

Comments

  • Linda ABCLinda ABC Member Posts: 1,171 ✭✭
    edited June 2020
    what is the error message you get when importing back in?  there are some fields (usually the Taxable one) that can cause issues when importing back in?
  • Data RecData Rec Reckon Staff Posts: 772 ✭✭✭
    edited September 2019
    H Chris,

    Try to give the software an indicator that something has changed other than just the inactive/hidden status.

    As a test, edit one of the suppliers in that list and make a change to the "NOTE" field.

    * Add a full stop character. 
    * Import the list into your data file.
    * Confirm if the Supplier has now been made inactive.

    Regards,

    Data Recovery Team

    Regards,

    Reckon Data Recovery Team

    You can request assistance via the case request web form below.

    https://www.reckon.com/au/data-services-request/

Sign In or Register to comment.