PO1800 Purchase Order and Receiving Open Purchase Orders Reports

Open Purchase Orders Reports

Application Overview

The Open Purchase Orders Reports application enables you to identify items that were ordered and not received into inventory.  You can select to print the report in vendor or item number order. It can display the quantity ordered, dollar value and quantity not received of each item ordered through a specified date.

The Received/Not Invoiced report prints items that have been ordered and received, but that you have not yet received an invoice for.  It prints the quantity ordered and received of each item as well as the quantity invoiced and dollar value not yet invoiced.

 

Run Instructions

 Select Open Purchase Orders Reports from the pull down P/O Reports window.  The following screen will then be displayed:

 

 

 

The following options are available:

    • Select the Print mode from the Open Purchase Orders Reports menu bar
    • Select the Open Purchase Orders Report By Vendor, the Open Purchase Orders Report By Item, or the Received/Not Invoiced Report from the print pull-down window.
    • Enter the data requested on the screen

     To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.

     

    Entry Field Descriptions

     

    Vendor

     

    Name

    Type and Description

    1.  Starting Vendor

    6 alphanumeric characters.

    Enter the starting vendor number in the range you want to print, or press RETURN to print All vendors.

    To search by Vendor No. enter F7, or F8 to search by Vendor Description.

    2.  Ending Vendor

    6 alphanumeric characters.

    Enter the ending vendor number in the range you want to print.

    To search by Vendor No. enter F7, or F8 to search by Vendor Description.

    3.  Use Request Or Promise           Date ?

    R or P.

    Enter R to select purchase orders by request date or P to select by promise date.

    Defaults to R.

    4.  Starting Date

    A date in the standard date format.

    Enter the starting date in the range you want to print.

     

    5.  Ending Date

    A date in the standard date format.

    Enter the ending date in the range you want to print.

    6.  Include Unprinted Po's ?

    Y or N.

    Enter Y to include unprinted Po's or N to decline.

    7.  Include Qty Rejected In             Calc ?

    Y or N.

    If you answer Y, the inventory that has been received, but rejected and not placed into inventory will be included in the "Not Received Quantity" and "Not Received Dollar Amount" totals.  Otherwise, it will not be used for these totals. 

    Default is N.

    8.  Include Blanket Orders?

     

    Answer Y to include Blanket Orders on the report 

    Default is N.

     


    Item
     

    Name

    Type and Description

    1.  Starting Item

    6 alphanumeric characters.

    Enter the starting item number in the range you want to print, or press RETURN to print All items.

    To search by Item No. enter F7, or F8 to search by Item Description.

    2.  Ending Item

    6 alphanumeric characters.

    Enter the ending item number in the range you want to print.

    To search by Item No. enter F7, or F8 to search by Item Description.

    3.  Use Request Or Promise           Date ?

    R or P 

    Enter R to select purchase orders by request date or P to select by promise date.

    4 . Starting Date

    A date in the standard date format.

    Enter the starting date in the range you want to print.

    5.  Ending Date

    A date in the standard date format.

    Enter the ending date in the range you want to print.

    6.  Include Unprinted Po's ?

    Y or N.

    Enter Y to include unprinted Po's or N to decline.

    7.  Include Qty Rejected In             Calc ?

    Y or N.

    If you answer Y, the inventory that has been received, but rejected and not placed into inventory will be included to the "Not Received Quantity" and "Not Received Dollar Amount" totals.  Otherwise, it will not be used for these totals. 

    Default is N.

    8.  Include Blanket Orders?

     

    Answer Y to include blanket orders on the report.

    Default is N.

     

                Received/Not Invoiced

     

    Name

    Type and Description

    1.   Starting P.O. Number

    6 numeric digits followed by 2 numeric digits (999999-99).

    Enter the starting purchase order number for the range to be printed. 

    Defaults to All.

    2.   Ending P.O. Number

    6 numeric digits followed by 2 numeric digits (999999-99).

    Enter the ending purchase order number for the range to be printed.

    Defaults to the starting purchase order number.

    3.   Starting Date Entered

    A date in the standard date format.

    Enter the earliest purchase order entry date for the range to be printed.  Only purchase orders entered between this and the ending date will be printed.

    Defaults to All.

    4.   Ending Date Entered

    A date in the standard date format.

    Enter the latest purchase order entry date for the range to be printed.

    Defaults to the starting date.

     

     

     


     

    Open Purchase Report By Vendor

    Screens

    4

    Open Purchase Report By Item


     


     

    Open Purchase Report Received/Not Invoiced


    REPORTS

    Run Date: Nov 13, 1992 ‑ 12:39pm         Elliott Electronics Co.                                                            Page    1

     

                                         O P E N   P U R C H A S E  O R D E R S   B Y   V E N D O R

    Ranges: For All Vendors

            For All Dates

            For All Printed Purchase Orders

            Qty Rejected Not Included In Qty Not Received Calculation

     

    Vendor‑Number               Item‑Number     Item Description                 Po‑No    Um      Quantity     Quantity     Qty/Dollars

    Vendor‑Name                      Request‑Date                                                  Ord/Rec     Rejected     Not Received

    000100                      CHAR‑GEN        Character Generator At 25 Meg  000001‑00  EA       50.000        .000         40.000

    Computer Electronics Center       02/03/92  Character ‑ Gen ‑ 25                               10.000                     312.00

                                PAR‑PORT        Parallel Port For I/O          000001‑00  EA       40.000        .000         30.000

                                      02/03/92  Parallel Port                                      10.000                     300.00  

                                SER‑PORT        Serial Port For Z80 25 Meg     000001‑00  EA       40.000        .000         30.000

                                      02/03/92  Serial ‑ Port                                      10.000                     240.00  

                                RAM‑ADDRES      Ram Address Multiplexer        000005‑00  EA       20.000        .000         10.000

                                      02/03/92  Ram ‑ Add ‑ Mult                                   10.000                     170.00  

                            Vendor Totals         150.000 Ordered            .000 Rejected            110.000 Not Received Quantity

                                                   40.000 Received                                   1,022.00 Not Received Dollar Amount

    000200                      VID‑AD          Video Addressing Module        000002‑00  EA       40.000        .000         30.000

    CompuPart Computer Services       02/03/92  Vid ‑ Address                                      10.000                     166.20  

                                VID‑CLKS        Video Clock For 25 Meg Video   000002‑00  EA       60.000        .000         50.000

                                      02/03/92  Video ‑ Clock                                      10.000                     400.00

                                VID‑DRIVER      Video Driver For 25 Meg Video  000002‑00  EA       20.000        .000         10.000

                                      02/03/92  Vid‑25‑driver                                      10.000                     224.00

    Run Date: Nov 13, 1992 ‑ 12:40pm         Elliott Electronics Co.                                                            Page    1

                                         O P E N   P U R C H A S E  O R D E R S   B Y   I T E M

    Ranges: For All Items

            For All Dates

            For All Printed Purchase Orders

            Qty Rejected Not Included In Qty Not Received Calculation

    Vendor‑Number               Item‑Number     Item Description                 Po‑No    Um      Quantity     Quantity     Qty/Dollars

    Vendor‑Name                      Request‑Date                                                  Ord/Rec     Rejected     Not Received

    000100                      CHAR‑GEN        Character Generator At 25 Meg  000001‑00  EA       50.000        .000         40.000

    Computer Electronics Center       02/03/92  Character ‑ Gen ‑ 25                               10.000                     312.00

                            Item Totals:           50.000 Ordered            .000 Rejected             40.000 Not Received Quantity

                                                   10.000 Received                                     312.00 Not Received Dollar Amount

    000400                      CLOCK           25 Meg Clock For Mother Board  000004‑00  EA       30.000        .000         20.000

    Computers of America              02/03/92  Clock ‑ 25M                                        10.000                     250.80

    000700                      CLOCK           25 Meg Clock For Mother Board  000006‑00  EA       15.000        .000           .000

    Southern Electronics              02/06/92  Clock ‑ 25M                                        15.000                        .00

                            Item Totals:           45.000 Ordered            .000 Rejected             20.000 Not Received Quantity

                                                   25.000 Received                                     250.80 Not Received Dollar Amount

    000700                      CPU‑30MEG       Z80 Micro Processor 30 Meg     000006‑00  EA       15.000        .000           .000

    Southern Electronics              02/06/92  CPU ‑ Z80                                          15.000                        .00

                            Item Totals:           15.000 Ordered            .000 Rejected               .000 Not Received Quantity

                                                   15.000 Received                                        .00 Not Received Dollar Amount

    000300                      DATA‑BUS        Data Bus/Buffer 25 Meg         000003‑00  EA       60.000        .000         50.000

    Anawalt Computer Company          02/03/92  Data ‑ Buffer                                      10.000                     772.50

    000700                      DATA‑BUS        Data Bus/Buffer 25 Meg         000006‑00  EA       15.000        .000           .000

     

     Run Date: Nov 13, 1992 ‑ 12:41pm         Elliott Electronics Co.                                                            Page    1

                                         R E C E I V E D / N O T   I N V O I C E D   R E P O R T

    Ranges: For All PO‑Nos

            For All Dates

    PO‑Number  Vendor‑Number               Item‑Number     Item Description               Um      Quantity     Quantity       Dollars

               Vendor‑Name                      Receipt‑Date                                       Ord/Rec     Invoiced     Not Invoiced

    000001‑00  000100                      CHAR‑GEN        Character Generator At 25 Meg  EA       50.000        .000

               Computer Electronics Center       02/03/92  Character ‑ Gen ‑ 25                    10.000                      78.00

                                            PAR‑PORT        Parallel Port For I/O          EA       40.000        .000

                                                 02/03/92  Parallel Port                           10.000                     100.00 

                                           SER‑PORT        Serial Port For Z80 25 Meg     EA       40.000        .000

                                                 02/03/92  Serial ‑ Port                           10.000                      80.00

                                                                                                                Total:         258.00

    000002‑00  000200                      VID‑AD          Video Addressing Module        EA       40.000        .000

               CompuPart Computer Services       02/03/92  Vid ‑ Address                           10.000                      55.40 

                                           VID‑CLKS        Video Clock For 25 Meg Video   EA       60.000        .000

                                                 02/03/92  Video ‑ Clock                           10.000                      80.00

                                           VID‑DRIVER      Video Driver For 25 Meg Video  EA       20.000        .000

                                                 02/03/92  Vid‑25‑driver                           10.000                     224.00 

                                           VID‑RAM         Video Ram For 25 Meg Video     EA       25.000        .000

                                                 02/03/92  Video ‑ Ram                             10.000                     120.00

                                                                                                               Total:         479.40

     


    REPORTS

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Purchase Order

    1. Why Receiving Non-Inventory Items in PO Will Cause General Ledger Inventory Account Out of Balance?
    2. Order Has Been Printed But Not Posted
    3. When does the Purchase Line History data get updated?
    4. Can I Edit the Ship Date Field in PO Line Item Screen?
    5. Getting PO Lock File Problem During PO Printing
    6. Feature - Notes Tracking from PO Warehouse Receiving to Inventory Transfer Management to Inventory Transaction
    7. Feature - Prevent MM Item from Purchasing
    8. Feature - Include Or Exclude UDC in Buyer's Desk
    9. Feature - Item Number Verification After Serial Number Scan
    10. PO05S1 Purchase Order and Receiving Receivings Audit Trail Report
    11. PO05S2 Purchase Order and Receiving Drop Shipment Receivings Report
    12. PO0104 Purchase Order and Receiving Release Blanket Orders
    13. PO0105 Purchase Order and Receiving Purge Closed Purchase Orders
    14. PO0200 Purchase Order and Receiving Print Purchase Orders
    15. PO0300 Purchase Order and Receiving Purchase Order Inquiry
    16. PO0400 Purchase Order and Receiving Scheduled Receipts Reports
    17. PO0600 Purchase Order and Receiving Purchase Line History Report
    18. PO0700 Purchase Order and Receiving Cash Requirements Projection Report
    19. PO0800 Purchase Order and Receiving Commodity Code Vendor Report
    20. PO0900M Purchase Order and Receiving Vendor Performance Analysis Report
    21. PO1000 Purchase Order and Receiving P/O Setup
    22. PO1101 Purchase Order and Receiving Buyer Code File Maintenance
    23. PO1201 Purchase Order and Receiving Comment Code File Maintenance
    24. PO1301 Purchase Order and Receiving Reject Reason Code File Maintenance
    25. PO1401 Purchase Order and Receiving Ship-To File Maintenance
    26. PO1501 Purchase Order and Receiving Item Vendor File Maintenance
    27. PO1502 Purchase Order and Receiving Purge Item Vendor File Maintenance
    28. PO1601 Purchase Order and Receiving Vendor Service Address
    29. PO1700 Purchase Order and Receiving Clear Year-to-Date Statistics
    30. PO1800 Purchase Order and Receiving Open Purchase Orders Reports
    31. POCLSMNU Purchase Order and Receiving PO Close Processing
    32. POIMPMNU Purchase Order and Receiving Purchase Order Import
    33. POINVMNU Purchase Order and Receiving Invoice Processing
    34. POORDEXS Purchase Order and Receiving Purchase Order Export
    35. POEQMNT Purchase Order and Receiving Purchase Order Requisition
    36. POREQPST Purchase Order and Receiving Post Requisitions
    37. PORSTSCN Purchase Order and Receiving Reset P/O Rec/Inv Qty
    38. POUPDSTA Purchase Order and Receiving Update Vendor Statistics
    39. POWHRMNT Purchase Order and Receiving Warehouse Recovery Process
    40. POWRIMNT Purchase Order and Receiving Warehouse Receiving Import
    41. Feature -- PO Ship-to File Maintenance Determine Drop Ship Location by State/Zip Code Tables
    42. Feature - Warehouse Receiving Serial Number Validation
    43. Feature - Buyer's Desk Inventory Class Selection Criteria
    44. Feature - PO Ship-To File Received to Transit Location
    45. Purchase Order Line Item Add or Change Event
    46. PO0000 Purchase Order and Receiving Overview 1
    47. PO0000 Purchase Order and Receiving Overview 2
    48. PO0000 Purchase Order and Receiving Overview 3
    49. PO0000 Purchase Order and Receiving Overview 4
    50. PO0000 Purchase Order and Receiving Overview 5
    51. PO0000 Purchase Order and Receiving Overview : Index
    52. PO0100 P/O and Receiving Purchase Order Processing 1
    53. PO0100 P/O and Receiving Purchase Order Processing 2
    54. PO0100 P/O and Receiving Purchase Order Processing 3
    55. PO0100 P/O and Receiving Purchase Order Processing 4
    56. PO0100 P/O and Receiving Purchase Order Processing 5
    57. PO0100 P/O and Receiving Purchase Order Processing: Index
    58. PO2000 P/O and Receiving Receivings Processing 1
    59. PO2000 P/O and Receiving Receivings Processing 2
    60. PO2000 P/O and Receiving Receivings Processing 3
    61. PO2000 P/O and Receiving Receivings Processing 4
    62. PO2000 P/O and Receiving Receivings Processing 5
    63. PO2000 P/O and Receiving Receivings Processing 6
    64. PO2000 P/O and Receiving Receivings Processing 7
    65. PO2000 P/O and Receiving Receivings Processing 8
    66. PO2000 P/O and Receiving Receivings Processing 9
    67. PO2000 P/O and Receiving Receivings Processing: Index
    68. POFRMMNT P/O and Receiving P/O Form Setup 1
    69. POFRMMNT P/O and Receiving P/O Form Setup 2
    70. POFRMMNT P/O and Receiving P/O Form Setup 3
    71. POFRMMNT P/O and Receiving P/O Form Setup 4
    72. POFRMMNT P/O and Receiving P/O Form Setup 5
    73. POFRMMNT P/O and Receiving P/O Form Setup: Index
    74. PORCNMNU P/O and Receiving P/O Reconciliation Process 1
    75. PORCNMNU P/O and Receiving P/O Reconciliation Process 2
    76. PORCNMNU P/O and Receiving P/O Reconciliation Process 3
    77. PORCNMNU P/O and Receiving P/O Reconciliation Process: Index
    78. How to Retrieve Open Purchase Orders Through SQL SELECT Statement
    79. Feature - Receivings Processing Mass Receiving Changes
    80. Feature - Warehouse Receiving Mass Receiving
    81. How to Remove Outstanding PO from Received Not Invoiced Report
    82. Feature - Add Events for Addition of PO Header and Line
    83. Feature - Allow to Enter Unit Cost in PO Warehouse Receiving Add Mode
    84. Feature - Ability to Create a CSV Export in PO Edit List When "Show Headers Only" = "Y"
    85. Feature - Added PO by Comment Code List to the Schedule Receipts Reports
    86. Feature - Support Negative PO Line Item Unit Cost
    87. Feature - Added F4=Revision Option to PO Inquiry Drill Down
    88. Feature - Add Serial Number Support to PO Warehouse Receiving Import

    Feedback and Knowledge Base