How to Delete a Financial Dimension in AX 2012

1. First check which dimension you need to delete, let us example "Customer" .

2. Go to AOT-->DataDictionary-->Tables-->DimensionAttributes 

3. Check for the Financial dimension attribute "Customer" and select the RecId of that line.

4. Copy the above table RecId

5. Go to DimensionAttributesSetItem Table and open the table.

6. In Dimension attribute field filter with the above table recid.

7. Delete a record in DimensionAttributesSetItem table.

8. Go to Financial dimension form in General Ledger. try to delete "Customer" system will ask you weather you want to delete are not.

9. Delete Financial dimension.

                                              Thank You- Subrat Kumar

How to use Fixed Financial Dimensions in AX 2012 R2

Hi All,

AX 2012 R1 did not allow you the ability to fix a financial dimension value for a given main account. However, AX 2012 R2 has added functionality allowing you to fix a financial dimension value for a given main account. This ensures that regardless of other financial dimension assignments used on a particular AX transaction, posting to the main account for which you’ve defined a fixed dimension will always use that fixed financial dimension value. The key towards using fixed financial dimension values in AX 2012 R2 for a given main account is to use the ‘Select the level of main account to display’ option in the Main accounts form. When this is set to ‘Companies’ you can map your individual companies and an additional fast tab called Financial dimensions fast tab becomes available.

Please consider the following example on how to use fixed financial dimension values in AX 2012 R2:

Assume that you have a main account ‘110110’ in your Chart of Accounts, for which you want to make sure you always have a Department financial dimension value of ‘022’ posted with the main account.

You would start by going to General Ledger | Common | Main accounts to open the Main accounts list page. Within the Main accounts list page, you would double-click on the ‘110110’ main account to open the Main accounts form. Once in the Main accounts form, you should select ‘Companies’ from the ‘Select the level of main account to display’ field.

You can then click the green Plus button to the right of the Companies field and select the individual company for which you want to assign a fixed financial dimension value for. In my example, I’ve used the green Plus button to select the ‘USSI’ company.

Now that I have the ‘USSI’ company selected in the Companies field, the Financial dimensions fast tab appears at the bottom of the Main accounts form. When I expand the Financial dimensions fast tab, I can select ‘022’ in the Department field and specify ‘Fixed’.

I can now close the Main accounts form. At this point, any future postings against the 110110 main account in the USSI company will always associate the ‘022’ department financial dimension value. As an example, I will simply create a GL journal using the ‘110110’ main account. You will see that the ‘022’ department defaults in.

When you then post the journal, the ‘022’ Department financial dimension value will always be passed in. I can see from the posted voucher (clicking on Inquiries | Voucher at the top of the Journal voucher form) that the ‘022’ Department financial dimension value was passed in.

In this example, I’ve articulated how this works using the example of a simple GL journal. However, where this fixed financial dimension value becomes more valuable/advantageous is in those unique types of subledger tranasctions where you need to ensure that a main account always has a specific financial dimension value passed in to ensure accurate financial reporting.

                                 Thank you- Subrat Kumar

Understanding the Inventory Value Report in Microsoft Dynamics AX 2012

AX’s Inventory Value Report is a very powerful tool…IF you know how to build it to display the information that your business requires and IF you know how to interpret this information.  So, what is the inventory value report anyways?  The inventory value report is a tool for you to look at the total quantity and value of your inventory posted to the inventory subledger by item number or resource group.  It is a great tool for helping you reconcile inventory value with GL balances, which we will discuss in part two of this series. 

In this post we will focus on setting up Inventory Value Report IDs so that the report will show you exactly what you need to see, no more no less.  It is a good idea to set up several inventory value report IDs to show different information depending on who is running the report and why it is being run. 

Building Inventory Value Report ID’s

1)      Navigate To: Inventory management > Setup > Inventory > Inventory value reports

2)      Click ‘New’ and type in a unique ID and descriptive name.

3)      Expand the General fast tab to choose where the data for the report is coming from:  

·        Date interval: Set if you want your report to default to a pre-defined date interval every time it is run (ex: this year, last year, current period, etc…).  This date interval can be overridden at the time the report is run.

·        Range: Choose whether ‘Posting’ Date or ‘Transaction Time’ is the range for the data

·        Dimension Set: Choose what dimension set you want to run the data for.  For example, you can run the data by Main Account, or by Main Account + Business Unit.

4)      Expand the Columns fast tab to choose what columns you would like to see in your report:

·        Financial positions

o   Inventory: If ticked, report displays the financial and physical quantities and amounts that posted to inventory accounts – explanation of financial and physical quantity/amount below.

-  Inventory: Financial Quantity = physical quantity of on hand inventory (in a unit e.g. EA) that has been financially updated (i.e. invoiced or production ended)

-  Inventory: Financial Amount = dollar amount value of on hand inventory that has been financially updated

-  Inventory: Physical quantity posted = physical quantity of on hand inventory that has been physically updated but not financially updated (i.e. PO Receipt, SO Packing Slip, or Report as Finished posted to ledger)

-  Inventory: Physical amount posted = dollar amount value of on hand inventory that has been physically updated but not financially updated

o   WIP: If ticked, report displays physical quantities and amounts of inventory in WIP status – WIP is anything that has been picked for a production order or reported as finished for a production order, but not yet ended.

o   Deferred COGS and COGS: If ticked, report displays physical quantities and amounts of inventory that should post to Deferred COGS and financial quantities and amounts that should post to COGS. Deferred COGS are physical quantities and amounts because they offset picking list quantities and amounts whereas COGS are financial quantities because they offset invoice quantities and amounts.

o   P&L: Displays the financial amount posted to P&L for inventory.

·        Compare On-hand inventory value to cumulative accounting values: Check this box to print account balances on the bottom of the report for reconciliation purposes – will cover this in more detail in Part 2 of this series.

·        Summarize: If this is ticked, you will not see both inventory physical and inventory financial values, instead the two values will be added together to give and overall inventory quantity and inventory amount.

·        Average Unit Cost: If this is ticked in the last column of your report you will see a value for the average unit cost of each item that has inventory on the report.

·        Print Total: If this is ticked the inventory physical and financial quantities will be added together in an additional column on the report and the inventory physical and financial amounts will be added together in an additional column on the report. (Can only be checked if summarize is not checked.)

·        Inventory Dimensions: Displays a column for each inventory dimension that is ticked– for example if you tick site, you will see separate inventory values for each site. 

·        Resource ID: If view is selected, you will see a column for each resource (i.e. item) in inventory and the value for each dimension tracked, if there is inventory across multiple dimensions a separate row will be displayed for the value in each dimension tracked. If total is selected, a row will display directly beneath showing the total value across all dimensions.

·        Resource Group: If view is selected, you will see a column for each resource group (i.e. item group) and the value of the groups inventory, if there is inventory across multiple dimensions a separate row will be displayed for the value in each dimension tracked.  If total is selected, a row will display directly beneath showing the total value across all dimensions. 

(If none of the Resource ID or Resource Group boxes are checked you will simply get a report with the total value of inventory per dimension.)                                                                                                                                    

5)      Expand the rows tab to choose what rows you want to see on your report:

·        Resource Type: Displays rows for inventory value of each of the resource types that you select.  Material is what is most commonly viewed in this report and is mandatory.

·        Detail Level: This allows you to choose how detailed you want your report to be.  If you select totals you will view only the total value of inventory on the date you run the close for for each resource or resource group.  If you select transactions you will view each transaction for each resource or resource group.  This is not recommended if you are looking at a large range of resources.  Include beginning balance is only available for the transactions level of detail.

Now you have the knowledge and tools to be able to set up your inventory value reports based on what is right for the people in your company.  Maybe someone in finance only wants to see a high level overview of the total value of actual inventory for each resource group, so we would simply set up an inventory value ID that only shows the totals for each resource group.  Maybe your inventory cost controller wants to see the totals for each resource include the values that are in WIP, so we would set up an inventory value report ID that includes totals for each resource and has columns for the value of WIP inventory.  Once the setup for the report IDs has been complete we can now start to run our reports, understand our reports, and utilize them to make our jobs easier.  

transfer Order in MS Dynamics AX-

The transfer order is used for registering in the system the items that must be moved from one warehouse to another and for managing this process. What is the difference between a transfer journal and a transfer order?

With the help of the transfer journal, the Inventory Manager transfers the items from one dimension (warehouse, location, color, etc) to another one instantaneously .

The Transfer order is used for managing the transfer process itself – that is all steps of transferring an item from one place to another. (Transfer journals are located under Inventory management > Journals > Itemtransaction > Transfer.)

Transfer orders are located under Inventory management > Periodic> Transfer orders.

We will study the most complex flow when items must be picked and registered in the system (i.e. we will use the Warehouse Management functionality). 

Let’s assume that the Inventory Manager wants to move 5 Standard Digital Video Recorder Model 01 (1601) items from warehouse 22 to warehouse 23.

Prerequisite Step

We need to have the Standard Digital Video Recorder Model 01 (1601) items on-hand in the warehouse 22.

You can perform all required purchase steps to have it on-hand (i.e. create a purchase order, arrive items, register items , and post a packing slip and an invoice). 

Or, we can add item on-hand with the help of the counting journal:

1. Go to Inventory management > Journals > Item counting. TheInventory journal form opens.
2. Click the Create new button. The Inventory dimension form opens.
3. Select the Warehouse check box and then click OK. TheJournal lines form opens.
4. Create a line with the following values:
• Item number = 1601
• Site = 2
• Warehouse = 22
• Location = 01-03-01-1 (any location)
• Pallet = 00000125_114 (you can create a new pallet and use one)
• Quantity = 50 (the new on-hand quantity)

The counting journal has been posted. Let’s check the on-hand inventory for the 1601 item:

1. Go to Inventory management > Common Forms > Item details. The Item form opens.
2. Find and select the 1601 item and then click the On-handbutton. The On-hand form opens.

Note: to view the warehouse, location, and pallet dimensions, click the Dimension display button and then select the corresponding check boxes.

We have added the on-hand for the 1601 item in the warehouse 22, so now we can transfer 5 items from the warehouse 22 to the warehouse 23.

Setup

Where is the item on-hand recorded when it is half way from the warehouse 22 to the warehouse 23? These warehouses don’t have the on-hand for the transported items.

In Microsoft Dynamics AX, the transit warehouse is available for these purposes. When items are half way from one warehouse to another one, they are recorded to the transit warehouse.

In our case, the warehouse 22 must have the transit warehouse. Let’s check:

1. Go to Inventory management > Setup > Inventory breakdown >Warehouses. The Warehouses form opens.
2. Find the warehouse 22 and then go to the General tab.

We can see that the warehouse 22 uses the  warehouse 29 as transit warehouse.

Let’s create a transfer order and analyze generated inventory transactions.

Create Transfer Order

Now, the Inventory Manager will create the transfer order:

1. Go to Inventory management > Periodic > Transfer orders. TheTransfer orders form opens.
2. The transfer order consists of the header and lines.
3. Create new line. Fill in the transfer order header with the following values:
• From warehouse = 22
• To warehouse = 23
• Shipment date = today. The Available ship and receipt dates form opens.

This is because the transfer order, like a sales order uses the Delivery date control functionality. To get more information about it, read the Create Sales order article. In this training lesson, we will not use the Delivery date control functionality. Click the Disable dlv. datecontrolbutton in the Available ship and receipt dates form.

• Receipt date = today.
3. Create a transfer order line with the following values:
• Item number = 1601
• Transfer quantity = 5
4. The Transfer orders form will have the following view:

The transfer order has been created. Let’s analyze what inventory transactions have been created. In the Transfer orders form, clickInventory > Transactions. The Transactions form opens.

We can see the following:

• 5 items are ordered in the warehouse 22 for issue, i.e. they will leave the warehouse 22. The issue status is On order.
• 5 items are ordered in the warehouse 29 for receipt, i.e. they will be delivered to the warehouse 29. The receipt status isOrdered.
• The same time, 5 items are reserved for issue in the warehouse 29. That is 5 ordered items will leave the warehouse 29 and they can’t be used for other purposes.
• 5 items are ordered in the warehouse 23 for receipt, i.e. the items will be delivered to the warehouse 23.

The following picture illustrates these inventory transactions:

Pick Items to Transfer

The transfer order picking process is similar to the sales order picking process. 

The Inventory Manager creates the output orders:

1. In the lines area of the Transfer order form, click Inventory >Output orders. The Create inventory order form with the item quantity opens. Click OK.
2. The Output order form with the created output order opens.

The Inventory Manager creates a shipment:

1. Go to Inventory management > Common Forms > Shipments. The Shipment form opens.
2. Create a new line. The Create shipment wizard appears.
3. Click Next on the Welcome page.
4. Select the 100_all shipment template and then click Next on the Identification page.
5. Click Next on the Configuration page.
6. Make sure that the inventory order is available on the Inventory order page. Click Next.
7. Click Finish on the Ready page.
8. The shipment is created:

The Inventory Manager creates the picking route (picking instruction):

1. In the Shipment form, click Functions > Activate.
2. The picking route is created. Make sure that the Pick field is set to Activated.

The Warehouse Worker picks the items and registers this information in the system:

1. Go to Inventory management > Common Forms > Picking routes. The Pick form opens.
2. In the Picking route field, select the last picking route number.
3. Click the Create picking pallet button. In the Create picking pallet form, click OK.
4. The Pick form will have the following view:

5. Click the Approve details button. The Approve line form opens.

6. Click the Pick selected button. Since all picking route quantity is approved, the Deliver picked items form opens.

7. Click the Deliver items button.

The items are picked and transported to the outbound location.

If we return to the Shipment form, we can see the following results:

We can see that the Pick field is set to Completed and the shipment status is Staged.

The Warehouse Worker performs the last optional step he or she records in the system that the pallets are loaded into the truck.

1. In the Shipment form, click Shipment staging. The Shipment staging form opens.
2. Click Functions > Load. The Handling status is changed toLoaded. Note that no inventory transactions are created or updated. Close the form.
3. In the Shipment form, the Status field value is changed from the Staged to Loaded.

Let’s check the inventory transactions:

1. Go to Inventory management > Common Forms > Item details. The Item form opens.
2. Find the 1601 item and then click the Transactions button. TheTransactions on item form opens.

Note that the Item form displays all inventory transactions for this item, among them we can see the inventory transactions generated from the counting journal. Don’t take this transaction into account.

We can see the following changes: 5 items are picked from the warehouse 22. The other transactions remain unchanged.

The following picture illustrates these inventory transactions:

Ship Transfer Order

The Inventory Manager ships the transfer order. It means that the items have been taken from the warehouse 22 and are half way from the warehouse 22 to the warehouse 23.

Let’s ship the transfer order and analyze inventory transactions:

That is all, the items are transferred from one warehouse to another one.

Summary

In this training lesson, we have studied how to set up the transit warehouse and how to work with a transfer order. We also studied the main steps of the transfer flow.

Let’s recall the main steps of the transfer flow, they are as follows:

1. Creating a transfer order
2. Picking items for the transfer order
3. Shipping the transfer order
4. Items arrival and registration  in the destination warehouse
5. Receiving the transfer order

                                             Thank You- Subrat Kumar