IdealWare Online Users Manual

SP5-10 S/P LISTINGS, REPORTS AND FORMS
31621 Quotation Report/Purge

 

PURPOSE

 

The order/quotation report/purge program prints outstanding and expired quotations. The program also has the option to purge expired quotations. The program is used for both order and quotation reports.

 

Order/Quotation Report is accessed from:

 

PROCEDURE

 

Select Order/Quotation Report from the Sales Processing menu. The following prompts display.

 

** ENTER STORE CODE:

 

Enter store code.

 

In a single store environment this field defaults to the usual store.

 

 

[F5] to display list for selection.

 

** CURRENT, HISTORY OR BOTH? (C/H/B):

 

"C" for current orders/quotations.

 

"H" for history (updated) order/quotations.

 

"B" for both types of orders/quotations.

 

** QUOTES OR ORDERS? (Q/O):

 

"Q" for quotations.

 

"O" for orders.

 

** SHOW ORDER STATUS? (Y/N):

 

"Y" to show status of orders/quotations.

 

"N" to not show status of orders/quotations.

 

** SEQUENCE (1=CUSTOMER/EXPIRY, 2=CUSTOMER/QUOTE, 3=QUOTE):

 

"1" to sequence by customer and expiry date.

 

"2" to sequence by customer and order/quotation number.

 

"3" to sequence by order/quotation number.


** STARTING ORDER/QUOTE# (CR FOR FIRST):

 

Enter starting quotation/order.

 

[Enter] for first quotation/order in system.

 

** ENDING ORDER/QUOTE# (CR FOR LAST):

 

Enter ending quotation/order.

 

[Enter] for last quotation/order in system.

 

** PRINT FOR WHICH SALESMAN? (CR=ALL):

 

Enter salesman/operator code.

 

[Enter] for all salesmen.

 

[F5] to display salesman/operator codes list for selection.

 

If you selected ORDERS above the following prompt appears:

 

ORDER REPORT OPTIONS:
( 1)  SELECT ORDERS BASED ON PICKING LIST DATE
( 2)  SELECT ORDERS WITH LINES WHICH HAVE BEEN PRINTED MORE THAN ONCE
( 3)  SELECT ORDERS WHICH HAVE FINANCE PAYMENTS
( 4)  SELECT ORDERS WITH TRANSFER REQUEST LINES
( 5)  SELECT ORDERS SHIPPED FROM OTHER LOCATIONS
( 6)  SELECT ORDERS WITH LINES PRINTED ON OR BEFORE A GIVEN DATE
( 7)  SELECT ORDERS WITH ZERO DOLLAR LINES
( 8)  SELECT ORDERS FOR SALES PERIOD (YYYYMM)
( 9)  SELECT ORDERS LINKED TO P/Os BEFORE A GIVEN DATE
** ENTER ORDER REPORT OPTION (ENTER=NONE):

 

Enter desired option.

 

[Enter] for all orders.

 

** CONFIRMATION STATUS (Y/N/CR=BOTH):

 

Applicable to quotation report only.

 

"Y" to include confirmed quotations only.

 

"N" to include unconfirmed quotations only.

 

"B" to include both types.

 

** PRINT QUOTES EXPIRING BEFORE WHAT DATE? (F2=ALL):

 

Applicable to quotation report only.

 

Enter date in format MMDDYYYY.

 

[F2] for all dates.

 

** PURGE 'CURRENT' EXPIRED QUOTES OR MOVE TO HISTORY? (P/M/CR=NEITHER):

 

Applicable to quotation report only.

 

[Enter] to not purge or move.


"P" to purge current expired date quotations.

 

"M" to move current expired date quotations to history.

 

** REMOVE CONTRACT PRICING FOR ABOVE 'TO PURGE/MOVE' EXPIRED QUOTES? (Y/N):

 

Applicable to quotation report only.

 

"Y" to remove contract pricing for purged/moved expired quotes.

 

"N" to not remove contract pricing for purged/moved expired quotes.

 

** PURGE 'HISTORY' QUOTES EXPIRED OVER 12 MONTHS AGO? (Y/N):

 

Applicable to quotation report only.

 

"Y" to purge history quotes expired more than 12 months.

 

"N" to not purge history quotes expired more than 12 months.

 

** REMOVE CONTRACT PRICING FOR ABOVE 'TO PURGE' HISTORY QUOTES? (Y/N):

 

Applicable to quotation report only.

 

"Y" to remove contract pricing for purged history quotes.

 

"N" to not remove contract pricing for purged history quotes.

 

Example Order/Quotation Report Completed Parameters display:

┌────────────────────────────────────────────────────────────────────────────────┐
│ 04/17/08               ***** ORDER/QUOTATION REPORT *****                      â”‚
│                             COMPANY: 01 - IDEALWARE                            â”‚
│                                                                                â”‚
│                                                                                â”‚
│ ** ENTER STORE CODE: 01 - IDEALWARE                                            â”‚
│ ** CURRENT, HISTORY OR BOTH? (C/H/B): BOTH                                     â”‚
│ ** QUOTES OR ORDERS? (Q/O): Q                                                  â”‚
│ ** SHOW ORDER STATUS? (Y/N): Y                                                 â”‚
│ ** SEQUENCE (1=CUSTOMER/ExPIRY, 2=CUSTOMER/QUOTE, 3=QUOTE): QUOTE              â”‚
│ ** STARTING QUOTE# (CR FOR FIRST): 01E000000                                   â”‚
│ ** ENDING QUOTE# (CR FOR LAST): 01E999999                                      â”‚
│ ** PRINT FOR WHICH SALESMAN? (CR=ALL): ALL                                     â”‚
│ ** CONFIRMATION STATUS (Y/N/CR=BOTH): BOTH                                     â”‚
│ ** PRINT QUOTES ExPIRING BEFORE WHAT DATE? (F2=ALL): 99/99/99                  â”‚
│ ** PURGE 'CURRENT' ExPIRED QUOTES OR MOVE TO HISTORY? (P/M/CR=NEITHER): NEITHER│
│ ** REMOVE CONTRACT PRICING FOR ABOVE 'TO PURGE/MOVE' ExPIRED QUOTES? (Y/N): NO â”‚
│ ** PURGE 'HISTORY' QUOTES ExPIRED OVER 12 MONTHS AGO? (Y/N): NO                â”‚
│ ** REMOVE CONTRACT PRICING FOR ABOVE 'TO PURGE' HISTORY QUOTES? (Y/N): NO      â”‚
│ ** PRESS CR TO CONTINUE:  _                                                    â”‚
│                                                                                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO CONTINUE:

 

[Enter] to continue to printer selection menu.

 

[F3] to change previous selections.

 

[F4] to cancel and exit to menu.


PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

An example Quotation Report printout follows.

 



                                                            IDEALWARE
 04/17/08  15:32:22                                                                                                      PAGE: 1
                                                   QUOTE REPORT BY QUOTE NUMBER
                                SALESMAN: ALL, CONFIRMED STATUS: BOTH, BEFORE EXPIRY DATE: 99/99/9999
                       EXPIRED QUOTES TO PURGE: 0, EXPIRED QUOTES TO HISTORY: 0, HISTORY QUOTES TO PURGE: 0
-----------------------------------------------------------------------------------------------------------------------------------
           QUOTE           QUOTED  CONFIRM   EXPIRY  CONTRACT
CUSTOMER   NUMBER   SMAN    DATE     DATE     DATE   PRICES?  STATUS  TELEPHONE#                      CONTACT                 TOTAL
-----------------------------------------------------------------------------------------------------------------------------------
ACTDEV   01A001234  BARJO 01/26/07 01/26/07 01/26/07                  545-4444                                               346.79
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
UNKNOWN  01A001235  BARJO 09/08/07 09/08/07 00/00/00   D                                                                   1,123.76
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
AAAWOO   01A100169  SALES 09/26/96 09/26/96 09/26/96                      438-9696                                         3,921.55
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
AAAWOO   01A100171  GEN   09/26/96 09/26/96 09/26/96                      438-9696                                            38.52
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
ACTDEV   01A100188  BARJO 10/25/96 10/25/96 10/25/96                      736-6909                                         1,235.67
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
ACTDEV   01A100495  BARJO 12/22/96 12/22/96 12/22/96                  545-4444                                                32.59
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
$STEEJEN 01A100517  BARJO 07/20/07 07/20/07 07/20/07                                                                         357.74 
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
$STEEJEN 01A100518  BARJO 07/20/07 07/20/07 07/20/07                                                                         651.86
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
ABACON   01A100521  BARJO 07/26/07 07/26/07 07/26/07                                                                         651.86
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
BAZGOR   01A100522  BARJO 07/26/07 07/26/07 07/26/07                                                                         825.02
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
ABACON   01A100523  BARJO 07/26/07 07/26/07 07/26/07                                                                         224.22
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------
BAZGOR   01A100524  BARJO 07/26/07 07/26/07 07/26/07                                                                       2,188.81
         STATUS -->       QUOTE IS COMPLETE AND SELECTABLE
-----------------------------------------------------------------------------------------------------------------------------------




FIELDS                                    

CUSTOMER       Customer code.
QUOTE NUMBER   Quotation number.
SMAN           Salesman code.
QUOTED DATE    Date of quotation.
CONFIRM DATE   Date confirmed.
EXPIRY DATE    Date quotation expires.
CONTRACT PRICES?    Contract prices generated from this quote? Y yes N no.
STATUS         Current status.
TELEPHONE#     Contact person telephone.
CONTACT        Name of contact person.
TOTAL          Total amount of quote.