Services
Platform and Technology Capabilities
Home / Insights / Case Study / Dynamics 365 Global Financial Implementation Helps an Industrial Engineering Company with Seamless Financial Unification and Consolidation
Services: Dynamics 365 for Finance and Operations Implementation
The manufacturing company has over 15,000 passionate associates in offices across six continents, with 50 legal entities spread across the US and UK. To connect all the financial and accounts data in a seamless manner, the client implemented Microsoft Dynamics AX 4.0 (on-premises) solution.
Dynamics AX 4.0 was used to maintain accounting and financial data, which includes usage of modules such as General Ledger, Accounts Receivable, Accounts Payable, Cash and Bank management and Fixed Assets. The client was also using CRS for consolidating their financial data across all entities.
However, due to rapid growth in business, the client required enhanced connectivity and scalability capabilities to take full advantage of their business data. Also, support for Dynamics AX 4.0 ended in 2016. They were looking to upgrade to Dynamics 365 for Finance and Operations, so they could seamlessly manage their business, import critical financial data, and record Vendor Invoices in the solution once they are processed and approved.
The client also had a requirement of generating and consolidating Financial Statements out of Dynamics 365 which were customized in Dynamics AX 4.0. The client approached Synoptek to carry out the Dynamics 365 for Finance and Operations implementation and upgrade project.
Through a series of requirements and design workshops, Synoptek performed the upgrade assessment and evaluated the manufacturing client’s existing Dynamics AX system.
A hybrid approach was taken to ensure that Dynamics AX 4.0 related processes and setups were retained. Additionally consolidation and updated features were leveraged by the client team.
CRS: The client used CRS for financial data consolidation. Synoptek customized the export format for Trial Balance to export balances from Dynamics 365 for Finance and Operations and upload to CRS. The integration was supported by a master which offered mapping for Dynamics 365 for Finance and Operations and CRS Chart of Accounts.
Paymode: For making Vendor payments in the US, the client used Paymode by Bank of America. Synoptek developed a customized payment file which contained all required information along with the specification for Check and ACH payments.
HSBC Payment files: In the UK, HSBC payment file formats BACS and SEPA were used; Synoptek customized these formats as per the Bank’s requirement for formats.
Basware: Since Vendor Invoices were processed in Basware, once the Invoices are processed and approved, we made use of an Excel add-in and customized it, so invoices could be exported from Basware and uploaded in Dynamics 365 for Finance and Operations.
Synoptek configured all customized reports used by the client in Dynamics AX 4.0 in Management Reporter. Since we used a reporting tree, it made it easy for users to switch between the entities and generate consolidated reports.
Synoptek divided the Data Migration project into two parts: Master Data Migration to Dynamics 365 for Finance and Operations which was done before the cut-off date and Balance Data Migration which was done after the cut-off date, once the balances were finalized by the team. To make the process seamless, Synoptek shared templates for all the Masters and Balances with the client and uploaded them into the system using an Excel add-in.
For security roles, the client needed three roles:
Synoptek customized and enabled all three roles in Dynamics 365 for Finance and Operations.
With Synoptek’s guidance and support for Dynamics 365 for Finance and Operations implementation, the client has been able to: