Simple code to get the Current time using X++

staticvoid getCurrentTime(Args _args)

{

info(strFmt(“%1”, DateTimeUtil::applyTimeZoneOffset(DateTimeUtil::getSystemDateTime(),Timezone::GMTPLUS1200AUCKLAND_WELLINGTON)));

}

Document Printing Error in AX 2012

Recently, I have got a few questions regarding in Error message which is encountered when printing a business document in AX 2012 e.g. Sales Packing Slip, Purchase Order…

The following error message was recorded:

“Error while setting server report parameters. Error message: The item ‘/DynamicsAX/StaticReports/en-US/SalesPackingSlip.Report’ cannot be found. (rsItemNotFound)”

The report viewer screen then displays a blank screen

Error Message Printing Sales Packing Slip AX 2012

To fix the issue, follow the menu path System administration > Setup > Business Intelligence > Report deployment settings and uncheck the checkbox “Use static report design”

Report Deployment Settings

Year-end closing in MS Dynamics AX 2009

Closing MS Dynamics AX

This is my booklet on closing the financial year using Dynamics AX.
Thanks to Accolade Publications for publishing the book.
Click here to navigate to Accolade publications website

The year-end closing process is an often forgotten and very critical process. “Closing MS Dynamics AX” walks Closing Microsoft Dynamics AX users through the year-end, as well as, the period-end closing processes.

Closing Microsoft Dynamics AX users will find this book helpful and reassuring as it walks you properly through the steps you need to complete a proper closing. When a process is performed only once per year, people tend to forget the details. This book guides you step-by-step.

Microsoft Partners will find this book perfect as a text for a Year-end Closing seminars. Accolade has special pricing for educational volume purchases. We can even drop-ship the book when seminars are performed via the web! Contact our office for more details.

Topics covered…

Closing Microsoft Dynamics AX: Accounts Receivable
Closing Microsoft Dynamics AX: Sales Orders
Closing Microsoft Dynamics AX: Accounts Payable
Closing Microsoft Dynamics AX: Purchase Orders
Closing Microsoft Dynamics AX: Fixed Asset
Closing Microsoft Dynamics AX: Depreciation
Closing Microsoft Dynamics AX: Production Orders
Closing Microsoft Dynamics AX: Inventory
Closing Microsoft Dynamics AX: Exchange Rate Adjustments
Closing Microsoft Dynamics AX: Consolidation

 

3 Critical Topics for Year-end Closing in Microsoft Dynamics AX

Year-end closing is only performed once-a-year, and so it is a process that
is difficult to master and often leaves many of us anxious about whether or
not we will effectively complete what is required. Three complex topics that
deserve special attention when implementing year-end closing in Microsoft
Dynamics AX are: planning, closing inventory, and consolidation with
multiple currencies…

Read more at >> http://accoladepublications.com/3CriticalTopicsClosingAX2011

Dynamics AX 2012 Beta version

The beta version is available for partners to download from partner source here

Get ready for AX 2012

Purchase requisition

After a few implementations of AX 2009, I am extremely expecting some upgrade of purchase requisition functionality:

1. Purchase requisition doesn’t support blanket purchase order.

2. Purchase requisition doesn’t support purchasing fixed asset at all.

3. No validation against Purchase Forecast nor GL/Fixed asset Budget.

Lean manufacturing using AX, a demo

http://player.vimeo.com/video/5953217

For Full Screen and to view in HD click on Vimeo logo to goto and view in Vimeo – it will not full screen in this site from Stephen Wilson on Vimeo.

Create Intercompany PO from Project item requirement

This might be a bug of standard AX:

Go to CEE company.

Go to Project > Item tasks > Item requirement and create a new Item requirement then Click on Function > Create Purchase order

Select vendor 9100 which is CEU, and click OK.

System creates a purchase order which is linked to the sales order (of the item requirement). But:

1. Purchase type is [Journal] and you can’t change it.
2. You can’t post the purchase order
3. No intercompany sales order is created in CEU.

OK… I have just received feedback saying that this is a bug in AX 2009 and will only be fixed in the next version… That’s not a good news then.

Setting up a link between a financial dimension and the site inventory dimension

Setting up a link between a financial dimension and the site inventory dimension enables a company to produce profit and loss figures per site. Use the following procedures to configure and manage financial dimension links for your sites. Set up a financial dimension link to a site Activate the financial dimension link Lock the financial dimension link Unlock the financial dimension link Deactivate the financial dimension link

Note

The Logistics configuration key must be enabled to carry out these tasks.

Set up a financial dimension link to a siteEstablishing a financial dimension link to a site results in the following conditions: A financial dimension is associated with the site inventory dimension. A financial dimension value is associated with each site.

1. Click Inventory management > Setup > Posting > Dimension link.
2. In the Dimensions field, select the financial dimension that you want to link to the site inventory dimension. The Department dimension is selected by default, but you can change it.
3. Click the Sites button to open the Sites form. The financial dimension that you selected (in the previous step) now appears as a column header on the Overview tab.
4. Select a site. In the Dimensions column, select a financial dimension from the lookup list. The list displays the dimensions that are set up in the Dimensions form, which is located at Basic > Dimensions.

The specified financial dimension value is now associated with the selected site. Repeat this step for each site. Activate the financial dimension linkActivating the financial dimension link results in the following conditions: When new transactions are created that carry both inventory dimensions and financial dimensions, the linked financial dimension is assigned the dimension value that is specified for the site. You can post transactions that carry both inventory dimensions and financial dimensions even though the linked financial dimension value does not match the value that is specified for the site. On open transactions that carry both inventory dimensions and financial dimensions, you can change the value of the linked financial dimension.

Note

You must assign a financial dimension value to each site before you can perform this task.

1. Click Inventory management > Setup > Posting > Dimension link.
2. In the Current status: field group, click the Activate link button.
3. The program displays a dialog box that asks whether or not to update the value of the financial dimension value on all open transactions so that it matches the value that is specified for the site.
4. Click Yes. The program updates all open transactions accordingly.

Note

The transactions are updated even if the resulting set of financial dimensions is not a valid combination that is set up in the Dimension sets. This step is the same as running the Linked dimension update batch job, which you can access at Inventory management > Periodic.

1. The program generates the Account dimension validation report, which you can access at Inventory management > Reports > Base data. This report lists the accounts, if any, that are used for inventory-related postings, and that will override the value of the financial dimension that is selected in the Dimension link form.
2. The Current status: button states that the financial dimension link is active, and the colour of the button is yellow. The Dimensions field is unavailable.

Lock the financial dimension linkLocking the financial dimension link results in the following conditions: New inventory transactions that carry both inventory dimensions and financial dimensions are assigned a financial dimension value based on the value that is specified for the site. You can post transactions that carry both inventory dimensions and financial dimensions only when the linked financial dimension value matches the value that is specified for the site. You cannot change the value of the linked financial dimension on transactions that carry both inventory dimensions and financial dimensions. You cannot edit the financial dimension value that is associated with a site. The prerequisites for locking the financial dimension link are: A financial dimension link with the site inventory dimension must be established. The multisite functionality must be activated.

1. Click Inventory management > Setup > Posting > Dimension link.
2. Click the Lock link button.
3. The program generates the Account dimension validation report. This report lists any general ledger accounts that are used for inventory-related postings and that will override the value of the linked financial dimension that is selected in the Dimension link form.
4. The program displays a dialog box stating that it will update the linked financial dimension value on all open transactions so that the linked financial dimension value matches the value that is specified for the site.
5. Click OK. The program updates all open transactions accordingly.
6. The Current status: button states that the financial dimension link is locked, and the colour of the button is green.

Unlock the financial dimension linkOnce the financial dimension link is locked, you can unlock it. When it is unlocked, you can perform the following tasks: Post transactions that carry both inventory dimensions and financial dimensions, even though the linked financial dimension value does not match the value that is specified for the site. Edit the value of the linked financial dimension on open transactions that carry both financial dimensions and inventory dimensions. Edit the financial dimension values that are set up in the Sites form.

1. Click Inventory management > Setup > Posting > Dimension link.
2. Click the Unlock link button.
3. The Current status: button states that the financial dimension link is active, and the colour of the button is yellow.

Deactivate the financial dimension linkWhen the financial dimension link is deactivated, the following conditions apply: The link between the site inventory dimension and the financial dimension is removed. The linked financial dimension is not assigned the dimension value that is specified for the site inventory dimension. You can select a different financial dimension to link to the site inventory dimension.

1. Click Inventory management > Setup > Posting > Dimension link.
2. Click the Deactivate link button.
3. The Current status: button states that the financial dimension link is inactive, and the colour of the button is red.

 

Fill Utility in AX2009

If you are using AX2009, you may want to explore a new feature called Fill Utility. This functionality allows you to update a range of records with a value. Basically, I found that this works like using UPDATE T-SQL statement in query analyzer.

An example: I want to change all customers that are using mode of delivery 10 – Truck to 30 – Rail.

Firstly, you need to activate the configuration setting for Fill Utility by going to Administration > Setup > System > Configuration

Under Administration node, you will find the Fill utility node and need to activate this. It may take a while to finish the task with configuration change or synchronization.

Once you have done that, go to the customer master file, right click on the customer, and choose Record Info

Click Fill utility, you will be able to specify the selection criteria you want to filter. Reset the customer account to blank and set the Mode of delivery to 10 and click OK, system will filter the customer list to get your customers.

Enter the new Mode of delivery and think twice then click OK.

Technorati Tags: AX2009,Fill utility

Alternative Item

Actually, when you set up alternative item with “Nothing in inventory” and create sales order line, system will check the total physical available of ALL site and warehouses. If there is not enough stock, AX will change to the alternative item.

Sometimes, this is confused when you turn on the “Auto reservation” functionality. Because the reservation will only work at warehouse level, not site level. Therefore, if you have enough stock in all sites, system will not replace the item. But it doesn’t reserve against the other site, and you always have something to be available for checking of “Nothing in inventory” functionality.

Here is an example:

Scenario	Sample data	Expected Results
Open item master file, select item number 1501	– Use alternative = “Nothing in stock” – Alternative item number = “1509”
Check the inventory on-hand of item 1501, make necessary quantity adjustment to make sure the on-hand quantity (available physical) is	– Site 1, warehouse 11 = 10 – Site 2, warehouse 21 = 294 – Site 3 = 0
Create a new sales order line	– Item id = 1501 – Site = 2 – Warehouse = 21 – Quantity = 304 – Reservation = Automatic	AX to save the sales order line without replacing the item with alternative item.
Create a new sales order line	– Item id = 1501 – Site = 2 – Warehouse = 21 – Quantity = 11 – Reservation = Automatic	System will change the item id from 1501 to 1509