Why Does the AP Comprehensive Cash Projection Report Mismatch Other Report Amounts?
Released Date: 07/03/2025
Version: 8.5 & Up
Q - If I go to PO ->Processing -> Warehouse Receiving Process and I run an edit list, I can see the pending receiving total amount. On the other hand, if I go to AP -> Report -> Cash Requirements Report -> Print -> Comprehensive Cash Projection Report, the total in that report shows a different pending receiving amount than the PO warehouse receiving edit list. How can that happen?
A - The warehouse receiving edit
list prints all of the receiving transactions regardless of the expected
receiving date. The pending purchase order section on the report ages the
document either based on the vendor number of due days or the purchase order
header number of due days. In this particular case, Vendor KINGST due days is set to 75. When you
run the Comprehensive Cash Projection Report, your aging periods are 30,
60, 90 and 120 days. See sample screen below:
Anything that ages past 120 days is not included on
the report. That means that anything with a scheduled receiving transaction date after (today + 120 days – 75 days) will not be included on the report.
If you change the last aging bucket to 999 days, the pending total matches the total on
the warehouse receiving edit list.
Please also see the following related KB articles:
EMK
Related Articles
How to Speed up AP Comprehensive Cash Projection Report
Released Date: 07/03/2025 Version: 8.5 & Up Q - When I go to A/P -> Report -> Cash Requirements Report -> Print -> Comprehensive Cash Projection Report, it takes two hours to run. How can I speed it up? A - In general, you should consider purging ...Feature - CSV Support Added to A/P Comprehensive Cash Projection Report
Release Date: 6/11/25 Version: 8.5 and Above This feature adds CSV file support to the A/P Comprehensive Cash Projection Report. Adding CSV support requires the addition of the report parameter ID as one of the options for this report. Use This ...Feature - Support ATP Planning/Actual Data in A/P Comprehensive Cash Projection Report
Release Date: 6/26/25 Version: 8.5 and Above Cash Projection Based on ATP Options The Comprehensive Cash Projection Report now uses available-to-promise (ATP) data to generate the sales and purchase order sections of the report. The report also ...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 ...BB17S4 Bank Book Cash Projection Report
Cash Projection Report Application Overview Without needing the use of extensive financial analysis software the Cash Projection Application allows for a compact view of future cash needs. The application looks at the current cash requirements ...