Customer Combiner and Modifier Tool - Attached Documents

(1) Share

Report

Posted on by Community member

I'm having a hard time confirming by searching internet that attached documents get lost when using the Customer Combiner and Modifier Tool.

I am modifying a customer number that has an attachment and the attachment is not there after the process is complete. Is this a known issue?
I can modify the customer back to the original number and the attachment is back again.
Any help or confirmation would be appreciated.
Thanks

I have the same question (0)

All responses (3)

Answers (0)

Judy Microsoft Employee on at

Like (0)

Report

Hi, Thanks for your sharing. Hope other experts can suggest on this.

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

It seems that I can get the attachments to appear if I manually update these tables via SQL SSMS with the following lines:

update CO00102 set BusObjKey='0\RM\Customer Maintenance\MYNEWID' where BusObjKey='0\RM\Customer Maintenance\MYOLDID'
update CO00104 set BusObjKey='0\RM\Customer Maintenance\MYNEWID' where BusObjKey='0\RM\Customer Maintenance\MYOLDID'
update CO00105 set BusObjKey='0\RM\Customer Maintenance\MYNEWID' where BusObjKey='0\RM\Customer Maintenance\MYOLDID'

Any reaction to that?

Thanks, DelW

Was this reply helpful? Yes No
ArthurA 4 on at

Like (1)

Report

I am pretty sure it doesn't, I have looked at the stored procedures it uses and I see no reference to the attachment tables.

I recommend adding your own logic to the rmCustomerCombinerPost or rmCustomerCombinerPre procedure.

For what you are doing rmCustomerCombinerPost is suitable, now if it had trouble with a third party module such as Wennsoft, you could modify the rmCustomerCombinerPre as you would need to deal with duplicate keys.

thanks

Was this reply helpful? Yes No

Join the conversation

Community site session details

Customer Combiner and Modifier Tool - Attached Documents

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Customer Combiner and Modifier Tool - Attached Documents

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates