Use Excel Worksheets To Make Entering Budgeting A Breeze

Tip Of The Day - Use Excel Worksheets To Make Entering Budgeting A BreezeAt first glance, entering in all of your budgets within Dynamics AX may seem like a daunting prospect, because it looks like you need to break all of your budget entries out by account, and then by period.  But it’s not really the case.  You can link all of your budget with Excel templates that you can then use to make the entry an extremely simple task.

Budgeting within Dynamics AX does not have to be a painful process.

How To Do It…

When you are assigned a budget to update, rather than entering in the budget line by line, and period by period, just click on the Worksheet button within the Supplemental group of the Budget Plan ribbon bar.

20140117.01

This will open up the budget entry template within Excel, and populate it with all of your budget detail.

20140117.02

All you have to do now is update all of the budgets by account and period, and then click on the Publish All option of the Publish menu button within the Update group of the Dynamics AX ribbon bar.

20140117.03

Now when you return to your budget detail within Dynamics AX, you will see that it has added records for you for all of the new budget entry records, and updated all of the budget figures with the values that you entered in the worksheet.

Also, you can always return to the worksheet by clicking on it within the Budget Plan Documents fact box.

20140117.04

How cool is that!

Advertisements
1 comment
  1. Hichem CHEKEBKEB said:

    Hello Murray, I have see the Microsoft presentation video of Project Planning, the presenter showed some projection calculations for head count, Revenue whereas neither the white paper nor Technet are showing how to get those calculations. Could you please help me on that?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: