Here is an example of how to import a Budget Register Entry through the Excel Add-in using the Contoso Demo Data.
PreConfiguration: You have installed the Excel Add-in components. For more information on this see: http://technet.microsoft.com/en-us/library/gg731844.aspx
figure 2: Register Service
4. Close the Development Workspace.
5. In the AX Client navigate to System Administration > Setup > Services and Application Integration Framework > Inbound Ports.
6. Select the New button to create a new port and populate the following:
FIGURE 3: Naming the Port
7. Select the Service Operations button.
8. Add all the services that start with BudgetTransactionService to the left column as seen in figure 4.
Figure 4: Budget Services
NOTE: Setup completed within AX.
5. Select the OK button.
6. On the Dynamics AX tab select the Add Data button > Add Data.
7. Select the Budget Register Entries selection from the list and select OK.
8. You should see a form open on the left side of the Excel Spreadsheet with fields that you can drag onto the spreadsheet.
9. Select the following fields in this order to drag onto the spreadsheet.
NOTE: These are your budget header fields
10. Expand the Budget Account Entries node and drag the following field onto the form – move them a couple spaces to the left of your last field (Default Date).
NOTE: These are you budget Line fields
11. Close the pane with all the fields that you can drag on to the spreadsheet.
12. Add the following information into line 2:
Ledger.Ledger name: ceu -- (this is the company name).
Entry Number: Test1 -- (This is a place holder, your number sequence from within AX will substitute when you import).
Budget Code: Budget
Budget Model: Sub1
Default Date: 9/10/2012
Ledger Name: ceu
Entry Number: Test1 ---- This must match your header entry number
Line Number: 1
Comment: Anything you want
Transaction Currency: Amount: 10,000
13. Select any cell that is blank on the spreadsheet – this will activate the “Publish Data” button.
14. Select the Publish Data button > Publish All.
NOTE: You will see all data from the BudgetTransactionHeader and BudgetTransactionLine tables populate on the spreadsheet which is fine – this is in case you want to update which you can also do from the spreadsheet.
15. Open an AX client.
16. Go to Budgeting > Common > Budget Register Entries.
17. Search for a budget register entry with the date of the one you entered (9/10/2012 in my case).
You can see it imported correctly. I can also see that “Test1” was replaced with 000529_1032 which was the next number in my number sequence.
If I wanted to add more lines to this budget entry it would be as easy as adding more lines to your spreadsheet with the correct entry number.
When importing: If you are receiving the error:
Method 'System.ServiceModel.FaultException.Detail' not found.
Load KB 2721075 which is a kernel fix.
NOTE: Kernel fixes need to applied wherever there are AX Components (Client, AOS, BC, Etc...)
This is great, thanks.
An observation I have made with general uploading from Excel is that if there is a dimension combination issue with the account stucture, then the budget header will load, however, the lines will not. Also, Excel does not provide an error about why the file failed.
Is there an easy/convenient way to check the dimension combinations in the file are valid with the given account structure?
On the inbound port there is a troubleshooting tab. I would try setting:
1. Logging mode: All Document Versions
2. Include exceptions in fault: Checked
With the "Include exceptions in fault" flagged this should hopefully provide you with more information from the Excel Speadsheet on what's the problem.
The Logging mode will provide messages in: System Administration > Periodic > Services and Application Integration Framework > Exceptions.
Hopefully, these will help you troubleshoot the errors.
I am using this method and encountered few problems.
Firstly I was getting errors on Schema and I un-checked 'Validate document XML' check-box under Processing options for new Inbound port I created (as per steps above).
Now I am getting following error on Budget line, although I am filling out the Dimension values.
Field 'Dimension values' must be filled in.
Any ideas why I may be getting this and how to workaround this as I am filling in all the Dimension values.
Hi Tom, please I need ur help badly. I followed thru ur procedure and it helped a great deal. But I cannot type over a 100 lines of budget entries into the excel format for upload and I need to copy and paste. Each time I copy and paste, it tells me "there are incomplete records in your spread sheet" I dont know how to correct this. Please help its very urgent. Also,must the accounts specified for budget be in line with the default account structure or the accounts can use another account structure different from the one specified as the default one? Thanks!