Invoice Journal
This report is a chronological listing of the Invoices raised during the specified period. You can control the selection to show a range of Invoice Numbers or Invoices made out to a particular Customer. The type of Invoice can also be selected.
- Invoice No
- Range Reporting
Numeric
- Limit the report to a single or range of Invoices.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the report period. The first row of the Reporting Periods setting is used as a default.
- Customer
- Paste Special
Customer register
- If necessary, limit the report to a single Customer by entering a Customer Number here.
- Category
- Paste Special
Customer Categories setting, Sales Ledger
- If you want to restrict the report to Customers of a particular Category, specify that Category here.
- Classification
- Paste Special
Customer Classifications setting, CRM module (if installed)
- Enter a Classification Code in this field if you want to list Invoices from Customers with a certain Classification. If you enter a number of Classifications separated by commas, only Invoices from those Customers featuring all the Classifications listed will be shown.
- Salesman
- Paste Special
Person register, System module
- Specify a salesman.
- Object
- Paste Special
Object register, System module
- Specify an Object to to restrict the report to Invoices featuring that Object. This refers to Objects entered at Invoice level, not those entered for Invoice rows. If you enter a number of Objects separated by commas, only those Invoices featuring all the Objects listed will be shown in the report.
- Object Type
- Paste Special
Object Types setting, Nominal Ledger
- To limit the report to Invoices containing Objects of a single Object Type, enter that Object Type here.
- Project
- Paste Special
Project register, Job Costing module (if installed)
- Selects only Invoices for a certain Project. Such Invoices must be raised from the Job Costing module, using the 'Create Project Invoices' Maintenance function.
- Location
- Paste Special
Locations setting Stock module
- This option restricts the report to those Invoices that took their stock from a particular Location (shown on the 'Identifiers' card of each Invoice).
- Payment Term
- Paste Special
Payment Terms setting, Sales/Purchase Ledger
- This option restricts the report to Invoices with a particular Payment Term.
- Function
- Specify here the level of detail required in the report.
- Overview
- This choice gives a report with one row per Invoice, showing the Date, Customer, Type, Total and Currency.
- Detailed
- In addition to the information shown above, this option shows the Invoice Address, Due Date, Order Number and Contact. For each row of each Invoice, the Item Code, Name, VAT Code and Sum are shown. You can use this report as an archive file instead of a copy of each Invoice.
- Overv. With Cur.
- This option is as the Overview, but also shows exchange rates.
- Status
- Specify here whether approved, unapproved and Disputed Invoices are to be included in the report.
- Sorting
- The report can be sorted by Invoice Date or Number, or by Location.
- Invoice Type
- Check the boxes to include Invoices of different types in the report.
- Show comment
- This option is only used when the Detailed report is printed. If chosen, the Comment from the 'Identifiers' card of each Invoice will also be included in the report.
- Show Base Currency 1 & 2 Totals
- By default, the report contains totals (including and excluding VAT) for each Currency that has been used in Invoices in the report. If you would like to print overall totals converted to Base Currencies 1 and 2 as well, check this box.
|
Introduction to Reports in the Sales Ledger
