User Tools

Site Tools


acq:reports

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
acq:reports [2022/11/15 10:35] – [Direct Charges] tlittleacq:reports [2022/11/15 10:37] (current) tlittle
Line 51: Line 51:
  
 ==== Direct Charges ==== ==== 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=== ===Sum of direct charges invoiced by a provider===
 //Created by PINES// //Created by PINES//
 +
 Uses nullability. 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. //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.
  
acq/reports.txt · Last modified: 2022/11/15 10:37 by tlittle

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.