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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 01.05.2015, 01:12   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
emeadaxsupport: View a full breakdown of cost per item using the Inventory Value Statement with Standard Cost Breakdowns report in Dynamics AX
Источник: http://blogs.msdn.com/b/axsupport/ar...namics-ax.aspx
==============

*Disclaimer: This blog only applies to items using a Standard Cost item model group.



Many customers have the need to view a full breakdown of costs for individual items that they produce, but have difficulty generating a report that accurately and cleanly breaks down this information. This can easily be achieved by effectively utilizing the setup of cost groups associated with an item's Bill of materials (BOM) and Route.

Before setting up the report parameters, there are a few essential prerequisites that must be first established:

1. Ensure that a cost group is associated on the item record of all items wanting to be costed, including finished goods and raw materials/components.



2. For labor cost reporting, ensure that a Cost group is associated with the 'Cost categories' that are specified on the Route's resource or resource group



3. Set your Bill of materials 'Cost control' settings to activate Cost breakdown by cost group in Inventory and Warehouse management parameters. Without activating these settings, the report will NOT pull in a breakdown by cost group.



4. Ensure that all cost groups are associated with a 'Cost group type' of something other than 'Undefined'. All 'Undefined' cost groups will not be pulled in to the breakdown.



5. If ANY changes are made in the steps above, a new standard cost calculation MUST be calculated and activated before the changes will take effect. This must be done for all items that are tied to the finished good.





Report parameters for the 'Inventory Value Statement with Standard Cost Breakdowns' report

Keep in mind that there are various ways to configure this report, and preferences are likely to vary across companies; however, this is the setup that I have had the most success with when working with customers in the past.

1. Date interval: Select the specific date range for the cost details you wish to view. If changes were made to cost group setup and a new cost rollup was activated, only the transactions from after the new activation will generate a breakdown.

2. Sorting and grouping: By selecting a sorting and grouping of 'Item', the report will group by item number for easy review of cost details per item.

3. Detail level: For a full breakdown by cost group, this must either be set to 'Single' or 'Multi'.

4. Include beginning: If you would like to view a breakdown with the beginning inventory amounts, ensure that this checkbox is checked.

5. Miscellaneous 'View' settings: Check the box to add a column header on the report for any of these options.

6. Query selections: If desired, you can specify to only display results based on specific Inventory dimensions and/or items.



Report Generation:






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

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
emeadaxsupport: AX Performance Troubleshooting Checklist Part 2 Blog bot DAX Blogs 0 09.09.2014 16:11
emeadaxsupport: Microsoft Dynamics AX general performance analysis scripts page 6 Blog bot DAX Blogs 0 01.09.2014 14:11
crminthefield: Podcast and Overview: Microsoft Dynamics CRM 2011 Update Rollup 17 Blog bot Dynamics CRM: Blogs 0 10.05.2014 06:30
daxdilip: Whats New in Dynamics AX 2012 (A brief extract from the recently held Tech Conf.) Blog bot DAX Blogs 7 31.01.2011 12:35
dynamics-ax: Official Details about Dynamics AX '6' released, including comments from Microsofts Kees Hertogh Blog bot DAX Blogs 0 11.01.2011 05:22
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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