10 cash flow

Cash Flow Management in Microsoft Dynamics AX 2012 R2 Case Study Workshop 10 Microsoft Corporation Soheil Aghazadeh 1/1/2013

Cash Flow Management in Microsoft Dynamics AX 2012 R2

Microsoft Corporation. All rights reserved. Page 1

Last Revision: January 16th 2013 This workshop is provided as-is. Information and views expressed in this workshop, including URL and other Internet Web site references, may change without notice. Unless otherwise noted, the examples depicted herein are provided for illustration only and are fictitious. No real association or connection is intended or should be inferred. This workshop does not provide you with any legal rights to any intellectual property in any Microsoft Corporation product. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this workshop may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means or for any purpose, without the express written permission of Microsoft Corporation. Copyright 2012 Microsoft Corporation. All rights reserved. Microsoft, Microsoft Dynamics, Microsoft PowerPoint, Microsoft SQL Server data management software and Microsoft Dynamics AX are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners. This course content is designed for Microsoft Dynamics AX 2012 R2

Authors Bio:

Soheil Aghazadeh is a Microsoft Certified Master, and Microsoft Certified Trainer. He holds more than 32 industry certifications including MCT, MCSE+I, MCSD, MCSA, MCDST, MCITP, MCTS, MCP+I, MCDBA, MSF Practitioner, Microsoft Dynamics ERP, and Microsoft Windows Embedded. His experience covers a spectrum of areas. He has over 20 years business experience in service and manufacturing industries. He specializes in Microsoft Dynamics AX and has been working with it since version 3.0. He is currently a freelance contractor, in ERP training, development and consulting. His worldwide consulting engagements range from implementation and designing ERP for small size businesses to large enterprises. He excels in solution architecture and ERP customization and development and his real-world experience is one of his greatest strengths. As a Microsoft-endorsed trainer, he has trained worldwide partners, including those attending The Microsoft Dynamics AX 2012 Enterprise Academy in North America (Fast TrAX), Europe, and Asia Pacific as well as Microsoft Consulting Services (MCS), Microsoft Product Support Services (PSS) technicians, Center of Excellence, COE and Sr. Technical Product Managers at Microsoft. Soheil has been a technical reviewer for the Microsoft Official Curriculum, an author for Microsoft, and created self-paced videos for official Microsoft training, official webinar as well as workshops for Microsoft Partner Network program, Partner Academy and in Microsoft Dynamics Partner Source portal.



Seahorse Retailers Cash Flow Seahorse Retailers controller, Sabrina, needs to check the cash flow in company. She considers the bank account as her main liquidity account. You need to setup the cash flow in the system for 100% of the amount of the transactions and only 60% of the approved budget.

You need to demonstrate cash flow management along with workflow process to Sabrina.



Challenge yourself: High-level activity description Step number Module Entry point Step General Ledger 15 General ledger Main Accounts Setup cash flow for both transactions and

budget in Seahorse Retailers.



Proposed Step by Step Solution: Step 15: Cash Flow 1. Click Area Page node: General ledger -> Setup -> Posting -> Liquidity.

2. Verify that you have account 10000 and 10001 listed as illustrated above.

3. Click the New button.

4. Change Main account from '' to '50000'.

5. Close the Liquidity form.

6. Click Area Page node: General ledger -> Common -> Main accounts.



7. Make sure the selection is changed in table Main account to:

Main account Name Main account type Main account category

10000 Bank of Ireland Profit and loss CASH

8. Click the Main accounts -> Related information -> Cash flow forecasts button.

9. Verify that there are no records, since we have not setup the cash flow for this account.

10. Close the Cash flow forecasts form.

11. Click the Main accounts -> Maintain -> Edit button.

12. Change Select the level of main account to display from 'Chart of accounts' to 'Companies'.

13. Click the Add company button and select SEA. (The button which has the plus sign on it)

14. Switch to the General tab on the Main accounts - chart of accounts: Seahorse COA form.



15. Click the View cash flow forecast button. You can also verify the cash flow transactions using this command. There are no records since we have not setup the cash flow for this account.


17. Under the Setup Fast tab, Click the Cash flow forecast button.

18. Change the percent field from '' to '100.00'.

19. Change Terms of payment from '' to 'N30'.


21. Note the default value of Transactions/Budget field is 'Transactions'.


23. Change the percent field from '' to '60.00'.



26. Change Transactions/Budget from 'Transactions' to 'Budget'.

27. Save the record in the Set up cash flow forecasts form.



28. Close the Set up cash flow forecasts form.

29. Switch to the General tab on the Main accounts - chart of accounts: Seahorse COA form.


Main account Name

50000 Expense Allocation

31. Change Select the level of main account to display from 'Chart of accounts' to 'Companies'.

32. Click the Add company button and select SEA. (The button which has the plus sign on it)

33. Switch to the Setup tab on the Main accounts - chart of accounts: Seahorse COA form.



34. Click the Cash flow forecast button.

35. Change Percent from '0.00' to '100.00'.



38. Make sure that the value of Transactions/Budget is Transactions.


40. Change Percent from '0.00' to '60.00'.



43. Change Transactions/Budget from 'Transactions' to 'Budget'.

44. Save the record in the Set up cash flow forecasts form.

45. Close the Set up cash flow forecasts form.

46. Close the Main accounts - chart of accounts: Seahorse COA form.

47. Click Area Page node: General ledger -> Journals -> General journal.




49. Select a General journal Name.

50. Change Description from 'General Journals' to 'General Journals - Cash Flow'.

51. Click the Lines button.

Note: From this step forward throughout the rest of the case studies, the values for department and cost center might be different from the ones proposed in these solutions. Please make sure to choose values that are available on your Dynamics AX image. Just make sure that you choose a different value for each step.

52. Change Account from '' to '50000-022-'.

53. Change Debit from '' to '1000.00'.

54. Change Offset account from '' to '20001-022-'.

55. Click the Validate -> Validate menu button.



56. Click the Close button.

67. Click the Inquiries -> Balance control menu button.

58. Close the Balance control form.

59. Close the Journal voucher form.

60. Close the General journal form.









65. Click Area Page node: General ledger -> Periodic -> Currency requirement -> Calculate cash flow forecasts.

66. Click the OK button.









71. Switch to the General tab on the Cash flow forecasts form.



72. Switch to the Overview tab on the Cash flow forecasts form.

73. Make sure the selection is changed in table Cash flow forecasts to:

Date Source Number Posting Amount 1/16/2013 GeneralJournalAccountEntry -1845.51






Date Source Number Posting Amount 2/6/2013 GeneralJournalAccountEntry 6500.00







80. Click the Cash flow forecasts button.









Date Source Number Posting Amount 2/6/2013 GeneralJournalAccountEntry 6500.00






89. Select the address SEA ->Budgeting -> Common -> Budget register entries -> All budget register entries.

90. Click the Budget register entry -> New -> Budget register entry button.

91. Change Budget model from '' to 'Sales'.

92. Change Budget code from '' to 'Orig'.

93. Save the record in the Budget register entry form.



94. Click the Add line button.

95. Change Account structure from '' to 'Seahorse P&L'.

96. Change Dimension values from '' to '50000-'.

97. Change Amount from '0.00' to '2000.00'.

98. Click the Add line button.

99. Change Dimension values from '' to '10000-'.

100. Change Amount from '0.00' to '5000.00'.

101. Change Amount type from 'Expense' to 'Revenue'.

102. Make sure the selection is changed in table Budget account entries to:

Budget check results

Date Account structure

Dimension values

Amount Amount type

Currency

1/7/2013 Seahorse P&L

10000- 5000.00 Revenue EUR

103. Switch to the Budget account entry details tab on the Budget register entry form.

104. Change Cash flow forecast from 'false' to 'true'.




Dimension values

Amount Amount type

Currency


50000- 2000.00 Expense EUR



106. Change Cash flow forecast from 'false' to 'true'.

107. Save the record in the Budget register entry form.




Dimension values

Amount Amount type

Currency


10000- 5000.00 Revenue EUR

109. Click the Submit button.

Note: You need to run Tutorial_WorkflowProcessor prior to any workflow in this case study. Also you need to approve this workflow by Phyllis. Refer to Budget case study for the instructions.

110. Change Comment from '' to 'Please review and approve'.

111. Click the Submit button.

112. Switch to the Budget register entry tab on the Budget register entry form.



113. Click the Actions -> View history menu button.

114. Switch to the Tracking details tab on the Workflow history form.

115. Click the Refresh button few times until you the following dialog box appears.




117. Close the Workflow history form.

118. Close the Budget register entry form.

119. Click the Budget register entry -> List -> Refresh button.

120. Make sure the selection is changed in table Budget register entries to:

Date Entry number

Budget model

Budget code

Budget type

Budget register entry status

Source document

In use

1/7/2013 SEA-000002

Sales Orig Original budget

Completed

121. Click the Actions -> View history menu button.

122. Switch to the Tracking details tab on the Workflow history form.



123. Close the Workflow history form.

124. Select the address SEA -> General ledger -> Common -> Main accounts.



127. Select the address SEA -> General ledger -> Periodic -> Currency requirement -> Calculate cash flow forecasts.



128. Click the OK button.






132. View the top of the list and note that a new cash flow forecast has been created for each line in the budget entries. Select the first line

133. Click the Cash flow forecasts button. Note the amount.



Date Source Number Posting Amount 2/6/2013 BudgetTransactionLine -3600.00

136. Click the Cash flow forecasts button. Note the amount.





We will turn off the budget control, in order to have no limitation for future case studies;

1. Click Area Page node: Budgeting -> Setup -> Budget control configuration.

2. Switch to the Activate budget control tab on the Budget control configuration form.

3. Click the Turn off button.

4. Click Yes in the Microsoft Dynamics form.

If budget control is no longer turned on, draft budget reservations will be removed and any confirmed budget reservations will remain unrelieved. If budget control is turned on later, budget balances must be adjusted manually. Do you want to continue?

5. Close the Budget control configuration form.

This is the end of this step. Please take some time and write any additional notes in the next page from your experience in this case study.



Additional Notes:



2012 Microsoft Corporation. All rights reserved. Microsoft, Microsoft Dynamics, and the Microsoft Dynamics logo are trademarks of the Microsoft group of companies. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation.

Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee

the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

Seahorse Retailers Cash FlowChallenge yourself: High-level activity description

Additional Notes:

10 cash flow

Documents

microsoft dynamics ax

microsoft powerpoint

microsoft dynamics erp

r2 microsoft corporation

microsoft corporation

official microsoft training

microsoft official curriculum

microsoft certified