Deactivate suppliers in bulk

Options
Chris Xiao
Chris 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 ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    edited June 2020
    Options
    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?
  • Datarec_ReckonLtd
    Datarec_ReckonLtd Reckon Staff Posts: 1,063 Reckon Staff
    edited September 2019
    Options
    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

    How to ask good questions on the Reckon Community

    Data Services Tip - Try this first before requesting a data service

Categories