Post on 18-Oct-2015
ERP SYSTEM
ERP SYSTEMEnterprise Resource PlanningWhat does it do?It gives you flexibility in terms of: Report designCustom fit according to specific particular needAccessibilityBetter Internal Control / TransparencyPossibility of Integration with existing IT systemsAdds efficiency to the operationProper data warehousingGives real time overview of core business processes and performance
How to design? Crucial point to considerThere is a need to know the internal processes in the companyCompany set up: is it a group?, Sole company?, How many subsidiaries?Reporting requirements internally and statutory, Individual I/S and B/S for subsidiaries? and or Just one consolidated F/S?Chart of accounts segmentation:Example: A01-B02-C003-D0004-E9000-F900A stands for the companyB stands for the subsidiaryC stands for the locationD stands for the Chart of account Like Sales/ RevenueE stands for product codeF stands for business type or segment Like wholesale / Retail
Financial Reporting Structure Set-UpSamples of Internal Process Flows
Purchase Order Flow
9
Why did we chose JDE?JD Edwards runs under Oracle Database and it is already under Oracle licensingIts price is reasonable and affordable compared to the Oracle Business SuiteThe ERP system already existed for 20 years and it is already stable and widely used by different type of industriesTHE PRICE IS AFFORDABLE 60,000 USD to 100,000 and includes:HR & PAYROLLPurchase OrderSalesFinancial Modules (AP/AR/CASH MANAGEMENT Etc.)One View ReportingBusiness Intelligence (Business overview at a glance)Mobile applicationsCAPEX Maintenance and management Demo And SnapshotsOneView Reporting / BI Interactive ReportingDynamic column sorting and filteringGroup filters Charts with animationCollapsible Regions
13
FeaturesBI with Plant Managers Dashboard Revenue Management Customer Shipment Performance Manufacturing Performance Inventory Management Effectiveness Supplier Performance Cash to Capital ManagementMetrics Configurable summary page Drill-up/down: context sensitive View By: data sorting Actions: e-mail link to application
15Advanced Report Tools like BI PublisherClean report layoutTablesChartsImagesLeverage existing EnterpriseOne reportsEasy to create templates using familiar products(MS Word, Adobe)EDI creation through eText templatesTranslationsTransformations
16Mobile application
17Mobile Application Demo
Name of Subform
Label
Header
Find
- for
Label
Enter Text
Enter Text
Option 1
Alerts
Days Sales in Inventory
Days Payables Outstanding
Days Sales Outstanding
Actual production vs. plan
View Details
View Details
View Details
View Details
Cash and Capital Management
Related Actions
Equipment Failure
Shipments below target
Projected cash vs Planned production
Cash to Cash cycle
Related Metrics
Search by
Plant Manager: Lujiangs Dashboard
or
Saved Queries
Stock for Q1
Save query
Edit queries
Company
4242
Capital System
Branch / Plant
M30
Product Family
*
Western Region
Customer/Supplier
11/01/2005
From
12/31/2005
To
Offset
30
days from
12/01/2005
View Metrics
Cash and Capital Management