Deactivate suppliers in bulk

  • 1
  • Question
  • Updated 3 months ago
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?
Photo of Chris Xiao

Chris Xiao

  • 70 Points

Posted 3 months ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 16,026 Points 10k badge 2x thumb
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?
Photo of Data Rec

Data Rec, Employee

  • 8,382 Points 5k badge 2x thumb
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