Report: Sales Journal

The Sales Journal is a general ledger view of posted sales (billing) transactions. The journal may be printed for a transaction date range and/or journal reference number range. The Sales Journal prints in journal reference number order.

Report Selections

What is this?

Transaction Date Range

Options	What is this?
Current Date	Click this option if you want to report transactions for the current system date only.
Select Date Range	Click this option if you want to report transactions for a specific date range. Fill in the From and To dates.

Reference Number Range

Options	What is this?
All Reference Numbers	Click this option if you want the report to include all reference numbers for the Transaction Date Range selected.
Select Reference Number Range	Click this option if you want the report to include only a specific reference number range for the Transaction Date Range selected. Fill in the From and To reference numbers.

Business Unit

Click the link to open the Business Unit Selections form and make your selections.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

Report Fields

Report Fields	Description
Ref #	Reference number.
GL Date	General ledger date.
Approved	Approved date. The date is followed by the short name for the employee who posted the invoice.
Tran	Billing Transaction Codes.
GL #	General ledger account number.
Dept	Department short name.
Subledger	Subledger entity, if any.
Description	Transaction description.
Debit	Debit amount.
Credit	Credit amount.
Reason for Void	If this is a voided transaction, reports the reason for the void.

CSV Columns

CSV Columns	Description
RefNo	Reference number.
GLDate	General ledger date.
ApprovedDate	Approved date.
ApprovedBy	Employee short name who posted the invoice.
Tran	Billing Transaction Code.
GL#	General ledger number.
Subledger	Short name of the subledger entity, if any.
Description	Transaction description.
Division	Division name.
Department	Department short name.
Debit	Debit amount.
Credit	Credit amount.
Invoice	Invoice number.
Polno	Policy number.
FirmNameCust	Customer firm name, if any.
CustLastName	Customer last name.
CustFirstName	Customer first name.
VoidReason	If this is a void transaction, then the void reason appears. Otherwise this field is blank.
Branch	Branch short name.
Group	Group short name.