Microsoft Dynamics GP 2013 Financial Management

Ian Grieve

• Publisher: Packt Publishing
• Year: 2013
• eBook ISBN: 9781782171300
• Edition: 1
• Topic: Computer Science
• Subtopic: Business Intelligence
• Index: Computer Science

In Detail

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.

Approach

A standard tutorial-based approach covering Microsoft Dynamics GP 2013 and its six financial modules. The book is intended to allow users to improve their system use and workflow by introducing new modules to assist in financial management.

Who this book is for

This book is for you if you're a Dynamics GP partner, or Dynamics GP user, primarily focused on delivering application optimizations. This book assumes that you have a working knowledge of Microsoft Dynamics GP and have an understanding of the requirements of financial management.

Microsoft Dynamics GP 2013 Financial Management

---

Table of Contents

Microsoft Dynamics GP 2013 Financial Management

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Analytical Accounting

Creating default records

Setting up posting options

Activating Analytical Accounting

Assigning security roles and tasks

Configuring Analytical Accounting options

Configuring Assignment Setup

Creating transaction dimensions and dimension codes

Setting up an accounting class

Granting user access to transaction dimensions

Entering a transaction with Analytical Accounting information

Duplicate analysis information when copying a transaction

Integration of Analytical Accounting with Fixed Asset Management

Creating an Analytical Accounting budget

Analytical Accounting budgets in Microsoft Excel

Year-end processing

Activating Analytical Accounting in an existing system

Analytical Accounting inquiries

Transaction Dimension Relation

Analytical Accounting – Journal Entry Inquiry

Distribution Query Wizard

Multilevel Query Wizard

Analytical Accounting Budget vs Actual Inquiry

Analytical Account SmartLists

Summary

2. Cash Flow Management

Creating a cash flow forecast

Using the Cash Flow Calendar

Viewing other cash flow forecasts

Launching Cash Flow Calendar from Cash Flow Explorer

Printing weekly cash flow reports

"What if?" transactions

Summary

3. Budget Creation and Maintenance

Creating a budget with Microsoft Excel

Editing a budget in Microsoft Excel

Importing a budget from Microsoft Excel

Maintaining budgets

Combining budgets

Entering budget transactions

Summary

4. Budget Reporting

Inquiries

Budget Summary Inquiry

Budget vs. Actual Inquiry

Budget Journal Entry Inquiry

Budget Transaction Summary Inquiry

Account Rollup Inquiry

Detailed budget report

Budgets in Management Reporter 2012

Creating the row definition

Creating the column definition

Creating the report definition

Summary

5. Purchase Order Commitments

Enabling PO Commitments

Entering a Purchase Order Commitment

Budget vs Actual & Committed Inquiry

Summary

6. Encumbrance Management

Setting up Encumbrance Management

Encumbrance statuses

Transaction entry

Encumbrance inquiries

Encumbrance Summary Inquiry

Encumbrance Detail Inquiry

Encumbrance PO Inquiry

Encumbrance GL Inquiry

Encumbrance Reports

Year-end processes

Summary

Index

Microsoft Dynamics GP 2013 Financial Management

Copyright © 2013 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: September 2013

Production Reference: 1300813

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-78217-130-0

www.packtpub.com

Cover Image by Aniket Sawant (<[email protected]>)

Credits

Author

Ian Grieve

Reviewers

Mark Polino, CPA

Jivtesh Singh

Acquisition Editor

Akram Hussain

Commissi...

Table of contents

• Microsoft Dynamics GP 2013 Financial Management