Project Budgeting in AX 2012 R2

AX 2012 R2- Project Budget

1. Select the address CEU -> Project management and accounting from the Address bar by clicking the navigation path arrows.

2. Click Area Page node: Project management and accounting -> Common -> Projects -> All projects.

3. Click the Project -> New -> Project button.

 4. Change Project type from 'Time and material' to 'Fixed-price'.

5. Change Project ID from '' to 'BudgetLabPractice'.

6. Change Project name from '' to 'BudgetLab Practice'.

7. Change Project group from '' to 'FP2'.

8. Change Project contract ID from '' to '100201'.

9. Click the OK button.

10. Click the Project -> Maintain -> Edit button.

11. Click the Project -> Maintain -> Project stage -> In process menu button.

12. Click Ok in the Change of status form.

Update to status In process?

13. Select the Project stage field.

14. Right-click the field to View details.

15. Click the Estimate project -> Maintain -> Edit button.

16. Click the Close toolbar button.

17. Change Period code from 'EstQuarter' to 'EstMonth'.

18. Close the Estimate projects form.

19. Close the Estimates form.

20. Close the Estimate project forecasts form.

21. Close the Actual costs form.

22. Click the Plan -> Forecast -> Hour forecasts button.

23. Click the New button.

24. Create a new record in the Hour forecasts form.

25. Change Category from '' to 'Design'.

26. Change Hours from '0.00' to '100.00'.

27. Click the New button.

28. Create a new record in the Hour forecasts - Forecast model: , 5/9/2013 form.

29. Change Category from '' to 'Install'.

30. Change Hours from '0.00' to '200.00'.

31. Close the Hour forecasts - Forecast model: , 5/9/2013 form.

32. Click the Plan -> Maintain forecast -> Copy forecasts to ledger button.

33. Change Reverse previously transferred from 'true' to 'false'.

34. Click the OK button.

35. Click the Close toolbar button.

36. Close the Projects form.

37. Close the Pending transactions form.

38. Close the Project transactions form.

39. Close the Item tasks form.

40. Close the Resource scheduling form.

41. Close the Invoice form.

42. Close the Actual cash flow form.

43. Close the Actual costs form.

44. Close the Actual costs form.

45. Close the Project forecasts form.

46. Close the Pending transactions form.

47. Close the ProjProjectsPreviewPane form.

48. Click Area Page node: Budgeting -> Common -> Budget register entries -> All budget register entries.

49. 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
	5/9/2013	000530_1032	www	PrCode	Project	Draft

50. Double-click or press Enter on the selected record in form Budget register entries.

  

51. Click the Budget register entry -> Update -> Update budget balances button.

52. Switch to the Batch tab on the Microsoft Dynamics AX form.

53. Click the OK button.

54. Click the Close button.

55. Close the Account and financial dimension details form.

56. Click the Close toolbar button.

57. Close the Budget register entry form.

58. Close the Actuals vs. budget form.

59. Close the Budget balances form.

60. Close the Budget register entry totals form.

61. Close the Budget register entry totals form.

62. Change Budget code from '' to 'PrCode'.

63. Close the BudgetTransactionListPagePreviewPane form.

64. Click Area Page node: Project management and accounting -> Common -> Projects -> All projects.

65. Make sure the selection is changed in table Projects to:

Project ID	Project name	Legal entity	Project contract ID	Customer name	Project type	Project stage
BudgetLabPractice	BudgetLab Practice	ceu	100201	Kiwi Conference Center	Fixed-price	In process

66. Double-click or press Enter on the selected record in form Projects.

67. Click the Manage -> Process -> Estimates button.

68. Click the New button.

69. Change Estimate date from '4/30/2013' to '5/31/2013'.

70. Change Cost to complete method from 'Set cost to complete to zero' to 'Remaining budget'.

71. Change Forecast model from '' to 'Annual'.

72. Click the OK button.

73. Click the Edit button.

74. Change Image from '0.00' to ''.

75. Make sure the selection is changed in table Cost group to:

Cost line	Transaction type	Cost to complete method	Actual cost	Cost to complete	Total cost	Image
Design	Hour	Remaining budget	0.00	4500.00	4500.00

76. Click the Forecast button.

77. Close the Hour forecasts - Forecast model: Annual, 5/9/2013 form.

78. Make sure the selection is changed in table Cost group to:

Cost line	Transaction type	Cost to complete method	Actual cost	Cost to complete	Total cost	Image
Implemnt.	Hour	Remaining budget	0.00	9000.00	9000.00

79. Click the Forecast button.

80. Close the Hour forecasts - Forecast model: Annual, 5/9/2013 form.

81. Click the Close toolbar button.

82. Close the Cost estimate form.

83. Click the Post button.

84. Click the OK button.

85. Click the Ledger -> Posted menu button.

86. Close the Voucher transactions form.

87. Close the Estimate form.

88. Click the Plan -> Forecast -> Hour forecasts button.

89. Change Hours from '100.00' to '150.00'.

90. Make sure the selection is changed in table Hour forecast to:

Forecast model	Project date	Project ID	Activity number	Category	Personnel number	Description	Hours	Line property	Budget type	Indirect cost component group
Annual	5/9/2013	BudgetLabPractice		Install			200.00	Charge	None

91. Change Hours from '200.00' to '250.00'.

92. Make sure the selection is changed in table Hour forecast to:

Forecast model	Project date	Project ID	Activity number	Category	Personnel number	Description	Hours	Line property	Budget type	Indirect cost component group
Annual	5/9/2013	BudgetLabPractice		Install			250.00	Charge	None

93. Close the Hour forecasts - Forecast model: Annual, 5/9/2013 form.

94. Click the Plan -> Maintain forecast -> Copy forecasts to ledger button.

95. Change Reverse previously transferred from 'false' to 'true'.

96. Click the OK button.

97. Click the Close button.

98. Click the Close toolbar button.

99. Close the Projects form.

100. Close the Project transactions form.

101. Close the Resource scheduling form.

102. Close the Item tasks form.

103. Close the Invoice form.

104. Close the Pending transactions form.

105. Close the Actual costs form.

106. Close the Actual cash flow form.

107. Close the Actual costs form.

108. Close the Pending transactions form.

109. Close the Project forecasts form.

110. Close the ProjProjectsPreviewPane form.

111. Click Area Page node: Budgeting -> Common -> Budget register entries -> All budget register entries.

112. 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
	5/9/2013	000532_1032	www	PrCode	Project	Completed

113. Close the Account and financial dimension details form.

114. 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
	5/9/2013	000531_1032	www	PrCode	Project	Draft

115. Click the Budget register entry -> Update -> Update budget balances button.

116. Switch to the Batch tab on the Microsoft Dynamics AX form.

117. Click the OK button.

118. Click the Close button.

119. Close the Budget register entry totals form.

120. Change Budget code from '' to 'PrCode'.

121. Close the BudgetTransactionListPagePreviewPane form.

122. Click Area Page node: Project management and accounting -> Common -> Projects -> All projects.

123. Make sure the selection is changed in table Projects to:

Project ID	Project name	Legal entity	Project contract ID	Customer name	Project type	Project stage
BudgetLabPractice	BudgetLab Practice	ceu	100201	Kiwi Conference Center	Fixed-price	In process

124. Double-click or press Enter on the selected record in form Projects.

125. Click the Manage -> Process -> Estimates button.

126. Click the New button.

127. Change Forecast model from '' to 'Annual'.

128. Click the OK button.

129. Switch to the General tab on the Estimate form.

 130. Click the Post button.

131. Click the OK button.

132. Click the Close toolbar button.

133. Close the Estimate form.

134. Click the Project -> Journals -> Hour button.

135. Click the Enter ->  -> New button.

136. Change Name from '' to 'Hours'.

137. Change Description from '' to 'Hours No Approval Journal'.

138. Click the Enter -> New -> Lines button.

139. Change Hours from '0.00' to '25.00'.

140. Click the Add button.

141. Create a new record in the Journal lines for hours form.

142. Change Category from 'Design' to 'Install'.

143. Change Hours from '0.00' to '50.00'.

144. Click the Post button.

145. Click the OK button.

146. Click the Close button.

147. Click the Close toolbar button.

148. Close the Journal lines for hours form.

149. Click the Close toolbar button.

150. Close the Hour journal form.

151. Click the Manage -> Bill -> On-account transactions button.

152. Click the New button.

153. Create a new record in the On-account form.

154. Click the Close toolbar button.

155. Change Sales price from '0.00' to '50000.00'.

156. Close the On-account form.

157. Click the Manage -> Bill -> Invoice journals button.

158. Close the Invoice journals form.

159. Click the Manage -> New -> Invoice proposal button.

160. Click the OK button.

161. Switch to the On-account tab on the Invoice proposals form.

 162. Click the Invoice proposal -> Functions -> Post button.

163. Click the OK button.

164. Click Ok in the Microsoft Dynamics form.

Warning: update has been selected, but no print.

165. Click the Close toolbar button.

166. Close the Invoice proposals form.

167. Click the Manage -> Process -> Estimates button.

168. Click the New button.

169. Change Forecast model from '' to 'Annual'.

170. Click the OK button.

171. Switch to the General tab on the Estimate form.

 172. Click the Edit button.

173. Change Image from '0.00' to ''.

174. Make sure the selection is changed in table Cost group to:

Cost line	Transaction type	Cost to complete method	Actual cost	Cost to complete	Total cost	Image
Design	Hour	Remaining budget	1125.00	6750.00	7875.00

175. Change Cost to complete method from 'Remaining budget' to 'Total cost - actual'.

176. Change Cost to complete from '6750.00' to '5625.00'.

177. Change Total cost from '7875.00' to '6750.00'.

178. Make sure the selection is changed in table Cost group to:

Cost line	Transaction type	Cost to complete method	Actual cost	Cost to complete	Total cost	Image
Design	Hour	Total cost - actual	1125.00	5625.00	6750.00

179. Click the Close toolbar button.

180. Close the Cost estimate form.

181. Switch to the Overview tab on the Estimate form.

 182. Click the Calculate button.

183. Click the OK button.

184. Switch to the Overview tab on the Estimate form.

185. Make sure the selection is changed in table Control periods to:

Estimate date	Version	Estimate status	Forecast model	Manual calculation	Hour - quantity	Value-added hour rate	Recalculation
7/31/2013	1	Created	Annual	16.67	450.00	111.11

186. Click the Edit button.

187. Change Image from '0.00' to ''.

188. Make sure the selection is changed in table Cost group to:

Cost line	Transaction type	Cost to complete method	Actual cost	Cost to complete	Total cost	Image
Design	Hour	Total cost - actual	1125.00	5625.00	6750.00

189. Change Cost to complete method from 'Total cost - actual' to 'Set cost to complete to zero'.

190. Change Cost to complete from '5625.00' to '0.00'.

191. Change Total cost from '6750.00' to '1125.00'.

192. Make sure the selection is changed in table Cost group to:

Cost line	Transaction type	Cost to complete method	Actual cost	Cost to complete	Total cost	Image
Implemnt.	Hour	Remaining budget	2250.00	11250.00	13500.00

193. Change Cost to complete method from 'Remaining budget' to 'Set cost to complete to zero'.

194. Change Cost to complete from '11250.00' to '0.00'.

195. Change Total cost from '13500.00' to '2250.00'.

196. Click the Update button.

197. Click the OK button.

198. Close the Cost estimate form.

199. Click the Calculate button.

200. Click the OK button.

201. Make sure the selection is changed in table Control periods to:

Estimate date	Version	Estimate status	Forecast model	Manual calculation	Hour - quantity	Value-added hour rate	Recalculation
7/31/2013	1	Created	Annual	100.00	75.00	666.67

202. Click the Post button.

203. Click the OK button.

204. Click the Eliminate button.

205. Change Print estimate list from 'Include warnings' to 'Nothing to print'.

206. Click the OK button.

207. Make sure the selection is changed in table Control periods to:

Estimate date	Version	Estimate status	Forecast model	Manual calculation	Hour - quantity	Value-added hour rate	Recalculation
7/31/2013	2	Eliminated	Annual	100.00	75.00	666.67

208. Click the Ledger -> Posted menu button.

209. Make sure the selection is changed in table General journal entry to:

Journal number	Voucher	Date	Year closed	Ledger account	Currency	Amount in transaction currency	Amount	Amount in reporting currency	Posting layer
GJT-035655	PJPV_170000029	7/31/2013	No	540100---	USD	3375.00	3375.00	3375.00	Current

210. Click the Close toolbar button.

211. Close the Voucher transactions form.

212. Click the Close toolbar button.

213. Close the Estimate form.