acq:reports
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
acq:reports [2022/08/10 16:22] – tlittle | acq:reports [2022/08/10 16:24] – tlittle | ||
---|---|---|---|
Line 4: | Line 4: | ||
===== Report Sources ===== | ===== 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 ===== | ===== Sample Templates ===== | ||
Line 91: | Line 101: | ||
- | ===== Funds / Fund Debits | + | ==== Funds / Fund Debits ==== |
**Fund Debit SQL query**\\ | **Fund Debit SQL query**\\ | ||
//Created by PINES// | //Created by PINES// | ||
Line 141: | Line 151: | ||
- | ===== Purchase Orders | + | ==== Purchase Orders ==== |
- | ===== Claiming | + | ==== Claiming ===== |
===Claim ready items=== | ===Claim ready items=== | ||
Line 157: | Line 167: | ||
- | ===== EDI ===== | + | ==== EDI ==== |
**EDI-enabled POs ordered yesterday**\\ | **EDI-enabled POs ordered yesterday**\\ | ||
//Submitted by PINES// | //Submitted by PINES// | ||
Line 189: | Line 199: | ||
If you would like to try to use the spreadsheet, | If you would like to try to use the spreadsheet, | ||
- | ===== Invoices | + | ==== Invoices ==== |
**List Invoices by Date Range** | **List Invoices by Date Range** |
acq/reports.txt · Last modified: 2022/11/15 10:37 by tlittle