O cash pilot, a cash flow management solution developed by MPL, was created to meet the requirements of several of our customers. clients and fill a functionality gap in JD Edwards. The end result is presented as an additional feature of the system, since it was developed using JD Edwards' own tools, with the same standards as online and batch applications.

1. Benefits

• Integrates Cash Flow management with other JD Edwards financial administrative operations;
• Allows for short and medium term planning, including already confirmed transactions (Accounts Payable and Accounts Receivable) and forecast transactions (Open Purchase Orders and Sales Orders not yet invoiced);
• It improves decision making based on the management of each company's cash flow, bringing operational gains.

• Cash Flow Detail: Estimated and Realized;
• Manual Adjustments to Estimated and Realized Cash Flow;
• Configuration of Banking Operations;
• Cash Flow Inquiries, comparing estimated and realized positions;
• Cash Flow Reports: Estimated, Realized, with detailed or consolidated positions.

   

3. How It Works

By extracting data from the JD Edwards Original Modules - Accounts Payable, Accounts Receivable, Purchasing and Sales - the system builds a database containing dates and amounts receivable, as well as information related to clients and suppliers;

Due dates related to Purchase Orders are calculated using the estimated delivery date and payment term of the order; the due date related to Sales Orders considers the estimated billing date and also the payment term of the sales order;

In addition to the information retrieved from the original JD Edwards modules, the cash pilot also takes into account manual adjustments made directly to your database;

From this point, the user defines a series of parameters for the presentation of the cash flow: consolidated or detailed, date range to be visualized, bank accounts to be considered and the visualization currency;

Queries and Reports retrieve information from the Cash Flow database, and combine them with the parameters made by the user, presenting the desired results.

4. Assumptions

• The product cash pilot is compatible from version 9.0 of JD Eddwards;
• Due to the different levels of ESUs installed in each client, some kind of adjustment to the cash pilot may be necessary;
• Before the cash pilot, We have to ensure that no objects customized by the client match the objects created by the MPL;
• It is not within the scope of the project to implement other JD Edwards modules. For example: if the purchasing module is not implemented in JD Edwards, there will be no records – in the cash flow – corresponding to this JDE module.

5. Deployment Service

Considering that there will be no coincidence of objects between those developed by MPL and those already customized by the client, the project lasts approximately 15 working days. The project duration can be revised according to the scope agreed between MPL and the client, and will be part of the first project activity.