Profit5RM Software Data split manual
1Data Split Procedure- 31-03-2018
Important Note:
Please read this document completely, understand and then complete the procedure as per following steps:
- STEPS TO BE COMPLETED BEFORE STARTING DATA-SPLIT.
Ensure that data entries of all the transactions till 31-Mar-2018 arecompleted.
If Any Stock Adjustment entries till 31-Mar-2018 are pending that should be completed before running this procedure.
Please generate all the necessary reports (mainly Excise Reports) and save these reports in excel for your future usage.
Confirm the Statistics status of your depot from HO before you start.
Make Sure Profit5RM is closed in all the systems. Take 3 Backups as under:
(1)in Hard disk of any Desktop
(2)in Pen-Drive
(3)in CD.
These backup should be marked as BACKUP310318-BEFORE SPLIT.
Send CD backup to HO.
- IMPORTANT INFORMATION BEFORE STARTING THE PROCEDURE.
The Update Procedure has to be done in the Server Only.
Profit5RM should be closed in all systems and ensure that all the users are logged out of the P5RM.
System will take around 30-45 minutes to complete the data split process.
STEPS for SPLIT PROCEDURE.
1)Download the necessary files required to run from the below link. This link will be activated on 01-Apr-2018 afternoon 12.00 o’clock only.
2)Extract the zip file and copy the following file in C:\ drive of Server Only.
i)DataSplit1718.txt
ii)DS1718_Data.dmp
See the figure given below:
1) Open Oracle 11g SQLPlus. (Start AllPrograms Oracle - OraDb11g_home1 Application Development SQL Plus) Right-Click and select “Run as administrator”,
see the figure given below.
2) The SQL Command Line window will display as under:
Here user has to enter the Current Project Name and password in lower caseand then press “Enter”. (For example, Project Name of HASSAN2 Depot ishasan2ksbcl, then enter hassan2ksbcl/logand press enter key. The user has to enter their Project Name properly and press ENTER key.
Project Name is displayed while one logs into Profit5RM as under:
- Refer the figure given below.
4) User has to type @C: \DataSplit1718.txtin the SQL Command line window and then Press “Enter”. After pressing the enter key the system will ask the User Name for Data Split.
Enter User Name for Data Split:Here user has to enter the Current Project Name and then press “Enter”. (For example, Project Name of UDUPI Depot is udupiksbcl) The user has to enter your Project Name properly.
5) The SQL Command Line window will close automatically, after executing all the
Necessary updates.
6) Now, the process has been completed. You have to send the following 4 files to HO for confirmation:
Open “My Computer” in Server, Open “Local Disk (C:\)”, here you will find a file
“DataSplitResults1718.txt” attach the files and mail to HO.
Open Profit using “Profit5RM”, go to “Depot Reports”, go to “Others”, open following Reports:
1)Download Versions Details”, and take the “Screen shot” of this report
2)Opening Stock Comparison Report”, and take the “Screen shot” of this report.
3] Opening A/c Balance Comparison Report”, and take the “Screen shot” of this report
and then send all the above 4 reports as an attachment to HO mails as under:
Nodal Officer
Following Updates are affected on successful completion:
S.No / Module / Enhancement / Modification1 / Pricing / Selling Rate is updated as zero for all IML items Other than Slab1 items.
2 / Transport Permit Label – Print / While printing system is taking long time (or) sometimes system hangs. It is fixed now.
3 / Materials Inward Slip / Issue regarding Transit Damage Qty is resolved, sometimes, transit damages are showing double in the report.
4 / Drained out Reports / All issues relating to Drained out Repots are Resolved
5 / Blocking of Expiry Stock / Originally deletion of entry is permitted and now it is disabled
6 / Account Opening Balance / Account Opening Balance is Updated only for Retailers account and Petty Cash Balance. All other accounts are made “0”
Note:-
For any further Clarifications, Please Contact your Nodal officer.
Thank you
1