INVOICE: Printing a Customer Invoice

INVOICE prints a customer invoice on pre-printed stationery. In this report, the standard Report Writer page headings are switched off, and the predefined variable TODAY is used to print today's date.

Table Details and Type

The report is sequenced by customer.

Report Heading

"CUSTOMER INVOICE Acme Product Sales Plc".

Field Processing

The main features of the field processing are:

• Field 1, CUSTOMER.NAME, presents customer records one per page (New page on change ? 'Yes' and Break on change 'Yes')

• Fields 1 and 2 print the customer name and address at the top of the invoice, for example:

  
  Barnes J
  Townsend House
  Little Downham
  Pymore

• Field 3, STATEMENT_DATE, prints today's date. It is a calculated field with the formula: TODAY, where TODAY is a predefined variable

• Fields 4, 5, 6, 7 and 8 print the order details

• As well as printing a column of order line values, Field 8 prints a total beneath the column. This is due to Total field ? 'Yes' and List on break lines ? 'Yes'

Nr Name             Type Occurs Sort Tot List L/Brk P/Brk Rpt Page Break Fold
1  NAME              C30                  Yes   No    No  No   Yes   Yes  Yes
   in CUSTOMER
2  ADDRESS           C30   1-3            Yes   No    No  No   No    No   Yes
   in CUSTOMER
3  STATEMENT_DATE    D10                  Yes   No    No  No   No    No   Yes
4  ORDER_NUMBER      L5              No   Yes   No    Yes No   No    No   No
5  LINE              I3              No   Yes   No    No  Yes  No    No   No
6  DESCRIPTION       C20                  Yes   No    Yes Yes  No    No   No
7  QUANTITY          I5              No   Yes   No    Yes Yes  No    No   No
   in ORDER_LINE
8  LINE_VALUE        N8.2            Yes  Yes   Yes   Yes Yes  No    No   No

Record Selection Condition

All records from the CUSTOMER table are selected.

Output Options

Pause after each page ? 'Yes' allows you to view the report page by page. Suppress 1 item totals ? 'Yes' stops a LINE_VALUE total being printed when the invoice only contains one line.

Screen ?      Yes                Blank character
Printer ?     No                 Remove trailing blanks ?
File ?        Yes
Print device  DEFAULT_PRINTER    Ask for start/stop values ? No
File Name     INV                Pause after each page ?     Yes
Repeat fold headers ?     No     Subtotal only program ?     No
Print date/time/pagenr ?  No     Suppress 1 item totals ?    Yes
Spacing after last fold   1      Suppress grand totals ?     Yes
Spacing at end of page    6

Printing the Report

REPPRINT -DB SALESORD -PROG INVOICE