P-052848: From Spreadsheets to System of Record: Implementing JDE EnterpriseOne Cash Forecasting for Daily Treasury Visibility

This session was presented at INFOCUS 2026.

Most JD Edwards customers manage cash forecasting in disconnected spreadsheets pulling AR aging, AP aging, and GL balances by hand, reconciling against bank balances, and emailing static workbooks to Treasury. The result is stale numbers, no audit trail, and limited visibility into daily, weekly, or rolling cash positions. JDE already ships with a powerful, fully integrated Cash Forecasting capability inside General Accounting that pulls live data from the AR Ledger, AP Ledger and GL Detail into a Cash Forecast Data table without redundant data entry. This session walks through a real-world implementation of the JDE Cash Forecasting module and shows how Treasury and Finance teams gain a daily, defensible view of cash positions directly inside their ERP. Attendees will learn how to configure cash type codes and rules to map AR invoices, AP vouchers, and GL bank balances into Opening Balances, Incoming Cash, Outgoing Cash, Net Operating, and Total Cash Forecast. Learn how to build a cash forecast structure to mirror Treasury’s reporting expectations that can be refreshed by based-on dates and future-day horizons for daily, 30-day, and 90-day rolling forecasts and visualize insights using the Cash Forecast Analysis application or report for daily review. Walk away with a working blueprint to replace spreadsheet-driven cash forecasting with a governed, automated, JDE-native solution.

This session is eligible for the following CPE certification: NASBA

Speaker: Doug Roesch, Grant Thornton Advisors LLC