Uploaded image for project: 'Reporting'
  1. Reporting
  2. REP-82

Invoice report (with order data)

    XMLWordPrintable

Details

    • ID268
    • Resource Management
    • As needed
    • Hide
      Output: Invoice ID, Vendor, Fiscal Cycle, Date Created, Date Modified, Date Paid, Invoice Type, Total Amount Paid, Invoice Line Numbers, Invoice Line Amount(s) Paid, Fund Code, Fund Code Enterprise System Account Number, Invoice Amount, Paid Amount, Invoice Note, Date Received, Order ID (Order Data), Fiscal Cycle (Order), Order Type (Order), Order Line (Order), Vendor (Order), Date Created (Order), Date Modified (Order), Date Paid (Order), Encumbered Amount (Order), Paid Amount (Order), Total Copies (Order), Copies Received (Order), Copies Cancelled (Order), Copies Paid (Order), Order Note(Order).
      Show
      Output: Invoice ID, Vendor, Fiscal Cycle, Date Created, Date Modified, Date Paid, Invoice Type, Total Amount Paid, Invoice Line Numbers, Invoice Line Amount(s) Paid, Fund Code, Fund Code Enterprise System Account Number, Invoice Amount, Paid Amount, Invoice Note, Date Received, Order ID (Order Data), Fiscal Cycle (Order), Order Type (Order), Order Line (Order), Vendor (Order), Date Created (Order), Date Modified (Order), Date Paid (Order), Encumbered Amount (Order), Paid Amount (Order), Total Copies (Order), Copies Received (Order), Copies Cancelled (Order), Copies Paid (Order), Order Note(Order).
    • No
    • Selection criteria: Fiscal cycle
    • R1
    • R4
    • R4
    • R4

    Description

      At Cornell, this report is good for selectors and accounting. This purpose of this report is to provide a summary of what was spent by purchase order line on an invoice line across all the invoices within a particular time period. Invoice line adjustments are included in the invoice line total. The "invoice_line_total_sum" column shows the sum of invoice line totals associated with each purchase order line number. This query only shows invoice line data that is linked to a purchase order. The output is aggregated by purchase order line id, purchase order line number, and invoice status.

      A good example of invoices with orders is available at https://github.com/folio-org/folio-analytics/tree/main/sql/report_queries/invoices

      TestRail: Results

        Attachments

          Issue Links

            relates to

            New Feature - New feature requests UXPROD-2301 RM-Invoice Cluster

            • TBD - To be determined
            • Draft

            Activity

              People

                Unassigned Unassigned
                hollyolepm Holly Mistlebauer
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases