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

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Feedback and Knowledge Base