Differences

This shows you the differences between two versions of the page.

--- acq:reports [2022/08/10 16:22] – tlittle
+++ acq:reports [2022/11/15 10:37] (current) – tlittle
@@ Line 4: / Line 4: @@
 ===== Report Sources =====
+Beyond the list of Core Sources, the list of reports sources is very long. These are some suggested report sources to start with for Acquisitions reports.
+  * Debit from Fund
+  * EDI Account
+  * Fund
+  * Funding Source
+  * Invoice
+  * Invoice Entry
+  * Line Item
+  * Line Item Detail
+  * Purchase Order
 ===== Sample Templates =====
@@ Line 39: / Line 49: @@
 **Display:**
 {{:acq:truecancels_displays.jpg?400|}}
+==== Direct Charges ====
+Direct charges on purchase orders are called PO Items in the reporter/database. Direct charges on invoices are called Invoice Items in the reporter/database. There currently are not reporter sources for each of these, so to find PO Items, start from the Purchase Order source. To find Invoice Items, start from the Invoice source.
+===Sum of direct charges invoiced by a provider===
+//Created by PINES//
+Uses nullability.
+//Note from creator:// I've used nullability on this report, but I can't remember if it was truly necessary or not. You might try creating this without using nullability and see if you get the same results. It's only using "inner" joins, which are the "None nullable" option when using nullability in the reporter.
+(Click on the images to see larger versions)
+Filters
+{{:acq:dc_rpt_filterfields.png?400|}}
+Display Fields
+{{:acq:dc_rpt_displayfields.png?400|}}
 ==== Line Items ====