Creditors Account
This page describes the Creditors Account report in the Nominal Ledger.
---
The Creditors Account report satisfies a specific requirement of users in Russia. It is a list of Suppliers, summarising the debit and credit postings made to a specified Creditor Account that are associated with each Supplier.
The report is compiled from Transaction rows that post to the specified Account. It uses the Supplier information on flip E of each Transaction row to connect that row to a Supplier. If the Supplier information is missing from a particular Transaction row that posts to the specified Creditor Account, that Transaction row cannot be connected to a Supplier and therefore it will not be included in the report. When a Nominal Ledger Transaction is created from a Purchase Invoice or Payment, Supplier information will only be copied to flip E of that Transaction if the Supp. Info on Trans. option on the 'Comment' card of the Purchase Invoice or in the Payment is selected. This option will be selected by default if you are using the Supp. Info on Trans. option in the Account Usage P/L setting, so it is 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 Creditor Account specified below made during the period that you specify here.
- Accounts
- Paste Special
Account register, Nominal Ledger/System module
- Range Reporting Alpha
- Specify the Creditor Account whose postings are to be included in the report. You can also enter a range of Accounts separated by a colon (:). You must specify an Account, otherwise the report will be empty.
- Suppliers
- Paste Special
Suppliers in Contact register
- Range Reporting Alpha
- Enter a Supplier Number (or range of Supplier Numbers separated by a colon) here if you need to report on a particular Supplier (or range of Suppliers).
- Supplier Category
- Paste Special
Supplier Categories setting, Purchase Ledger
- Enter a Supplier Category here if you need the report to list postings to the Creditor Account related to Suppliers belonging to a particular Supplier Category.
- Supplier Class.
- Paste Special
Contact Classifications setting, CRM module
- Enter a Classification Code in this field if you want to list Suppliers with a certain Classification in the report. If you leave the field blank, all Suppliers, with and without Classification, will be included. If you enter a number of Classifications separated by commas, only those Suppliers featuring all the Classifications listed will be included. If you enter a number of Classifications separated by plus signs (+), all Suppliers featuring at least one of the Classifications listed will be included. If you enter a Classification preceded by an exclamation mark (!), all Suppliers featuring any Classification except the one listed will be included.
- For example:
- 1,2
- Lists Suppliers with Classifications 1 and 2 (including Suppliers with Classifications 1, 2 and 3).
- 1+2
- Lists Suppliers with Classifications 1 or 2.
- !2
- Lists all Suppliers except those with Classification 2.
- 1,!2
- Lists Suppliers with Classification 1 but excludes those with Classification 2 (i.e. Suppliers with Classifications 1 and 2 are not shown). Note the comma before the exclamation mark in this example.
- !1,!2
- Lists all Suppliers except those with Classification 1 or 2 or both. Again, note the comma.
- !(1,2)
- Lists all Suppliers except those with Classifications 1 and 2 (Suppliers with Classifications 1, 2 and 3 will not be listed).
- !1+2
- Lists Suppliers without Classification 1 and those with Classification 2 (Suppliers with Classifications 1 and 2 will be listed).
- (1,2)+(3,4)
- Lists Suppliers with Classifications 1 and 2, and those with Classifications 3 and 4.
- 1*
- Lists Suppliers with Classifications beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Lists Suppliers with Classifications beginning with 1 but not 1 itself.
- *1
- Lists Suppliers with Classifications ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Lists Suppliers with Classifications beginning and ending with 1.
- Suppliers with Balance only
- By default, the report will list every Supplier in the Contact register. Select this option if you want the report only to list those Suppliers that have been quoted in at least one posting to the Creditor Account (i.e. Suppliers with at least one Purchase Invoice or Payment 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 Supplier, showing the following debit and credit balances for the specified Creditor 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 Creditor Account, showing the Purchase Invoice Number in each case.
---
Reports in the Nominal Ledger:
---
Go back to: