Skip to Content

GR/IR aging report

Hi all,

I need to create a report based on PO + GR + IR data.

I have a DSO which contains a characteristic which distinguishes between the different types of documents (PO / INV / GR).

The requirement is to see in the report only POs which already have a GR.

How can this be done?

Thanks,

Hagit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 28, 2011 at 08:44 AM

    Hi Hagit,

    I don't quite get what you mean by saying PO/GR/IR can be differentiated by a Doc Type Char coz a GR or IR always has an associated PO to it. Also GR / IR have dates/qty associated with them. If there is a way to know whether GR has happened for a PO say by the GR Date / Quantity i.e. GR Qty > 0 or likewise in the PO record, you can always filter on these conditions in the Query.

    --Priya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2011 at 11:38 AM

    hi,

    you cannot acheive this in the report level.

    my idea is get the build a dso or cube for this report and load it from your orginal dso.

    using start routine get the source data from the orginal dso and sort the data for with the criteria that it should only pick po which have document type as GR and store it in an internal table.

    and in the end routine use this internal table to populate directly to the active table of the dso.

    or

    you can interpret the same logic directly at the end routine

    by this way you will have dso straight away withy pos containing document type as GR

    And you can esaily generate teh report.

    Thanks

    krishna.y

    Add comment
    10|10000 characters needed characters exceeded