AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 10.09.2012, 23:15   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
emeadaxsupport: Importing a Budget via the Excel Add-in
Источник: http://blogs.msdn.com/b/axsupport/ar...el-add-in.aspx
==============

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/l.../gg731844.aspx

Area 1: Configuring the Inbound Port


  1. Open a Development Workspace (CTRL + SHIFT + W).
  2. In the AOT navigate to Services > BudgetTransactionService.
  3. Right-click on it and select Add-ins > Register Service as seen in figure 2.


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:
  • Port Name: BudgetImport
  • Description: Importing Financial Budgets


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.

Area 2: Setup with Excel


  1. Open Excel and create a new spreadsheet.
  2. Select the Dynamics AX tab.
  3. Select the Connection button.
  4. Select the Legal Entity that you want to import into and the Account Structure you will evaluate against.




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.
  • Ledger.Ledger Name --- This will pull two fields onto the spreadsheet
  • Budget Code
  • Budget Model
  • Default Date
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).
  1. Parent.EntryNumber
  2. Date
  3. Currency
  4. LedgerDimension.MainAccount
  5. Comment
  6. Transaction Currency Amount
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:

Header Entries

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



Lines Entries

Ledger Name: ceu

Entry Number: Test1 ---- This must match your header entry number

Date: 9/10/2012

Line Number: 1

Currency: USD

LedgerDimension.MainAccount: 170150

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.

Enjoy!




Источник: http://blogs.msdn.com/b/axsupport/ar...el-add-in.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
ax_gfm_framework_team: Integrating a Source Document with Budget Control Blog bot DAX Blogs 0 18.07.2012 00:11
emeadaxsupport: Microsoft Dynamics AX 2012 Office Addins tab does not appear in Microsoft Excel 2007 or Word 2007 on a 64bit Windows system Blog bot DAX Blogs 0 25.02.2012 05:42
daxmusings: Importing Data to AX 2012 Using Excel Add-ins Blog bot DAX Blogs 0 19.01.2012 06:16
dynamics-ax: Microsoft Dynamics AX 2012 Excel Add-in Blog bot DAX Blogs 0 08.06.2011 08:12
emeadaxsupport: How does the Export to Excel feature work under the hood? Blog bot DAX Blogs 0 07.09.2009 19:05
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 10:36.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.