Tender For Work Of Conversion And Migration Of Existing Foxpro Database To Oracle 12C Platform, palakkad-Kerala

Work Of Conversion And Migration Of Existing Foxpro Database To Oracle 12C Platform , Items , System Study Analysis Design And Coding Afresh For The Following 1.Financial Accounting System A ) Financial Accounting System Including Billing And Daybooks Likes Sales, Purchase, Journal And Bank Books. Maintenance Of Debtors And Creditors Sub Ledger And Its Mis Reports. B ) Pricing Of All Receipt Vouchers - While Receipt Voucher Pricing Necessary Changes Are To Be Made In The Existing Commercial Order Processing System Also. Passing Of All Vouchers And Making Bank Payments. C ) Fixed Asset And Its Depreciation Calculations. D ) Other Statutory Output Requested For Commercial Tax And Central Excise Departments. 2.Material Pricing A ) Priced Stores Ledger - Data To Be Integrated From Exiting Customer Order Processing System. B ) Machine Shop Work Order Pricing. C ) Product Costing. D ) Sub Contractors Material Issue And Pricing Of Sub Contractor Bills. E ) Finished Goods Maintenance. F ) Necessary Journal Entries And Payment Vouchers To Be Generated For Financial Accounting System. 3.Payroll A ) Il Monthly Payeroll And Generation Of Its Journal Entries To Financial Accounting System. B ) Arrear Calculations Module. C ) Income Tax Calculations And Creating Required Data For Income Tax Department. D ) Advance Payment To Employees And Its Adjustments Including Its Interest Calculation And Preparation Of All Schedules For Financial Year. E ) Creation Of Required Data For Pf. F ) All Payments To Employees Other Than Salaries Like El Encashment And Ltc. 4.Establishment A ) Module For All Payments To Employees Like Ta, Medical And Other Establishment Payments. 5. Personnel Information System A ) Employees Personal Data, Family Depends Data And Maintenance From Joining Details, Promotions. B ) Capturing Of Attendance Data From Time Office And Transferring The Same To F&A Payroll Module. C ) Leave Data Maintenance And Preparations Of All Statutory Outputs. , All The Existing Relevant Dats’S To Be Converted From Foxpro To Oracle 12C.

Sr No	CorrigendumDate	Corrignedum	CorrigendumType	NewSubmissionDate
1	24-Aug-2023	Extend Auction	Date	05-09-2023

Refer document

Refer document

Refer document

Name of Work: work of conversion & migration of existing FoxPro database to Oracle 12c platform

Sl. No.	Item Description
1	ITEMS
2	System study analysis design and coding afresh for the following 1.Financial Accounting system a)Financial Accounting system including billing and daybooks likes sales, purchase, journal and bank books. Maintenance of debtors and creditors sub ledger and its MIS reports. b)Pricing of all receipt vouchers - while receipt voucher pricing necessary changes are to be made in the existing commercial order processing system also. Passing of all vouchers and making bank payments. c)Fixed asset and its depreciation calculations. d)Other statutory output requested for commercial tax and Central Excise departments. 2.Material Pricing a)Priced stores ledger - data to be integrated from exiting customer order processing system. b) Machine Shop work order pricing. c) Product costing. d)Sub contractors material issue and pricing of sub contractor bills. e) Finished goods maintenance. f) Necessary journal entries and payment vouchers to be generated for financial accounting system. 3.Payroll a) IL Monthly payeroll and generation of its journal entries to financial accounting system. b) Arrear calculations module. c) Income tax calculations and creating required data for income tax department. d) Advance payment to employees and its adjustments including its interest calculation and preparation of all schedules for financial year. e) Creation of required data for PF. f) All payments to employees other than salaries like EL Encashment and LTC. 4.Establishment a) Module for all payments to employees like TA, Medical and other establishment payments. 5. Personnel Information System a) Employees personal data, family depends data and maintenance from joining details, promotions. b)Capturing of attendance data from time office and transferring the same to F&A payroll module. c) Leave data maintenance and preparations of all statutory outputs.
3	All the existing relevant dats’s to be converted from FoxPro to Oracle 12c.