How To

AX 2009BasicCodeAX 2012FileDirectory

Build A List Of Files In A Directory

By Nathan Clouse / Tue 12,2011

A code sample on how to build a list of files in a directory.

Configuration KeyAX 2009BasicAX 2009

Check if a Configuration Key is Active / Enabled

By Nathan Clouse / Fri 11,2011

Code sample to check if a configuration key is enabled.

LabelAX 2009BasicSysDictFieldAX 2012AX 2009

Get a label for a field

By Nathan Clouse / Fri 11,2011

A code sample on how to get the label for a field on a table.

QuerySQLAX 2009Basic

Get SQL from an AX Query

By Nathan Clouse / Tue 11,2011

Need to get the SQL satement from a query? Take a look here.

AX 2009BasicAX 2009DataAreaId

Force Data Area ID on SSRS report that doesn't use an AX Query

By Nathan Clouse / Wed 11,2011

If you have SSRS reports that are "Classic" SSRS reports that don't use an AX Query, you can still force feed the report a data area Id dynamically to use when running.

AOSAOS ClusterAX 2009BasicAX 2012Config

Put Multiple AOS's in a Cluster

By Nathan Clouse / Wed 10,2011

Creating a dynamically load balanced AOS cluster without a dedicated load balancer is easy and straight forward.

AX 2009Production / Production ControlCodeAX 2012ProdTableJour

SQL: Query to sum up Batch Order Pick or report as finished Journals

By Nathan Clouse / Wed 10,2011

SQL query to get the sum of Good Qty  for a production order.

Number SequencesAX 2009BasicAX 2012AX 2009Number Sequence Ref

Adding a Number Sequence Ref to a module parameters screen

By Nathan Clouse / Mon 10,2011

If you want to add a number seqeunce reference to a module, you can use the following code in the class NumberSeqReference_(FunctionalArea).

AX 2009Accounts PayableCodeAX 2009purchFormLetter

Purchase Order: Post Purchase Order in Code

By Nathan Clouse / Tue 09,2011

A code sample on how to post a purchase order in code.

AX 2009Accounts PayablePurchFormLetterCodeAX 2009purchFormLetter

Purchase Order: Post Receipts List in Code

By Nathan Clouse / Tue 09,2011

A code sample on how to post a receipts list in code.