Why Does the AP Comprehensive Cash Projection Report Mismatch Other Report Amounts?

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. 

​

 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 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 supports the option to include Actual ...

    • 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 ...

    • ARCSHSCN Accounts Receivable Cash Projection Report

      Cash Projection Report Application Overview The Cash Projection Report graph application facilitates Elliott reporting features by plotting the anticipated future revenue outlook of your organization. It processes information obtained from the A/R ...