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.

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
Connect with Whatsapp 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.

USER RESTRICTION

  • User can able to provide the roles and permissions for each user.

UPDATE PROFILE

  • User can able to update his personal information.
  • User can also able to change the password anytime.

SITE SETTING

  • User can able to update the basic site settings like site title and contact number.

Summary

Based on the requirements given by the client, we have developed three different blockchain-based applications which solves the following problems,

  • Stock management- McD
  • Purchase Order Management- McThai Accounting
  • Delivery Management- MyGo

We have completed the project within the delivery date and the client is happy with our offerings.