on 06-02-2009 2:02 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.