Skip to Content
0

SAP B1 - Bulk delete BP address's (Pay to)

Mar 27 at 01:07 PM

30

avatar image

I have a lot of Supplier BP addresses (Pay to) that all need to be reformatted & reimported.

I have the new 'pay to' address's setup in the DTW template.

But how can I delete the existing address ID's without doing each one individually using the 'remove address' option?

My new address's will have a different address ID & I don't want to end up with 2 BP addresses.

Has anyone come across this before? Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jimmy Liang Mar 27 at 08:41 PM
0

Hi Eoin,

I used to try the Master Data Cleanup wizard. It somehow helped with some item master clean up for me.

For your requirement about BP, I am afraid it will not wipe out the address info as clean as you wish. The Note from this user guide (page 12-13 about BP) says "some content is retained to avoid creating inconsistencies with documents linked to the deleted address..." .

If the BP is not linked to other records, it may be a better idea to just remove the BP then import again, instead of just to remove the address record.

Cheers,

Jimmy

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Jimmy, I don't have any transactions yet so I'll delete & reimport, cleanest way to keep the data in the required format.

0