Language:


Debtors Account

This page describes the Debtors Account report in the Nominal Ledger.

---

The Debtors Account report satisfies a specific requirement of users in Russia. It is a list of Customers, summarising the debit and credit postings made to a specified Debtor Account that are associated with each Customer.

The report is compiled from Transaction rows that post to the specified Account. It uses the Customer information on flip E of each Transaction row to connect that row to a Customer. If the Customer information is missing from a particular Transaction row that posts to the specified Debtor Account, that Transaction row cannot be connected to a Customer and therefore it will not be included in the report. When a Nominal Ledger Transaction is created from an Invoice or Receipt, Customer information will only be copied to flip E of that Transaction if the Cust. Info on Trans. option on the 'Identifiers' card of the Invoice or in the Receipt is selected. This option will be selected by default if you are using the Invoice Info on N/L Transaction option in the Account Usage S/L setting, so it is therefore recommended that you select this option if you want to use this report.

Period
Paste Special    Reporting Periods setting, System module
The report will include all postings to the Debtor Account specified below made during the period that you specify here.

Accounts
Paste Special    Account register, Nominal Ledger/System module
Specify the Debtor Account whose postings are to be included in the report. You must specify an Account, otherwise the report will be empty.

Customers
Paste Special    Customers in Contact register
Range Reporting    Alpha
Enter a Customer Number (or range of Customer Numbers separated by a colon) here if you need to report on a particular Customer (or range of Customers).

Cust. Category
Paste Special    Customer Categories setting, Sales Ledger
Enter a Customer Category here if you need the report to list postings to the Debtor Account related to Customers belonging to a particular Customer Category.

Customer Class.
Paste Special    Contact Classifications setting, CRM module
Enter a Classification Code in this field if you want to list Customers with a certain Classification in the report. If you leave the field blank, all Customers, with and without Classification, will be included. If you enter a number of Classifications separated by commas, only those Customers featuring all the Classifications listed will be included. If you enter a number of Classifications separated by plus signs (+), all Customers featuring at least one of the Classifications listed will be included. If you enter a Classification preceded by an exclamation mark (!), all Customers featuring any Classification except the one listed will be included.

For example:

1,2
Lists Customers with Classifications 1 and 2 (including Customers with Classifications 1, 2 and 3).

1+2
Lists Customers with Classifications 1 or 2.

!2
Lists all Customers except those with Classification 2.

1,!2
Lists Customers with Classification 1 but excludes those with Classification 2 (i.e. Customers with Classifications 1 and 2 are not shown). Note the comma before the exclamation mark in this example.

!1,!2
Lists all Customers except those with Classification 1 or 2 or both. Again, note the comma.

!(1,2)
Lists all Customers except those with Classifications 1 and 2 (Customers with Classifications 1, 2 and 3 will not be listed).

!1+2
Lists Customers without Classification 1 and those with Classification 2 (Customers with Classifications 1 and 2 will be listed).

(1,2)+(3,4)
Lists Customers with Classifications 1 and 2, and those with Classifications 3 and 4.

1*
Lists Customers with Classifications beginning with 1 (e.g. 1, 10, 100).

1*,!1
Lists Customers with Classifications beginning with 1 but not 1 itself.

*1
Lists Customers with Classifications ending with 1 (e.g. 1, 01, 001).

1*,*1
Lists Customers with Classifications beginning and ending with 1.

Customers with Balance only
By default, the report will list every Customer in the Contact register. Select this option if you want the report only to list those Customers that have been quoted in at least one posting to the Debtor Account (i.e. Customers with at least one Invoice or Receipt posting to that Account).

Function
Use these options to control the level of detail shown in the report.
Overview
The Overview is a simple list with one line per Customer, showing the following debit and credit balances for the specified Debtor Account: opening balances; period balances; and closing balances.

Detailed
As well as the information contained in the Overview, the Detailed option lists the individual postings to the Debtor Account, showing the Invoice Number in each case.

---

Reports in the Nominal Ledger:

---

Go back to: