Step-by-Step Tutorial on Sales Order Approval!

[@masofi1096]

Hi! thanks for the video. Do you know in which table I can find the order rules?

[@FusionNexgenLearning]

Dear , Sorry for the late response. Please use below query to get the same Use to see Order Approval Details# -------------------------------------------------------------------- SELECT dha.order_number order_number, dha.header_id , dha.approval_sequence_number , t.IDENTIFICATIONKEY || '#####' , dha.creation_date , t.ASSIGNEES assignee , t.version , t.CREATEDDATE , t.UPDATEDDATE , t.state , t.outcome FROM fusion.doo_headers_all dha, fa_fusion_soainfra.wftask t WHERE t.IDENTIFICATIONKEY LIKE'DOO' || dha.header_id || '%' AND dha.submitted_flag = 'Y' AND dha.source_order_number = '&SOURCE_ORDER_NUMBER' UNION SELECT dha.order_number order_number, dha.header_id , dha.approval_sequence_number , t.IDENTIFICATION_KEY || '#####' , dha.creation_date , a.ASSIGNEE , a.version , a.CREATION_DATE CREATEDDATE , a.LAST_UPDATE_DATE UPDATEDDATE, t.STATUS_CODE state , t.OUTCOME_CODE outcome FROM fusion.fnd_bpm_task_assignee a, fusion.FND_BPM_TASK_B t , fusion.doo_headers_all dha WHERE a.task_id =t.task_id AND t.identification_key LIKE'DOO' || dha.header_id || '%' AND dha.submitted_flag = 'Y' AND dha.source_order_number = '&SOURCE_ORDER_NUMBER' ###### Regards, Fusion NexGen Learning

[@SunilKumar-df1hv]

Very good 😌

[@FusionNexgenLearning]

Thank you

[@varshasterling3204]

How Sales Order auto Approve if Sales Order havig a Revision ...?

[@pranavmakharia7652]

and for return sales order how do we configure that ?

[@FusionNexgenLearning]

Thanks for your queries, We will release video on this soon. Keep Watching.... Happy Learning..!! Regards, Fusion NexGen Learning