How to delete payment term after mass upload in vendor master

[Former Member]

I have uploaded 500 vendors masters through LSMW. I found 100 vendors have uploaded with wrong payment terms. How to replace the payment terms for those vendors. I don't want to delete one by one. Is there anyway I can delete just how we do mass upload.

[Former Member · Accepted solution]

Hi Vicky ,

Insteaded deleteing Vendor completely you can  do mass change of payemnt term in all vendors by T-code XK 99 .

Many Thanks

Regards

[Former Member · Accepted solution]

Hi Preethi,

How about deleting data from customer master, asset and GL masters? And can we upload account groups for chart of accounts through LSMW?

[Marssel700 · Accepted solution]

Hi,

Account Groups are uploaded by LSMW during Master Data creation.

You can delete your vendor and customer records by OBR2 since you have no Purchase or sales organization. Assts records can be deleted by AS06 or OABL for all company code records.

regards

[Former Member · Accepted solution]

Hi,

I agree with your answer, however, I want to know what abt the data in customer master and vendor master for example- payment terms, reconciliation account, address etc. Similarly in asset if we have updated wrong asset class for mass asset master, how can we delete and upload correct values?

[Marssel700 · Accepted solution]

In case for these fields you can do by XK98 and XK99 for Vendor and customers. Assets records can be done by LSMW in transaction AS92.

if you a looking for deletion of records take a look in transaction on my previous comment.

regards