Patrik L. posted an article on
IT Pro Ramblings
-
Jan 17, 2012, 3:07 pm
Introduction
In this post, I explain the different steps to generate a document using a Word template and the Office Add-ins for Dynamics AX 2012. Publish data sources
You need the define which data sources from Dynamics AX, users are allowed to use in Office. Go to Organ... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 17, 2012, 4:40 am
Problem description
You may be searching for the Quantity tab on the Sales order form in Dynamics AX 2012 where you can find stuff like the Quantity Delivered, Invoiced, … for each sales line of the sales order, and not able to find it. It has been moved a bit in the AX 2012 release. So... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 13, 2012, 2:57 am
Finally, entering hours on a project in another legal entity will become possible in Dynamics AX 2012, according to a Technet article.
I haven’t tried it yet, but it sounds great:
The intercompany timesheet feature in Microsoft Dynamics AX makes it possible for a worker who is emp... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 9, 2012, 8:18 am
There is a nice Technet article, describing the different ways of consuming item in the Project management and accounting module. I would like to extend it a bit further with this post, elaborating further the differences between all those ways. Method 1: Project sales order
 Item tr... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 2, 2012, 10:38 am
Some information about creating purchase orders for projects in AX 2012 can be found on TechNet.
In the past, I wrote already a post Project Purchase Orders vs Purchase Orders. This post was valid for AX 2009 and before, some changes have been made in AX 2012.
I would like to extend th... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Nov 4, 2011, 6:09 am
Business requirement
In AX 2012, there is the whole new concept about the Organization Model. One of the scenarios you can support is to use a worker in multiple legal entities. To do so, you have to employ the worker in multiple legal entities. Let’s say for example the worker has to be a... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Oct 25, 2011, 7:43 am
Business requirement: Printing documents linked with Document Handling while printing Reports
This post describes how you can print automatically documents linked with Document Handling while printing a Report. This post elaborates following business scenario: users attach documents to the P... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Oct 24, 2011, 9:33 am
Business Requirement: printing ranges on a report
Printing the ranges with which a Report has been executed is only available for a AutoDesignSpecs Design of a Report.
Unfortunately this option is not available for Reports having a Generated Design. Solution: override executeSection ... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Aug 9, 2011, 8:33 am
Problem description: Intercompany orders with direct delivery cannot be created because of the WMS setup
Creation of a direct delivery purchase order for an intercompany vendor may fail with following error message: Intercompany orders with direct delivery cannot be created because of the WMS... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jul 13, 2011, 11:25 am
This X++ Code Snippet describes how to create a PurchTable.
PurchTable purchTable;
NumberSeq numberseq = NumberSeq::newGetNumFromCode(
PurchParameters::numRefPurchId().NumberSequence,
true);
purchTable.clear();
purchTable.PurchId = numberSeq.num();&... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jul 8, 2011, 7:13 am
This post is a code snippet showing how to extract the date from a DateTime field myDate = DateTimeUtil::date(ContactPerson.LastEditAxDateTime)
Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jun 10, 2011, 3:42 am
Business requirement: automatic setting of mail recipient and mail subject during posting
This post describes how to set the mail recipient and mail subject dynamically, but in an automatic way upon posting the packing slip for a purchase order. The printed packing slip is added as PDF to the... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jun 3, 2011, 4:49 am
Business requirement: update planned order
upon modification of a salesline
without master scheduling
Sometimes you want to see changes made on a SalesLine immediately on the
reference Planned Order, without Master Scheduling. This post describes
how you ... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Apr 21, 2011, 7:33 am
Problem description: fill utility not working
Upon using the Fill utility in Dynamics AX 2009, you may notice it didn’t update your selected values. Nevertheless you didn’t receive an error or message. Probably the cause is the field you want to mass update is not part of the primary dat... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Mar 10, 2011, 4:39 pm
Problem description: how to remove HTML tags from a string with X++ code
How to remove HTML tags from a string with X++ code. Solution: Web::stripHTML
There is a nice X++ function: just call Web::stripHTML(string), which will return the string without the HTML tags.
... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Mar 6, 2011, 11:25 am
Interview with Guy Weismantel, Microsoft’s Director ERP Marketing about the upcoming new release of Dynamics AX 2012 from Software Advice. Guy explains how he thinks Microsoft’s partners will have to adapt to survive in the cloud.
Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Mar 6, 2011, 10:58 am
Interview with Guy Weismantel, Microsoft’s Director ERP Marketing about the upcoming new release of Dynamics AX 2012 from Software Advice.
Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 18, 2011, 3:56 am
Introduction
This post describes the difference between Project Purchase Orders and normal Purchase Orders. Both can be used to buy items for a Project and both to generate Item Transactions on a Project, but nevertheless there are some major differences between both, mainly in the logistic f... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 5, 2011, 5:44 am
Problem description:
Upon deploying proxies (Tools > Development Tools > Web development > Proxies > Generate), I ran into following error: ClrObject static method invocation error. Solution: Specify manually the proxies Directory
The problem is apparently that the process wasnâ€... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Nov 2, 2010, 4:15 pm
Business requirement: Adding a custom filter to a form
In some cases it is required to ease the filtering on a form. In some cases end users don’t have enough Dynamics AX knowledge to use the Advanced Filter Sort functionality to create a query on the form to achive their filtering require... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Nov 2, 2010, 3:46 pm
Business requirement: creation of Intercompany Purchase order for a project item requirement
Upon creating an Intercompany Purchase Order based on a project item requirement, the Purchase Order is of type Journal and is uneditable. Hence the Intercompany Sales Order isn’t created neither i... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Oct 19, 2010, 3:49 pm
This X++ Code Snippet describes how to handle all values in a switch statement or if else statement. If you want to avoid someone calls the function or method with a value which isn’t explicitly handled in your conditional statement, you can throw an error with the name of the function to the end ... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Oct 4, 2010, 3:53 pm
I decided to share all my interesting reads and resources month by month with my blog readers. You can find these posts by searching on the label Links. I'll try to order the resources in logical categories. If you would like to see some interesting stuff added in the next month, don't hesitate to p... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Sep 24, 2010, 4:04 pm
This X++ Code Snippet post describes how to find the available quantity from the physical inventory over all storage dimensions (it is, without taking into account site, warehouse, batch number, location, pallet id or serial number) for a particular item. X++ Code Snippet: Find available quantity f... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jul 19, 2010, 9:49 am
Business Requirement: Supplementary items functionality on Project Item Requirements
In standard Dynamics AX, the Supplementary Items functionality to calculate the number of supplementary items to be added to an order line is not available for item requirements. It can be added however easil... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jul 17, 2010, 3:46 pm
Problem description: Add method of Styles class failed
Upon exporting some Dynamics AX data to Microsoft Excel, I ran into an Error, mentioning the cryptic Add method of Styles class failed. Solution: Rename the added Style
I described in a previous post Export to Excel with X++ code:... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jun 29, 2010, 2:54 pm
Business requirement: Change the behaviour of a form without user interaction
Upon opening a form, you would like to change its behaviour without interaction of the end user, for example, you want to preset some filters, hide some columns, … depending on the context it is called. Off cours... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jun 25, 2010, 3:44 pm
This X++ Code Snippet post describes the use of a Message Box to ask the user for a confirmation before an update or process is executed. X++ Code Snippet: Using a Message Box
A Message Box will be created using the Box class, asking the end user for a confirmation before the process is ... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jun 15, 2010, 5:47 pm
Introduction
I wrote already in the past about the possibilities to export data from your Dynamics AX ERP system to Microsoft Excel through X++ code.
My first post Export to Excel with X++ code described how to export some data to different worksheets in an Excel file.
My secon... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jun 1, 2010, 4:33 pm
I decided to share all my interesting reads and resources month by month with my blog readers. You can find these posts by searching on the label Links. I'll try to order the resources in logical categories. If you would like to see some interesting stuff added in the next month, don't hesitate to p... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
May 4, 2010, 4:48 pm
Business Requirement
With the DataField Property of a section group control on a report, you can create sections using the same table. In this post I explain how you can turn this off if the DataField Property has a value in your Report Design.
This post uses an existing Report as exa... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
May 1, 2010, 7:36 am
I decided to share all my interesting reads and resources month by month with my blog readers. You can find these posts by searching on the label Links. I'll try to order the resources in logical categories. If you would like to see some interesting stuff added in the next month, don't hesitate to p... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Apr 14, 2010, 3:52 pm
Introduction
This post is a sequel to my post Export to Excel with X++ code. In this post I add some formatting to my Excel export file. autofit column width working with styles to set fonts to bold working with style to set font color setting the format of a column X++ ... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Apr 5, 2010, 9:28 am
The Fill Utility is a handy new tool since Dynamics AX 2009 with which you can update multiple records at the same time. However in some cases, you’ll notice it isn’t available.
This depends on the Table Group. The Fill Utility can only be used on tables belonging to the Table Group Main... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Apr 5, 2010, 8:47 am
This X++ Code Snippet post describes how you can easily copy records by running over all of the fields of the from-record. During this looping over all the fields, you can exclude some fields if needed. X++ Code Snippet: Copying records
Create following method in a class: static void ... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Apr 4, 2010, 2:55 pm
Business Requirement: Incrementing Date in Repeating Table
The business requirement of this post covers the following topic: each time the user adds a line in a Repeating Table on an InfoPath form, the Date Field of the line should increment by one day automatically.
An example is elab... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Apr 1, 2010, 3:33 pm
I decided to share all my interesting reads and resources month by month with my blog readers. You can find these posts by searching on the label Links. I'll try to order the resources in logical categories. If you would like to see some interesting stuff added in the next month, don't hesitate to p... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Mar 27, 2010, 3:26 pm
Introduction
In Dynamics AX, you can use valueStr to get the string value of a ComboBox control on a Form. In Axapta 3.0 SP1, this method doesn’t exist. Example in Dynamics AX 2009 Create a new form. Add a ComboBox control in the Design node. Set property EnumType of... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Mar 20, 2010, 5:45 pm
Business Requirement: go to other form
The Infolog System can be easily customized in Dynamics AX. You can attach actions to the displayed messages in the infolog. Upon double clicking the message you could for example go to another form, related to the displayed message. On MSDN, you can fi... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Mar 8, 2010, 10:49 am
Business Requirement: Forms should have a different colored background by company account
When users are working in different company accounts in Dynamics AX, it isn’t always obvious to know in which company account they’re working. Off course they can see it in the Status bar if they have... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 15, 2010, 11:42 am
Problem description: Windows cannot access the file gpt.ini
In a Microsoft Virtual Machine, following error is logged in the Event Viewer:
Windows cannot access the file gpt.ini for GPO CN={31B2F340-016D-11D2-945F-00C04FB984F9},CN=Policies,CN=System,DC=,DC=local. The file must be prese... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 6, 2010, 8:26 am
Introduction: Week numbers in Dynamics AX
This post is about showing the week number in date controls in Dynamics AX. This was by default shown in Axapta 3.0, but disappeared since Dynamics AX 4.0. The second part of this post describes how you can adapt the week number calculation, as there... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Jan 1, 2010, 8:51 am
I decided to share all my interesting reads and resources month by month with my blog readers. You can find these posts by searching on the label Links. I'll try to order the resources in logical categories. If you would like to see some interesting stuff added in the next month, don't hesitate to p... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Nov 30, 2009, 11:59 am
I decided to share all my interesting reads and resources month by month with my blog readers. You can find these posts by searching on the label Links. I'll try to order the resources in logical categories. If you would like to see some interesting stuff added in the next month, don't hesitate to p... Comment - Like
Patrik L. posted an article on
IT Pro Ramblings
-
Nov 21, 2009, 1:28 pm
Business requirement: find all relations defined on a Dynamics AX table object
In Dynamics AX, relations can be defined on a table object to connect tables with each other: it lets MorphX know how the data model looks like. Next to relations defined on the table itself, it is also possible that a ... Comment - Like
Recent Discussions
