Dimension Group in Ax 2012

Inventory dimension are used to determine physical characteristics of product, storage of products well as track inventory transactions for product.
There are three type of inventory dimension group
http://www.cloudfronts.com/wp-content/uploads/2015/06/DimensionsGroupAX-1.jpg
1. Product Dimensions: Product dimensions are characteristics that serve to identify a product variant. The following table shows the storage dimensions that are available.
> Size
> Color
> Configuration
> Style
For open Product dimension group form navigate to Product information management > Setup > Dimension groups > Product Dimension Group
http://www.cloudfronts.com/wp-content/uploads/2015/06/DimensionsGroupAX-2.jpg
2. Storage Dimensions: A Storage Dimensions determine where and how a product is stored.
> Site
> Warehouse
> Location
> Pallet ID
> Inventory status ( New dimension in AX 2012 R3)
> License Plate ( New dimension in AX 2012 R3)
To open Storage Dimension Group form navigate to Product information management > Setup >Dimension groups > Product Dimension Group
http://www.cloudfronts.com/wp-content/uploads/2015/06/DimensionsGroupAX-3.jpg
3. Tracking Dimensions: Tracking Dimensions provide companies with the ability to trace their products.
> Batch
> Serial Number
To open Tracking Dimension Group navigate to Product information management > Setup > Dimension groups > Tracking Dimension Group
http://www.cloudfronts.com/wp-content/uploads/2015/06/DimensionsGroupAX-4.jpg
The following information provides descriptions for the controls Storage Dimension Group and for Tracking Dimension Group. 
Mandatory: If the Mandatory check box is selected, you want to have dimension as a mandatory dimension for products that are associated with the dimension group.
The Site dimension is always mandatory. However, the Location and the Pallet ID dimensions cannot be set to mandatory.
(Note: This option is only available for Storage Dimension Group)
Primary Stocking: If the Primary stocking check box is selected, it is mandatory that the dimension be entered before any physical updates.
(Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group)
Active: If the Active checkbox is selected, the dimension is enabled for any products that are associated with the dimension group.
Blank Receipt Allowed: If the Blank receipt allowed check box is selected, Microsoft Dynamics AX 2012 accepts a blank value for the dimension at the physical update of a receipt. This option only applies if the Primary stocking check box is cleared.
(Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group)
Blank Issue Allowed: If the Blank issue allowed check box is selected, Microsoft Dynamics AX 2012 accepts a blank value for the dimension at the physical update of an issue. This option only applies if the Primary stocking check box is cleared.
(Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group)
Physical Inventory: If the Physical inventory checkbox is selected the dimension must be included in physical inventory.
(Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group)
Financial Inventory: Select the Financial inventory check box if the dimension is to be included in calculating the financial cost of a product sold.
(Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group)
(Example of Physical and Financial Inventory: If you booked an item into Warehouse 1 and Site 1 at $600 and the same item into Warehouse 2 site 1 at $400. (Cost FIFO)
If you unticked physical inventory from warehouse you could pick 2 from warehouse 1 because the check is at site where you have 2. At the same time if you looked at the cost and unticked financial inventory from warehouse the cost of each would be $500.)
Coverage plan by dimension: Select the Coverage plan by dimension check box if this dimension is to be included in coverage plans that are created through master planning.
(Note: This option is only available for Storage Dimension Group and for Tracking Dimension Group)
For Purchase Price: Select the for purchase price check box if you want to include the dimension as a criterion to determine a product’s purchase price. In the Journal lines, price/discount agreement form, you can create a trade agreement where you associate a purchase price with a specific dimension that is set up for a product.
For Sales Price: Select the for sales price check box if you want to include the dimension as a criterion to determine a product’s sales price. In the Journal lines, price/discount agreement form, you can create a trade agreement where you can associate a sales price with a dimension that is set up for a product.
Now you can use Inventory Dimension for Purchase Order for Sales order and also for Inventory Journals like Movement, Adjustment, Transfer, Counting, Item arrival, Counting etc.
After Inventory transaction you can track the inventory by Inventory dimensions in On hand inventory form.
http://www.cloudfronts.com/wp-content/uploads/2015/06/DimensionsGroupAX-4.jpg


Comments

Post a Comment

Popular posts from this blog

Write/ Read to Excel Sheet

File exists in a Directory:  static void FileExists(Args _args) { str filePath = @”C:\\vani.pdf”; ; if(WinAPI::fileExists(filePath)) { WinAPI::copyFile(filePath,”C:\\1.pdf”); } } Dynamics AX X++ code to Read/Write data to excel Writing Data to Excel file   How it works 1. Use SysExcelApplication class to create excel file. 2. Use SysExcelWorkbooks and SysExcelWorkbook to create a blank workbook(by default 3 worksheets will be available). 3. Use SysExcelWorkSheets to select worksheet for writing data. 4. SysExcelCells to select the cells in the excel for writing the data. 5. SysExcelCell to write the data in the selected cells. 6. Once you done with write operation use SysExcelApplication.visible to open file. static void Write2ExcelFile(Args _args) { InventTable inventTable; SysExcelApplication application; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet workshee...
Read more

Table Methods in Ax 2012

Table Methods in Ax 2012 Methods are used for adding X++ code to your application. The code in methods is also referred to as business logic. Whenever records are changed, inserted or deleted from a table various default methods are executed. We can change the default methods and by doing so we are overriding the default methods.To override a method go to the  Methods  node of a table, right click and choose  Override Method . Below are few examples of Overriding commonly used Table methods: initValue(): If we create a new record from the table browser or a form the table method initValue() is executed. It is used to set a default value for the fields.  Example (1): Let’s override intiValue for MyFirstTable and set default value for custGroupId public void initValue() { super(); this.custGroupId = "10"; } After adding this method, open table MyFirstTable  through Table browser and press ctrl+n ...
Read more

Financial Dimensions in AX 2012

Image
Today we will be exploring the new changes  related  to Financial dimensions in AX 2012. Earlier versions AX 2009, 4.0 : Ø   In older version System use to limit the creation of dimensions up to 10.  Ø   By default 3 dimensions were available in the system namely Department, CostCenter and Purpose. Ø   Technically these dimensions were controlled by Enum SysDimension and an array EDT Dimension. Ø   So If we have 3 enum elements in SysDimension, then its corresponding array elements are stored in    dimension EDT and can be referred as Dimension[0], Dimension[1]..... Ø   If you would like to store these dimension values against customized table, then simply we were adding the EDT Dimension to that Table. At  Form  level simply drag and drop field on Group then system use to  show all the array elements as string control. New version AX 2012 (6.0) :   Ø   In AX 2012(6.0), there is no ...
Read more