RQ351209 - Q35 Manage Cancelled Order Approvals

This report assesses F4209 records for the Data Selection where the Status code is either “1N” or “2N”. Each record in that selection is evaluated to determine if all related PO lines are at next status “999” or not. If any lines are not at next status “999” then the order is not reported, but if all lines are at cancelled/closed status “999” then the F4209 approval record is eligible for purging and is listed on the report output. 

If the report is run in Final mode, then these records are also deleted from F4209. 

Note the logic implemented in this report is equivalent to the “Remove Msg” Row Exit logic in P43081. The approval records relating to cancelled orders can also be suppressed by a new Processing Option on the P43081 application version settings for JDE 9.2 x64 systems. So, this report is developed to identify these records which may be suppressed from view, and provide a method of purging these records so that they do not continue to accumulate forever. 

Approved Status notes:
Text indicating where this order stands in the approval process. The following are valid status messages: 

Approved - The approver has approved the order. When an approver approves an order, the system sends an electronic mail message to the next approver stating that his approval is required next. If there are no more required approvers, the system sends a final approved electronic mail message to the person who entered the order. 

Rejected - The approver has rejected the order. When an approver rejects an order, the system sends an electronic mail rejection message to the person who entered the order indicating the order was rejected and changes are necessary before the order can be approved. After the person who entered the order makes changes, the approval processing begins again with the first approver. 

Pending - The approver has not yet taken action on the order. 

Bypassed - The approver was skipped in the approval process because someone of greater authority has approved or rejected the order. 

First position meaning: 

   1   Budget Approver 

   2   Dollar Level Approver 

   3   Originator of the Request  

Second position meaning: 

   R Rejected - Valid with first positions 1, 2, or 3

   A Approved - Valid with first positions 1, 2, or 3

   N Pending Message - Message is waiting in the Approval Process. 

   B Approval Level Skipped - A level of Approval was skipped. 

   O Time Stamp - The information is a record of when the originator entered the information. 

Call By:  

Processing option template: TQ354809.

Processing Options: