Li & Fung Blockchain Automated Supply Chain Solution Case Study

Challenges the Client Wished to Address

The existing supply chain procedures involve a lot of manual intervention that increases the possibility of human-induced errors resulting in unfavorable situations.

Such levels of human involvement also tend to reduce the overall efficiency of operations due to various factors such as mismanaged workload, fatigue, and worker shortage.

Especially the processes “stock trading,” “purchase orders,” and “delivery” face the most problems in this regard.

Project Requirements

We came up with a blockchain-powered solution consisting of four elements – a smart contract-based database, stock management system, purchase management system, and delivery management system.

We planned to make these portals friendly to both Web and mobile versions as both types of devices were used in the client’s outlets.

Our idea was to implement an automated system consisting of 3 different portals loaded with nearly 40 features for easy functionality and management.

What Did We Do?

Three different teams of blockchain developers, web developers, mobile app developers, and project managers were utilized for the project to accomplish the task in the given time frame. We employed agile methodology for the process that helped our professionals deploy the completed application in the said timeframe. The platform was built on the Ethereum network to enhance the security of smart contracts that monitor the database. We enabled various functionalities for each portal according to particular user-end requirements to facilitate seamless processes and data safety.

Propose Your Ideas Here Consult Our Experts

Technological Stacks Employed

Blockchain

Ethereum

Backend

Java

PHP

Storage Platform

SQL

Frontend

Node.JS

The Outcome

The resultant platform comprised the following portals – McD, McThai Accounting, and MyGo that catered to different user ends. The McD portal helps the client track and manage stocks in the outlet. The McThai Accounting app assists the client in managing orders and transactions. The MyGo application allows the client to manage deliveries and service partners without hassles. Together, these applications facilitate a smart solution that eases operations for the client’s various outlets at all times, powered by decentralized processes and real-time updates.

Requirement from LI FUNG

Purpose of Optimization – Problem Statement

Logistics and supply chain is a vast area of exploration in operations. Considering the steps in the operational processes carried out, the number of manual processes are huge in numbers. We know the vulnerability of human errors and how much they can affect a process in supply chain.

So Li Fung came to us with an existing problem of errors and efficiency in their processes. So to optimize the process we intended to automate it. Based on the requirements, we figured out the following problems,

Stock tracking

Purchase Orders

Delivery

Schedule A Meeting Talk with our Experts

McD

Mobile (Restaurant Login):

Stock taking

Update the stock on their server (OTM)- Stocks received, damages, shortage, return, etc.
Based on the data, reports will be generated

Admin

Product management
User management
Restaurant management
Reports, able to send through mail

Offerings - Mobile and Web (Admin)
Design - Marvel provided by client
Aim - To track the purchase orders of the restaurants
Smart contract - The received purchase data will be validated by the smart contract

Inputs for Purchase Order:

Client has provided web services to tracking the purchase order details.

MCThai Accounting

Design - We have done it based on the requirements client has given
Purchase Order - Client will update the inputs through FTP, upload the PO and able to Import through application.

By running CRON, we will be able to check if there is any file added in the FTP. We will send the file to PO maintenance. We will integrate the inputs ID with the Master data and process the calculation based on the data from the client and update the purchase order table.

Smart Contract - The smart contracts validates the results of the purchase orders which cannot be altered manually. Client will be verifying the purchase orders such as total amount, price, etc. Once they approve the data, it will be sent to
Purchase History - If it’s rejected, it will be sent again to the purchase update.

Transaction:

Inputs are coming from Client end through FTP (EDI file)
Client provide I/p - Inbound, Outbound, Return, Adjustment, Credit Note, Inventory Snapshot and POD
We help the client in providing reports of different combinations by integrating various links and processes thereby reducing the time and resources of the company.

MyGo

Offerings - Web (Global Admin, Country Admin, Dispatcher, Driver and Customer) anMobile.
Design - Web and Mobile, Client has provided.
Client Inputs - Number of orders (pallots, cartons) , shipments,
Aim - To manage their deliveries done by the service providers.
Global Admin - Manage Country Admin and all settings
Smart contract - We will be integrating the details such new delivery address, assign drivers, track shipments.
Country Admin - Manage dispatcher, customer, driver, language and map settings, guidelines for driver and customer, warehouse, dropping location, settings for country process.
Dispatcher - Manage Driver, shipment, orders activity. Able to assign open orders to the drivers, reschedule the order.
Driver - Check job list, number of stops, drivers can scan the orders to know the job (pick-up or drop), history, cash deposit.
Customer - New order creation, update into OTM, tracking their own order.

Solutions Offered

To create a optimized automated supply chain platform for Li Fung.

Login
PO Update
Import Data
PO Approval
PO Release
PO History
Transaction – Inbound Details
Outbound Transaction
Credit-note Transactions
Return Details
Adjustment Details
Inventory Snapshot
POD Transactions
Report - Reconcile in Report
Reconcile – Out Report

Reconcile Adjustment Report
Inbound Summary
Inbound Details
Credit Note
Inbound Return and Reject
Outbound Summary
Outbound Details
Outbound to store
Stock Ageing
Stock Movement
Inbound Goods Transit
Outbound in Transit
Import Invoice
Invoice Payment Report
Monthly invoice payment report

Vendor Summary
Stock Movement by Region
PO Price Master
SKU Master View
Codelookup Master View
User Manager
User Restriction
Update Profile
Site Setting

LOGIN

User can able to login with the his credentials like email and password.
User can able to change his password using forgot password option.

PO UPDATE

User can able to view the entire product order details.
User can able to add a new row and add the data manually.
Once the user edits the data, it can be saved.
User can also able to export the details externally.
Once the user confirms the order he can able to submit for approval.

IMPORT DATA

PO data can be imported by the user using import option.

PO APPROVAL

Once the PO is ready for approval the user can able to cross check once again and confirms the approval.
User can also able to reject the approval if the data is mismatched.
User can also able to edit the data before the approval.

PO RELEASE

User can able to view the PO details which is ready for release.

PO HISTORY

User can able to view all the PO details which has been approved and released in the history.

TRANSACTION-INBOUND DETAILS

Inbound transaction data will be fetched every one hour from the EDI (mcdonald01-th-sftp-test/inbound).
The fetched data can be edited and saved later.
User can also add a new row and add the data manually.

OUTBOUND TRANSACTION

Outbound transaction data will be fetched every one hour from the EDI (mcdonald01-th-sftp-test/out bound).
The fetched data can be edited and saved later.
User can also add a new row and add the data manually.

CREDITNOTE TRANSACTION

Credit note transaction data will be fetched every one hour from the EDI(mcdonald01-th-sftp-test/creditNote).
The fetched data can be edited and saved later.
User can also add a new row and add the data manually.

RETURN DETAIL

Return transaction data will be fetched every one hour from the EDI(mcdonald01-th-sftp-test/return).
The fetched data can be edited and saved later.
User can also add a new row and add the data manually.

ADJUSTMENT DETAIL

Adjustment transaction data will be fetched every one hour from the EDI(mcdonald01-th-sftp-test/adjustment).
The fetched data can be edited and saved later.
User can also add a new row and add the data manually.

INVENTORY SNAPSHOT

Inventory snapshot transaction data will be fetched every one hour from the EDI(mcdonald01-th-sftp-test/inventory-soh).
The fetched data can be edited and saved later.
User can also add a new row and add the data manually.

POD TRANSACTION

POD transaction data will be fetched every one hour from the EDI(mcdonald01-th-sftp-test/POD).
The fetched data can be edited and saved later.
User can also add a new row and add the data manually.

REPORT-RECONCILE IN REPORT

Reconcile in report will be generated using Inbound transaction related with SKU master, code lookup master, supplier master and PO.
User can also search for the particular report.
Generate SAP EDI- If PO type is “LOCAL” the report(Header and detail) will be generated in the path (mcdonald01-th-sftp-test/edi/inbound-local)
Generate SAP EDI- If PO type is “IMPORT” the report(Header and detail) will be generated in the path (mcdonald01-th-sftp-test/edi/inbound-import)

RECONCILE OUT REPORT

Reconcile out report will be generated using Outbound transaction related with SKU master, code lookup master, supplier master, POD, inventory snapshot and PO.
User can also search for the particular report
Generate SAP EDI- The report(Header and detail) will be generated in the path (mcdonald01-th-sftp-test/edi/outbound)

RECONCILE ADJUSTMENT REPORT

Reconcile adjustment report will be generated using Adjustment transaction related with SKU master and PO.
User can also search for the particular report
Generate SAP EDI- The report(Header and detail) will be generated in the path (mcdonald01-th-sftp-test/edi/adjustment)

INBOUND SUMMARY

Inbound summary report will be generated using Inbound transaction related with SKU master, code lookup master and PO.
User can also search for the particular report.

INBOUND DETAIL

Inbound detail report will be generated using Inbound transaction related with SKU master, code lookup master and PO.
User can also search for the particular report.

CREDIT NOTE

Credit note report will be generated using Credit note transaction related with SKU master, code lookup master and PO.
User can also search for the particular report

INBOUND RETURN & REJECT

Inbound return & reject report will be generated using Inbound transaction related with SKU master, code lookup master and PO.
User can also search for the particular report

OUTBOUND SUMMARY

Outbound summary report will be generated using Outbound transaction related with SKU master and PO.
User can also search for the particular report

OUTBOUND DETAIL

Outbound detail report will be generated using Outbound transaction related with SKU master, code lookup master and PO.
User can also search for the particular report

OUTBOUND TO STORE

Outbound to store report will be generated using Outbound transaction related with SKU master, supplier master, code lookup master and PO.
User can also search for the particular report

STOCK AGING

Stock aging report will be generated using Inventory transaction related with SKU master, code lookup master and PO.
User can also search for the particular report

STOCK MOVEMENT

Stock movement report will be generated using Inventory transaction related with inbound transaction, outbound transaction, adjustment transaction , return transaction ,SKU master, PO price master and PO.
User can also search for the particular report

INBOUND GOOD INTRANSIT

Inbound good in transit report will be generated using Inbound transaction related with SKU master and PO.
User can also search for the particular report

OUTBOUND INTRANSIT

Outbound in transit report will be generated using Outbound transaction related with SKU master, code lookup master, inventory snapshot, POD and PO.
User can also search for the particular report

IMPORT INVOICE

Import invoice report will be generated using Inbound transaction related with SKU master, inventory snapshot and PO.
User can also search for the particular report

INVOICE PAYMENT REPORT

Invoice payment report will be generated using Inbound transaction related with SKU master and PO.
User can also search for the particular report

MONTHLY INVOICE PAYMENT REPORT

Monthly invoice payment report will be generated using Inbound transaction related with supplier master and PO.
User can also search for the particular report

VENDOR SUMMARY

Vendor summary report will be generated using Inbound transaction related with PO.
User can also search for the particular report

STOCK MOVEMENT BY REGION

Stock movement by region report will be generated using Inbound transaction related with SKU master, inbound transaction, outbound transaction, return transaction and adjustment transaction.
User can also search for the particular report

PO PRICE MASTER

PO price data can be imported using a file uploads in step 1.
PO price data can be previewed in step 2
Error in PO price data in step 3 will be shown if any exists.
User can add a new row and add a PO price details manually.
User can be able to edit & delete the data and save.
User can able to export data externally.

SKU MASTER-VIEW

The data for SKU master will be fetched from the EDI path (mcdonald01-th-sftp-test/sku)

SUPPLIER MASTER-VIEW

Supplier master data can be imported using a file uploads in step 1.
Supplier master data can be previewed in step 2
Error in Supplier master data in step 3 will be shown if any exists.
User can add a new row and add a Supplier master data manually.
User can be able to edit & delete the data and save.
User can able to export data externally.

CODELOOKUP MASTER-VIEW

Code lookup master data can be imported using a file uploads in step 1.
Code lookup master data can be previewed in step 2
Error in Code lookup master data in step 3 will be shown if any exists.
User can add a new row and add a Code lookup master data manually.
User can be able to edit & delete the data and save.
User can able to export data externally.

USER MANAGER

User can able to add a new user.
And also authorization for the particular user will given with their email address and password.
User can able to edit the details or delete them anytime.