Feature - Support ATP Planning/Actual Data in A/P Comprehensive Cash Projection Report

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 (showing sales and purchase order data), Firm ATP, Firm Plan ATP, or Plan & Forecast ATP to provide a more accurate cash projection. If your intention is to project cash flow for the long term (e.g., more than three months), then you should include ATP planning and forecasting data to make the projection more realistic.

Since this cash projection report now relies on ATP data, you must ensure that your ATP is being regenerated frequently. In particular, planning and forecasting data will not be updated in the ATP database unless you perform a Total ATP Regen by answering "Y" to "Create Plan Order". See the sample screen below under I/M -> Utility -> ATP Regen and Process -> Generate -> Total Regen:



If your Cash Projection Report is to include planning and forecasting data, you must answer "Y" to "1. Create Plan Order." Since it is not recommended to run ATP Total Regen during the day, users typically use Elliott Deferred Processing to automate this task to run nightly.

In Comprehensive Cash Projection Report,  a new parameter, 10. Project ATP Type/Print Option, allows the user to choose the level of ATP data that is used to project cash requirements.



The last time that ATP was regenerated is displayed on the parameter screen as a reminder. If it has been 7 or more days since the ATP regeneration was run, the user will be warned before printing the report.


10. Project ATP Type/Print Option - The options are A=Actual, F=Firm ATP, X=Firm Plan ATP, and P=Plan & Forecast ATP. Default is A. 
A – This will allow the user to choose options for processing the sales and purchase order records.
F – This option will in include all firm plan ATP records in addition to the sales and purchase order records. 
X - This option will in include all firm plan ATP records including "L" type in addition to the sales and purchase order records.
P - This option will include all forecast and firm plan ATP records including "L" type in addition to the sales and purchase order records.

Once an ATP type is chosen, a popup window allows the user to choose the format of the output.

The options are S=Summary, B=Brief and D=Detail.

If Project ATP Type is not set to A, field 11. Project Purchase Orders and field 12. Project COP Sales will not be available. The data will automatically be included in the report output. If Project ATP Type is set to A, field 11. Project Purchase Orders will have the following options: N=Do Not Include, P=Pending, F=Firm, and O=Open. 


  1. N - Purchase order data will not be included in the output.
  2. P - Only Unposted warehouse/legacy receiving transactions will be included in the purchase order section of the report. 
  3. F - Order lines that are set to Firm and unposted warehouse/legacy receiving transactions will be included in the purchase order section of the report. 
  4. O - All open line items, whether firm or not, and unposted warehouse/legacy receiving transactions will be included in the purchase order section of the report. 
If Project ATP Type is set to A, field 12. Project COP Sales will have the following options: N=Do Not Include, O=Open, and B=Backorder.


  1. N - Sales order data will not be included in the output.
  2. O - Only open quantities excluding back ordered quantities will be included in the output.
  3. B - All sales order quantities including back ordered quantities will be included in the output.

Note: Credit memo data is not included in the sales order report output.  Typically, credit memos are posted by the end of the day and are reflected in the A/R open items data. Therefore, we recommend running the Comprehensive Cash Projection Report early in the morning, rather than in the evening, so there is no pending credit memos in COP affect this report.

Three new output sections are included in the report output.
Purchase order requisition data is available if the Project ATP Type is set to F=Firm ATP, X=Firm Plan ATP, or P=Plan & Forecast ATP.


ATP Planning "L" type data is available if the Project ATP Type is set to X=Firm Plan ATP or P=Plan & Forecast ATP.


Forecast data is available if the Project ATP Type is set to P=Plan & Forecast ATP.


The summary page of the report shows the breakdown by each type. Sales orders are now broken in to two sections: open and back orders. 
Purchase orders are broken into three sections: open, firm, pending and requisitions (if Project ATP Type is set to F, X or P). 
Projected plan and forecast ATP sections are also included.


Programs Modified: APCSHPJS, APCSHPJP
CLS

    • Related Articles

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

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

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

    • Feature - Add Multiple Planning Types to Show in ATP Process Criteria

      Release date: 5/8/2020 Version 8.5 & up Currently in I/M -> Utility -> ATP Regen And Process -> ATP Processing, the following screen is displayed: In the field “5. Planning Type to Show?” the user can enter one of the following values: P = Plan Order ...

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