Description
The Purchases By Date Report allows you to look at all transactions that go against the Purchase Journal for a particular Date Range.
Data: Purchase Journal
Note: This report is run for a date range. You may not see the same figures if you are trying to compare this to an Income Statement or a Balance Sheet that uses a GL Period as a Date Filter.
Prompt
Date Ranges
| • | Start & End Date - Filters the data by the Date Type supplied in the next selection. |
| • | Date Type (Required) - Options are: |
| o | Check Date - The Check date of the journal entry. |
| o | Create Date - Create Date of the transaction |
| o | Modify Date - Modify Date of the transaction |
General
| • | Vendor - Allows you to filter the report to a single vendor. If left blank, all vendors will be returned. |
| • | A/P Base Code - Filters transactions to a specific Accounts Payable G/L Base Code. |
| • | Use Org. Filter - When selected, the A/P Org. Unit selected is used to filter the report. |
| • | A/P Org Unit - Filters to a specific the Organizational Unit related to the G/L Base Code of the Transaction. |
| • | Include Org. Children - Includes the Organization Units Children when filtering to a specific the Organizational Unit. |
| • | Show Comments - When checked, the report will show the G/L Comments from the line-items of the Journals. |
| • | Hide Detail - When selected, the detail of the Purchase Journal is hidden. |
| • | Currency Type - The Type of Currency to be used when running the report. Options are Base, Company, Project and Transaction. |
| • | Currency Code - The Currency Code to be used when running the report. Options are set in the Multi-Currency applet. More on Multi-Currency |
Sorts
The Sorts section Groups & Sorts the report by Invoice Date, Invoice No (Number), Create Date, Modify Date, Vendor and A/P Account.
| • | Sort 2 - Second Level Sort. |
| • | Sort 3 - Third Level Sort |
Report
Report Columns
| • | A/P Account - Accounts Payable G/L Account associated with the transaction. |
| • | Firm Name - Name of the Vendor associated with the transaction. |
| • | Invoice Number - Invoice number associated with the transaction. |
| • | Due Date - Due Date assigned to the Purchase Journal entry. |
| • | Invoice Date - The Invoice Date Associated with the transaction. |
| • | Amount - Amount of the Purchase Journal Transaction. |
| • | Account - G/L Account associated with the detail of the Purchase Journal Transaction. |
| • | Project - The Project associated with the detail of the Purchase Journal Transaction. |
| • | Expense Code - The Expense Code associated with the detail of the Purchase Journal Transaction. |
| • | Amount - The amount of the line item in the detail of the Purchase Journal Transaction. |
Sample(s)
|