cancel
Showing results for 
Search instead for 
Did you mean: 

Information required

Former Member
0 Kudos

Dear All,

I am BI Technical Consultant.

We have implement CRM sales module report in BI reporting. Now sometimes there is a scenario where in user deletes an opportunity for some reason. But in my reporting we cant capture this because that deleted entry is not avaialable in CRM system itself so we cant capture this anyhow.

Is there any way in CRM where in we can mark the Opportunity as deleted or reverse but not completely deleting the transaction from the database.

I hope i am clear . Please feel free to raise any doubt if any.

Rgds

Anup

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Anup,

Do you want to know how logically delete the opportunity not physically delete, right? Generally the user status is prepared to delete logically or close the document and it changes the system status. The system status controls the condition of the document.

But it's depends on customize of your system how the setting of user status or system status. I recommened to ask it for your application member.

Regards,

Masayuki

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Anup,

If the intention is to capture the data then you can archive the document instead of deleting it. You will find a status called "to be archived".If set then the value of the field 'Archiving_flag" will be set to 'X' in CRMD_ORDERADM_H and the document will not be deleted also fron the table.

From you BI you can then capture the documents with this field which is set.

Hope this helps.

Thanks

Abishek

Former Member
0 Kudos

Hi,

Can we mark the Transaction marked as deletion say as 'D' or 'R' instead of 'X'??

Former Member
0 Kudos

Hi Anup,

The field 'Archiving_flag' is boolean field, so only 'X' or blank is set.

Regards,

Masayuki

Former Member
0 Kudos

Hi Anup,

It can be marked as X only like the previous post has indicated.

Thanks

Abishek