Reports

Print Customer Document Listing

The Print Customer Document Listing allows you to view all customer transactions, including Invoices, Payments, Credit Notes, Debit Notes, Refunds, and Contras. It is also used for batch printing or emailing documents.

1. Go to Customer → Print Customer Document Listing.

   

2. Select the Document Type you wish to view (e.g., Invoice, Payment).

   

3. Click Apply.

   

4. Click Preview to view the listing report.

   

Example of Customer Invoice Listing Report:

Print Document Style

• Check the Print Document Style box.

  

Field Name	Description
Print Document Style	Enables bulk printing or batch emailing of the actual documents (not just the list).
Include Cancelled Documents	Includes documents marked as cancelled in the listing.

1. Once enabled, you can select the specific Report Format for the documents.

   

Group/Sort by

You can refine your report by filtering and grouping data.

• Filters: Filter by Customer, Agent, Area, Currency, Project, or Company Category.

• Group/Sort By: Choose how to organize the data (e.g., by Customer Code).

• Listing Report: Select the desired listing format before previewing.

Print Customer Balance Report

This report provides a summary of outstanding balances for all customers as of a specific date.

1. Go to Customer → Print Customer Balance Report.

   

2. Select the Date or period for the report.

   

3. Apply filters such as Customer, Agent, or Area if needed.

   

4. Click the [+] icon to expand a row and view transaction details for a specific customer.

   

5. Click Preview to generate the report.

   

Print Customer Due Document Listing

The Customer Due Document Listing is primarily used to identify overdue amounts and generate Reminder Letters.

1. Go to Customer → Print Customer Due Document Listing.

2. Filter by Date and Document Type (Invoice, Debit Note, etc.).

3. Select whether to show Overdue or Undue documents.

4. Click Apply.

   

Generating Reminder Letters

1. In the Group / Sort by section, ensure Customer Code is checked.

2. Click Apply.

   

3. Click Preview and select the Cust Overdue Letter format.

   

Customer Analysis By Document

This report provides a high-level analysis of all customer-related documents, showing totals for Invoices, Credit Notes, Payments, and more.

1. Go to Customer → Print Customer Analysis By Document.

2. Filter by Document Date and other optional fields.

3. Click Apply.