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.
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.
- N - Purchase order data will not be included in the output.
- P - Only Unposted warehouse/legacy receiving transactions will be included in the purchase order section of the report.
- 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.
- 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.
- N - Sales order data will not be included in the output.
- O - Only open quantities excluding back ordered quantities will be included in the output.
- 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.