DATED 16082014 WESTERN TELECOM REGION ERP ENTERPRISE RESOURCE PLANNING ERP REVIEW Connectivity to ERP Server at Hyderabad ERP SERVER 10197216213 NETWORK PLAN DOMAIN REMARKS ID: 147380
Download Presentation The PPT/PDF document "REVIEW MEETING" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
REVIEW MEETING DATED 16-08-2014WESTERN TELECOM REGION
ERP
ENTERPRISE RESOURCE PLANNINGSlide2
ERP REVIEWConnectivity to ERP Server at HyderabadERP SERVER : 10.197.216.213NETWORKPLANDOMAINREMARKSCDRFROM NEAREST CDR ROUTER OR SWITCH
MPLS-VPN2 MBPS GOLD
BBoVPN
BUSINESS-700BROADNET-512
BROADNET-256
ERPBSNL.INSlide3
ERP REVIEWERP CONNECTIVITY : VPN OVER BROADBANDSlide4
ERP REVIEWGMM wise ERP Connectivity Status WTR Circle Office, Mumbai :Division/UnitConnected viaCDR/VPN/BBoVPNStatus
Remarks
WTR Circle Office Prabhadevi
VPN
Completed
Telecom Building
Prabhadevi
VPN
Completed
Fountain Telecom Building-1
VPN
Completed
Fountain Telecom Building-2
VPN
CompletedSlide5
ERP REVIEWGMM wise ERP Connectivity Status GMM, WTR Mumbai :
Division/UnitConnected
viaCDR/VPN/BBoVPNStatus
Remarks
MUMBAI
VPN
Completed
KALYAN
VPN
Completed
THANE (KOPRI)
VPN
Completed
THANE (DGMM
OFFICE)
VPN
Completed
SATELLITE THANE
VPN
Completed
PANVEL
CDR
Completed
NASIK
CDR
Completed
DHULIA
CDR
Completed
RATNAGIRI
CDR
CompletedSlide6
ERP REVIEWGMM wise ERP Connectivity Status GMM, WTR Mumbai : continued…
Division/Unit
Connected viaCDR/VPN/BBoVPN
Status
Remarks
PUNE (MHS)
CDR
Completed
PUNE (MPLS)
CDR
Completed
AHMEDNAGAR
CDR
Completed
AURANGABAD
CDR
Completed
KOLHAPUR
CDR
Completed
LATUR
CDR
Completed
PANJIM
CDR
Completed
SATARA
CDR
Completed
SOLAPUR
CDR
CompletedSlide7
ERP REVIEWGMM wise ERP Connectivity Status GMM, WTR Mumbai : continued…
Division/Unit
Connected viaCDR/VPN/BBoVPN
Status
Remarks
NAGPUR
VPN
Completed
NAGPUR (SAKKARDARA)
VPN
Completed
AKOLA
CDR
Completed
CHANDRAPUR
CDR
Completed
JALGAON
CDR
Completed
NANDED
CDR
Completed
YAVATMAL
CDR
CompletedSlide8
ERP REVIEWGMM wise ERP Connectivity Status GMM, WTR Bhopal :
Division/UnitConnected
viaCDR/VPN/BBoVPNStatus
Remarks
BHOPAL (CITY)
CDR
Completed
BHOPAL (ARERA)
CDR
Completed
GWALIOR
CDR
Completed
GUNA
CDR
Completed
INDORE
BBoVPN
Completed
ITARSI
CDR
Completed
MANDSAUR
CDR
Completed
RATLAM
BBoVPN
Completed
UJJAIN
BBoVPN
CompletedSlide9
ERP REVIEWGMM wise ERP Connectivity Status GMM, WTR Bhopal : continued…
Division/Unit
Connected viaCDR/VPN/BBoVPN
Status
Remarks
JABALPUR
CDR
Completed
CHATARPUR
BBoVPN
Completed
CHINDWARA
BBoVPN
Completed
NARSINGHPUR
CDR
Completed
REWA
BBoVPN
Completed
SAGAR
CDR
Completed
RAIPUR
CDR
Completed
BILASPUR
CDR
Completed
DURG
CDR
Completed
AMBIKAPUR
CDR
Completed
JAGDALPUR
CDR
CompletedSlide10
ERP REVIEWGMM wise ERP Connectivity Status GMM, WTR Ahmedabad :
Division/Unit
Connected viaCDR/VPN/BBoVPN
Status
Remarks
AHMEDABAD
VPN
Completed
AHMEDABAD (BHADRA)
CDR
Completed
BARODA
CDR
Completed
BHARUCH
CDR
Completed
BULSAD
CDR
Completed
GODHRA
CDR
Completed
HIMMATNAGAR
CDR
Completed
MEHSANA
CDR
Completed
PALANPUR
CDR
Completed
SURAT
CDR
CompletedSlide11
ERP REVIEWGMM wise ERP Connectivity Status GMM, WTR Ahmedabad : continued…
Division/Unit
Connected viaCDR/VPN/BBoVPN
Status
Remarks
RAJKOT
CDR
Completed
BHAVNAGAR
CDR
Completed
BHUJ
CDR
Completed
JAMNAGAR
CDR
Completed
JUNAGARH
CDR
Completed
SURENDRANAGAR
CDR
CompletedSlide12
SSA - KALYAN
Kalyan1- E10B
Kalyan1-CDot
Kalyan1-OCB
Kalyan1-TAX OCB
Kalyan1- Tandem OCB
Dombivelli1-OCB-Local
Dombivelli1 C-DOT
Talasari1 CDOT
Ulhasnagar-OCB
Ulhasnagar2-OCB
Ulhasnagar1-Fetex
Ulhasnagar1-E-10B
Dombivelli1-EWSD
Vasai Papdi1 OCB
Wada1 CDOT
Mokhada1 CDOT
E1
Shahapur1-C-DOT
Murbad CDOT
Badalapur
East1 EWSD
Vasai
Road 1 OCB
Bhiwandi1 CDOT
Bhiwandi1-OCB Local
Jawhar1 CDOT
Bhiwandi1-AXE
NIB II Cloud
Central router
Aggregation router
Palghar1 CDOT
Tarapur1 OCB
Dahanu1 CDOT
FE
STM1
FE
CSR Network
Pune CR
KalyanSlide13
SSA - AHMEDABAD
Railwaypura
Bapunagar 5ESS
Naranpura
5ESS
Navrangpura EWSD
Sanand
CDot MAX-L
Barwala
CDot MAX-XL
Bhadra 5ESS
Dhandhuka
CDot MAX-L
Dholka
CDot MAX-L
Vasna EWSD
Jamalpur EWSD
Naranpura
E10B
Gulbai Tekra
EWSD
Bhadra TAX EWSD
Gulbai Tekra
TAX OCB
Gulbai Tekra TAX AXE-10
Gandhinagar OCB
Gandhinagar E10B
Dehgam CDOT MAX-XL
Gandhinagar 5 ESS
OCB
EWSD
LG-WLL BSC-0
LG-WLL BSC-1
Navrangpura OCB
Central Router at GBT (32 addl. E1s)
NIB II Cloud
FE
AHMEDABAD
VADODARA
E1
STM1
FE
CSR Network
Viramgam
CDot MAX-L
Vasna E-10B
ZTE-WLL
STM-1
STM 1
Aggregation
Router at Bhadra NIB
Existing
router
4 E1
FE
32 E1sSlide14
SSA - BHOPAL
NIB II
Cloud
Central
Router
BHOPAL
CSR Network
STM1
Aggregation
Router
INDORE
FE
E1
STM1
FE
RS Nagar EWSD
Obedullagan CDOT
Berasia CDOT
Ashta CDOT
Sehore CDOT
Budhni CDOT
Govindpura C-DOT
City E10B
CTX TAX II
CTX OCB
ATX ZTE WLL-MSC
ATX EWSD
ATX
OCB TAX I
FE/E3
FESlide15
SSA (1) Network – ERP Users
SSA(1) – Site 1
SSA(1) – Site 2
SSA(1) – Site 3
Proposed ERP User Access Connectivity to CDR MPLS for Circle Offices
NIB-2 MPLS VPN Network
PE Router
(Cisco
7613)
PE Router
(Cisco
7613)
Aggregation
Router
(Cisco 7609)
Aggregation
Router
(Cisco 7609)
STM-1/FE
STM-1/FE
CDR Aggregation Network
Aggregation
Router
(Cisco 7609)
Aggregation
Router
(Cisco 7609)
Aggregation
Router
(Cisco 7609)
Aggregation
Router
(Cisco 7609)
Remote Router
SSA (2) Network – ERP Users
SSA(2) – Site 1
SSA(2) – Site 2
SSA(2) – Site 3Slide16
ERP REVIEWGMM wise Status of Filled-up Templates WTR Circle Office, Mumbai :ERP ModuleTotal Templates
Filled-upuploadedPendingRemarks
HCM383520
15
FICO
1817
9
8
PM
11
1
1
0
MM
5
4
4
0
REM
23
1
0
1
PS
2
0
0
0Slide17
ERP REVIEWGMM wise Status of Filled-up Templates GMM, WTR Mumbai :ERP ModuleTotal TemplatesFilled-up
uploadedPendingRemarks
HCM13212076
44
FICO72
54
41
13
PM
40
20
0
20
MM
20
1
1
0
REM
23
0
0
0
PS
2
0
0
0Slide18
ERP REVIEWGMM wise Status of Filled-up Templates GMM, WTR Bhopal :ERP ModuleTotal TemplatesFilled-up
uploadedPendingRemarks
HCM999158
33
FICO
5449
30
19
PM
30
0
0
0
MM
15
1
1
0
REM
23
0
0
0
PS
2
0
0
0Slide19
ERP REVIEWGMM wise Status of Filled-up Templates GMM, WTR Ahmedabad :ERP ModuleTotal TemplatesFilled-up
uploadedPendingRemarks
HCM666038
22
FICO
3631
18
13
PM
20
14
0
14
MM
10
1
0
1
REM
23
0
0
0
PS
2
0
0
0Slide20
ERP REVIEWGMM wise Status of SAP CLIENT in PCs WTR Circle Office, Mumbai :UnitSAP InstalledRemarksWTR Circle Office Prabhadevi
YES
Telecom Building Prabhadevi YES
Fountain Telecom Building-1
YES
Fountain Telecom Building-2 (NIB)
YESSlide21
ERP REVIEWGMM wise Status of SAP CLIENT in PCs GMM, WTR Mumbai :UnitSAP InstalledRemarksMUMBAIYESKALYAN
YES
THANE (DGMM OFFICE)YES
THANE (KOPRI)
YES
SATELLITE THANE
YES
PANVEL
YES
NASIK
YES
DHULIA
YES
RATNAGIRI
YESSlide22
ERP REVIEWGMM wise Status of SAP CLIENT in PCs GMM, WTR Mumbai : continued…UnitSAP InstalledRemarksPUNE (MHS)YES
PUNE (MPLS)YES
AHMEDNAGARYES
AURANGABAD
YES
KOLHAPUR
YES
LATUR
YES
PANJIM
YES
SATARA
YES
SOLAPUR
YESSlide23
ERP REVIEWGMM wise Status of SAP CLIENT in PCs GMM, WTR Mumbai : continued…UnitSAP InstalledRemarksNAGPURYES
NAGPUR (SAKKARDARA)
YESAKOLAYES
CHANDRAPUR
YES
JALGAON
YES
NANDED
YES
YAVATMAL
YESSlide24
ERP REVIEWGMM wise Status of SAP CLIENT in PCs GMM, WTR Bhopal :UnitSAP InstalledRemarksBHOPAL (CITY)YESBHOPAL (ARERA)
YES
GWALIORYES
GUNA
YES
INDORE
YES
ITARSI
YES
MANDSAUR
YES
RATLAM
YES
UJJAIN
YESSlide25
ERP REVIEWGMM wise Status of SAP CLIENT in PCs GMM, WTR Bhopal : continued…UnitSAP InstalledRemarksJABALPUR
YESCHATARPUR
YES
CHINDWARA
YES
NARSINGHPUR
YES
REWA
YES
SAGAR
YES
RAIPUR
YES
BILASPUR
YES
DURG
YES
AMBIKAPUR
YES
JAGDALPUR
YESSlide26
ERP REVIEWGMM wise Status of SAP CLIENT in PCs GMM, WTR Ahmedabad :UnitSAP InstalledRemarksAHMEDABADYESAHMEDABAD (BHADRA)
YES
BARODAYES
BHARUCH
YES
BULSAD
YES
GODHRA
YES
HIMMATNAGAR
YES
MEHSANA
YES
PALANPUR
YES
SURAT
YESSlide27
ERP REVIEWGMM wise Status of SAP CLIENT in PCs GMM, WTR Ahmedabad : continued…UnitSAP InstalledRemarksRAJKOTYES
BHAVNAGAR
YESBHUJ
YES
JAMNAGAR
YES
JUNAGARH
YES
SURENDRANAGAR
YESSlide28
User’s Categorization/Creation in ERPMODULEACTIVITY
SHORT DESCRIPTION
CIRCLEHQ
HR
OM
OM consist of Org Units, Positions, Person & relation between each other
2
PA
Personal Administration deals with activities related to employees on day to day basis
2
MM
STORE Manager
Monitoring of Store, Diversion of Store
1
STORE In-Charge
In-charge of the Store (Goods Issue/ Receipt/ Transfer Posting/ Physical Verification of Store/etc..)
1/STORE
PROCUREMENT
Purchasing Activities such as PO, Agreement/Contract
2
PM
WORK
CENTRE
Creation of MO,PR,PO & SE
1
In-Charge
Creation of notification
1
REM
MASTER
Lease in/out of
land,bldg,towers
& allotment of qtr/
IQ,propty
tax etc
2
TRANSACTIONL
FICO
PAYROLL
Circle MDM Team for Payroll Execution
3
CSC
Payment Processing Team at Circle
2
CA / Finance
Budgeting / Audit / CA Team at Circle
3
WORKS
Planning / Works related Task Force
2
TR
TR / Collection Management
1
CLAIM
CELL
Acknowledging Claims of Employees / Vendors & Record Keeping
2
PS
PLANNING
Proj def.,WBS creation & Mtce.
2
WORKS
Budg
. Allocation & settlement
Slide29
User’s Categorization/Creation in ERPMODULEACTIVITY
SHORT DESCRIPTION
GM Ms
HR
OM
OM consist of Org Units, Positions, Person & relation between each other
0
PA
Personal Administration deals with activities related to employees on day to day basis
2
MM
STORE Manager
Monitoring of Store, Diversion of Store
1/GM&DGM
STORE In-Charge
In-charge of the Store (Goods Issue/ Receipt/ Transfer Posting/ Physical Verification of Store/etc..)
1/DE&1/STORE
PROCUREMENT
Purchasing Activities such as PO, Agreement/Contract
2
PM
WORK
CENTRE
Creation of MO,PR,PO & SE
1/DE
In-Charge
Creation of notification
REM
MASTER
Lease in/out of
land,bldg,towers
& allotment of qtr/
IQ,propty
tax etc
0
TRANSACTIONL
2
FICO
PAYROLL
Circle MDM Team for Payroll Execution
0
CSC
Payment Processing Team at Circle
0
CA / Finance
Budgeting / Audit / CA Team at Circle
0
WORKS
Planning / Works related Task Force
2
TR
TR / Collection Management
1
CLAIM CELL
Acknowledging Claims of Employees / Vendors & Record Keeping
2
PS
PLANNING
Proj def.,WBS creation & Mtce.
1
WORKS
Budg
. Allocation & settlement
Slide30
FILLING OF PM TEMPLATES IN ERP ALL EQUIPMENTS ARE TO BE ENTERED WHICH ARE IN ASSET. EQUIPMENT ALSO MEANS VEHICLE, CABLE, COMPUTER, ACs etc. ALL EQUIPMENTS FILLED-UP IN THE PM TEMPLATE MUST HAVE A CORRESPONDING ASSET_ID OF FICO TEMPLATE IF ASSET_ID IS NOT AVAILABLE FOR WANT OF ATD, AO MAY CREATE ASSET FOR 2014-15 WITH ZERO VALUE WITHOUT WAITING FOR ATD.
DATA TO BE FILLED-UP : PM ORGANIZATION DATA
WORK CENTRE MASTER DATA FUNCTIONAL LOCATION MASTER EQUIPMENT MASTER EBOM DETAILSSlide31
ACTIVITIES IN PM MODULEWORK FLOW : CREATED BY INITIATOR ASSIGNED TO VENDOR/MECHANIC/FIELD OFFICER ACKNOWLEDGED BY CONCERNED PERSON RE-ASSIGNED TO CONCERNED PERSON COMPLETED
BY THE CONCERNED PERSON CONFIRMED BY INITIATOR
REWORK REQUIRED BY INITIATOR NOTIFICATION :
OSNO : OUTSTANDING NOTIFICATION
NOPR : PENDING NOTIFICATION
NOCO :
COMPLETED NOTIFICATIONSlide32
ERP REVIEWFinalization of Store Locations STORE LOCATION AT SDE LEVEL AT BIG STATIONS, ONE SUB-STORE FOR MUX AND OTHER ONE FOR ROUTE MAIN STORE UNDER THE CONTROL OF DE INVENTORY AVAILABLE IN THE STORES TO BE INFORMED TO CONCERNED AO FOR ACCOUNTING. Slide33
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
1
Vendor Details not available:
Address
Registration details
Pan Card,
Bank Details
IFSC Code
Tax Registrations
Duplicate Vendors
Unidentified Vendors
Payment automation hindered – NEFT / RTGS
Un-reconciled vendors payables
Audit Observation
Distribute Data forms to collect data at the point of vendor interactions.
Encourage Vendors to provide data through BSNL Portal
Make payments subject to submission of data – on lines of KYC of BanksSlide34
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
2
Employee Details not available:
IFSC Code
Bank account details not updated
Details for Retired employees
Communication details
Credit of Salary
Credit of reimbursements
Payment automation hindered – NEFT / RTGS
Un-reconciled employee advances / payables
Higher tax rate (TDS for not providing PAN).
Audit Observation
All employees to verify & update their personal details in HRMS
Data forms to collect data at the point of retired employee interactions / Unions
Encourage retired employees to provide data through BSNL Portal
Make payments subject to submission of data – on lines of KYC of BanksSlide35
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
3
Schedule of Employee Loan & Advances do not reconcile with the Trial Balance:
Employee / Loan type break-up does not match with G/L
Balance Outstanding does not have details / identifier
Employee Loans and advances data can not be uploaded in SAP
Automatic Loan management is hampered
Un-reconciled employee Loans & Advances
Audit Observation
Extended Black out
All employees to verify & update their personal details in HRMS
Data forms to collect data at the point of retired employee interactions / Unions
Encourage retired employees to provide data through BSNL Portal
Make payments subject to submission of data – on lines of KYC of BanksSlide36
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
4
IT / Arrear data not updated in HRMS correctly:
Established processes in HRMS not being followed by units.
Wrong data pertaining to IT/ Arrear / Perks / Medical are fed in HRMS
Income Tax calculation would not tally with SAP
Wrong IT liability calculated
Salary calculation would not reconcile
Audit Observation
All employees to verify & update their personal IT
Standard process to be followed across BSNL in HRMS.Slide37
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
5
EMD / SD details not available (unidentified):
EMD / SD outstanding for more than three years
EMD / SD outstanding for less than three years
EMD / SD outstanding data can not be uploaded in SAP
In future cannot be refunded through SAP
Un-reconciled EMD / SD
May need to pay penalty if payment deadline will be missed
Audit Observation
Extended Black out
All EMD / SD details to be dug out and matched against parties
Write-off EMD / SD outstanding for more than three years as per BSNL policy (Treat as Misc Income)Slide38
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
6
Interface with banks for electronic transactions not standardized across BSNL :
Interface for electronic upload of RTGS/NEFT transfers not in place with the banks BSNL is operating with.
Banks not geared up with electronic bank statements in standard formats fir BRS
Cheque printing formats not standardized
Automatic payment process from SAP will be delayed.
Automatic BRS will not be done.
Manual effort will be increased leading to inherent mistakes.
Manual Check writing to continue
Unified bank for making payment
Liaison with banks to get the electronic transactions in place. This should be completed for entire BSNL well in advance.
Finalization of format required for bank reconciliation by using international formats (MT940 /
Multicash
)
Moving to a phase of single banker for all employees for all payroll / reimbursement related payments.Slide39
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
7
The Application Landscape of BSNL is not standardized across BSNL. Automated Electronic Interfaces with SAP would not work :
Interface with QMS for fault data at NTR / ETR / WTR.
Sancharsoft
not being used for sales processes with standardized processes
HRMS not being used in BSNL CO for payroll / HR processes
Automatic Interfaces with SAP will not work.
PM / SD / MM / FICO processes in SAP would get impacted.
Non standardized interfaces / processes would leave room for errors / mischief.
Manual effort would increase
Reconciliation problems
Unified Standard Application to be implemented across BSNL – QMS, HRMS,
Sancharsoft
etc.
Sancharsoft
to be configured with mapping tables for entire BSNL (as done for KTK)
Sales processes to be aligned with KTK processes.
Process standardization of entire BSNL to be done inline with processes frozen for POCsSlide40
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
8
Un-reconciled Remittance
Intra-circle remittances not paired and having balance.
Balance will not be matching at different head of account (exp/cash/bank/asset/inventory/payable/receivable)
Incorrect TB
Data can not be uploaded in SAP
Un-reconciled data
Audit Observation
Extended Black out
All intra-circle remittances should be paired at circle level.
After pairing remittances, requisite heads of account will get the due credit /debit and the balance should be matched with TB.Slide41
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
9
Inappropriate budget at node levels of IM structure.
Problem at the time of booking CAPEX/OPEX expenditure.
Delay in defining applicable IM structure
Expense booking on wrong Estimate / Project / exceeding budget allocation / closed projects
Data can not be uploaded in SAP
Un-reconciled CWIP balances
Audit Observation
Extended Black out
Stops inventory processing / period closure
Budgets should be allocated appropriately to each node of an IM structure to ensure that the expenditure/budget available at bottom level is always less than the budget available in the upper node.
Reverse mechanism or, bottom up approach should be followed to derive the appropriate budget at each node of an IM structure.
IM structure to be defined well in advanceSlide42
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
10
CWIP Data not reconciled with open projects / estimates
Data can not be uploaded in SAP
Un-reconciled CWIP
Asset will get proper value if CWIP could not be matched with open projects
Audit Observation
Extended Black out
All Project / Estimate details to be dug out and matched against CWIP trial in advance
Old estimates to be closed as per BSNL norms
Reverse mechanism may be used to get this data reconciled.Slide43
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
11
Asset Data not reconciled with GL codes:
Non-assets included
Assets line items not maintained with details
Decommissioning not taken care of
Capitalization not updated in register
Wrong posting of Depreciation
Asset Class / component not proper
Data can not be uploaded in SAP
Un-reconciled Asset Register
Wrong calculation of depreciation
Audit Observation
Extended Black out
All Asset to be dug out and reconciled against trial – class, component, GL wise in advance
Retired / decommissioned assets to be accounted for prior to cutover
Capitalization of assets – squaring of ATD / ATC to be completed prior to cutoverSlide44
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
12
Un-reconciled Inventory
Sancharsoft
and other inventory management application inventory does not tally with TB
Stock position is not reconciled store wise
Non-usable inventory is not retired / scrapped
Data can not be uploaded in SAP
Un-reconciled data
Audit Observation
Extended Black out
All Inventory to be dug out and reconciled against trial – GL wise in advance
Requisite treatment should be done for inventory scrapped and the scrapped inventory balance should be matched with TB before cut-over.
Retired / decommissioned assets to be taken into inventory (if the same is
inventorised
and removed from asset register) prior to cutover
Physical inventory to be done and updated with trial prior to cutoverSlide45
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
13
Re-structuring of Units / Merger of Trial Balance :
Merger of Civil and Electrical Trial balance with SSA - delay
Delay in finalization of Treatment of CMTS units.
Formation of CSC / CPC cells
Delay in migration
Reconciliation issues across units post migration
Impacts master data and Roles & Authorization matrix of related functions
Appropriate Notification on merger / restructuring to be issued to all units well in advance
Merger of Civil and Electrical Trial Balance to be completed in the legacy system itself
The merged TB to be migrated in ERP
Treatment of CMTS unit to be finalized for all locations well in advance.
All Master data & R&A to be prepared after the merger / restructuring.Slide46
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
14
Changes incorporated in ERP solution during Cutover:
Location specific changes incorporated in the solution
Changes done to the solution / process at the last moment
Solution Changes released to PRD during cutover
Pan-BSNL Standardization of business process is lost
Last moment changes impacts the solution stability and has cascading impact on the integrated solution
Impacts master data and Roles & Authorization matrix of related functions
Poses reconciliation problem / Post Implementation issues
All changes to the solution to be governed through a Change Control Board
Effective Corporate communication / campaign on standardized processes across BSNL to all Units
All Releases of the Application to be controlled by a Release Management Cell
Use of tools for requirement gathering and effective monitoring of change management process (currently Mantis is used). Slide47
ERP REVIEWCommon mistakes/errors faced during GO-LIVE#
Issue / Risk
Impact
Resolution / Mitigation
15
Cut-over period is not well defined: :
Black-out period is too extended
Business transactions are carried out during Black-out
Delay in reconciliation of accounts
Reconciliation issues across units post migration
Data inconsistencies due to uncontrolled back log data
Lot of unnecessary effort spent in bringing the system to real time
Checks & balances are compromised making the system vulnerable.
Ensure that all the master data is complete and correct before starting cut-over
Ensure that all Schedules are complete and tallied during last closure of accounts prior to go-live.
Cut-over should not exceed 3-4 days
Business Transactions to be stopped to near complete level during the entire Blackout period.Slide48
ERP REVIEWGO-LIVE Schedule for WTRItemScheduled DateRemarksBLACK OUT START DATE30-09-2014FINALISATION OF TRIAL BALANCE10-10-2014GO-LIVE TO ERP14-10-2014Slide49
Pre GO-LIVE ACTIVITIESHCM, FICO, PM AND REM MODULES WILL GO-LIVE IN SEPT-2014 EXCEPT ESS.SALARY FOR FIRST TIME IN ERP IN LAST WEEK OF SEPT-2014ESS WILL GO-LIVE BETWEEN 05-10-2014 TO 10-10-2014LEAVE TRANSACTION TO CONTINUE IN HRMS TILL 30-09-2014LEAVE BLACKOUT PERIOD FROM 01-10-2014LEAVE TAKEN DURING BLACK OUT CAN BE ENTERED IN ERP MANUALLY AFTER GO-LIVEBLACKOUT FOR GPF/MEDICAL FROM 01-09-2014.Slide50
ERP TRAININGSEND USER TRAININGS COMPLETED :Sl.No.ModuleWTRHQMBITHNPUNENGPAMRJBPLJBRYP1.HCM5312
232
1242.FICO4
41
221
05
2
2
3.
PM
3
3
1
1
1
1
1
1
1
2
4.MM21101112025.REM000
00
00
10
1
6.
PS
0
0
0
0
0
0
0
1
0
1
TOTAL
14
11
4
5
6
6
4
11
5
12Slide51
THANK YOU