How To

AX 2012Financial DimensionsSQLGeneral LedgerAX 2012View

Implementing Your Ledger Transactions with split out Financial Dimensions view

By Nathan Clouse / Wed 09,2015

This articles covers implementing your Ledger Transactions with Financial Dimensions view. This create a view similar to the table LedgerTrans from 2009.

AX 2012Financial DimensionsSQLGeneral LedgerAX 2012View

Implementing Ledger Dimensions Flattened View for your Financial Dimensions

By Nathan Clouse / Wed 09,2015

Implement a series of views that creates a view that works similar to the LedgerTrans table in 2009.

AX 2012Financial DimensionsSQLGeneral LedgerAX 2012View

Implementing Your Ledger Split Dimension Entity

By Nathan Clouse / Tue 09,2015

Part of a series of views to create a view that is similar the the table LedgerTrans in 2009.

AX 2012ReportingSQLSSRSBasicAX 2012

AX 2012 Simple Reporting Database

By Nathan Clouse / Mon 08,2015

Creating a database to hold simple but powerful reporting shortcuts can help provide data on demand to executives and department heads when a unique or surprising issue arises.

AX 2012Financial DimensionsSQLGeneral LedgerAX 2012View

AX 2012 Financial Reporting, simplified

By Nathan Clouse / Fri 08,2015

The changes from 2009 to 2012 as it related to financials are fairly comprehensive and those of us who have made that transition have at least one point in time said "I miss LedgerTrans".

PPVSQLAX 2009Accounts PayableAP ReceiptAP Invoice

2009: PO Receipt and Invoice PPV

By Nathan Clouse / Tue 08,2013

A sample query to provide additional insight into PO Receipt and Invoice PPV in 2009.

AX 2012PPVSQLAccounts PayableAX 2012AP Invoice

2012: PO Invoice PPV

By Nathan Clouse / Tue 08,2013

A sample query to provide additional insight into PO Invoice PPV in 2012.

PPVSQLAX 2009Accounts PayableAP InvoiceAX 2009

2009: PO Invoice PPV

By Nathan Clouse / Tue 08,2013

A sample query to provide additional insight into PO Invoice PPV in 2009.

AX 2012PPVSQLProcurement and SourcingAX 2012AP Receipt

2012: PO Receipt PPV

By Nathan Clouse / Wed 08,2013

A sample query to provide additional insight into PO Receipt PPV in 2012.

PPVSQLAX 2009Procurement and SourcingAP ReceiptAX 2009

2009: PO Receipt PPV

By Nathan Clouse / Tue 08,2013

A sample query to provide additional insight into PO Receipt PPV in 2009.