1 Reply Latest reply: Feb 28, 2012 8:45 PM by Shubhranshu patra RSS

OPEN ORDER documents need to be closed.

Sharma I V N
Currently Being Moderated

Hi All,

 

I need to calulate the Open PO documents.

The Open PO document older than 6 months needs to be treated as open and if the PO is satisfy

the below requirement then it will consider as close.

       Deletion indicator set   or

        GR Delivery indicator set and IR Final invoice indicator set

 

 

By using the Counter Key figure I calculated the Open PO and also by using standard

Variable I calculated the Older than 6 Months PO also. But How do I calculated at query level .

Deletion indicator set   or

GR Delivery indicator set and IR Final invoice indicator set

Here the Open PO fulfills the any one conditions of the above (OR function).

 

Please guide me, how do I complete this requirement at query level.

 

Regards,

Sharma.

  • Re: OPEN ORDER documents need to be closed.
    Shubhranshu patra
    Currently Being Moderated

    HI sharma,

     

    Just drag and drop the three characteristics to the row, then you don't want it in you report then change it's display property to hidden.

     

    Then go to column, then create a formula then select on the edit button to edit this formula. In that prompt , below the keyfigure list you will have Variable list, right click on it and create new variable. Select "replacement path" as type of variable and give any one of the characteristics like "Deletion Indicator"in characteristic, then go to 2nd tab and choose boolean value.

     

    In this way you can create the replacement variable and use that in formula  to find the status.

     

    The best way is write a field routine in DSO or Cube level to get the status of each record.

  • Re: OPEN ORDER documents need to be closed.
    Geeta Patil
    Currently Being Moderated

    Hi,

     

    Create three replacement path formula variables on the characteristics - Deletion indicator,GR Delivery indicator and IR Final invoice indicator with Replacement Rule as 'InfoObject' and Replace with 'Key'.

     

    Use these variables in the Boolean function in a formula for If condition and display the required values.

     

     

     

    Regards,

    Geeta

  • Re: OPEN ORDER documents need to be closed.
    kamesh k
    Currently Being Moderated

    Hi ,

    If im not wrong , you have a variable to cal the PO older than 6 months,GR Delivery indicatorand IR Final invoice and deletion Indicatorfrom the info provider.

     

    Create a CKF with IF condition of OR(GR Delivery indicator set,IR Final invoice indicator set,Dleteted set) then take the value as 1 .

    Use this CKF and restrict it with the variable for  older than 6 months and use Exception aggrigation to sum WRT Po numbers

     

    @Sri

Actions