Customer Master – Transactions Tab

The Transactions tab provides a detailed breakdown of a customer's account activity, showing both summary and line-level details for each transaction. It is used to review sales, payments, discounts, and balance movements over a selected period.

This view is essential for account management, reconciliation, and customer inquiries.

Date Range Filter

At the top of the tab, you can select a date range to filter which transactions are displayed:

Use the calendar icons to choose a start and end date.

Click Refresh to reload data for the selected range.


Transaction Grid Overview

Column

Description

Date/Time

Date and time of the transaction

Docket #

Unique reference number for the transaction

SSP/ISC

Stock or service code

Type

Transaction type (e.g., Sale, Pay)

Qty

Quantity of items sold or paid

Value

Total value of the transaction or item

Discount

Discount applied (if any)

Bal Effect

The effect on the customer’s account balance (e.g., increases with sales, decreases with payments)

Sales transactions can be expanded to reveal individual line items, showing the breakdown by stock code, name, quantity, and value.

Transaction Types

Sale – Goods sold to the customer. These increase the balance.

Pay – Payment received from the customer. These reduce the balance.

Account – Special journal entries or adjustments (e.g., opening balance).

Features

Expand/Collapse All – View all item lines or collapse to summary view.

Live Balance – Total balance shown at the top right, updated in real time.

Print – Use F11 to print a statement or transaction summary.

Edit/Delete – Use F2/F3 if access rights allow adjustments (audit-logged).

Use Cases

Verify customer balance and match against payments.

Respond to customer queries about invoices or credits.

Print or email statements for account customers.

Assist in reconciliation when end-of-month or end-of-year reviews are conducted.