divine it limited 34 gausul azam avenue, sector-13 uttara , dhaka-1230 bangladesh
DESCRIPTION
Divine IT Limited 34 Gausul Azam Avenue, Sector-13 Uttara , Dhaka-1230 Bangladesh. What is ERP?. A software solution that streamlines and automate all business processes of an organization. Which facilitate the flow of information covering all functional areas that is accessible for all - PowerPoint PPT PresentationTRANSCRIPT
Divine IT Limited34 Gausul Azam Avenue, Sector-13
Uttara, Dhaka-1230Bangladesh
What is ERP?
A software solution that streamlines and automate all business processes of an organization.
Which facilitate the flow of information covering all functional areas that is accessible for all
Integrates all departments to form a single computing system.
Performs core corporate activities and increases customer service augmenting corporate image
History of ERP
1960’s - Systems Just for Inventory Control
1970’s - MRP – Material Requirement Planning (Inventory with material planning & procurement)
1980’s - MRP II – Manufacturing Resources Planning (Extended MRP to shop floor & distribution management)
Mid 1990’s - ERP – Enterprise Resource Planning (Covering all the activities of an Enterprise)
2000 onwards – ERP II – Collaborative Commerce (Extending ERP to external business entities)
Why implement an ERP system?
Internal Benefits Integration of a single source of data Common data definition throughout the organization A real-time system that provides complete overview of the business activities Increased productivity Reduced operational costs Increases efficiency among people of the organization by reducing small, redundant daily tasks Ensure reporting & regulatory compliances Efficient financial management Foundation for future improvement
External Benefits Improved customer service and order fulfillment Improved communication with suppliers and customers Enhanced competitive position Increased sales and profits Standardize global business operations Position the company for growth Information supply chain visibility New/improved business processes
77%
62%
51%
50%
45%45%
42%
39%
36%
25%
22%22% 15%
Top Implemented Modules
Sales & Distribution / Order ProcessingMaterials Management HR / PayrollCRMWarehouse ManagementBusiness IntelligenceManufacturing / MPSAdvance Planning / Supply ChainTransportation / LogisticsBusiness WarehouseProduct Lifecycle ManagementProduct ConfiguratorRatail
Top implemented modules of ERP
The success factors of ERP
Focus on business processes and requirements first Take measures to achieve a healthy ERP ROI Strong project management and resource commitment is key Commitment from organization executives Take time to plan up front Ensure adequate training and change management Make sure to understand why you are implementing ERP Focus on data migration early in the process Leverage the value of conference room pilots (CRPs) Chart the course
Why ERP implementation is unsuccessful
Lower returns than expected Inability of the ERP system to meet predetermined functional requirements Lack of clarity on functional requirements Lack of commitment from management Crossing budget limitations Higher maintenance & training costs Missing development & deployment dates Incorrect working of the system Not living up to estimated expectations Inadequate Training Improper package selection Miscalculations & Expectations Incompatibility with business processes
ERP implementation plan
Top challenges companies face during the ERP implementation
Challenge Fact Reasons
ERP implementations take longer than expected
35.5% of ERP implementations take longer than expected
• Unrealistic expectations of implementation duration• Inadequate accounting for business-oriented activities• Software customization and/or mismanagement of project scope• Lack of resources
ERP projects go over budget
Only 48.6% of ERP projects are completed on- or under-budget
• Unrealistic project plan and cost expectation• Hidden costs associated with ERP• Underestimated project complexity• Rushed ERP project and/or mismanagement of scope
ERP projects fail to deliver expected business benefits
Only 33% of companies realize at least half of expectedbusiness benefits from ERP
• Failure to manage the software vendor and project scope• Inadequate definition of functional requirements• Misalignment of ERP business software with business processes• Unrealistic ROI expectations
– All About
PrismERP
‘PrismERP’ is an incorporated enterprise business solution It allows administering business oriented operations for conglomerate. A centralized framework to integrate and automate all business processes
of an establishment with the aim of increasing operational efficiency and improving the accessibility and flow of information across all departments.
‘PrismERP’ is the automation of any business processes which offers customer & vendor management, multilevel inventory management, POS (Point Of Sale), core business accounting, employee & payroll management, LC management system, user access management and customizable advanced reports.
It is an uncomplicated and user-interactive solution that leads the business owners to momentous financial control and better management of their business development.
‘PrismERP’ is an integration of core business modules which have the ability to maintain your all-encompassing business.
Features-PrismERP
Supports strategic and business planning, operational planning and execution activities, creation of materials and resources.
Facilitates companywide integrated information system covering all functional areas like manufacturing, selling and distribution, payables, receivables, inventory accounts, human resources, purchases etc etc.
Performs core activities and increases customer service, thereby augmenting the corporate image
Bridges the information gap across organizations Provides complete integration of systems not only across departments but also across
companies under the same management PrismERP is the solution for better project management Eliminates most business problems like materials shortages, productivity enhancement,
customer service, cash management, inventory problems, quality problems, prompt delivery etc
Provides multi-platform, multi-mode manufacturing, multi-currency, multi-lingual facilities Provides intelligent business tools like decision support system, executive information
system, data mining and easy working systems to enable better decisions PrismERP provides business customizable to meet the needs of your market niche Advanced reporting methods and high visibility of information
Modules
Budgeting capability
Recurring Journal Entries
General ledger
Accounts payable
Accounts receivable
Multiple Cash/Bank
Multiple Debit/Credit entries
Bill-wise/on account
Bank Reconciliation statement
Group/Sub-group-wise Trial Balance
Cash/Fund flow statements
Monthly analysis of all account head
Customizable financial reporting
Scalable as business grows
Easy to expand as required
Variance analysis
Module overview – Financial Accounting
Features
Cash & Cash Equivalents
Chart of Accounts
Vouchers
Settings & Configuration
Reports
Cash & Cash Equivalents
Vouchers
Settings & Configuration
Reports
Chart of Accounts
Financial Accounting (cont.)
Cash & Cash
Equivalents
Cash & Cash Equivalents
Chart of Accounts
Vouchers
Settings & Configuration
Reports
Financial Accounting (cont.)
Create voucher
Payment
Receipt
Journal
Contra
Vouchers Edit Voucher
Journal Posting
Ledger Posting
Approve voucher
Cash & Cash Equivalents
Chart of Accounts
Settings & Configuration
Reports
Vouchers
Financial Accounting (cont.)
Settings & Configuration
General Information Accounts
Company Details
Change Password
Backup Data
Set user Access control
New Accounts
New Cash Accounts
New Bank Accounts
Account Access management
Year closing facility
Cash & Cash Equivalents
Chart of Accounts
Reports
Vouchers
Settings & Configuration
Financial Accounting (cont.)
Cash & Cash Equivalents
Chart of Accounts
Vouchers
Settings & Configuration
Reports
Monthly Profit & Loss
Nominal Ledger
Balance Sheet
Trial Balance
Profit & Loss Statement
Prepayments and Accruals
Journal
Ledger Books
Year End Process
Cash & Cash equivalents
Ledger Summary
All Transactions
Ledger Summary of Bank
Bank Reconciliation
Statement
Ledger Summary of Cash
Receipts & Payments Statement
Party wise Ledger Summary
Account wise Ledger
Financial Accounting (cont.)
System Flow
Create voucher
Payment
Receipt
Journal
Contra
Vouchers
Ledger
Trial Balance
P&L Statement Balance Sheet
Other Statements
Is PL Item?
COA
Account Type
Asset
Expense
Liability
Income
Equity
Journal Posting
Ledger PostingApprove voucher
Financial Accounting (cont.)
Warehouse Management
Product Category Management
Brand/Manufacturer Management
Multiple Units of measure
Order Management
Delivery Management
Product costing
FIFO / Average Applicable
Movement history
Inventory reconcile
Under stock tracking
Warranty Management
Serial Management
Inventory Management
Features
Product
Inventory Operation
Product Configuration
Procurement & Sales
Delivery Management
Reports
Inventory Operation
Procurement & Sales
Delivery Management
Reports
Inventory Management
Inventory Operation
Product Configuration
Procurement & Sales
Delivery Management
Reports
Transfer Product
Voucher Approval
Inventory 01
Inventory 02
Inventory N
Transfer Voucher
Spend Product
Expense
COGS
PAQ Voucher
Product
Opening Product
PAQ Voucher
Add Product
Free Product
Inventory Management
Inventory Operation
Product Configuration
Delivery Management
Reports
Procurement & Sales
Inventory
Raw Product
WIP
Finished Product
PurchaseRequisition
Store
Procurement Department
Delivery Voucher
Sales Department
Sales
Delivery Voucher
Voucher Approval
Production
Inventory Management
Inventory Operation
Product Configuration
Reports
Procurement & Sales
Delivery ManagementVoucher Approval
Inventory 01
Inventory 02
Inventory N
Vendor
Purchase Delivery Return Voucher
Product
Purchase Delivery Voucher
Voucher Approval
Customer
Sale Delivery Voucher
Sale Delivery Return Voucher
Stoc
k o
ut
Stock In
Stock In
Stock out
Inventory Management
Inventory Operation
Product Configuration
Procurement & Sales
Delivery Management
Reports
Inventory Stock
Requisitions
Product Ledger
Transfer History
Consumptions
Acquisitions
Daily Transfer Report
Warehouse wise product Ledger
Under Stock List
Delivery Return report
Inventory wise Delivery
Daily delivery
Booked product Reports
Product Details
Product wise Return Report
Inventory Management
Inventory
Raw Product
WIP
Finished Product
PurchaseRequisition
Store
Procurement Dept.
Delivery Voucher
Sales Dept.
Sales
Voucher Approval
ProductionJournal Posting
Operations
Opening Prod.
Free Prod.
Expense
COGS
Other Inv.
Add Prod.
Spend Prod.
Transfer
PAQ, PCM & TFR Voucher
Voucher Approval
Accept Transaction
Inventory Update
Accounts Update
Reports
Delivery Voucher
Inventory Management
Sales and Purchase Order processing utility Sales and purchase invoice generation Purchase request and receipts processing Customer and Vendor ledger management Payment and receive maintenance Product price settings Check a customer's available credit Delivery management Order cancellation and adjustment Order regeneration Split order processing
Purchase and Sales Management
Features
Sales Department
Product Requisi
tion
Check stock
availabilityAckno
wledge to
concern Dept.
Purchase
RequestReques
t for Quotati
on
Receive
Multiple Quotati
on
Compare
Quotation for
POPurchase
Order
Purchase Management
Procurement Process
Sales Management
Delivery Management
Settings & Configuration
Reports
Purchase Management
Sales Management
Delivery Management
Settings & Configuration
Reports
Purchase and Sales Management
Purchase Management
Procurement Process
Sales Management
Delivery Management
Settings & Configuration
Reports
No
Vendor
Departments
StoreInventory
Service
AssetStationary
Inventory
Service
AssetStationary
Procurement
Open LCCreate PO
Accept Order
Is Local Purchase?
Accept Transactions
Payment
Amendment
Return
Add Delivery
Cancellation
Production
Inventory
Vendor Ledger
Inventory Update
Yes
Order Operations
Delivery IN
Product Requisition
Purchase Requisition
Received Quotation
PI Receive
Purchase and Sales Management
Purchase Management
Procurement Process
Delivery Management
Settings & Configuration
Reports
Sales Management
No
Yes
Send PI
Yes
No
Send Requisition
Accept TransactionsDelivery Out
CustomerRequest
Sales Department
Is Local Sales?
Create SO
Create LC Accept Order
Receipt
Amendment
Return
Add Delivery
Cancellation
Is Product
Available?
Store
Procurement
Customer Ledger
Inventory Update
Order Operations
Purchase and Sales Management
Delivery Management
Purchase Management
Procurement Process
Settings & Configuration
Reports
Sales Management
Voucher Approval
Inventory 01
Inventory 02
Inventory N
Vendor
Purchase Delivery Return Voucher
Product
Purchase Delivery Voucher
Voucher Approval
Customer
Sale Delivery Voucher
Sale Delivery Return Voucher
Stoc
k o
ut
Stock In
Stock In
Stock out
Purchase and Sales Management
Settings & Configuration
Delivery Management
Purchase Management
Procurement Process
Reports
Sales Management
Settings & Configuration
Product Sales Purchase
Auto Accept
Auto Delivery
Auto Payment
Down payment
Show Stock Qt.
Show Order Qt.
Auto Commit
Auto Delivery
Auto Payment
Discount Per Product
Voucher Visible
Vendor dues
Serial Settings
Purchase Warranty
Sale Warranty
Product Reorder Qt.
Expiry Date Settings
VAT settings
Purchase and Sales Management
Purchase Request List
P. Request Summary
Monthly Purchase
Purchase Delivery
Vendor Ledger
Yearly Purchase
Payment History
Month wise Purchase
Product wise Purchase
Product Request ListP. Request Summary
Quote Comparison Sheet
Daily Sales Register
Sales KPI
Monthly Sales
Sales Delivery
Customer Ledger
Yearly Sales
Sales Collection
Month Wise Sales
Product Wise Sales
Purchase ReportSales Report
Purchase Management
Procurement Process
Sales Management
Delivery Management
Settings & Configuration
Reports
Purchase and Sales Management
Journal Posting
Accounts Update
Inventory UpdateAccept Transactions
Customer
Sales Department
Create SOAccept Order
Order Operations
Receipt
Amendment
Return
Add Delivery
Cancellation
Vendor
Accept Order
Payment
Amendment
Return
Add Delivery
Cancellation
Order Operations
Inventory
Delivery IN
Departments
Store
Inventory
Service
Asset
Stationary
Inventory
Service
Asset
Stationary
Procurement
Production
Product Requisition
Purchase Requisition
Accept Transaction
Receive Quotation
Create PO
Purchase and Sales Management
Types wise Assets Management
Category wise Assets Management
Item wise Assets Management
Serial number wise Assets tracking
Depreciation Model Implemented
Depreciation methods implemented
Depreciation period Management
Depreciation rate Management
Assets Allocation Management
Assets integration with Accounts
Assets Procurement Management
Assets Disposal Management
Assets expenditure Management
Fixed Assets Management
Features
Product Requisition
From Department
Purchase Requisition
from Concern Dept.
Receive Quotation
from Vendor for PO
Purchase Order from Concern
Dept.
Receive Assets
Delivery
Purchase Management
Procurement Management
Assets Stock Management
Distribution Management
Depreciation Management
Sales & Expenditure
Purchase Management
Assets Stock Management
Distribution Management
Depreciation Management
Sales & Expenditure
Fixed Assets Management
Purchase Order from
Management
Purchase Order List Generation
Payment to Vendor
Receive Delivery from Vendor
Assets Serial generation
Send to storePurchase Management
Procurement Management
Assets Stock Management
Distribution Management
Depreciation Management
Sales & Expenditure
Fixed Assets Management
Store
Assets Status (In use / Not in use)
Assign / Reassign
to Concern Dept.
Release from Dept.
Assets Movement
History
Assets repair
Send to store
Purchase Management
Procurement Management
Assets Stock Management
Depreciation Management
Sales & Expenditure
Distribution Management
Fixed Assets Management
Assets Product
Set Depreciation Method
Fix Depreciatio
n Rate
Depreciation pulse
Generate Depreciation Voucher
Depreciation ReportPurchase Management
Procurement Management
Assets Stock Management
Distribution Management
Depreciation Management
Sales & Expenditure
Fixed Assets Management
Store Receive
Assets Repairing
Expenditure Voucher Generation
Assets for Sale
Disposal Voucher Generation
Release From Department
Send to Store
Purchase Management
Procurement Management
Assets Stock Management
Distribution Management
Depreciation Management
Sales & Expenditure
Fixed Assets Management
Configuration Accounts ReportingDaily Procedure
Asset Purchase
Distribution history
Asset Depreciation
Asset Sales
Acquisitions
Consumptions
Asset Wise Dep.Declare Dep. Process
Store
Departments
Dep. Expense Ac
Requisition
Depreciation Cal
AdminAsset Category
Asset Declarations
Furniture & Fixtures
Land & Building
Plant & Machineries
Electronics Equip.
Computer & Accs.
Account Association
Accu. Dep. Ac
Asset Account
Asset
Asset Distribution Process
Purchase
Journal Posting
Accounts Update
Asset Inventory Update
Asset Sales
Spend Asset
Asset Operations
Add Opening Asset
Accept Transactions
Others
Purchase Requisitio
n
Procurement Received Quotation Vendor
Add PO
Fixed Assets Management
Quick Start feature and easy to set up & understanding
Program default information minimizes user input requirements
Reducing processing time and labor
Support huge numbers of employees
Accommodates any combination of incomes, deductions, benefits, and leaves
Offers consolidated entry screen for quick payroll entry
Attach documents, files, images and locations to any Employee file
Detail paychecks and vouchers
Uninterrupted online and onsite support
HR Management
Features
Add Branch
Add Department
Employment History
Payroll History
Release Resign
Employee closing
Final Settlement
History
Loan & AdvanceLeave History
Add Employee
Employee List
Detail of an Employee
Add
SignaturePhoto
Attendance (Manual or Auto Retrieve from
Device)
Add Shift
Add Leave Policy
Add Holiday Policy
Add Pay scale
Add Payroll Schedule
Add DepartmentAttendance Management
Employee Management
Leave Management
Payroll Management
Attendance Management
Leave Management
Payroll Management
HR Management
Attendance Management
Employee Management
Leave Management
Payroll Management
Reports
Daily Timesheet
From Excel File
Device Data
Attendance Entry
Manual
Manual Auto
Attendance Summary
Post Attendance Data
Daily Timesheet
Weekly Timesheet
Overtime Report
Monthly Timesheet
Branch Wise Timesheet
Dept. Wise Timesheet
Sheet Wise Timesheet
From software
HR Management
Add Leave Application
Leave Balance
Employee
Add Leave Type
Add Leave policy
Leave Status
Employee Wise Report
Dept. Wise Report
Leave Summary
Monthly Leave
Add Opening Balance
Add Holiday Type
Add Holiday Frequency
Add Holiday Policy
Holiday List Leave Recommender
Leave Approver
Attendance Management
Employee Management
Leave Management
Payroll Management
HR Management
Attendance Management
Employee Management
Leave Management
Payroll Management
Payroll Item Sales Bonus
Employee Benefit Salary Incentive
Advance Payment
Provident FundLoan Festive
Bonus
Performance
Bonus
Adjustment
Installment
Pay scale
Salary Payment
Payroll Schedule
Post Journal
Payment list
Approve Accounts Update
Adjustment Report
Unscheduled Payment
Salary Report
Deduction Report
Employee wise Report
Bonus Report
Overtime Report
Others more Reports
HR Management
Configuration HR & Payroll Management
Add Leave Application
Add Leave Type
Add Shift
Add Leave Policy
Add Holiday Policy
Add Pay scale
Add Payroll Schedule
Leave Recommender Leave Approver
Holiday Type
Add Payroll Item
Salary Calculation
Installment
Advance
Loan
Related Reports
Add Layer nNo
Company
Add Branch
Add Department
Add Layer 1
Multiple Layers
Add Designation
Yes
Employment HistoryPayroll History
Release Resign
Employee closing
Final Settlement
History
Loan & AdvanceLeave History
Add Employee
Employee List
Detail of an Employee
Add
SignaturePhoto
Attendance (Manual or Auto Retrieve from
Device)
HR Management
Order, Style & Work Order
PI Tracking
Indent Tracking
Shipmen Scheduling
Import LC Operation
Export LC Operation
Sales Contract
B2B Operation
Indent Management
CI Operation
Inventory Control
UD Generation
Loan Management
Commission Statement
Packaging
Accounting Integration
LC Management
Features
Departments
Requisition
Procurement
Store
Customer
Vendor
Sales Dept
Request
Requisition
Request PI
Request PI
Receive PI
Send PI
Open Import LC
Export LC
Shipment
Amendment
Expenses
Receipt
Payment
Amendment
Expenses
Shipment
Accept Transactions
Receive Invoice
Send Invoice
Customer Ledger
Journal Posting
Inventory Update
Vendor Ledger
Accounts Update
Related Reports
LC Management
Purchase warranty period Management
Sales warranty period Management
Serial less warranty Management
Unique Serial Tracking Management
Non warranty claim management
Automated claim adjudication
Online warranty claim entry and processing
Categorized service management
Claim wise required parts management
Service status management
Streamlined service authorizations.
Automated service and recall operation
Warranty claim Solution tracking
Warranty Liability tracking
Afterward Service delivery Management
Service & Warranty Management
Features
Inventory 0r stock Mgt
Sales & Purchase Mgt
Product Serial Mgt
Warranty Mgt
Warranty Claim Mgt
Product Servicing Mgt
Inventory or stock Mgt
Product Serial Mgt
Warranty Mgt
Warranty Claim Mgt
Product Servicing Mgt
Vendor Customer
Add PO Add SO
Delivery in Delivery out
Delivery Return
Delivery Return
Assign serial
Serial outInventory
Service & Warranty Management
Inventory or stock Mgt
Sales & Purchase Mgt
Product Serial Mgt
Warranty Mgt
Warranty Claim Mgt
Product Servicing Mgt
Product Serial Mgt
Warranty Mgt
Warranty Claim Mgt
Product Servicing Mgt
Product Transfer
Purchase Delivery
Inventory 1
Inventory 1
Inventory 1
Add Opening Product
Spend Product
Sales Delivery
Serial out
Assign serial
Assign serial
Service & Warranty Management
Inventory or stock Mgt
Sales & Purchase Mgt
Product Serial Mgt
Warranty Mgt
Warranty Claim Mgt
Product Servicing Mgt
Warranty Claim Mgt
Product Servicing MgtProduct
Serial type
Manual
Inventory 1
Warranty Claim
Purchase
Warranty Applicable?
Auto
Yes
No
Sales
Assign serial
Assign serial
Serial out
Service & Warranty Management
Inventory or stock Mgt
Sales & Purchase Mgt
Product Serial Mgt
Warranty Mgt
Warranty Claim Mgt
Product Servicing MgtProduct Servicing MgtClaim
Resister
Product
Claim
VendorCustomer
Is sales warranty
available?Is pur.
warranty available?
Warranty Product
Non-warranty Product
Add Sales Claim
Send to Service Center
Add Purchase Claim
Send to Service Center
Yes No
No
Yes
Service & Warranty Management
Inventory or stock Mgt
Sales & Purchase Mgt
Product Serial Mgt
Warranty Mgt
Warranty Claim Mgt
Product Servicing Mgt
No
Claim Resister
Is sales warranty
available?Is purchase
warranty available?
Warranty Product Non-warranty Product
Add Sales Claim
Sales center
Receive from Sales Center
Repair
Replace
Spare Parts Request
Delivery to Sales Center
Product
Claim
Yes
Send to Service Center
No
Service & Warranty Management
Product
Manual
Claim
Serial Type
Send to Vendor
Accounts
Warranty Applicable?
Auto Generated
Yes
No
Product
Customer
Sales
Add Sales Claim
Claim Registration
Add Purchase Claim
Claim RegistrationRegister Claim
Is Sales Warranty
Available?
Warranty Product Non warranty Product
NoYes
Accept Transaction
Service Centre
Vendor
Purchase
Product
Assign Serial
Inventory
Delivery In
Is PO Warranty Available?
Yes
Generate Invoice
Delivery Out
Receive from SC
Repair
Replace
Spare Request
Delivery to SC
Operations
Service & Warranty Management
Select Administration Role
Select Role for General
Create Role
User Type
Admin
General
Create User
Admin User List General User List
Is Admin User?
Module / Section
Actions
Activities
Pages
Create Group
Permission
Application
Module Selection
Module List
Role List
Group List
Group Permission
Yes No
Role Permission
User Access Control
Technological Platform - PrismERP
OS Individual / Client PC Enterprise System (Server PC)
Windows
Windows 8
Windows7
Vista
XP
Windows Sever 2008
Windows Sever 2002
Windows Sever 2003
Windows 2000 ServerLinux Fedora Head Hat Enterprise Linux
CentOS CentOS
Ubuntu Ubuntu Server Edition
Debian Debian Enterprise Edition
OS Platform
Technological Platform - PrismERP
We modify the Model Layer and create our own framework furinaPy. We use ‘Form Encode’ for Validation (it is the number one tool in Validation). For data connectivity, our framework uses SQLALCHEMY. It can easily convert SQL commands and DB structure to any database like MySQL, ORACLE and MS SQL SERVER. It can not convert 100%, some verification required.
We choose Python for our development, because of: Performance speed in Python is high. Code can manage efficiently. PHP runs with error, but Python and other languages run
without error. For error they show error message. High development speed with many built-in functions. For continuous modification, Python is better. Python is embedded with Linux. Python has better library. Python has better features than PHP. Python has some Framework. We use our own framework furinaPy for the purpose. Python can run on both Microsoft and Linux platform. MAC OS Client PC can also access
Python developed system through its Web Browser.
Development Language: Python
Database - PrismERP
Default database : MySQLCompatible with : ORACLE / MS SQL Server
Reason to choose MySQL
It is Free and Easy to Use and Manage. No License required, so cost effective. Our system is secured by Machine Level Access from Operating System (use Linux). Web Server Secured by its own Security (User need to update time to time from the
Web Server Provider). MySQL has capacity to store 8 GB in a single table. Our System runs from Python Code and Report from BIRT Reporting Server. So, we need not huge or robust Database for processing any business from Database. We connect and manage multiple Databases from our System (Python Code). So, MySQL is enough to run the system. Data Backup and Restore service is managed from the System (Python Code).
Reporting Tools
BIRT Server
Reasons to choose BIRT Server as reporting tool
It is open source from Eclipse.
It has better Database connectivity through XML format data as source.
BIRT has complex reporting features.
Python code is speedier than complex query or stored procedures execution. Python generates XML format after retrieving from Database for its own view. BIRT uses those view XML data as report source. So, it requires no extra connection time or access to database.
BIRT can use many more databases with receiving XML format data and can process of its own to generate complex query for the reports.
Dynamic Column selection is the most specialty of BIRT Reporting Tool. Jasper is best for its PIXEL Perfection. But we use Dynamic column selection in the time of report generation. So, Pixel perfection is not required here. So, BIRT is the best solution.
BIRT supports script writing.
BIRT VIEWER developed by Java and has more flexibility to use any system’s own interface with out recognizing BIRT separately. It can not be possible for Crystal Report and Jasper.
Three-tier Client/Server Architecture
USER PCsUSER PCs
ApplicationServer
ApplicationServer
ApplicationServer
ApplicationServer
DatabaseServer
Software Requirement - PrismERP
Server end
Web Sever:
FOR 32 BITAPACHE Sever (apache_2.2.10-win32-x86-no_ssl.msi)ActivePython-2.7.1.4-win32-x86.msi & it's dependencies
FOR 64 BITAPACHE Sever (apache_2.4.1-x64-openssl-1.0.0g.msi)ActivePython-2.7.2.5-win64-x64 & it's dependencies
DB Server:
FOR 32 BITMysql-essential-5.0.45-win32.msi
FOR 64 BITActivePython-2.7.1.4-win32-x86.msi & it's dependencies
Report Server:
FOR 32 BITapache-tomcat-7.0.14BIRT ServerAdbeRdr1000_en_US.exe (Reports in PDF format)
FOR 64 BITapache-tomcat-7.0.14 or apache-tomcat-7.0.32BIRT ServerAdbeRdr1000_en_US.exe (Reports in PDF format)
Client end
Browser: (more than 85-90% covered by Firefox and Google Chrome)
Firefox 3.5 and Above (Recommended)IE 8.0 or AboveGoogle ChromeSarafi, Opera and so on
Hardware Requirement - PrismERP
Server end hardware
2.0 GHz Dual Core or Higher1 Gigabytes of RAM1 GB Hard Disk SpaceInternet Connectivity for Online Use OR Intranet Connection of Local Use
Client end hardware
Intel Pentium IV or Higher512 MB of RAM100 GB Hard Disk SpaceInternet Connectivity for Online Use OR Intranet Connection of Local Use
A client PC which can run INTERNET with WEB BROWSER like Firefox version 3.5 or above or IE more than version 6.0 (7.0, 8.0, 9.0 etc.)
Security
OS Level: Default is Linux, so, most secured.
Web Server: APACHE is used for the purpose.
Database: MySQL is now widely used. Database Server is here fully secured by
Access limitation from OS (Linux – all port default close, only permitted USER can
Access).
Application: Application using Python Code, Python is more secured programming
language than any other. It is itself manages the security. The another security by
User Name, Password policies and User Access Control. Our system is default
creates all users as NO PERMISSION.
Data Security: PrismERP uses SHA-256 for Data Encryption .
Licensing: PrismERP runs on License. It is PC Physical configuration dependent.
System Backup
5. CoreLive Backup System
Firewall
Database Server
Application Server
Internet
8. Backup to CoreLive
2. Backup Instruction
Client PC
1. Backup Request from System
Backup Server
3. System Backup Service
4. B
acku
p st
ored
9. Backup to CoreLive
6. CoreLive Backup Service
7. CoreLiveBackup Service
Conclusion
ERP implementation demands huge commitment from the organization. It causes millions of
dollars and can take up to several years to complete
When an ERP integrated successfully, the benefits can be enormous.
A well-designed and properly integrated ERP system allows the most updated information to be
shared among various business functions. These resulting in tremendous cost savings and
increased efficiency
When making the implementation decision, management must considered fundamental issues
such as the organization’s readiness for a dramatic change, the degree of integration, key
business processes to be implemented, e-business applications to be included, and whether or
not new hardware need to be acquired
In order to increase the chance of user acceptance, employees must be consulted and be
involved in all stages of the implementation process.
Providing proper education and appropriate training are also two important strategies to increase
the end user acceptance rate.
The organization is also going through a drastic change, with changes in the way businesses are
conducted, the organization being restructured, and job responsibilities being redefined
CONTACT DETAILS
Divine IT Limited34, Gausul Azam AvenueSector 13, UttaraDhaka 1230, Bangladesh
Phone : +880-2-895-6074 +880-2-895-3460
Fax : +880-2-893-2417E-mail : [email protected]
Divine IT LimitedRoad-12, House-29Sector 10, UttaraDhaka 1230, Bangladesh