Book Image

Microsoft Dynamics GP 2013 Financial Management

By : Ian Grieve
Book Image

Microsoft Dynamics GP 2013 Financial Management

By: Ian Grieve

Overview of this book

Microsoft Dynamics GP 2013 is a mature accounting software, ERP application, which is aimed at making life easier for financial professionals. This book is to assist readers in improving their use of Microsoft Dynamics GP by showing them how to get the most out of the financial aspect of the system. Microsoft Dynamics GP 2013 Financial Management is intended to add value to your organization by making use of additional modules and processes by introducing readers, new or experienced, to some of the financial management modules of Dynamics GP, such as Analytical Accounting, Cash Flow Management, and Encumbrance Management. Microsoft Dynamics GP 2013 Financial Management introduces the six essential financial modules. You will get acquainted with accounting to enable reporting, before gaining an oversight into inflow and outflow of cash. Budget studies cover all aspects of budget use in Dynamics GP for comparing actual figures against the budgets created and maintained within the system. The final chapters cover PO Commitments and Encumbrance Management; two sides of the same coin. Both modules allow for the control of purchasing by either committing or encumbering the transactions and preventing overspending.
Table of Contents (14 chapters)
Microsoft Dynamics GP 2013 Financial Management
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Creating a budget with Microsoft Excel


Budgets can be created in Dynamics GP directly, but the most efficient way of creating a budget for use in Microsoft Dynamics GP is to create it using Microsoft Excel.

There are four steps to create a budget in Dynamics GP. They are as follows:

  1. Create the budget.

  2. Export the budget to Microsoft Excel from Dynamics GP.

  3. Edit the budget in Microsoft Excel.

  4. Import the budget back into Dynamics GP.

It is strongly recommended that the budget be created in Dynamics GP and exported to Microsoft Excel for editing, as the import process requires the structure of the file to be exactly the same as the one being exported. The attempts to create the budget template manually can be very problematic.

To create a budget in Microsoft Excel, follow the given steps:

  1. Open the Budget Selection window in Dynamics GP by clicking on Financial from the Navigation Pane on the left, and then clicking on Budgets in the area page under Cards | Financial.

  2. Click on the New button and then...