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

Entering a transaction with Analytical Accounting information


With the setup of Analytical Accounting that we have covered so far in this recipe, we are now able to start entering transactions, and record the additional information via the transaction dimensions.

To enter a payable transaction with Analytical Accounting information, perform the following steps:

  1. Open the Purchase Order Entry window in Dynamics GP by selecting Purchasing from the navigation pane on the left, and then clicking on Purchase Order Entry in the area page under Transactions.

  2. Leave the Type: field as Standard, and tab through the PO Number field to have a purchase order number assigned.

  3. Enter IMAGEMAK0001 in the Vendor ID field.

  4. Enter MARKETING in the Item field.

  5. Enter Each in the U of M field.

  6. Enter 1 in Quantity Ordered.

  7. Enter a unit cost of $10,000 in the Unit Cost field.

  8. Enter Online Marketing in the Description field.

  9. Enter NORTH in Site ID.

  10. Click on the blue expansion arrow button next to the Item field header to open Purchase Item Detail Entry.

  11. Click on the Analytical Accounting button next to the Purchases Account field to open the Analytical Purchase Order Entry window.

  12. Change the Assign % field to 66.67%.

  13. Enter ONLINEADS in the Alphanumeric column of the scrolling window.

  14. Enter Online adverts via adsense in the Reference field (this field is restricted to 30 characters).

  15. Click on the Assign % column on the second row, and enter 33.33%.

  16. Enter Sponsored tweets in the Reference field.

  17. Enter TWITTER in the first row of the Alphanumeric column.

  18. Click on OK to save, and close the Analytical Payables Transaction Entry window.

  19. Click on Save, and close the Purchasing Item Detail Entry window.

  20. Click on Save, and then close the Purchase Order Entry window.

Analytical Accounting transaction dimension information can be broken down on each distribution line by changing the Originating Amount or Assign % values on the Analytical Payables Transaction Entry window, and then entering an Originating Amount or Assign % on the next line, in the scrolling window.

Microsoft Dynamics GP 2013 has seen several enhancements to the Analytical Accounting series such as integration to the Fixed Asset Management and the ability to duplicate analysis information when copying a transaction.

Duplicate analysis information when copying a transaction

Analysis information can be copied for three types of transactions: Purchase Orders, Sales Orders, and posted General Ledger transactions.

In each of the copy transaction windows, a new checkbox has been added. For example, in the Copy Journal Entry window, a new Copy Analytical Accounting Information checkbox has been added.

The same functionality has been added to the copy of Purchase and Sales Orders.

Integration of Analytical Accounting with Fixed Asset Management

In Dynamics GP 2013, Fixed Asset Management has been enhanced to allow the entry of analysis information for distribution accounts, which are linked to an account class. With the batch enhancements also added to Fixed Assets General Ledger Posting, the analysis information can be saved prior to posting the batch.