Differences

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

--- acq:reports [2022/11/15 10:34] – tlittle
+++ acq:reports [2022/11/15 10:37] (current) – tlittle
@@ Line 51: / Line 51: @@
 ==== 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.
+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|}}