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 Parameters Setting ID - This is a required field. F7/F8 search support is available with the ability to add a parameter setting ID. The user is required to add an ID the first time the report is run. Pressing the F7 or F8 key will launch the parameter setting ID search. See https://support.netcellent.com/portal/en/kb/articles/feature-report-parameters-setting-id-support for more information on how to set up this option.
15. Create CSV File? - Default is N. Answer Y if you would like to send this output to CSV. Answering Y will divert the detail information normally printed on this report to the CSV output file instead.
For example, if the Create CSV File option is set to Y, the report output will contain the summary section of the report. No detail information will be printed and all of the detail information will be provided in the CSV file.
16. CSV File Path and Name - Enter the CSV file path and name. Formats YYYYMMDD, YYMMDD, YYMM, MMDD are supported. For example, if today's date is 06/11/2025, the following formats will be supported:
- YYYYMMDD: 20250611
- YYMMDD: 250611
- YYMM: 2506
- MMDD: 0611
The last page of the printed report now includes a full list of the parameters chosen for the report.
Criteria Used For This Report:
Parameter Settings ID:
Projection Date
Beginning G/L Cash Account
Ending G/L Cash Account
Current G/L Cash Account Balance
Include Additional A/R Dist Cash
Include Additional A/P Dist Cash
Include Additional P/R Dist Cash
Project Accounts Receivable ?
Based On Option
Project Accounts Payable ?
Based On (D)ue Date Or (I)nvoice
Paid on Due/Inv Date + or - Days
Take Advantage of Early Pay Disc?
Project Purchase Orders ?
Project COP Sales?
Ship Date Distribution
30 Days
60 Days
90 Days
120 Days
# Days In Period 1
# Days In Period 2
# Days In Period 3
# Days In Period 4
Period 1 Description
Period 2 Description
Period 3 Description
Period 4 Description
Report Format
Enter Additional Adjustment?
Create CSV File?
CSV File Path and Name
The following columns are included in the CSV file:
- Package - Package where the detail amounts originated
- RefNo - Vendor or customer number
- DocNo - Document number
- Tp - Document type - For recurring vouchers this is the type of recurrence. For COP line items C=Credit, I=Invoice, S=Selected for O type order, x=Invoice Printed for C, I, or O type order, and Blank=Regular Open Order for O type order.
- Interval - Recurring voucher interval
- TrxDate - Document date
- DueDate - Due date
- AvgPayDays - Average days to pay
- Terms
- ItemNo - Item number for COP and PO line items
- QtyOrder - Quantity ordered for COP and PO line items
- UnitPrice - Price for COP line items and cost for PO line items
- DistAmt - Distribution amount for A/R, A/P or Payroll distributions if printed in detail
- AdjToBegin - Adjustment to beginning balance
- NetAmt - Net document amount
- Age - Document Age
- Period 1
- Period 2
- Period 3
- Period 4
The top line of the CSV will be the opening balance as entered on the report parameter screen. If the A/R, A/P, or Payroll distributions are included with the summary option, the summary amounts are also included in the top portion of the report. If additional adjustments are entered for A/R, A/P, Payroll, PO or COP, the amounts for each period are included in the top portion of the report.
The detail that is printed will be summarized on the Totals line. The Projected Balance Based On Detail line should match the Projected Balance Based On Summary line at the end of the CSV file. Changing anything above the Totals line will affect the Totals and the Projected Balance Based On Detail lines, but will not be reflected in the summary section at the end of the CSV file. The summary section shows what was printed on the summary page of the physical report.
Programs Modified: APCSHPJS, APCSHPJP
CLS
Related Articles
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 ...Feature - Report Parameters Setting ID Support
Release Date: 5/30/25 Version: 8.5 and Above This enhancement improves Elliott report printing capability by providing the following features: Allows the user to save report parameters to be used again. This is especially helpful for those reports ...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 - Added User ID to User Defined CSV Export
Release Date - 01/29/18 The User-Defined CSV Export option has been added to I/M-> Reports. Users can now grant/deny access to this application from Password Setup. When running the application from this location in the menu system, the User-ID ...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 ...