Major Projects as an Independent consultant

AX 2012 R2 to R3 upgrade   Duration – 1 month

• Client had two different companies which were on AX 2012 R2 version and wanted to start with the pilot project of upgrade from AX 2012 R2 to R3 (In-place upgrade) for their smaller company which acts as a financial organization.
• We had started the upgrade process as per the Microsoft recommended scenario of In-place upgrade and successfully completed Data upgrade and Code upgrade from AX 2012 R2 to R3.
• After successful completion of Data upgrade and Code upgrade, we moved Database DB and Model DB to UAT environment for full business processes functional testing to business users. During the UAT, whichever issues found by the business users on UAT, we resolved them on DEV environment and then promoted changes to UAT for further testing. Gradually, we completed functional testing as well as regression testing throughout different trials and start preparation for Production upgrade.
• At the time of Production upgrade, we created a new box with installation of required components of AX 2012 R3 and then restored UAT databases on the new box. After that provided shared configuration file to the business users to access new AX 2012 R3 PROD box.

AX 2012 R3 Implementation   Duration – 4 months

• Worked as a Lead consultant with the team including Finance consultant and T&L consultant for an outsourced project.
• Went to Riyadh, Saudi Arabia at client site with the Business consultant to understand requirements of customizations needed and also gathered new report design requirements

Worked modules: Sales and marketing, Inventory management, Product information, Procurement and souring

Area of work: Tables, Forms, Classes, SSRS reports

AX 2009 customizations      Duration – 4 months

• Client asked to update labels and add some new fields on few Forms and display them on MorphX reports in AX 2009.
• Client didn’t have English language license and the entire AX 2009 system was in ‘Thai’ language. This was the most challenging part of the project as the navigation in AX 2009 was in ‘Thai’ and thus it required more efforts even for a small change because of the language barrier.
• With the help of a functional consultant (Thai to English translator) who captured requirements from business users and transferred over to me, was able to complete technical challenges.

Worked modules: Customer, Vendor, Ledger

Area of work: Tables, Forms, MorphX reports

AX 2012 Customizations/Bug fixings/Support        Duration – 8 months

• This project was a post implementation project. There were lot of customizations done by old developer but were not as per the client specifications.
• As a Technical consultant, communicated with the end users to capture requirements and issue list of current customizations. Also, captured new requirements of customizations from business users.

Worked modules: Sales and marketing, Procurement and sourcing, Accounts Receivables, Accounts payables, General ledger, Inventory management, Product information management

Area of work: Tables, Forms, Classes, SSRS reports

Other customizations as an Independent consultant

• Inventory counting management analysis inquiry – A customized inquiry form to get the details of counting history by item, site and warehouse. Also, wanted to have On-hand value and Count value variance on the same screen to identify the discrepancy between the Count and On-hand inventory.
• Purchase order import entity in DMF – Created new entity in DMF to import purchase order header and lines
• Fixed asset and Fixed asset transaction entities in DMF – Created new entities in DMF to import fixed assets and fixed asset transactions
• Bank account reconciliation modifications – Client asked to add Recipient type, Recipient name and Modified date & time fields to Checks form. Also, add a new field name ‘Cleared date’ on Bank account transactions form which will be populated with today’s date when a transaction is ‘Cleared’ (checkbox is checked). The user can also manually change the cleared date. If the check box is unchecked, the date is blanked out from the new field. Also add the ‘Cleared date’ to the checks Form, also make it editable so user can update the cleared date.
• Mandatory fields on Return orders – Client asked to set Site and Warehouse as mandatory fields for Return order only.
• Item master cost price update – Client asked to update cost price on item master if there is a change in current value and the value provided in a CSV file. Developed a job to update cost price on item master with the required business logic.
• Security role modifications – Creation of new security role as well modifications to the existing security roles to add duties, privileges of newly created reports (Output menu items), classes (Action menu items) and forms (Display menu items).
• Return order modifications – Client asked to create new check box ‘Direct invoice’ on create new sales order form as well as sales order header view. If this check box is checked, allow the override of Order type as Return order and Unit price on sales order line. Also, confirm that packing slip option is enabled for return order else override to allow packing slip for return order.
• Sales order list page: Totals function – Currently Totals function does not show values when sales orders are Invoiced. Probably because it is only used to calculate the open lines. Client asked to create new function by copying the current function, place next to current function. Call it “Totals ALL”. Remove the logic to exclude invoiced activity. The function should run for entire sales order regardless of the status of this order.
• Discounted unit price on Sales orders and Sales quotations – In AX 2009, Client asked to add a new field on sales orders and sales quotations form to display calculated discounted unit price if there is any discount amount or discount percentage applied on sales line or sales quotation line.
• Data migration framework to import master – Prepared masters of customers, vendors, main accounts, items, bank accounts and other group tables also to import using Data migration framework in AX 2012.

Troubleshooting/Maintenance/Bug fixing in AX 2012

• Deployment of SSRS report – Client has reported that they are not able run the report due to configuration change of SSRS reporting. The applied solution was deleted the Dynamics AX report folder, created new folder, deployed reports using AOT, restarted the reporting service.
• Compile application, CIL full compilation and DB synchronization – Support for regular maintenance activities like full CIL compilation, compile application and DB synchronization of PROD, TEST and DEV environments weekly
• Copy down/Restore environments – Support to copy Data DB and Model store DB of PROD to TEST and PROD to DEV using SQL server as when required to have refresh environment as per PROD
• Install/Uninstall AX 2012 – Done Installation/Uninstallation of AX 2012 Database, Application object server, Client, Debugger, Management utilities, Visual studio tools, SSRS reporting services etc.
• Number sequence reset – Client has reported that they received an error while posting the payment journal. After debugging the code I found that it was due to data manipulation in the number sequence of payment journal number. I reset the number sequence of payment journal and cleared status list of number sequence and issue was resolved.
• AP payment journal date issue – Client has reported that when creating an account payable payment journal through the vendor payment proposal, system uses due date from the open vendor invoices as a transaction date on payment journal lines. It should be system date (Today’s date) as transaction date on payment journal lines. I have analysed and debugged the functionality of vendor payment proposal and found that there is a parameter named ‘Total payment date’ should be set as a system date (Today’s date). After making these changes when we created payment journal using vendor payment proposal, system had captured open vendor invoices and created payment journal lines using system date (Today’s date)

SSRS reports in Dynamics AX 2012

• New account manager report – A customized report to display newly created customer accounts with details
• Invoice payment terms report – A customized report to display invoice details along with their payment terms
• Credit card report – A customized report to display credit card transaction amount along with invoice information
• Debit memo report - A customized report to display pending invoice transactions with details
• Customer payment journal report – Modifications to an existing report in terms of design and additional fields
• Sales proforma invoice report – Modifications to an existing report in terms of design and additional fields
• Customer transaction list report – Modifications to an existing report(Commission transactions list) to display worker commissions with invoice information
• Detailed due day list report – Modifications to an existing report design to flatten the report by vendor account to export in excel
• External customer account statement report – Modifications to an existing report to export it into PDF file in a single page with additional information
• Customer extended info report – A customized report to display extended customer information which are customized fields on customer master along with customer account as a filter (Extended information fields are customized fields of customer)
• Raw material in process report – Modifications to an existing report of production control to add Site field on the report
• Purchase order confirmation report – Modifications to an existing report to add currency field on the report
• Customer title report – A customized report to display customer insurance information along with the loan details (Insurance and loan details of customer are customization)
• Invoiced sales detail statistics report – A customized report displaying customer invoice information with detail related to item, price, cost, sell from company, customer and related trade agreement
• Balance analysis report – A customized report displaying item sales information, with detail related to customer, site, main account and accounting period
• Sales by state report – A customized report displaying item sales information by state
• Invoiced gross sales with addresses report – A customized report displaying item sales information with addresses
• Adjustments report – A customized report displaying Invoice transactions and deduction transactions settled against payment transaction
• Sales order tracking report – A customized report displaying Sales transactions along with customer information, delivery information and tracking information.
• Open sales order report – Modifications to an existing report (Open sales orders) displaying Sales line transactions which are open and not invoiced along with customer information, quantity information and date information
• Consumer refund report – A customized report which display customer transactions records with open balance only along with RMA number, Customer PO number, delivery information and pricing details
• Check layout report – Modifications to an existing report (Check layout) to accommodate check layout changes
• Ledger transactions by Customer/Vendor report – A customized report to display ledger transactions along with the information from audit trail to show Customer/Vendor information

MorphX reports in Dynamics AX 2009

• Sales quotation, Sales confirmation and Sales invoice reports – Client asked to have discounted unit price field on all three reports also to adjust the report layouts to fit into a single page when exported to PDF file.
• Accrued purchase report – A customized report, Client asked to give accounting the POs received but not invoiced by Item / Qty. / Amount. The report should help accounting in reconciling the Goods Received not yet Invoiced account and should help in month end process to see which POs need to be invoiced. The report should also allow user to run for a previous date (As of Date)

SSRS reports in Dynamics 365 finance and operations

• Ledger trial balance (Summary, Detail, Consolidated) – Client asked to have same trial balance report as per AX 2012 R3 in D365. Designed Summary and Detail version of trial balance report as per client’s requirement. Also, added the capability to run this report from any legal entity including transaction currency for all the legal entity trial balance in a single report (Multi company, Multi currency report)
• Out of pocket expense report – A customized report, Client asked to have a report about the expenses occurred as project transactions on ledger accounts by vendors. This report was also designed to have cross-company capability.
• EL4 wire instructions report – A customized report, Client asked to have a report as per their current finance system which demonstrates wire instructions with detailed information about the vendor bank accounts.
• Internal wire cover sheet report – A customized report, Client asked to have a report as per the designed template they used with their current finance system to display wire transactions along with the disbursing bank account and receiving bank account information.
• Customer account statement report – Modifications to an existing report, Client asked to have modifications to the existing customer account statement report as out of the box report is basic and does not contain some information as per company’s standards. Added company logo, removed a number of extraneous fields, and some fields moved so that the report looks easier to read and fit client’s specifications.
• Deferred advisory income summary by fund report – A customized report, Client has asked to have report as per their existing finance system to group ledger transactions by the classification groups.
• Fees sharing percentage analysis report – A customized report, Client has asked to have report as per their existing finance system to display ledger transactions grouped by specific ledger accounts which are to account various fees.
• Cash reconciliation summary report – A customized report, this report was basically a reconciliation report between Bank accounts and GL accounts in which bank transactions are posted. The design was as per client requirements.
• Free text invoice report – Modifications to an existing report, Added new fields related to tax code information and displayed them on the report
• Project transactions report – A customized report to display project transactions as per the complex business logic specified by the client which include funding sources, funding rules and project contracts.
• Vendor transactions report – A customized report to display vendor transactions as per the client specifications of design. This report was developed to have consolidated option to run the report for all companies into one.
• Voucher transactions report – A customized report looks like the voucher transaction inquiry form. This report needed to have a capability to run across all companies and to add few extra columns like legal entity information, journal information, and financial dimension information.
• Fixed asset roll forward report – A customized report to display all fixed assets information from across all companies which includes beginning balance, additions to fixed assets, depreciations of fixed assets, disposals of fixed assets and ending balance of fixed assets.
• PMA invoice report – Modifications to an existing report, this was a report format changes to existing project invoice report. The new design format changes were as per the client specifications.
• Procurement and Sourcing reports – Modifications to some standard reports as well as new report customizations like Purchase order confirmation, Purchase order packing slip, Purchase inquiry, Product label report, Packaged item barcode report, Commercial invoice report (Bill of lading report)
• Sales and Marketing reports – Modifications to some standard reports as well as new report customizations like Sales order confirmation, Sales order packing slip, Sales order invoice, Sales order return ticket, Sales backlog details consolidated, Return order report
• Project Management and Accounting reports – Modifications to some standard report like Project invoice and Project invoice proposal reports

Customizations in Dynamics 365 finance and operations

• Service management module – Customizations to existing service management module’s objects. Added validation to service object to validate check for duplicate customer, Lookup on copy service object form, Added new lookups for customized entity Garages as well as for Transit authority, Provided address functionality as per Site entity to the Garage entity
• Data Entities – Creation of new custom data entities like Customer invoice transactions, Recreation of Project invoice journal entity, Project invoice item entity and Vendor packing slip transaction entity, Invent table entity, Modification to Employee data entity
• Positive pay format export – Initially created an SSRS report to export paid checks details to an ASCII file and send it over to the bank as positive pay file. However, while exporting the report first to a word file added some unwanted new line as well as carriage return ASCII character when tried to convert it to the ASCII from WORD file. Developed a customized process where user can enter details of the bank account and date range for the paid checks. At the end of the process it generates an ASCII formatted file as per the predefined format provided by the bank with the paid check transaction details
• Bill of lading generation and print process – In Dynamics 365 finance and operations, current Bill of lading report format was not up to the mark for client. It has been redesigned to full fill all the required fields on bill of lading report. Number of required fields have been added on load lines to link them with individual shipment and sales order. Customized bill of lading standard process to run with the custom bill of lading report design as well as modified packing slip posting process to control bill of lading print process.
• Consolidated project budget revision – In Dynamics 365 finance and operations, current project budget revision process doesn’t support project budget revision from two different projects which are not linked with each other or parent-child projects. In order to achieve this functionality, a new process has been developed with consolidated project budget revision list page and detail page where user can enter information about the project budget lines from different projects and revised the budget amounts. The purpose of this customization is that as per the business process of client, if they revise any project budget line with an increase amount at the same time they would like to decrease amount from another project budget line and it could be from any other projects. So, in consolidated project budget revision form, user can revise various project budget line information and submit them for project budget revisions. On back of the process, system creates individual project budget revisions per project defined in the consolidated project budget revision form and auto-submit it to the project budget revision workflow.
• Unit cost settlement process – As per the client requirements, they want to allocate/capitalize project transactions cost to fixed assets which are mapped as child fixed assets on the project. In this functionality, an entire wizard has been created to walk-through the unit cost settlement process. Initially, on the first screen of the wizard, system allows user to select child fixed assets mapped to the project on which unit cost should be settled. On the next screen, system allows user to select project cost transactions to be settled against the selected child fixed assets of the project. On the last screen of the wizard, system allows user to review child fixed assets, project cost transactions, grouped fixed assets based on the asset type and based on the amount to be settled from the project cost transaction. It does the calculation of extended unit cost, allocation percentage of amount per grouped fixed assets and acquisition value (customized field) of fixed assets. Once the wizard process finishes, system creates a fixed assets journal to capitalize project cost transactions to the parent fixed asset of the project and inserts all the reviewed information as records into the history tables. Along with this process, there are inquiry forms are created to view the unit cost settlement history, unit cost settlement history details and fixed asset unit cost settlement history.