Purchasing

Get Involved. Join the Conversation.

Topic

    chetan kumar
    Receipt Number field blank on OTBI report from Procure to...Answered
    Topic posted March 25, 2019 by chetan kumarBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Security 
    164 Views, 7 Comments
    Title:
    Receipt Number field blank on OTBI report from Procure to Pay Subject Area
    Summary:
    Receipt Number field blank on OTBI report from Procure to Pay Subject Area
    Content:

    Hi All,

    we built a OTBI report based on "Procure to Pay" subject area, receipt number field is blank,Could anyone check what would be the reason.

    Regards,

    Chetan

    Best Comment

    Minna Muikku

    Hi,

    Yes I understand that, and I think that is why it is empty (in my case). Not sure what the original poster is expecting this "receipt" attribute to show but if he/she is trying to get the gr number like I was, then that is a wrong attribute. There is no goods receipt number available in Procure to Pay subject area, which is kind of disappointing since gr is a key element in procure to pay process.

    Comment

     

    • Minna Muikku

      I noticed this too while creating our reports.  But I also noticed that the "receipt" attribute is under "Invoice" folder so I wonder if that is the case. Anyway, I would also be really interested to hear the reason. :)

       

      Br,

       

      Minna

      • Aditya Singh

        Hi Minna,

        Receipt attribute under invoice is different , In P2P material receipt or Goods Receipt is not under invoice , it should be under purchasing or receiving (self service receipt).

        Thanks

        Aditya Singh

    • Minna Muikku

      Hi,

      Yes I understand that, and I think that is why it is empty (in my case). Not sure what the original poster is expecting this "receipt" attribute to show but if he/she is trying to get the gr number like I was, then that is a wrong attribute. There is no goods receipt number available in Procure to Pay subject area, which is kind of disappointing since gr is a key element in procure to pay process.

    • Larry Gabucan

      Same issue here but if you try to expand the column from the Invoice folder area it isn't blank.

      But if you add this field into the report it's blank.

      • Craig Dacres

        Please advise on how to expand the column to see the receipt number becausing I am having the same issue.

         

        Which subject area receipt falls under?

    • Manavalan Ethirajan

      The current design is that ‘Receipt is tied to invoice in P2P subject area'. If invoice has the corresponding receipt, then it will show in the report along with the invoice attribute/metrics. However, if the receipt is only tied to PO and no invoice has been created, the receipt will not show. In P2P Subject Area, we support two functional areas, PO and Invoice. We do have requisition attributes as well receipt attributes. The other 2 areas (Requisition and Receipt) are treated like attributes tied to the 2 main areas, those (requisition and receipt) are not standalone functional areas.