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.

TipsTricks_BulkDeleteSuppliers1.jpg

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

TipsTricks_BulkDeleteSuppliers2.jpg

Next step is to create the data provider

TipsTricks_BulkDeleteSuppliers3.jpg

And link to an import scenario

TipsTricks_BulkDeleteSuppliers4.jpg

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

TipsTricks_BulkDeleteSuppliers5.jpg

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

TipsTricks_BulkDeleteSuppliers6.jpg

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

Comments