Solution Properties
Solution ID:
240304191731950
Last Modified Date:
Tue Apr 28 21:55:26 UTC 2026
Taxonomy Path:
Category//Reporting
Author:
sageadmin
How to create the Sales Day Book report
Description

Use the Sales Day Book report to view different sales transactions for each customer in one report. The report shows an overview of each transaction, including transaction type and amounts. View this for a specific date range for all transactions or different transaction types.

Cause
Resolution

To run the report

  1. Go to Reports, then select Sales Day Book.
  2. Enter the customer’s name in the search box.
    You can also search by invoice number, credit number, reference, or value. Enter a negative amount for credit notes. 
  3. From the Period drop-down menu, select a predefined period or choose Custom to enter From and To dates. 
  4. (Optional) Select More, then choose a transaction type in the Type field. 
  5. Select a transaction to view its details.
    Select Detailed to view all transactions, or Summary to return to the summary view. Use Back to return to the report. 
  6. Select Calculate. 
  7. Select Export, then choose CSV or PDF to save or print the report.

Download the report

The report automatically downloads. When it's ready, a message appears on your menu bar. The download time depends on the amount of data. Continue working while the report downloads.

Access the downloaded report

After the report downloads, select it from the menu bar. Depending on your export choice:

  1. CSV: The file automatically downloads to your Downloads folder or prompts you to save the file. Browse to where you want to save the file and click Save.
  2. PDF: The PDF opens in a new window or tab. Open your web browser's File menu, then choose to print or save the report.
Steps to duplicate
Related Solutions