MYOB Advanced – TIPS & TRICKS: How To Use Import Scenario To Mass Delete Suppliers

This article describes how you can use an import scenario to perform a mass delete of suppliers. This method can also be applied to other master data which has not been transacted against.

In this example the suppliers to be deleted are DELETE1, DELETE2 and DELETE3.


First step is to create an excel spreadsheet - generic inquiries can be used to extract data.


Next step is to create the data provider


And link to an import scenario


Next step is to do the update by the screen Import by scenario


Checking the suppliers show that the data is now removed by using the above import scenario.


As always, we recommend that thorough testing in a non-live environment is undertaken before commencing an upgrade.











Did this help? If not, try contacting us Submit a request