Microsoft Dynamics™ GP
Cash Flow Management

---

Copyright
Copyright © 2007 Microsoft Corporation. All rights reserved.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the
rights under copyright, no part of this document may be reproduced, stored in or introduced into
a retrieval system, or transmitted in any form or by any means (electronic, mechanical,
photocopying, recording, or otherwise), or for any purpose, without the express written
permission of Microsoft Corporation. Notwithstanding the foregoing, the licensee of the software
with which this document was provided may make a reasonable number of copies of this
document solely for internal use.
Trademarks
Microsoft, Dexterity, and Microsoft Dynamics, are registered trademarks or trademarks of
Microsoft Corporation or its affiliates in the United States and/or other countries. FairCom and
c-tree Plus are trademarks of FairCom Corporation and are registered in the United States and
other countries.
The names of actual companies and products mentioned herein may be trademarks or registered
marks - in the United States and/or other countries - of their respective owners.
Unless otherwise noted, the example companies, organizations, products, domain names, e-mail
addresses, logos, people, places, and events depicted herein are fictitious. No association with
any real company, organization, product, domain name, e-mail address, logo, person, place, or
event is intended or should be inferred.
Intellectual property
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual
property rights covering subject matter in this document. Except as expressly provided in any
written license agreement from Microsoft, the furnishing of this document does not give you any
license to these patents, trademarks, copyrights, or other intellectual property.
Warranty disclaimer
Microsoft Corporation disclaims any warranty regarding the sample code contained in this
documentation, including the warranties of merchantability and fitness for a particular purpose.
Limitation of liability
The content of this document is furnished for informational use only, is subject to change without
notice, and should not be construed as a commitment by Microsoft Corporation. Microsoft
Corporation assumes no responsibility or liability for any errors or inaccuracies that may appear
in this manual. Neither Microsoft Corporation nor anyone else who has been involved in the
creation, production or delivery of this documentation shall be liable for any indirect, incidental,
special, exemplary or consequential damages, including but not limited to any loss of anticipated
profit or benefits, resulting from the use of this documentation or sample code.
License agreement
Use of this product is covered by a license agreement provided with the software product. If you
have any questions, please call the Microsoft Dynamics GP Customer Assistance Department at
800-456-0025 (in the U.S. or Canada) or +1-701-281-6500.
Publication date
March 2007

---

Contents
Introduction ............................................................................................................................................... 1
What’s in this manual................................................................................................................................... 1
Symbols and conventions ............................................................................................................................ 2
Resources available from the Help menu.................................................................................................. 2
Send us your documentation comments ................................................................................................... 4
Chapter 1: Cash flow forecasts and transactions.................................................. 5
Setting up cash flow forecasts ..................................................................................................................... 5
Entering “what if?” cash flow transactions............................................................................................... 9
Troubleshooting .......................................................................................................................................... 10
Chapter 2: Inquiries and reports........................................................................................... 11
Using the Cash Flow Calendar window ................................................................................................. 11
Transaction inquiry using Cash Flow Explorer ...................................................................................... 13
Printing weekly reports.............................................................................................................................. 15
Printing the Monthly Calendar report..................................................................................................... 17
C A S H F L O W M A N A G E M E N T
i

---

ii
C A S H F L O W M A N A G E M E N T

---

Introduction
You can use Cash Flow Management to predefine an opening balance for a forecast,
based on a single cash management transaction or a specific General Ledger
account balance. You also can base a forecast on one or more checkbook balances
with or without work/adjust transactions, such as deposits, payments, and
reconciliation adjustments that are not part of the checkbook balance.
Cash Flow Management is installed automatically when you install Microsoft
Dynamics™ GP. You must have the appropriate registration keys to use it, however.
For additional information about entering registration keys, refer to the Installation
Instructions manual.
You also can use Cash Flow Management to complete the following tasks:
•
Create an unlimited number of cash flow forecast definitions
•
Forecast cash flows in different ways
•
Create scenarios without actually recording transactions
•
Summarize daily inflows and outflows of cash in the calendar window
•
View the summary of any given day’s cash inflow and outflow
•
Obtain weekly—detailed or summary—and monthly calendar reports
This introduction is divided into the following sections:
•
What’s in this manual
•
Symbols and conventions
•
Resources available from the Help menu
•
Send us your documentation comments
What’s in this manual
This manual is designed to give you an understanding of how to use the features of
Cash Flow Management, and how it integrates with the Microsoft Dynamics GP
system.
To make best use of Cash Flow Management, you should be familiar with
systemwide features described in the System User’s Guide, the System Setup
Guide, and the System Administrator’s Guide.
Some features described in the documentation are optional and can be purchased
through your Microsoft Dynamics GP partner.
To view information about the release of Microsoft Dynamics GP that you’re using
and which modules or features you are registered to use, choose Help >> About
Microsoft Dynamics GP.
The manual is divided into the following chapters:
•
Chapter 1, “Cash flow forecasts and transactions,” explains how to set up cash
flow forecast definitions and enter cash flow transactions, and how to
troubleshoot common problems.
•
Chapter 2, “Inquiries and reports,” describes how to forecast day-to-day cash
flow balances.
C A S H F L O W M A N A G E M E N T
1

---

I N T R O D U C T I O N
Symbols and conventions
For definitions of unfamiliar terms, see the glossary in the manual or refer to the
glossary in Help.
Symbol
Description
The light bulb symbol indicates helpful tips, shortcuts and
suggestions.
The warning symbol indicates situations you should be especially
aware of when completing tasks.
The multicurrency symbol points out features or procedures that
apply if you’re using Multicurrency Management.
This manual uses the following conventions to refer to sections, navigation and
other information.
Convention
Description
Creating a batch
Italicized type indicates the name of a section or procedure.
File >> Print or File >
The (>>) or (>) symbol indicates a sequence of actions, such as
Print
selecting items from a menu or toolbar, or pressing buttons in a
window. This example directs you to go to the File menu and choose
Print.
TAB or ENTER
All capital letters indicate a key or a key sequence.
Resources available from the Help menu
The Microsoft Dynamics GP Help menu gives you access to user assistance
resources on your computer, as well as on the Web.
Contents
Opens the Help file for the active Microsoft Dynamics GP component, and displays
the main “contents” topic. To browse a more detailed table of contents, click the
Contents tab above the Help navigation pane. Items in the contents topic and tab
are arranged by module. If the contents for the active component includes an
“Additional Help files” topic, click the links to view separate Help files that
describe additional components.
To find information in Help by using the index or full-text search, click the
appropriate tab above the navigation pane, and type the keyword to find.
To save the link to a topic in the Help, select a topic and then select the Favorites tab.
Click Add.
Index
Opens the Help file for the active Microsoft Dynamics GP component, with the
Index tab active. To find information about a window that’s not currently displayed,
type the name of the window, and click Display.
2
C A S H F L O W M A N A G E M E N T

---

I N T R O D U C T I O N
About this window
Displays overview information about the current window. To view related topics
and descriptions of the fields, buttons, and menus for the window, choose the
appropriate link in the topic. You also can press F1 to display Help about the current
window.
Lookup
Opens a lookup window, if a window that you are viewing has a lookup window.
For example, if the Checkbook Maintenance window is open, you can choose this
item to open the Checkbooks lookup window.
Show Required Fields
Highlights fields that are required to have entries. Required fields must contain
information before you can save the record and close the window. To change the
way required fields are highlighted, choose Microsoft Dynamics GP menu >> Tools
>> Setup >> User Preferences >> Display, and specify a different color and type
style.
Printable Manuals
Displays a list of manuals in Adobe Acrobat .pdf format, which you can print or
view.
Orientation Training
Accesses online tutorials that show you how to complete basic procedures within
Microsoft Dynamics GP. Additional tutorials are available through the
CustomerSource Web site.
What’s New
Provides information about enhancements that were added to Microsoft Dynamics
GP since the last major release.
Microsoft Dynamics GP Online
Opens a Web page that provides links to a variety of Web-based user assistance
resources. Access to some items requires registration for a paid support plan.
Current implementation and upgrade information The most recent
revisions of upgrade and implementation documentation, plus documentation
for service packs and payroll tax updates.
User documentation and resources The most recent user guides, how-
to articles, and white papers for users.
Developer documentation and resources The most recent
documentation and updated information for developers.
Product support information Information about the Microsoft Dynamics
GP product support plans and options that are available, along with
information about peer support and self-support resources.
Services information Information about Microsoft Dynamics GP support,
training, and consulting services.
C A S H F L O W M A N A G E M E N T
3

---

I N T R O D U C T I O N
Microsoft Dynamics GP Community Access to newsgroups, where you
can ask questions or share your expertise with other Microsoft Dynamics GP
users.
CustomerSource home page A wide range of resources available to
customers who are registered for a paid support plan. Includes access to
Knowledge Base articles, software downloads, self-support, and much more.
U.S. Payroll Updates
Provides access to tax updates for state and federal tax withholding. When you
select an option, the process to install the updates will begin immediately.
Check with your system administrator before installing tax updates. To be sure that tax
updates are installed correctly, refer to documentation for specific tax updates on the
CustomerSource Web site.
Customer Feedback Options
Provides information about how you can join the Customer Experience
Improvement Program to improve the quality, reliability, and performance of
Microsoft software and services.
Send us your documentation comments
We welcome comments regarding the usefulness of the Microsoft Dynamics GP
documentation. If you have specific suggestions or find any errors in this manual,
send your comments by e-mail to the following address: bizdoc@microsoft.com.
To send comments about specific topics from within Help, click the Documentation
Feedback link, which is located at the bottom of each Help topic.
Note: By offering any suggestions to Microsoft, you give Microsoft full permission to use
them freely.
4
C A S H F L O W M A N A G E M E N T

---

Chapter 1:
Cash flow forecasts and transactions
You can create and keep an unlimited number of cash flow forecast definitions. The
cash flow forecasts that you define will be displayed in the Cash Flow Calendar and
the Cash Flow Explorer.
“What if” transactions (external inflow and outflow transactions that are not
actually entered in Microsoft Dynamics GP) let you see what effect actual
transactions will have on your cash flow.
This information is divided into the following sections:
•
Setting up cash flow forecasts
•
Entering “what if?” cash flow transactions
•
Troubleshooting
Setting up cash flow forecasts
The Cash Flow Forecast window is divided into four main sections: Financial, Sales,
Purchasing, and General. You will use these sections to customize your cash flow
forecast as follows:
Financial This section specifies the opening balance of your forecast. Choose
checkbook ID balance(s), a flat amount, and/or a General Ledger account balance.
Sales This section specifies whether your forecast will include transactions from
Receivables (Open and/or Work) and/or Sales Order Processing documents.
Purchasing This section specifies whether your forecast will include transactions
from Payables (Open and/or Work) and/or Purchase Order Processing documents.
General This section specifies whether your forecast will include Cash Flow
Transactions and the number of weeks the Explorer Reports will display.
To set up cash flow forecasts:
1.
Open the Cash Flow Forecast window.
(Microsoft Dynamics GP menu>> Tools >> Setup >> Financial >> Cash Flow
Forecast)
C A S H F L O W M A N A G E M E N T
5

---

C H A P T E R 1 C A S H F L O W F O R E C A S T S A N D T R A N S A C T I O N S
2.
Enter or select a Forecast ID.
3.
To save this Forecast ID as the default forecast, mark the Default option. The
default forecast appears in both the Cash Flow Calendar and the Cash Flow
Explorer. You can change the default forecast at any time, by selecting another
Forecast ID and making it the default.
If you create multiple forecasts, it is recommended that you select one as the default
forecast. If you do not select a default, Cash Flow Management automatically selects the
first forecast as the default.
4.
Enter a description for the Forecast ID selected.
5.
To include an opening balance in your forecast, mark the appropriate options.
You may include a specific amount, an account balance, and/or the balance of
one or more checkbooks.
Select the checkbook IDs that you wish to include. To mark all checkbooks,
mark the All check box. To unmark all checkbooks, unmark the All check box.
If Multicurrency Management is registered, you must enter an exchange rate
and select either the Multiply or Divide method for any non-functional
currency checkbooks selected. Cash Flow Management will use this
information to convert the non-functional currency checkbook balance into
your functional currency. Functional currency checkbook IDs do not require an
exchange rate.
To include deposits, payments, and reconciliation adjustments that are not part
of the Checkbook ID balance, mark Include Work/Adjustment Transactions
(only available for marked checkbooks).
If Bank Reconciliation is registered, payments or deposits received with Sales
documents will be displayed as negative values in the Calendar and Explorer.
Cash Flow Management works this way to prevent doubling up these amounts
which may already be included in the forecast ID if the checkbook including
these deposits is marked.
If you enter individual transactions to your general ledger, as in Quick Journal entries
for example, these transactions will not follow through to your checkbook and will not
be included in Cash Flow Management forecasts. Always post transactions directly to
your checkbook to avoid creating this situation.
6.
To include Receivables Management transactions in your forecast, mark the
appropriate options. You may include Open (posted) transactions and/or Work
(unposted) transactions. Open transactions will include scheduled payments.
6
C A S H F L O W M A N A G E M E N T

---

Document Outline

• Copyright
• Contents
• Introduction
  • Whats in this manual
  • Symbols and conventions
  • Resources available from the Help menu
  • Send us your documentation comments
• Chapter 1: Cash flow forecasts and transactions
  • Setting up cash flow forecasts
  • Entering what if?Ž cash flow transactions
  • Troubleshooting
• Chapter 2: Inquiries and reports
  • Using the Cash Flow Calendar window
  • Transaction inquiry using Cash Flow Explorer
  • Printing weekly reports
  • Printing the Monthly Calendar report

---