Internship Report on Ptcl

INTERNSHIP REPROT On FI-CO_ERP in pic ERP- broadsheets & pay Submitted By Faisal Rasheed Internship Report on PTCL pattern Of Internship The purpose of this internship is to interpret how the practical overwork is performed in a computer based ERP resolving power. In access, to practic each(prenominal)y learn concepts which have been learned theoretic whollyy in education and to develop the understanding of the function performed by ERP Accounts and pay. desktop of Internship In six weeks instruct span, it is difficult to understand every work flow of each Sub sections of Accounts & Finance discussion section beca occasion of its huge meretriciousness of work.The briny focus was in the FICO module including General Ledger, creation of traffickers, Customers, pay impinge on/Receiving of advance, parking of n atomic number 53s, posting and payment/receipt of measures and cheque printing, Addition in Defaulters, Bad debts Pro rafts, Adjustment of Provision, and Recovery from Defaulter. Constitution and ownership, Mission, Vision & Core determine Pakistan telecommunicationmunication Comp some(prenominal) Limited (PTCL) Pakistan Telecommunication Comp both Limited (the retentivity Comp any) was in corporeald in Pakistan on December 31, 1995 and commenced disdain on January 01, 1996. The Company is listed on Karachi, Lahore and Islamabad stock exchanges.The Company was established to seek the telecommunication business formerly carried on by Pakistan Telecommunication good deal (PTC). The business was transferred to the Company on January 01, 1996 under the Pakistan Telecommunication (Re-organization) Act, 1996 at which engagement the Company took over all(prenominal) the properties, rights, assets, obligations and liabilities of PTC except those transferred to National Telecommunication hatful (NTC), Frequency Allocation Board (FAB), Pakistan Telecommunication Authority (PTA) and Pakistan Telecommunication Employees pull (PTET).The register ed self-confidence of the Company is situated at PTCL Headquarters, G-8/4, Islamabad. As a aftermath of PTCLs privatization during 2006, 26 % of its sh atomic number 18s were acquired by Etisalat International Pakistan LLC, based in the UAE. Pak Telecom Mobile Limited (PTML) PTML was incorporated in Pakistan on July 18, 1998, as a public limited company, to provide cellular mobile telephony go in Pakistan. PTML commenced its commercial operations on January 29, 2001, under the brand pull in of Uf iodine . It is a wholly owned subsidiary of PTCL. The registered office of PTML is situated at F-7 Markaz, Islamabad.Maskatiya Communications (Private) Limited (MAXCOM) On March 01, 2010 the holding Company acquired deoxycytidine monophosphate % shargons of MAXCOM. MAXCOM has been voluntarily wound up, effectual June 01, 2011 based on a limited resolution passed by the members of MAXCOM. The net assets of MAXCOM have been transferred to PTCL at a adjudge value amounting to Rs 68,382 thousand and the good pass on cerebrate to acquisition of MAXCOM has been compose off during the class. PTCL Corporate Vision To be the leading ICT service provider in the region by achieving customers satisfaction and maximizing shargonholders value. PTCL Mission To achieve our vision by having An organizational environment that fosters professionalism, motivation and quality. An environment that is cost effective and quality conscious. Services that ar based on the most optimum technology. fictitious character and Time conscious customer services. Sustained growth in earnings and profitability. PTCL Core Values Professional Integrity Customer triumph Teamwork Company Loyalty Organizational Structure Accounts & Finance Department link to ERP Only Under the electric chair & C. E. O, derive 9 department guide Including seven S. E. V. Ps, C. T.O and C. I. O are working each whizz is liable for formulating planning & strategies at corporate level with the suppo rt of their Teams. all(prenominal) S. E. V. P has more than one E. V. Ps and their teams. Under S. E. V. P Finance C. F. O, three E. V. Ps are working related to Revenue Accounts & Revenue Assurance, monetary Planning & Treasury Management, & Accounts Services. Under the E. V. P- Accounts Services, total two General Managers including G. M Accounts Taxation & pecuniary Reporting, G. M ERP Finance & Assets Management are working. Each G. M has at to the lowest degree one Senior Manager or Manager or both. Each S.M or Manager has at least one financial analyst or Assistant Manager. Internees are reportable to Assistant Manager or Financial analyst. ERP and Its Functionality ERP (enterprise resource planning) is an industry term for the broad set of activities that facilitates a business manage the important separate of its business. The information do ready(prenominal) with an ERP system provides visibility for key performance indicators (KPIs) required for meeting corporat e objectives. ERP software applications endure be utilize to manage product planning, parts purchasing, inventories, interacting with suppliers, providing customer service, and tracking orders.ERP give the axe to a fault include application modules for the pay and human resources aspects of a business. Typically, an ERP system uses or is integrated with a comparative informationbase system. pic saphead ERP Solution and its Functional Support pic rake (System Application Product) R/3 is a 3 tier Real snip selective information processing system developed by SAP AG, a German software company. The R/3 system, which is withal known as ERP (Enterprise imagery Planning) System, is a tightly integrated collection of applications de business firmed to handle the faultless data processing for many different images and sizes of organizations.Within R/3 is a run time environment and a set of application programs written in ABAP/4 programming language, which are highly customiza ble and scalable. SAP R/3 system has a three-tier client/server architecture. The classic chassis of an R/3 system leads three software layers, as inclined in the below picture. pic Presentation layer The PC-based GUI interface that is employ by the end- exploiter community. Application layer The SAP application servers that service requests for data and manage the interface to the presentation layer. infobase layerThe actual DBMS that communicates with the application servers to assemble their requests for data. SAP allows the IT supported processing of a multitude of tasks, accruing in a typical company or bank. SAP ERP is differing from R/3 in general because it is based on SAP NetWeaver core components mickle be utilize in ABAP and in Java and new functional field of forces are by and large no longer created as part of the former ERP system, with closely interrelated constituents, but as self-contained components or even systems. SAP in PTCL Every company has it s own unique business processes to meet destiny and challenges. That is why PTCL uses the SAP.SAP is standard project system it is divided into three servers. 1. exploitation legion 100 & 300 2. Quality Assurance boniface 600 & 790 3. Production. Server 800 In the development Server 100 new developments are made by SEMINES/ PTCL Development Team with help on business functional Team leads, technical coding is through with(p) in this server with SPRO & ABAP Language. The ERP staff consolidates the issues of users and solves them as per requirements. ERP Team Test the development made in development Server 300. Development server data, after scrutiny the codlings and commands, is quickly available for transferring to quality server.In the SAP the quality assurance is made for skill and testing. The QAS(Quality Assurance Server) 600 or 790 is utilize for the trainings purposes and to familiarize the user with the system. After testing the data, based on real scenarios, in qua lity Server the data is ready for transferring in production from where the users use it live. Production Server 800 is the main and live part of System Application Product on which all the financial and non financial records are kept on real time basis. FICO( Financial & Controlling) Module Includes the Following FI (Financial)- General Ledger rate Accounts collectable Accounts receivable Asset accounting Travel Management CO (Controlling)- appeal element accounting appeal center accounting Internal orders proceeds center accounting Profitability analysis Following Pictures go forth help you in understanding the SP ERP FICO Module and the related departments head functions of any organization. lick Flow Payments & FR Signatory Authority and Responsibility for Payment bill of exchange and Disbursement Office (DDO) i. e S. M of each region who is responsible for all nature of payment & recoveries related to employees, supplier and contractor as per policies and contr acts made by this department.Financial Reporting DDOs in regions recognize the financial proceedings in whole calendar month and the 3 working day of the next month are given to each department so that they undersurface concord sure the closing of last month is completed. Accounts section in the head quarter downloads all data related to each month from the main server & prepares an unregistered trail balance for the identical, and so a government agency it to the SM nominal ledger for finalizes the records hence the financial information with any error passel be rectified immediately so that Financial Statements mess made on timely basis.Monthly accounts, Quarterly, Half yrly & annual accounts are maintained and compared with the last yr. Some estimates and provisions at year end are taken to the annual report. PTCL follow financial year from July to June Whereas ETISALAT follow calendar year as Financial Year. ERP SAP duty assignment I was given internship with GM ERP -Finance whereas I had worked with Manager ERP-Finance and Financial Analyst D. B & I. S. They taught me many concept of SYSTEM APPLICTION PRODUCT (SAP) FICO, & I am very thankful to both of them.Following are the major activities performed by Financial Analyst in Accounts Payable a part of FICO Module in SAP. vendor Master Record Create/Change/ Display/ occlude or Un give up seller Master Data (T CODE FK01, FK02, FK03,FK05) instance FK01 in command telephone line and press enter here you will be asked for the fields of vendors to be modify like Company cipher, seller aggroup, Title Mr. Mrs. M/S and so on Name, street address, Postal Code, Telephone, VAT Reg No, Vendor marge Details, Sort Key, Payment Terms, and Payment Method. For the divulge use FK02 and if any changes in any field of vendor required use FK03.If you motivation to block or thaw any Vendor use FK05. regulate below how to do the above task manually convey without apply TCODES, by using SAP Menu. Par king of vender invoice (TCODE FV60, F-63) credence Memo(TCODE FV65) Parking drive homes the data in the form of batches, here the insertion is save but without updating the related ledge. nib is required for updating GL Balances. You can park invoices or credit memos which mean that you enter the invoice data or credit memo data in the system and save it in a record, but the system does non post this invoice initially.You can change a parked memorial as lots as you wish, for example, by adding or correcting data. The changes are logged. When you have finished changing the enrolment, you can post the parked document. Only when you post an invoice or credit memo, does the system carry out the normal account movements and make the necessary updates. Why we Need of Parking? Document Parking by One Accounts Payable Clerk An employee is interrupted when go into an invoice. He or she can park the document and continue processing it by and by on. This saves him or her having to enter the data twice.OR An employee wants to clarify certain issues before posting an invoice. He or she can park the document and continue processing it later on. This saves him or her having to enter the data twice. The process flow is organized in such a way that one employee parks invoices without checking them. Another employee then performs invoice verification and posts the parked documents, possibly after changing them. OR The process flow is organized in such a way that one employee saves invoices as complete for posting, this way that the balance is zero and no more changes are necessary.Another employee then approves these invoice documents, if they are subject to release. circuit card of vender invoice/ Credit Memo or Changing in Parked eyeshade (for TCODE sympathize Picture) If you are directly posting an invoice/ credit memo then choose Document Entry foremost highlighted menu, otherwise to post the parked documents choose Parked document. Any changes in the po st or parked document shall be dealt from the 2nd highlighted menu. surmount Payment or bolt down Payment or Print Cheques (for TCODE See Picture) Outgoing Payment means payment against the booked invoice which is dealt with the inaugural highlighted menu.On the other hand, Down Payment means the Payment before the Invoice creation which is dealt through 2nd highlighted menu and the profiting of the same will also be dealt from this menu. In the both transaction you account the Vendor Account and Credit the Bank. Only difference is the exceptional GL indicator a which is used for down payment. As per PTCL / PTML policy no advance has been given to any Vendor without PO (approved) so this field is mandatory. Another provoke thing, payments are made by the Cheques (see highlighted 2nd & 3rd menu). To print Cheques interest steps are required.When a vendor invoice is parked document containing 25000xxx is generated. Next step is to post the invoice by a elderberry bush manage r (as signatory authority) which generates document no. 26000xxx. Now Cheque is available for printing. Time barred Cheque is a type represents those Cheques which are not presented within six months, these will be reversed by the S. M. account Display Balances, Display/Change Line Items, Clearing except Down Payment (for TCODE See Picture) From highlighted menu you can view the balances or you can change any line item or you can clear invoices, reversals, credit memos, outgoing Payment.However, Down payment partial clearing should be done from the down payment menu as mentioned in the previous page TCODE F-54. Clearing a vendor document means nonentity is outstanding for the document the document is completed in all respect. pic SAP Include many modules which are integrated with each other in such a way that output of one module can be used as input for another or the same module. The following Landscape Picture represents the all SAP modules functionality & its practical applic ation. just about all of the modules are purchased by PTCL and working. Other Task other than ERP SAPSM Data Base Account coordinates with different integrated modules of system SAP i. e. FI, CO, HCM &MM. SM Data Base Account is directly reportable to the GM Accounts for any problem regarding working in SAP and also reportable to gm ERP Finance regarding FICO Role assignment. Following are the some responsibilities of Financial Analyst Data Base Account on which I have worked. Account Payable (Create, Block, And Unblock Vender) Non PO Based Vendors are created in SAP by a financial analyst Accounts & database. From time to time these vendors are blocked due to some reasons e. g.Vendor regularly not in use, block for payment or block for business. However, whenever any blocked vendor is need it can be activated/ unblocked. Account Receiveable (Create, block, and unblock customer) Customers are also created in the account data base department. These customers can be blocked, unbloc k at any time as per the requirement of the user. Fico Role engagement New employee is assigned to work on SAP FICO Module user role assignment for quality server 90 is made by financial analyst Accounts & database. This form includes the TCODES he or she is going to use on SAP.GM ERP Finance, SM Accounts Database, GM ERP Teams, and new user must sign Role Assignment Document. After this step, ERP team creates new user on QAS (Quality Assurance Server). Once the user is familiar with the TCODES and its working on Quality he or she can apply for the Production Server 800 which is also dealt from this office. Liaison with Finance, Accounts and ERP An interesting task which is also performed here is to convey the problem of the FICO end users to the ERP Team on timely basis so that solution can be immediately available for the user who can then work efficiently.Other Tasks To make each month a report of the users who are using TCODES which are not assigned any more to them and with th e help of ERP Team withdraw these roles from their users as per authority matrix. To make sure all the GL, Vendor, Customers, Commitment items are also available in QAS 790 if compared with Production Server 800. MS Outlook is also used all over the departments and is befitting very powerful tool to convey massages on timely basis. This office receives emails for Vendors and Customers creation, blocking and unblocking. Special Terms used in SAPI had gone through many TCODES in SAP which were the part of FICO it is not difficult to grip on SAP in this 6 weeks training if you are familiar with these terminologies given below you can easily understand how SAP works. Commitment Item These account numbers are essentially used for the allocation of reckons. Relationship of CI to GL is one to many which means One CI can cover more than one GL. e. g. there are so many Maintenance GL, however only one commitment item for these GLs can be choose for budget allocation. Sort Key It indicate s the layout rule for the Allocation field in the document line item.Assignment Field Assignment Field is a part of Line Item Display. The system notes the line items that have been posted to each customer account. You can presentation the line items on the line item display screen. You can specify the human body sequence of the line items by entering a key in the Sort key field in the account master record. This key specifies how the Assignment field is to be filled in the line items that are posted to the customer account. When you call up the line item display, the system sorts the line items according to the contents of this field.You can change the sort sequence in the line item display. e. g. 002 is the sort key when you make Customer or Vendor for NON PO establish in PTCL company commandment 1100. 002 sort key is configured to display the document number with fiscal year as assignment field. Special GL Indicator For all line items in customer or vendor accounts which are u pdated to an alternative reconciliation account in the general ledger, the particular(prenominal) G/L indicator determines which account is to be selected e. g. A is used for down payment of Vendors M is used for defaulters of Accounts Receivable.Account Type Key that specifies the accounting area to which an account belongs like asset accounts, customer accounts, vendor accounts, G/L accounts etc. The account type is required in addition to the account number in order to identify an account, since the same account number can be used for each account type . e. g. K for Vendors, D for Customer Document Type It classifies the accounting documents. It is stored in the document header. Attributes that control the entry of the document, or which are themselves noted in the document, are defined for each document type.Like KA is a vendor document. Posting key specifies the nature of account (e. g. GL account, Customer account, Vendor account etc. ) and controls the debit / credit indicat or of the amount e. g. 40 is used for GL Debit 50 is used for GL credits Stimulation means overview of accounting document after o Execution of all Substitutions o Execution of all validations o Creation of automatically created line Items Profit Center A profit center is a management-oriented organizational unit used for inseparable controlling purposes.Dividing your company up into profit centers allows you to analyze areas of responsibility and to denominate responsibility to decentralized units, thus treating them as companies within the company. Cost Center An organizational unit within a controlling area that represents a defined location of cost incurrence. Its a part of a company seen as a separate area of responsibility, location or cost-accounting entity. Place at which costs occur. Company Code The company code is an organizational unit within financial accounting, e. g. 1100 for PTCL & 1300 for UFONE (PTML).Account Group The Account Group to which your vendor/ Customer / Employee will belongs to. Control key in the Bank Details Represent nature of account (i. e. Current a/c, economic system a/c, etc. ) Withholding Tax Type This indicator is used to classify the different types of withholding tax revenue eg. Z2 is used payment for tote up of Goods Z3 is used for contractors Z4 is used for payment of services W/tax Code Codes determine is the various percentage rates for the withholding tax type. liable(p) If you set this indicator, you tell the system that the vendor is subject to withholding tax for this withholding tax type.If the involved party vendor or employee is exempted from withholding tax so provide details of exemption. e. g. 3. 5%, 6% etc commendation Document Number The reference document number can contain the document number of the business partner, but a different entry can also be made. The reference document number can be used as search criteria for document display/change. percentage point Account transaction figures are u pdated per period within the fiscal year . A maximum of 16 periods can be updated. You define how a fiscal year is divided into periods per company code e. g. period means March and 1 period means July. Document Header text This text contains explanations or notes which apply to the document as a whole, that is, not only for certain line items. Findings and Recommendations in Processes In PTCL there is a room for improvement. Besides, this is one of the best organization w. r. t. its environment, culture and SOPs. In my opinion, meetings with the lower staff should also be done at least once in a month in a palsy-walsy manner. Managers, Senior Managers, & General Manager should ask their working problems in their individual epartment and should also ask for the solutions. E mail in PTCL taken the institutionalize of meetings. In my point of view, email of an officer should be considered as veritable proof for getting required authorization for any task. Coordination and Comm unication amid departments are excellent. One department must support another department irrespective of their own interest. Organization Interest must be the beginning priority while working. I believe that Job rotations should be done to improve skills of employees in all related departments. I found employees are very loyal and dedicated towards their assigned work. Extracurricular activities arrange by PTCL like Painting Exhibition is another good and relaxing natural action for employees and their families. In my opinion, such occasion must be held at least once a year. SPECIAL THANKS I am indebted(predicate) and thankful to the PTCL which gave me a chance to learn about the business processes of accounts and finance wing and also thankful to the staff especially to the Manager ERP Finance and Financial Analyst D.B & I. S under whom I was attached with. They are all professional and cooperative and guided me that how to work in a professional environment. picpicpic S. E. V. P Finance/ CFO President / Vice President E. V. P Account Services G. M Accounts G. M ERP Finance S. M Accounts D. B & I. S Financial Analyst ERP Accounts Financial Analyst D. B & I. S Manager ERP Finance Accounts 21