IdealWare Online Users Manual

SP3-06 S/P INQUIRIES
31591 Price Change Inquiry

 

PURPOSE

 

The price change inquiry is used to display all sale order entry transactions which contain instances where the price of a product has been changed or discounted. The price change purge option is used to remove information from this inquiry. See also 31675 - SALES ORDER ENTRY MISC. PRICE CHANGE PURGE.

 

Price Change Inquiry is accessed from:

  • Sale Order Processing Menu, Miscellaneous Menu - Selections.

 

PROCEDURE

 

Select Price Change Inquiry from the Order Processing Miscellaneous menu. The price change inquiry screen displays.

 

 PRICE CHANGE INQUIRY DISPLAY

┌────────────────────────────────────────────────────────────────────────────────┐
│07/17/08             ORDER PROCESSING PRICE CHANGE INQUIRY             PAGE:    â”‚
│────────────────────────────────────────────────────────────────────────────────│
│STORE CODE:    __                                                               â”‚
│SORT OPTION:                  STARTING                                          â”‚
│SELECT:                                                                         â”‚
│────────────────────────────────────────────────────────────────────────────────│
│               <--------PRICE--------->   <----ExTENSION---->  CHANGE IN        â”‚
│  QUANTITY     FROM             TO            FROM         TO  EXTENSION   DISC%│
│────────────────────────────────────────────────────────────────────────────────│
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│────────────────────────────────────────────────────────────────────────────────│
│ENTER F4 TO END, F5 FOR STORE INQUIRY.                                          â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
STORE CODE:
ENTER F4 TO END, F5 FOR STORE INQUIRY.

 

Enter store code to inquire upon.

 

[F4] to exit inquiry.

 

[F5] to display list of stores for selection.

 

SORT OPTION:   
ENTER 'S' FOR SALESMAN, 'D' FOR DATE.

 

"S" to sort by salesman code.

 

The following prompt displays:

 


STARTING SMAN:
ENTER THE STARTING POINT TO DISPLAY FROM.

 

Enter starting salesman code.

 

[F5] to display list of salesman codes for selection.

 

"D" to sort by starting date.

 

The following prompt displays:

 

 

STARTING DATE: MMDDYY
ENTER THE STARTING POINT TO DISPLAY FROM.

 

Enter starting date.

 

[Enter] to accept current system date.

 

SELECT:
ENTER '1' TO SELECT ONLY REDUCED SALES AND INCREASED REFUNDS, CR=ALL.

 

[Enter] to select all price changes for store and sort option.

 

"1" to select only price changes that reduced sale or increased refund totals.

 

Example Price Change Inquiry by Salesman display :

┌────────────────────────────────────────────────────────────────────────────────┐
│07/17/08             ORDER PROCESSING PRICE CHANGE INQUIRY             PAGE:  1 â”‚
│────────────────────────────────────────────────────────────────────────────────│
│STORE CODE:    01             IDEALWARE STORE# 1                                â”‚
│SORT OPTION:   D              STARTING DATE: 01/17/08                           â”‚
│SELECT:        ONLY REDUCED SALES & INCREASED REFUNDS                           â”‚
│────────────────────────────────────────────────────────────────────────────────│
│               <--------PRICE--------->   <----ExTENSION---->  CHANGE IN        â”‚
│  QUANTITY     FROM             TO            FROM         TO  EXTENSION   DISC%│
│────────────────────────────────────────────────────────────────────────────────│
│1 JOHN  02/04/08 01-A100052 0020 CASHSALE 806804 TRANSFER CASH PAYMT TO A/R     â”‚
│    1.00-       .00/        18.70/EA          .00      18.70-     18.70-    .00 â”‚
│2 JOHN  02/04/08 01-A100052 0030 CASHSALE 806804 TRANSFER CASH PAYMT TO A/R     â”‚
│    1.00-       .00/        18.70/EA          .00      18.70-     18.70-    .00 â”‚
│3 JOHN  02/04/08 01-A100057 0020 SMITJIM  806804 TRANSFER CASH PAYMT TO A/R     â”‚
│    1.00-       .00/       100.00/EA          .00     100.00-    100.00-    .00 â”‚
│4 JOHN  02/04/08 01-A100060 0010 DIVCON   320570 HAMMER 16 OZ CLAW              â”‚
│    1.00      50.05/EA      14.99/EA        50.05      14.99      35.06-  70.05 â”‚
│5 JOHN  02/04/08 01-A100060 0010 DIVCON   320570 HAMMER 16 OZ CLAW              â”‚
│    1.00      14.99/EA      14.85/EA        14.99      14.85        .14-    .93 â”‚
│6 JOHN  02/04/08 01-C100054 0020 CASHSALE 806804 TRANSFER CASH PAYMT TO A/R     â”‚
│    1.00-       .00/         8.61/EA          .00       8.61-      8.61-    .00 â”‚
│────────────────────────────────────────────────────────────────────────────────│
│** PRESS CR TO CONTINUE, F4 TO END: _                                           â”‚
│   ENTER LINE# TO DISPLAY RELATED INVOICE.                                      â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** CR TO CONTINUE, F4 TO END:
   ENTER LINE# TO DISPLAY RELATED INVOICE.

 

This prompt displays when there are additional pages of information.

 

[Enter] to advance to next page of information

 

[F3] to display previous page of information.

 

This option only appears after pressing [Enter] from the previous page.

 

 

[F4] to display the following processing prompt.


** CR TO CONTINUE, F4 TO END; F3 FOR PREVIOUS PAGE, 'P' FOR PRINTOUT:
   'PURGE' TO PURGE. ENTER LINE# TO DISPLAY RELATED INVOICE.

 

This prompt displays when the final page of information is displayed or [F4] has been pressed to access processing options.

 

[Enter] to return to SORT OPTIONS.

 

[F3] to display previous page of information.

 

Select this option from the first page of information to return to SORT OPTIONS.

 

 

"P" to print display.

 

You are prompted to change the starting date or salesman and specify an ending date or salesman, depending on the sort option selected, and then taken to the print selection menu. An example price change inquiry, purge audit trail printout follows.

 

** ENTER STARTING DATE: MMDDYYYY.

 

Enter start date.

 

[Enter] to accept current system date.

 

** ENTER ENDING DATE: MMDDYYYY.

 

Enter ending date.

 

[Enter] to accept current system date.

 

** ENTER STARTING SALESMAN:

 

Enter starting salesman.

 

[F5] to display list of salesman codes for selection.

 

** ENTER ENDING SALESMAN:

 

Enter ending salesman.

 

[F5] to display list of salesman codes for selection.

 

PRESS 'F4' TO ABORT PRINT

 

[F4] at any prompt to cancel print and return to STORE CODE.

 

"P""U""R""G""E" to remove displayed information from the system.

 

The following warning message displays. You are prompted to specify a starting date or salesman and an ending date or salesman, depending on the sort option selected, and then taken to the print selection menu.

 

** WARNING: THE PURGE WILL DELETE ALL SPECIFIED PRICE CHANGES **
 
** ENTER STARTING DATE: MMDDYYYY.

 

Enter start date.

 

[Enter] to accept current system date.


** ENTER ENDING DATE: MMDDYYYY.

 

Enter ending date.

 

[Enter] to accept current system date.

 

** ENTER STARTING SALESMAN:

 

Enter starting salesman.

 

[F5] to display list of salesman codes for selection.

 

** ENTER ENDING SALESMAN:

 

Enter ending salesman.

 

[F5] to display list of salesman codes for selection.

 

PRESS 'F4' TO ABORT

 

[F4] at any prompt to cancel purge and return to STORE CODE field.

 

** CR TO CONTINUE:

 

[Enter] to purge selected items.

 

[F4] to cancel.

 

The following prompt displays:

 

 

** PURGE CANCELLED - PRESS CR:

 

[Enter] to confirm.

 

You are return to STORE CODE field.

 

 

After printing the audit record, the following prompt displays.

 

** CONTINUE WITH PURGE? (Y/N):

 

"Y" to purge selected price changes.

 

** PURGE SUCESSFULLY COMPLETED - PRESS CR:

 

[Enter] to confirm.

 

You are returned to the STORE CODE field.

 

 

"N" to cancel purge.

 

The following confirmation prompt displays:

 

 

** PURGE CANCELLED - PRESS CR:

 

[Enter] to confirm.

 

You are returned to the STORE CODE field.

 

 


FIELDS

 

First line of display:

 

SALESMAN CODE

 

Salesman ID code.

 

ORDER DATE

 

Date of order.

 

ORDER NUMBER

 

Number of order.

 

LINE NUMBER

 

Line number of order.

 

CUSTOMER CODE

 

Customer ID code.

 

PRODUCT CODE

 

Product code.

 

PRODUCT DESCRIPTION

 

Description.

 

Second line of display:

 

ORDER  QUANTITY

 

Quantity unit.

 

PRICE DEFAULT

 

Normal price.

 

PRICE CHANGED TO

 

New normal price.

 

EXTENSION DEFAULT

 

Normal extension price.

 

EXTENSION CHANGED TO

 

New extension price.

 

CHANGE IN EXTENSION

 

Change in extension price.

 

DISC%

 

Per cent of discount.

  



                                                       D E M O   C O M P A N Y
07/17/08  14:40:13                                                                                                    PAGE: 1

                                      ORDER PROCESSING PRICE CHANGE INQUIRY - PURGE AUDIT TRAIL
                                      ---------------------------------------------------------

_____________________________________________________________________________________________________________________________________

                          LINE          PRODUCT       ORDER       <---------PRICE--------> <----EXTENSION---> CHANGE IN  DISC
EMPL. DATE     ORDER NO.   NO. CUSTOMER CODE         QUANTITY.    FROM            TO           FROM        TO EXTENSION  PERC
-------------------------------------------------------------------------------------------------------------------------------------

JOHN  02/04/08 01-A100052 0020 CASHSALE 806804          1.00-      .00/        18.70/EA          .00     18.70    18.70-  .00
JOHN  02/04/08 01-A100052 0030 CASHSALE 806804          1.00-      .00/        18.70/EA          .00     18.70    18.70-  .00
JOHN  02/04/08 01-A100053 0010 SMITJIM  806804          1.00       .00/        18.70/EA          .00     18.70    18.70   .00
JOHN  02/04/08 01-A100055 0010 SMITJIM  806804          1.00       .00/         8.61/EA          .00      8.61     8.61   .00
JOHN  02/04/08 01-A100057 0020 SMITJIM  806804          1.00-      .00/       100.00/EA          .00    100.00   100.00-  .00
JOHN  02/04/08 01-A100060 0010 DIVCON   320570          1.00     14.99/EA      50.05/EA        14.99     50.05    35.06   234-
JOHN  02/04/08 01-A100060 0010 DIVCON   320570          1.00     50.05/EA      14.99/EA        50.05     14.99    35.06-70.05
JOHN  02/04/08 01-A100060 0010 DIVCON   320570          1.00     14.99/EA      14.85/EA        14.99     14.85      .14-  .93
JOHN  02/04/08 01-C100054 0020 CASHSALE 806804          1.00-      .00/         8.61/EA          .00      8.61     8.61-  .00
JOHN  02/04/08 01-C100058 0010 CASHSALE 806804          1.00       .00/       100.00/EA          .00    100.00   100.00   .00
JOHN  04/09/08 01-A200012 0010 AAAWOO   320570          1.00     57.00/EA      51.03/EA        57.00     51.03     5.97-10.47
JOHN  04/09/08 01-A200012 0020 AAAWOO   311421          1.00      4.89/EA       9.41/EA         4.89      9.41     4.52 92.43-
JOHN  04/09/08 01-A200012 0020 AAAWOO   311421          1.00      9.41/EA       8.43/EA         9.41      8.43      .98-10.41
JOHN  04/09/08 01-E200002 0020 ^0100002 320605          1.00    700.00/EA     700.00/EA       700.00    700.00      .00   .00
JOHN  04/09/08 01-E200003 0010 DIVCON   320570          1.00     54.00/EA      50.00/EA        54.00     50.00     4.00- 7.41
JOHN  04/09/08 01-E200003 0010 DIVCON   320570          1.00     50.00/EA      40.00/EA        50.00     40.00    10.00-20.00
JOHN  04/09/08 01-E200003 0010 DIVCON   320570          1.00     40.00/EA      54.00/EA        40.00     54.00    14.00 35.00-
JOHN  04/09/08 01-E200003 0010 DIVCON   320570          1.00     54.00/EA      50.00/EA        54.00     50.00     4.00- 7.41
JOHN  04/09/08 01-E200004 0010 DIVCON   320570          1.00     50.00/EA      60.00/EA        50.00     60.00    10.00 20.00-
JOHN  04/09/08 01-E200005 0010 AAAWOO   320570          1.00     57.00/EA      24.99/EA        57.00     24.99    32.01-56.16
JOHN  04/10/08 01-A200040 0010 AAAWOO   320570         10.00     24.99/EA      50.31/EA       249.90    503.13   253.23   101-
JOHN  04/10/08 01-A200040 0020 AAAWOO   NAIL2INCH      10.00      1.90/LB       3.83/LB        19.00     38.25    19.25   101-
JOHN  04/10/08 01-A200040 0030 AAAWOO   320570          1.00     24.99/EA      50.05/EA        24.99     50.05    25.06   100-
JOHN  04/10/08 01-E200006 0010 DIVCON   320570          1.00     24.99/EA      20.00/EA        24.99     20.00     4.99-19.97
JOHN  04/10/08 01-E200006 0010 DIVCON   320570          1.00     20.00/EA      21.00/EA        20.00     21.00     1.00  5.00-
JOHN  04/10/08 01-E200006 0020 DIVCON   NAIL2INCH       1.00      1.80/LB       1.00/LB         1.80      1.00      .80-44.44

      TOTALS:       DECREASE=   243.96-      INCREASE=   489.43