Your task is listed at the bottom of the document, but in short: (Do not USE ANY CHATGPT AND AI TOOLS)

Note: I want Excelsheet for sure please..

1. Understand the companys layout

2. Determine which modules will need to be deployed

3. How the finance modules need to be configured

4. Create a set of requirements (I would like you to produce at least 10 to 15 requirements for each module/area)

5. Create a test case and script for each of the requirements.

Scenario: Stellar Manufacture Inc.'s Implementation of Microsoft Dynamics 365 Finance

Company Overview:

Stellar Manufacture Inc. is a leading producer of advanced electrical components used in a variety of industries including automotive, aerospace, and consumer electronics. With its headquarters in Chicago and manufacturing plants in Mexico, Canada, and Germany, Stellar Manufacture has witnessed steady growth over the last decade.

Current Situation:

Due to increased demand, the company expanded its operations, added new product lines, and onboarded more suppliers. The legacy finance system, which was a patchwork of localized solutions, became inadequate to support this scale of operations. The system struggles with real-time reporting, consolidation of financial data across locations, and lacks integration with other business functions like HR and Sales.

To address these challenges, Stellar Manufacture's executive team has decided to implement Microsoft Dynamics 365 Finance.

Key Implementation Requirements:

Global Financial Consolidation:

With multiple manufacturing plants, there's a need for a single view of the company's financial health.

Will use a global chart of accounts.

Will complete IFRS consolidations.

Will implement the following modules:

Accounts payable

Accounts receivable

Budgeting

Fixed assets

Procurement

Expense Management

Real-time Reporting:

The finance team should be able to pull reports on demand without waiting for batch processing.

Currency and Localization:

The system must handle multiple currencies and be adaptable to local financial regulations of each operating country.

Integration:

Seamless integration with existing CRM, HRM, and supply chain systems to avoid data silos.

Scalability:

The solution should be able to handle the addition of new plants or business units in the future.

User Training:

Many employees have been using the old system for years. Comprehensive training is essential for a smooth transition.

Project Milestones:

Requirement Gathering (2 weeks):

Engage stakeholders from the finance, HR, sales, and supply chain teams to detail their specific needs.

Solution Design (4 weeks):

Collaborate with a Microsoft Partner to design the ERP solution tailored to Stellar Manufacture's needs.

Configuration and Customization (8 weeks):

Adjust Microsoft Dynamics 365 Finance to the company's business processes, ensuring all integrations are functioning as expected.

Data Migration (3 weeks):

Transition relevant historical data from the legacy system to the new platform.

Testing (4 weeks):

Develop test cases based on user requirements and execute them. Address any issues found.

Training (3 weeks):

Conduct hands-on training sessions for employees across different roles.

Go-live (1 week):

Officially transition from the old system to Microsoft Dynamics 365 Finance.

Post-implementation Review (2 weeks):

Address any teething problems, gather feedback, and make necessary adjustments.

Challenges Anticipated:

Resistance to Change:

As with many ERP implementations, there might be reluctance from long-time employees accustomed to the old system.

Data Integrity:

The legacy system may have inconsistencies or outdated records that need to be cleaned up before migration.

Customizations:

Any deep customization might increase the complexity of the project and could pose issues during future system updates.

Success Metrics:

Adoption Rate: 90% of the users should actively use the system within the first month of go-live.

Data Accuracy: Less than 0.5% discrepancies in financial data post-migration.

User Satisfaction: A post-implementation survey should indicate at least 80% user satisfaction.

Conclusion:

The success of Stellar Manufacture's implementation of Microsoft Dynamics 365 Finance will not only depend on the technical accuracy of the solution but also on the company's ability to manage change, ensure data integrity, and efficiently train its users.

Please create Exc for this please..

Full info given in the question.