Overview – Material Application

Main Feature

Material Application is an enterprise-grade platform for managing material requests, approvals, version control, and automated synchronization with SAP. The system streamlines the material request workflow, automates multi-step approvals, and ensures secure, auditable, and integrated material management.

Business Process

Create Request
- Users fill out the request form in the application to create a new material request or update existing material master data.
- Material Request: Submit a request for creating or changing a single material record.
Approval Workflow
- The system supports multi-level approval (up to 2 levels: Initiator → Checker → Approver).
- Reject: Request is terminated with “Rejected” status; requestor receives a notification email.
- Send Back: Request is returned to the requestor with status “Need to Update”; the requestor is notified to modify and re-submit.
- Approve: Request moves through each approval stage, updating the status as “Submitted”, “Approval in Progress”, “Checked”, and “Approved”; all actions trigger notification emails to the requestor.

Synchronization with SAP
- Upon final approval, the request is automatically synchronized to SAP.
- Success: If SAP synchronization is successful, request status is updated to “Success” in “Synchronization History” and marked as “Finished” in both single and batch request lists.
- Failed: If synchronization fails, the request is flagged as “Failed”; Admins can retry synchronization directly from the app.
Audit Trail & History
- Every step, approval action, and status change is recorded for auditing and troubleshooting.
- The system keeps detailed versioning and history records for all material requests.

Tech Stack

Frontend:
Microsoft Dynamics 365 CE Model-driven app, enhanced with JavaScript for UI automation and validation.
Backend:
Microsoft Dataverse platform using custom tables/entities, advanced Business Process Flows, and C# plugins for complex logic.
Integration:
Secure JSON/HTTP APIs for real-time synchronization with SAP ERP.
Security:
- Azure AD Authentication
- Role-based access control
- Data encryption (in transit and at rest)
- Full audit logging
Approval Workflow:
Multi-level (up to 4 steps) approval with automatic email notifications, delegation features, and seamless SAP integration after final approval.

Database and Data Model

Data is managed on Microsoft Dataverse.
Custom entities/tables for:
- Material Requests
- Material Approval History
- Versioning and Audit Trails
- SAP Synchronization History
- Support for material attributes, picking/warehouse info, and custom business rules

Environments

Production
- Solution: Material Application
- Application: Material Application (Approval Workflow)
- Owners: internalams_powerplf@coca-cola.com.vn
Development
- Solution: Material Application
- Application: Material Application (Approval Workflow)
- Owners: internalams_powerplf@coca-cola.com.vn

User Roles

Requestor: Create and submit material requests.
Approver/Checker: Review, approve, or reject requests as per assigned approval levels.
Admin: Configure workflows, manage SAP integration, audit logs, and resolve synchronization failures.

Environment:
1. Production (Approval Workflow):
  1. Solution: Material (Approval Workflow)
  2. Application: Material Approval
  3. User:
    1. Owner: fpt.support01@coca-cola.com.vn
    2. Co-owner:internalams_powerplf@coca-cola.com.vn
2. Development (Approval Workflow)
  1. Solution: Material (Approval Workflow)
  2. Application: Material Approval
  3. User:
    1. Owner: fpt.support01@coca-cola.com.vn
    2. Co-owner:internalams_powerplf@coca-cola.com.vn

Key Benefits

Automated, structured, and transparent material management process
End-to-end tracking and auditability
Tight integration with SAP ERP
Role-based, secure, and scalable
Comprehensive notification and escalation mechanisms

This application is ideal for companies seeking to digitize and automate their material management process, streamline SAP integration, and ensure governance and compliance in every material transaction.