PO0700 Purchase Order and Receiving Cash Requirements Projection Report

Cash Requirements Projection Report

Application Overview

 When you enter a purchase order line item you specify, by means of the request date, when you would like to receive the item.  If the vendor cannot deliver by the request date but offers a later delivery date, you may enter this date as the line item's promise date (unless you wish to cancel the order).  At some point you will receive all or part of the ordered quantity and the vendor will bill you for the merchan­dise.  Once you have billed you know what your cash requirement is.

It is possible to project your cash requirements before you are billed, however. Such projections are based upon the expected receipt dates for the items you have ordered and the expected costs of these items. To be totally comprehensive, the projection should also take into account unpaid invoices on file in the Accounts Payable package. Such invoices are actually known cash requirements but they are not all due at the same time so you can project when the actual cash outflow will occur.

This application accomplishes such a projection. It derives the cash requirements data from the purchase order line items and from the Accounts Payable Open Item file.

 

How The Report Is Structured

 This report first lists the cash requirements for a vendor that are derived from purchase order line items. These line items may have receivings posted against them.  They may even be partially billed.  The cash requirement for each line item is simply the unbilled portion of that line item's scheduled receiving.  The cash requirement date is the due date of the anticipated invoice, with the assumption being that the invoice will be dated as of the scheduled receipt date.

 The report next provides a summary of projected cash requirements from purchase orders for the vendor. This summary categorizes cash require­ments by their age.  Below this summary, the report shows the cash requirements that are derived from Accounts Payable data.  Those line items that have been billed, but not yet paid, are included in this section of the report.  They are summarized in categories based upon their age, just as items were categorized.  Note that these totals include payables from non‑purchase order sources such as expense billings.  They also include any recurring vouchers that have not yet been posted to the A/P Open Item file.

 Finally, there is a summary of the vendor's total cash requirements from both sources.  This summary is also categorized by the age of the cash requirements that are included.

 At the end of the report there are three additional summaries of aged cash requirements.  These are the total cash requirements from purchase orders, the total cash requirements from Accounts Payable and the total cash requirements.  These summaries are for the entire company and include all of the cash requirements listed above for individual vendors.

 

Defining The Aging Categories

 For each report that you print you will be required to define the categories that are used to age the projected cash requirements.  For purchase of this report, aging is simply the means used to determine during which of four periods a cash requirement will fall due.  You define the aging periods before the report is printed.

 In order to define an aging period you must enter the period's ending date and provide a brief description of the period.  You need to define four such periods. The first period includes all cash requirements from the earliest that are on file to those dated as of the period ending date that you enter. The period description that you choose will be determined by the significance of the ending date. It might say Current, for instance; or Before April; or As Of XX/XX/XX; where XX/XX/XX is the period ending date.  You are free to label this category as you see it.  You next enter the second period's ending date and its description.  This category includes all cash requirements whose due dates come after the first period's ending date and fall on or before the second period's ending date.  Again, whatever description you enter is determined by the significance of the date.

 Following this you enter the ending dates and descriptions of the last two periods. Cash requirements that are dated past the fourth period's ending date are ignored by the report.

 

Evaluating The Report

 The report shows the projected cash requirements for each vendor before showing the company's total projected cash requirements.  The cash requirements derived from the purchase order data are less likely to be accurate than those derived from the Accounts Payable data. For this reason you are given the option of itemizing the purchase order lines from which cash requirements are derived.  Seeing the purchase order line data can help you determine how reliable the projection for a particular vendor is. Purchase order lines are listed in order by their cash requirement date.

 For each line item that prints, the report indicates whether the projection is based upon an actual receiving or merely an expected receiving. Projections based upon actual receivings are more reliable than those based upon expected receivings since the expected receiving may arrive late or it may only be partially shipped or it may be canceled. For each cash requirement date, actual receivings are grouped together on the report above the group of expected receivings to further assist you in differentiating between them.

 You may wish to de‑emphasize the cash requirements from purchase orders somewhat in order to compensate for the inherent unreliability of the data. The cash requirements from the Accounts Payable is accurate, however, since it is based upon actual invoices in‑house with known due dates.  Even though there is a certain degree of inaccuracy in such projections, by including the expected receivings against purchase orders on the report you have a much larger window through which you can view your financial commitments than you would have if you only considered your Accounts Payable. This report can help you spot a tight financial situation far enough in advance to be able to do some­thing about it, particularly if you use this report in conjunction with projects of cash receipts from sales and other such tools of financial analysis.


Run Instructions

 Select Cash Requirements Projection Report 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 Cash Requirement Projection Reports menu bar
    • Enter the data requested on the screen
    • Before you select this report make sure that all Accounts Payable transactions have been posted.  Unposted A/P open items will not show up under either the cash requirements from purchase orders or Accounts Payable.  A warning message will appear if you have any unposted A/P transactions.
    • A screen will display upon which you specify whether the report should be printed in summary or detail.  You must also define the aging periods into which report data will be categorized.
    • The report then begins processing in the background.  There is a considerable amount of processing that must be done before the report begins printing.  This processing involves the consoli­dation of purchase order data into a new file from which the Cash Requirements Projection Report can be printed.  The data can be prepared for only one report at a time, so as soon as processing begins, the program will return to the Cash Requirements Projection Report 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

     

    Name

    Type and Description

    1.   Summary or Detail ?

    1 alphabetic character.

    S or D.  A submenu will display to remind you of the options.

    Default is D.  Enter D if you wish to see each of the line items that contribute to the projected cash requirements from purchase orders.  Enter S if you only wish to see the projected cash requirement totals.

    2.   Period‑1 Ending Date

    A date in the standard date format.

    Enter the ending date of the first aging period.  All cash require­ments for which the cash requirement date is on or before the date you enter here will be included in the first period's total.

    3.   Period‑1 Description

    14 alphanumeric characters.

    Enter the description for this aging period.

    4.   Period‑2 Ending Date

    A date in the standard date format.

    Enter the ending date of the second aging period.  All cash requirements for which the cash requirement date follows the first period's ending date, but is on or before the date you enter here, will be included in the second period's total.

    5.   Period‑2 Description

    14 alphanumeric characters.

    Enter the description for this aging period.

    6.   Period‑3 Ending Date

    A date in the standard date format.

    Enter the ending date of the third aging period.  All cash require­ments for which the cash requirement date follows the second period's ending date, but is on or before the date you enter here, will be included in the third period's total.

    7.   Period‑3 Description

    14 alphanumeric characters.

    Enter the description for this aging period.

    8.   Period‑4 Ending Date

    A date in the standard date format 

    Enter the ending date of the fourth aging period.  All cash requirements for which the cash requirement date follows the third period's ending date, but is on or before the date you enter here, will be included in the fourth period's total.  Cash requirements dated later than this date will not be included on the report.

    9.   Period‑4 Description

    14 alphanumeric characters.

    Enter the description for this aging period.




    2

     

    Cash Requirements Projection Entry Screen

    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

    Feedback and Knowledge Base