AX 2012: Understanding postal addresses data model

Purpose: The purpose of this document is to quickly understand the underlying data model which is used by Dynamics AX to store postal addresses for a party. Some examples of party are customer, vendor and company. Assumptions: Basic understanding of UML's crow foot notation for data modeling. Data model:  

AX 2012: Open fiscal periods in X++

Purpose: The purpose of this document is to describe how we can quickly open fiscal periods through X++. Development: // Developed on 28 Dec 2015 by Muhammad Anas Khan // Blog: dynamicsaxinsight.wordpress.com // LinkedIn: pk.linkedin.com/in/muhammadanaskhan // Description: Ability to confirm purchase order static void MAKOpenFiscalPeriods(Args _args) { FiscalCalendarPeriod fiscalCalendarPeriod; LedgerFiscalCalendarPeriod ledgerFiscalCalendarPeriod; ttsBegin; //Open fiscal periods … Continue reading AX 2012: Open fiscal periods in X++

AX 2012: Print SSRS Report in PDF to Disk

Purpose: The purpose of this document is to illustrate how we can print an SSRS report in PDF format to disk or file-system in X++. Business requirement: Ability to print an SSRS report in PDF format to disk or file-system automatically. Assumptions: SSRS report is successfully deployed to the report server. Development: Please find below the job … Continue reading AX 2012: Print SSRS Report in PDF to Disk

AX 2012: Cancel product receipt journal in X++

Purpose: The purpose of this document is to illustrate how we can cancel a posted product receipt in X++. Business requirement: Ability to cancel product receipt journal automatically. As of now Standard AX offers manual product receipt cancellation by clicking Procurement and sourcing > Inquiries > Journals > Product receipt > Cancel. Assumptions: Product receipt is posted. Development: Please find below the job … Continue reading AX 2012: Cancel product receipt journal in X++

AX 2012: Correct product receipt journal in X++

Purpose: The purpose of this document is to illustrate how we can correct a posted product receipt in X++ using PurchParmTable and PurchParmLine tables. Business requirement: Ability to correct product receipt journal automatically. As of now Standard AX offers manual product receipt correction by clicking Procurement and sourcing > Inquiries > Journals > Product receipt > Correct. Assumptions: Product receipt is … Continue reading AX 2012: Correct product receipt journal in X++

AX 2012: Confirm Purchase Order in X++

Purpose: The purpose of this document is to illustrate how we can confirm purchase orders in X++ using PurchParmTable table and PurchFormLetter class. Business requirement: Ability to confirm purchase order automatically. As of now Standard AX offers manual purchase order confirmation by clicking Procurement and sourcing > Common > Purchase orders > All purchase orders > Purchase > Generate > Confirm. … Continue reading AX 2012: Confirm Purchase Order in X++

AX 2012: Post product receipt of purchase order in X++

Purpose: The purpose of this document is to illustrate how we can create and post product receipts of purchase orders in X++. Business requirement: Ability to post product receipts of purchase order automatically. As of now Standard AX offers manual product receipt posting by clicking Procurement and sourcing > Periodic > Purchase orders > Product … Continue reading AX 2012: Post product receipt of purchase order in X++

AX 2012: Off-The-Shelf Excel Reader

Download it, adapt it, run it!   Please find above the project XPO of the Off-the-shelf Excel reader. To adapt and run it for your Excel file format: Update macros in the class declaration to match your Excel file columns. Update readExcelFile() method to use your table buffer to persist records in. Click Menu Items … Continue reading AX 2012: Off-The-Shelf Excel Reader