Difference between revisions of "DATA MAINTENANCE"

Revision as of 09:01, 23 June 2017

Main Page > Application Development Team > System Manual > SPGC EPAYROLL

Navigating to Data Maintenance

  * In the SPGC ePayroll Main page, there on the Nav. bar you will see Data Maintenance, click it.

 *After clicking it, you will be redirected to, Data Maintenance - Manage Master Data.

* You will see there, in the data maintenance page, are the following: Company, Pay Period, SDSA, Department, Work Schedule, Holiday, SAP GL Proc Parameters, Branch Code, Payroll Table, Bank Advice, Employment Information, Wage Order. Now you may pick your desired option.

Company

* When the user click on the Data Maintenance which manage the master data. The first button is the company. In this section includes the Company Code and the Company Name. The user can use the combo box for Pages which is the number of pages on the list. Next the user can also use the search box to find the Company of their choice. And the Reset button to go back to the main page of the data maintenance.

 * When the user clicks (+), The Company Entry Form will display. Then the user can input data to the entry which includes the Company Code, Name, Company Signatory,Abbr., etc. This button is use to Add new Company in the system. After that the user can now click on the Save Button then the records will save.

 * When the user click (=>]), The Company Entry will display. It will display also the Company code, Name, Abbr, etc. of the company the user selected. Then the user can also edit it's information and after that the user can now click on the Save button.

Pay Period

 * In the Data Maintenance it includes the Pay Period, When the user clicks it, the Payroll Period Setup will display.

 * When the user selects Weekly in the Pay class and selects the desired Company,it will display the Payroll Pay Period, Weekly Pay class of that certain Company.

   * When the user selects Monthly in the Pay class and selects the desired Company,it will display the Payroll Pay Period, Monthly Pay class of that certain Company.

   * When the user selects VIP in the Pay class and selects the desired Company,it will display the Payroll Pay Period, VIP Pay class of that certain Company.

 * When the user click (+), the Payroll Period Entry will display which is the new entry for Payroll Period. The user must input the entry including the Month, Period, No. of Days, Period From, Period to, Assumed From, Assumed to, Remote Cut-off From and Remote Cut-off to.
 After the user input the data on the entry, the user can now click the save button then the new entry will be saved.

*When the remarks of that Payroll period is Open, you can press the button on the left side of the screen, and there an edit option will appear, press that to edit that certain Payroll Period.

*After Pressing Edit, you may now edit or update that certain Payroll Period, after editing just press the Save button to save the changes you have made.

SDSA

 * The SDSA is in the Data Maintenance, Where the user can select a company on the combo box, then the user can also use the search box to Search SDSA. And when the user click the reset button it will go back to the SDSA page.

 * When the user select any company it will display below that No data was found.

 * When the user click (+),  the SDSA Master Entry will display. Then the user must input a data in the entry including the SDSA Code, The Description, Add/Ded  which can be select as Addition and Deduction, OLDGL Code, New GL Code and Group Type which can be select as Company, SSS and PIB. Then after the user input a data on the entry, the user now can click the Save button then then the record will save.

 Department

 * Under the Data Maintenance is the Department. The user can select a company in the combo box, then the use the search box to search Cost Center. And the Reset button to go  back to the main page of the Department.

 * When the user click (+) button , The Department/Cost Center Master Entry will display. Then the user must input a data on the entry including the Dept./Cost Center Code and Name. Then the user can check the check box for active.

 * When the user click (=>])  the entry of the company that the user selected will display. And the user can edit the data of the company and the user can now click the Save button.

 Work Schedule

 * Under the Data Maintenance is the Work Schedule. The user can use the search box to Search Work Sched. Then the user can also use the pages combo box which is the pages within the list. Then the reset button to go back to the main page of the Work Schedule.

 * When the user click(+). The Work Sched/Shift Code Master Entry will display. The user should input a data on the entry including the WS Code Code, Description and Coffee Break Allo. Mins. Then the user can check the check box to Activate Coffee Break.

 The Blank table will also display. The user should input a data on the entry then it will automatically save the the user click the save button.

 * When the user click (=>]) the entry that the user selected will display. Then the user can edit the data on the entry.

 * The table with data will display and the user can edit the entry then the user can now click the save button then the records will save.

 Holiday

 * Under the Data Maintenance is the Holiday. The user can use the search box to search Holiday. Then the combo box for number of pages. And the reset button to go back to main page of holiday.

 * When the user click (+) The Holiday Master Entry will display. The user should input a data on each entry including the Holi Date, Type, Location and the Company. Then the user can now  click on the Save button then data input by the user will save.

 * When the user click (=>]) The entry that the user selected will display then the user can also edit the data on the entry, then after that the user can now click the save button.

 SAP GL Proc Parameters

 * Under the Data Maintenance is the SAP GL Proc.Parameters. The user can use  the seach box to search the company. Then the user ca click the reset button to go back to the main page of the SAP GL Proc. Parameters.

 * When the user select any company the GL Code Breakdown Parameters will display. It includes in the Table the GL Code, Description and Tagging which can be selected as Breakdown Per GL, Then Breakdown Per Cost Center and Breakdown Per Employee.

 * When the user click(+), It will display a textbox below the SDSA Code. Then the user should input SDSA Code and after that the user can now click the save button then the records will save.

 Branch Code

 * In Data Maintenance, Branch Code is included. The user can search location on the search box. The user can use the combo box  pages which is the number of pages within the data. And the reset button to go back to the main page of the Branch Code.

 *  When the user click (+) The Branch Entry will display which includes the Branch Code and Branch Name. The user should input data on the entry then after that the user can now click the save button.

 * When the user click (=>]) The entry that the user selected will display and the user can edit the data on the entry and the user can now click the save button to save the records.

 Payroll Table

 * Under the Data maintenance is the Payroll Table, which includes the Pagibig Table, SSS table and Tax Table.

 * When the user click the Pagibig Table, The data content will display. The user can search data on the search box. Then the reset button to go back to the main page of Payroll Period.

* When the user click (+) it will display the Pagibig Entry. The user should input a data to each entry including the Lower Range, Upper Range, Employee Percentage, Employer Percentage, Employee Fixed Contribution and Employer Fixed Contribution then after that the user can now click the Save button.

* When the user click (=>]) The Pagibig Entry of  the data selected by the user will display. Then the user can edit each entry and the user can now click the Save button.

* Under the Payroll Table is the SSS table. When the user click (+) it will display the SSS Entry which the user should input data including the Level Range, Upper Range, Salary Credit, Employer Contribution, Employer Medicare, Employer EC Contribution, Employee Contribution and Employee Medicare. Then the user can now click the Save button.

 * When the user click (=>]) the SSS entry that the user selected will display, then the user can editand after that the user now can click the save button to Savethe record.

* Under the Payroll Table is the Tax Table. Then it's classified as Tax Additional Rate and Annual Tax Table. When the user click (+) The Deduction and Rate Table will display. The user should input data including the Sequence Number, Additional Deduction, and Rate. After that the user can now click the Save button to save the data.

 * When the user click (=>]) the entry that the user selected will display. Then the user can edit some entry and the user can now click the Save button.

* Under the Tax Table is the Annual Tax Table. The difference of it between the Tax Additional, the Annual is classified as Lower Range, Upper Range, Additional Deduction and Tax Rate. When the user click the (+) same procedure as Tax Additional.

 * When the user click (=>]) The Entry that the user selected will display and same procedure as Tax Additional.. Then the user now can click the Save button.

Reference

Data_Maintenance document

Main Page > Application Development Team > System Manual > SPGC EPAYROLL