Skip to main content
Question

Report Data Source - Received, Not Yet Invoiced

  • January 13, 2026
  • 4 replies
  • 50 views
D
Sidekick (Customer)
Forum|alt.badge.img+6

Hello Community,

 

Is there any way to see where data is pulled from when populating an operational report’s data source? Specifically we are interested in the Received - Not Yet Invoiced out-of-the-box operational report. We are having issues tying out values on this report to the GL, so It would really help to understand which transactional data ((ideally) posting control/voucher number/voucher type) qualifies an transaction to be added to the report.

I tried digging through the report views and ended up at the report data source table, but it’s just a database table with no information on where the data is actually coming from. Any help is greatly appreciated!

 

Thank you,

Dylan

    4 replies

    N
    Sidekick (Employee)
    Forum|alt.badge.img+5
    • Narmada G
    • Sidekick (Employee)
    • January 19, 2026

    Hi ​@dritter,

    Please try extracting GL transactions using transaction codes M10, M18, and M14. The resulting balance should align with the ‘Received Not Yet Invoiced’ report. Also, please ensure that ‘Inventory Part’ is selected under the Part Type parameter when you run the report.

    D
    Sidekick (Customer)
    Forum|alt.badge.img+6
    • dritter
    • Author
    • Sidekick (Customer)
    • January 21, 2026

    Hi ​@Narmada G,

     

    Thank you for your response! I reviewed the GL under these transaction codes and compared to the RYNI report for inventory parts, but I have a difference of a few percent. I did this in our STG environment which does not have any transactions being posted during the day, so it shouldn’t be a difference between transferring transactions and then updating GL vouchers. Any idea where this difference might come from?

     

    Thank you,

    Dylan

    T
    Superhero (Partner)
    Forum|alt.badge.img+14
    • Tracy Norwillo
    • Superhero (Partner)
    • January 21, 2026

    Dylan - In IFS Cloud, there are two ways to see the Report Definitions for Operational Reports. 

    Out of the box reports are in your Core Repository.  The RNYI report is in the following path purch/source/purch/database/PurchaseReceipt.rdf.  You would need to work with someone who has access to your Build Place to access the file.

    For each report, there is also an Oracle package.  For the RNYI report, you’d be looking for the purchase_receipt_rpi.  Again, you’d need to work with someone who has access to your Build Place because you probably don’t have access to the Oracle objects yourself.

    All of that being said, how much success you have after finding the code depends on your level of skill in reading and following complicated code. It’s not a single simple query, you’ll have to follow many cursors and many lines to put it all together.  I’m answering so you don’t drive yourself nuts trying to find the actual code.

     

    N
    Sidekick (Employee)
    Forum|alt.badge.img+5
    • Narmada G
    • Sidekick (Employee)
    • January 22, 2026

    Hi ​@Narmada G,

     

    Thank you for your response! I reviewed the GL under these transaction codes and compared to the RYNI report for inventory parts, but I have a difference of a few percent. I did this in our STG environment which does not have any transactions being posted during the day, so it shouldn’t be a difference between transferring transactions and then updating GL vouchers. Any idea where this difference might come from?

     

    Thank you,

    Dylan

    Hi ​@dritter ,

    Hope you transferred all inventory transactions and update GL vouchers before extract the data. If there any not transferred transactions and not update GL vouchers relating to PO receipts, that may cause difference. 

    Additionally, you can extract M91 transactions to verify the report with Non-Inventory Parts.

    Terms & ConditionsCookie settingsAccessibility statement