Share This Post

GP Updates

GP Cash Flow Management Inquiries and Reports

To make best use of GP Cash Flow Management Inquiries and Reports, you should be familiar with system wide features described in the System Users Guide, the System Setup Guide and the System Administrators Guide.

Cash Flow Management gives you customizable views and forecasting tools that enable you to control, predict, and monitor inflows and outflows that track your organization’s liquidity over time.

GP Cash Flow Management Inquiries and Reports

Use the Cash Flow Calendar and the Cash Flow Explorer to perform inquiries. You can use the same windows to generate the following reports:

  • Weekly Summary Report
  • Weekly Summary by Source Report
  • Weekly Detail by Source Report
  • Monthly Calendar Report

Information is divided into the following sections:

  • Using the Cash Flow Calendar window
  • Transaction inquiry using Cash Flow Explorer
  • Printing weekly reports
  • Printing the Monthly Calendar report

1. Using the Cash Flow Calendar Window

The GP Cash Flow Management Inquiries and Reports Calendar displays inflows and outflows based on the default forecast you set up in the Cash Flow Forecast window. You can utilize the Cash Flow Calendar to scroll to the different months, or to open to a specific day and view your transactions.

In the Cash Flow Calendar, outflows display in red, the balance to date is shown in black and inflows appear in blue.

To use the Cash Flow Calendar window:

  • Open the Cash Flow Calendar window. (Inquiry >> Financial >> Cash Flow Calendar)
  • To view the cash flow forecast for a different month, use the Go To button on the window toolbar.
  1. To view the cash flow forecast from the previous or next month, click the forward or back arrow.
  2. To view a specific month’s forecast, click the Go To button between the arrows. The CFM Calendar Month window opens. From the month dropdown list, select a month. Change the year if necessary and then choose OK.
  • To print the entire month as displayed, click the Print button.
  • To view the detail for a specific day, move the cursor over the date and click; the Cash Flow Explorer will appear listing the transactions for the day you selected.
  • If you make changes to your forecast while the Calendar window is open, click the Refresh button to see the resulting data changes in the open Calendar window.

2. Transaction Inquiry using Cash Flow Explorer

The GP Cash Flow Management Inquiries and Reports Explorer displays a detailed listing of all source documents that make up the net change in cash flow for any given day. It displays the hierarchy of transactions and provides information in an expandable outline.

When you choose a given date on the Cash Flow Calendar, the Cash Flow Explorer opens the source documents for that date and gives detailed information at your fingertips. The settings in the Explorer are based on the default forecast definition settings as the predefined in the Cash Flow Forecast window.

With Cash Flow Explorer, you can easily change the forecast period to a different day, month or even an year. The Cash Flow Explorer provides various reports and inquiries for supporting or original documents.

To use the Cash Flow Explorer:

  • Open the Cash Flow Explorer. (Inquiry >> Financial >> Cash Flow Explorer)
  • Use the controls in the window.

3. Printing Weekly Reports

Week 0 on all of the weekly reports indicates the running balance of all the transactions prior to the start date. The initial date for all the weekly reports is based on the current GP Cash Flow Management Inquiries and Reports Explorer date. The quantity of weeks in the report is based on the number of weeks as predefined in the Explorer Report Options field in the Cash Flow Forecast window.

To display any of the reports weekly:

  • Open the Cash Flow Explorer. (Inquiry >> Financial >> Cash Flow Explorer)
  • Choose the Print icon, and then from the drop-down menu, select the report of your choice: Weekly Summary, Weekly Summary by Source, or Weekly Detail by Source. The Report Destination dialog box appears.
  • Select the destination(s) for the report and click OK.

Weekly Summary Report

The Weekly Summary report displays a summary of the weekly cash flow net change for a fixed number of weeks beginning with the current Cash Flow Explorer date. The number of weeks for this report was defined in the Cash Flow Forecast window (Explorer Report Options field).

Weekly Summary by Source Report

The Weekly Summary by Source report is a weekly cash flow net change report for a fixed number of weeks the number of weeks defined in the Cash Flow Forecast window. This report shows the subtotals of the Forecast definition options.

Example, the RM Open indicates the summary of all Receivables Management transactions that are posted. This report includes the week number, the source description, start and end dates, net change, and balance for each week.

Weekly Detail by Source Report

The Weekly Detail by Source report is a weekly cash flow net change report for a fixed number of weeks which displays the detail of the Forecast definition options.

Example, the RM Open indicates the detail of all supporting documents for that given week. It includes the week number, the source description, start and end dates, Transaction ID (Customer ID or Vendor ID depending on the source), document number, document date, due date, remaining amount, and balance for each week.

4. Printing the Monthly Calendar Report

The Monthly Calendar report prints a snapshot of the current Cash Flow Calendar month. It also displays the net inflows, net outflows, and balance to date as you would see on the Cash Flow Calendar.

To print the Monthly Calendar report:

  • Open the Cash Flow Calendar. (Inquiry >> Financial >> Cash Flow Calendar)
  • Click either the Previous or the Next button to proceed to the month for which you want to print a report.
  • Choose File >> Print; the Report Destination dialog box appears.
  • Select the destination(s) for the report and click OK.

Cash flow management helps in keeping track of the cash flow and analyzing any changes to it. This will assist you to spot trends, prepare for the future and tackle any problems with your cash flow. For more information on Microsoft Dynamics GP Cash Flow Management Inquiries and Reports, please contact us.

Share This Post

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Skip to toolbar