IdealWare Online Users Manual

IY5-11 I/Y LISTINGS, REPORTS AND FORMS
31096 Purchase Order Header/Detail Report

 

PURPOSE

 

The purchase order header & detail report program enables you to print a report of PO header and detail information. It is typically printed when a supplier's shipment arrives and is used to validate the quantities received.

 

Purchase Order Header & Detail Report is accessed from:

  • Purchase Order Header options - Print Header and/or Detail Report for a specific PO.
  • Purchase Order Maintenance menu.

 

PROCEDURE - WITHIN A PURCHASE ORDER

 

Select [F12] at the purchase order header to display the header options menu.

 

PO HEADER OPTIONS MENU

┌────────────────────────────────────────────────────────────────────────────────┐
│01/25/08            ***** PURCHASE ORDER HEADER ENTRY *****                     â”‚
│────────────────────────────────────────────────────────────────────────────────│
│ORDER NUMBER 01-230028  ORDER DATE   11/29/07  STATUS  PENDING#01      PRT'D 00 â”‚
│ORDER TYPE   ORIGINAL   RECEIVE DATE 11/29/07  TO SUPP                          â”‚
│┌──────────────────────< MODIFY PURCHASE ORDER OPTIONS >───────────────────────┐│
││                                                                              â”‚│
││ F1  =  MODIFY LINES             P  =  PRINT OPTIONS                          â”‚│
││ F6  =  MODIFY HEADER           PI  =  PRINT INTERNAL COPY                    â”‚│
││  A  =  APPLY DISCOUNT          PV  =  PRINT VENDOR'S COPY                    â”‚│
││  B  =  BACKORDER LINES         PH  =  PRINT HEADER REPORT                    â”‚│
││  C  =  COPY P.O.               PD  =  PRINT DETAIL REPORT                    â”‚│
││  D  =  DELETE ORDER            PB  =  PRINT BACKORDER REPORTS                â”‚│
││  E  =  E-MAIL                  RH  =  RECEIPT HEADER HISTORY                 â”‚│
││  F  =  FAX P.O.                BC  =  BOX CONTENTS REPORT                    â”‚│
││  H  =  MODIFY HEADER           BI  =  BOX INQUIRY                            â”‚│
││  I  =  IMPORT/ExPORT P.O.      ST  =  SHOW SHIP-TO INFO                      â”‚│
││  L  =  PRINT LABELS            F5  =  P.O. INQUIRY                           â”‚│
││  M  =  MODIFY LINES            TS  =  TRANSMIT STATUS                        â”‚│
││  S  =  STATUS CHANGE          F11  =  CALC/DISPLAY FBM                       â”‚│
││  T  =  TRANSMIT P.O.                                                         â”‚│
││  U  =  UNIT CONVERSION                                                       â”‚│
││                                                                              â”‚│
││** SELECT OPTION (CR TO EXIT WINDOW): __                                      â”‚│
│└──────────────────────────────────────────────────────────────────────────────┘│
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** SELECT OPTION (CR TO EXIT WINDOW):

 

"P""H" to print header report.

 

"P""D" to print detail report.

 

See PROCEDURE - REPORT OPTIONS. The report is printed for the selected purchase order only.

 

 


PROCEDURE - THE PURCHASE ORDER MAINTENANCE MENU

 

Select Purchase Order from the Inventory Processing menu. The following prompts display.

 

** ENTER STORE CODE:

 

Enter applicable store code.

 

In a single store environment this value defaults to the normal store code.

 

 

** ENTER PURCHASER CODE:

 

This field defaults to the operator code entered at login. To change it press [F3] from the following prompt.

 

 

Enter salesman/operator code.

 

PURCHASE ORDER MAINTENANCE MENU

┌────────────────────────────────────────────────────────────────────────────────┐
│01/25/08             ***** PURCHASE ORDER MAINTENANCE *****                     â”‚
│                                                                                â”‚
│                                                                                â”‚
│** ENTER STORE CODE: 01 IDEALWARE STORE# 1                                      â”‚
│** ENTER PURCHASER CODE: SUPER                                                  â”‚
│( 1)  CREATE/ACCESS PURCHASE ORDER                                              â”‚
│( 2)  PURCHASE ORDER INQUIRIES                                                  â”‚
│( 3)  PURCHASE ORDER HEADER REPORTS                                             â”‚
│( 4)  PURCHASE ORDER COMBINE                                                    â”‚
│( 5)  RE-ORDER REPORT & AUTO P.O. CREATE                                        â”‚
│( 6)  PRODUCT INQUIRY                                                           â”‚
│( 7)  MAINTENANCE OPTIONS                                                       â”‚
│** ENTER P.O. OPTION (F12 FOR PO# 01-230028): __                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** ENTER P.O. OPTION (F12 FOR PO# 01-______):

 

[F4] to exit to menu.

 

"3" to access PO header/detail report.

 

** PRESS CR TO PROCEED, F3 FOR NEW OPTION:

 

[Enter] to continue PO header/detail report.

 

See PROCEDURE - REPORT OPTIONS.

 

 

[F3] or [F4] to reenter menu selection.

 


PROCEDURE - REPORT OPTIONS

 

** ENTER STORE CODE:

 

Enter store code.

 

In a single store environment this field defaults to the normal store code. In a multistore environment you system can be configured to default to the store code entered at the PO Mainitenance menu. When selected from a PO header, this field defaults to the store on the PO.

 

 

** ENTER REPORT TYPE (H=HEADER, D=DETAIL, R=RECEIVING): D

 

[Enter] to accept default value "D".

 

"H" to print header report.

 

"D" to print detail report.

 

"R" to print receiving report.

 

** ENTER P.O. NUMBER (CR FOR ALL; F5 FOR INQUIRY):

 

Enter PO number to report on.

 

When selected from a PO header, this field defaults to the selected PO.

 

 

[Enter] to select all PO's.

 

[F5] to access PO inquiry menu.

 

** ENTER SUPPLIER CODE (CR FOR ALL):

 

Enter supplier code to limit report to that supplier.

 

When selected from a PO header, this field defaults to the supplier code of the selected PO.

 

 

[Enter] to include all suppliers.

 

** ENTER ORDER STATUS (CR FOR ALL):

 

[Enter] to include PO's of any status.

 

"O" for status ordered only.

 

"P" for status pending only.

 

"R" for status be received only.

 

When selected from a PO header, this field defaults to the status of the selected PO.

 

 

** PURCHASER/BUYER CODE (CR=ALL):

 

Enter purchaser/buyer code.

 

[Enter] for all purchasers/buyers.

 

[F5] to display list of purchasers/buyers for selection.


** STARTING RECEIVE DATE (CR=FIRST): 00000000

 

Enter receipt date to begin range in format MMDDYYYY.

 

[Enter] for the earliest system date.

 

** ENDING RECEIVE DATE (CR=LAST): 99999999

 

Enter receipt date to end range in format MMDDYYYY.

 

[Enter] for last system date.

 

** PRINT HISTORICAL P.O'S? (Y/N):

 

[Enter] to accept default value "Y".

 

"Y" to include received/updated PO's in report.

 

"N" to not include received/updated PO's in report.

 

** PRINT COSTS, EXTENSIONS AND TOTALS ON REPORT? (Y/N):

 

[Enter] to accept default value "Y".

 

"Y" to print costs, extensions and line totals.

 

"N" to not print costs, extensions and line totals.

 

** MINIMUM GROSS PROFIT% (CR=ALL):

 

Enter minimum gross profit percentage to include.

 

[Enter] for all regardless of profit percentage.

 

Example Completed Parameters Entry display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/25/08             ***** PURCHASE ORDER MAINTENANCE *****                     â”‚
│                     COMPANY: 01 - D E M O   C O M P A N Y                      â”‚
│                                                                                â”‚
│** ENTER STORE CODE: 01  IDEALWARE STORE# 1                                     â”‚
│** ENTER REPORT TYPE (H=HEADER, D=DETAIL, R=RECEIVING): DETAIL                  â”‚
│** ENTER P.O. NUMBER (CR FOR ALL; F5 FOR INQUIRY): ALL                          â”‚
│** ENTER SUPPLIER CODE (CR FOR ALL):  ALL                                       â”‚
│** ENTER ORDER STATUS (CR FOR ALL): ALL                                         â”‚
│** PURCHASER/BUYER CODE (CR=ALL):                                               â”‚
│** STARTING RECEIVE DATE (CR=FIRST): 01/15/07                                   â”‚
│** ENDING RECEIVE DATE (CR=LAST): LAST DATE                                     â”‚
│** PRINT HISTORICAL P.O'S? (Y/N): Y                                             â”‚
│** PRINT COSTS, ExTENSIONS AND TOTALS ON REPORT? (Y/N): Y                       â”‚
│** MINIMUM GROSS PROFIT% (CR=ALL): ALL                                          â”‚
│** PRESS CR TO PROCEED, F3 TO BACKUP, F4 TO END: _                              â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│F4 TO RETURN TO MENU                                                            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO PROCEED, F3 TO BACKUP, F4 TO END:

 

[Enter] to continue to printer selection menu.

 

[F4] to exit and return to PO maintenance menu.

 

[F3] to return to previous field.

 

You can press [F3] at any field to return to the previous field.

 

 

The printer selection menu displays.

 

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.

 

Example P.O. Detail and Header Reports follow.

  



                                                             IDEALWARE
04/29/07  14:21:14                             PURCHASE ORDER DETAIL/RECEIVING REPORT                                PAGE: 1
                                                    PURCHASE ORDER DETAIL REPORT
                                                        STORE: 01-IDEALWARE
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100042  (ORDERED)           ORDER DATE:   01/08/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: ACKLA    ACKLANDS              RECEIPT DATE: 01/08/07   F.O.B. POINT:                       ** AUTOMATICALLY GENERATED **
PHONE#:                                  CANCEL DATE:  N/A        PURCHASER:    BARJO                 SALE: 01-C100672
CONTACT:                                 LAST REC'D:                                                  SMAN: BARJO  DATE: 01/08/07
-----------------------------------------------------------------------------------------------------------------------------------
      OUR        SUPPLIER'S                                        ORIGINAL                   QTY TO     QTY                 BK-ORD
SEQ  PRODUCT     PRODUCT         DESCRIPTION                       ORDER QTY     ORDER PRICE  RECEIVE  RECEIVED    EXTENSION   QTY
-----------------------------------------------------------------------------------------------------------------------------------
0050 320570     ACKHAMM          10LB SLEDGE HAMMER                  1  EA                          1  _________                  0
0100 109695                      2X4 S4S STD&BTR GR FIR 8-12     1,000  FBM                     1,867
                                                 IN BASE UNITS:  1,000  FBM        .450 FBM     1,867  _________                  0
                                 100 8'S 200 10'S



                                                             IDEALWARE
04/29/07  14:21:15                             PURCHASE ORDER DETAIL/RECEIVING REPORT                                PAGE: 1
                                                    PURCHASE ORDER DETAIL REPORT
                                                        STORE: 01-IDEALWARE
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100045  (ORDERED)           ORDER DATE:   01/08/07   SHIP VIA:     ASDF                  <----------COMMENTS---------->
SUPPLIER: ACKLA    ACKLANDS              RECEIPT DATE: 01/10/07   F.O.B. POINT:                       HEADER LINE
PHONE#:                                  CANCEL DATE:  N/A        PURCHASER:    BARJO                 ASDF
CONTACT:  BARJO                          LAST REC'D:                                                  SADF
-----------------------------------------------------------------------------------------------------------------------------------
      OUR        SUPPLIER'S                                        ORIGINAL                   QTY TO     QTY                 BK-ORD
SEQ  PRODUCT     PRODUCT         DESCRIPTION                       ORDER QTY     ORDER PRICE  RECEIVE  RECEIVED    EXTENSION   QTY
-----------------------------------------------------------------------------------------------------------------------------------
0050 109695                      2X4 S4S STD&BTR GR FIR 8-12     1,000  FBM                     1,587
                                                 IN BASE UNITS:  1,000  FBM        .400 FBM     1,587  _________                  0
                                 PREFER 100 8'S, 200 10'S



                                                             IDEALWARE
04/29/07  14:21:15                             PURCHASE ORDER DETAIL/RECEIVING REPORT                                PAGE: 1
                                                    PURCHASE ORDER DETAIL REPORT
                                                        STORE: 01-IDEALWARE
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100055  (RECEIVING - BO)    ORDER DATE:   01/23/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: ACKLA    ACKLANDS              RECEIPT DATE: 01/23/07   F.O.B. POINT:                       ** AUTOMATICALLY GENERATED **
PHONE#:                                  CANCEL DATE:  N/A        PURCHASER:    BARJO                 SALE: 01-C100713
CONTACT:                                 LAST REC'D:   01/23/07                                       SMAN: BARJO  DATE: 01/23/07
-----------------------------------------------------------------------------------------------------------------------------------
      OUR        SUPPLIER'S                                        ORIGINAL                   QTY TO     QTY                 BK-ORD
SEQ  PRODUCT     PRODUCT         DESCRIPTION                       ORDER QTY     ORDER PRICE  RECEIVE  RECEIVED    EXTENSION   QTY
-----------------------------------------------------------------------------------------------------------------------------------
0050 320589                      SPECIAL HAMMER                      1  EA                          1  _________                  0
0100 109695                      2X4 S4S STD&BTR GR FIR 8-12     1,000  PCS                       900
                                                 IN BASE UNITS:      0  FBM        .000 FBM     5,333  _________                  0
                                 PREFER 8'S AND 10'S

                                                     

FIELDS                                    

See 30110 Purchase Orders, Creation for a description of PO fields.

The Order Price and Extension print depending on whether the security actions flag for doing so has been
set to "Y" in the user's security profile.



                                                 D E M O   C O M P A N Y
Feb21/08  11:46:12                                  PURCHASE ORDER HEADER REPORT                                     PAGE: 1
                                                    PURCHASE ORDER HEADER REPORT
                                                    STORE: 01-IDEALWARE ELECTRIC

-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-000001  (PENDING)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:    WAYNE
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100001  (ORDERED)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:    WAYNE
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100002  (ORDERED)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:    WAYNE
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100003  (ORDERED)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:    WAYNE
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100004  (ORDERED)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:    WAYNE
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100005  (ORDERED)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:    WAYNE
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100006  (ORDERED)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:    SUPER
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100007  (RECEIVING - BO)    ORDER DATE:   Dec16/07   SHIP VIA:     LOOMIS AIR            <----------COMMENTS---------->
SUPPLIER: DRYAGE   DRYDEN AGENCIES LTD   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   7802 434 4900                  CANCEL DATE:  N/A        PURCHASER:    BEV
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100008  (PENDING)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:                       ** AUTOMATICALLY GENERATED **
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:                          SALE: 01-S100012
CONTACT:                                                                                              SMAN: SIMON  DATE: Dec16/07
-----------------------------------------------------------------------------------------------------------------------------------
ORDER:    01-100009  (ORDERED)           ORDER DATE:   Dec16/07   SHIP VIA:                           <----------COMMENTS---------->
SUPPLIER: BMOTORUS BALDOR ELECTRIC COM   RECEIPT DATE: Dec16/07   F.O.B. POINT:
PHONE#:   501-646-4711                   CANCEL DATE:  N/A        PURCHASER:    PETER
CONTACT:
-----------------------------------------------------------------------------------------------------------------------------------

TOTAL PURCHASE ORDERS: 10