Sales By Date

Top  Previous  Next

Description


The Sales By Date Report allows you to look at all transactions that go against the Sales Journal for a particular Date Range.

 

Data: Sales 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:
oInvoice Date - The Invoice date of the journal entry.
oCreate Date - Create Date of the transaction
oModify Date - Modify Date of the transaction

General

A/R Base Code - Filters transactions to a specific Accounts Receivable G/L Base Code.
Use Org. Filter - When selected, the A/R Org. Unit selected is used to filter the report.
A/R 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 Sales 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, Client and A/R Account.

Sort 1 - Top Level Sort
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)