Difference between revisions of "DATA MAINTENANCE"

From SPGC Document Wiki
Jump to: navigation, search
 
(96 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
 +
== Headline text ==
 
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Manual | System Manual]] > [[SPGC_EPAYROLL | SPGC EPAYROLL]]   
 
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Manual | System Manual]] > [[SPGC_EPAYROLL | SPGC EPAYROLL]]   
  
 
'''Navigating to Data Maintenance'''
 
'''Navigating to Data Maintenance'''
  
  '''*''' In the SPGC ePayroll Main page, there on the Nav. bar you will see Data Maintenance, click it.
+
  I.'''COMPANY'''
 
+
 
+
[[File:Datamainte.png|400px|center]]
+
 
+
  '''*'''After clicking it, you will be redirected to, Data Maintenance - Manage Master Data.
+
 
+
[[File:Datamainte1.png|400px|center]]
+
 
+
  '''*''' 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'''.
+
 
+
[[File:11111.jpg|400px|center]]
+
 
+
  * 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.
+
 
+
[[File:2222.jpg|500px|center]]
+
 
+
 
+
[[File:Compent.png|500px|center]]
+
 
+
 
+
  * 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.
+
 
+
[[File:4444.jpg|500px|center]]
+
 
+
[[File:Compent1.png|500px|center]]
+
 
+
 
+
 
+
=='''Pay Period'''==
+
 
+
  * In the '''Data Maintenance''' it includes the '''Pay Period''', When the user clicks it, the '''Payroll Period Setup''' will display.
+
 
+
[[File:1asd.jpg|500px|center]]
+
 
+
  * 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.
+
 
+
[[File:2asd.jpg|500px|center]]
+
 
+
    * 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.
+
 
+
[[File:5asd.jpg|500px|center]]
+
 
+
    * 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.
+
 
+
[[File:6asd.jpg|500px|center]]
+
 
+
  * 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.
+
 
+
[[File:Payr.png|400px|center]]
+
 
+
 
+
[[File:4asd.jpg|300px|center]]
+
 
+
*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.
+
 
+
 
+
[[File:Payr1.png|400px|center]]
+
 
+
 
+
[[File:Payr2.png|400px|center]]
+
 
+
*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.
+
 
+
 
+
[[File:Payr3.png|400px|center]]
+
 
+
 
+
 
+
 
+
+
 
+
 
+
=='''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.
+
 
+
[[File:9asd.jpg|500px|center]]
+
 
+
  '''*''' When the user selects any company it will display below SDSA codes, Description, Add/ded, Old Gl code, New Gl code available on that certain Company.
+
 
+
[[File:Sdsaa.png|500px|center]]
+
 
+
  '''*''' When the user clicks ('''+''') button,  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.
+
 
+
[[File:11asd.jpg|500px|center]]
+
 
+
[[File:13asd.jpg|300px|center]]
+
 
+
 
+
 
+
=='''Department'''==
+
 
+
  '''*''' Under the '''Data Maintenance''' is the '''Department'''. The user can select a company in the combo box, When selected the desired '''Company''', that certain Company's Dept./Cost Center Codes and Names will appear. 
+
 
+
[[File:Deptt.png|500px|center]]
+
 
+
'''*'''For specific searches, The '''User''' may use the search box to search '''Dept/Cost Center''' of that company. The user may also Press the '''Reset''' button to go back to the main page of the '''Department''' and reset the searches to none.
+
 
+
[[File:14asd.jpg|500px|center]]
+
 
+
  '''*''' When the users 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'''.
+
 
+
[[File:15asd.jpg|500px|center]]
+
 
+
 
+
[[File:16asd.jpg|500px|center]]
+
 
+
 
+
  '''*''' 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.
+
 
+
 
+
[[File:Deptt1.png|500px|center]]
+
 
+
 
+
=='''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.
+
 
+
[[File:19asd.JPG|500px|center]]
+
 
+
  '''*''' 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'''.
+
 
+
[[File:20asd.JPG|500px|center]]
+
 
+
 
+
[[File:21asd.JPG|500px|center]]
+
 
+
  The '''Blank table''' will also display. The user should input a data on the entry then it will automatically save the changes when the user clicks the save button.
+
 
+
[[File:24asd.JPG|500px|center]]
+
 
+
  '''*''' When the user click ('''=>]''') the entry that the user selected will display. Then the user can edit the data on the entry.
+
 
+
[[File:22asd.JPG|500px|center]]
+
 
+
 
+
[[File:23asd.JPG|500px|center]]
+
 
+
  '''*''' 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.
+
 
+
[[File:25asd.JPG|500px|center]]
+
 
+
 
+
=='''Holiday'''==
+
 
+
  '''*''' Under the '''Data Maintenance''' is the '''Holiday.''' The user can use the search box to search Holiday. Then the '''Pages Combo Box''' for number of pages. And the '''reset''' button to go back to main page of holiday.
+
 
+
[[File:26asd.JPG|500px|center]]
+
 
+
  '''*''' 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.
+
 
+
[[File:27asd.JPG|500px|center]]
+
 
+
 
+
[[File:28asd.JPG|500px|center]]
+
 
+
  '''*''' 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.
+
 
+
[[File:29asd.JPG|500px|center]]
+
 
+
 
+
[[File:30asd.JPG|500px|center]]
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
           
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
 
+
=='''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'''.
+
 
+
[[File:31asd.JPG|500px|center]]
+
 
+
  '''*''' 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'''.
+
 
+
[[File:32asd.JPG|500px|center]]
+
 
+
  '''*''' 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.
+
 
+
[[File:33asd.JPG|500px|center]]
+
 
+
 
+
[[File:34asd.JPG|500px|center]]
+
 
+
  
  '''*''' You may also delete SDSA code by pressing the SDSA code Text box, and erasing the SDSA Code, then press Save now the entire row will be deleted.
 
  
 +
[[File:c1.png|400px|center]]
 +
<center>  '''Figure 1.0''' </center>
  
[[File:Sapp.png|500px|center]]
+
[[File:c2.png|400px|center]]
 +
<center>  '''Figure 1.1''' </center>
  
[[File:Sapp1.png|500px|center]]
+
1.'''Search Field''': Through this field, users can search employees on the system by the use of company’s name.
 +
2.'''Reset''': To reset the history you search.
 +
3.'''Print''': To print the important information.
 +
4.'''Add''': Allows you to add company entry.
 +
5.'''Edit''': To edit the company entry.
  
[[File:Sapp2.png|500px|center]]
+
<center>Once you click '''Add Button''', it will show table company entry. You may see figure 2.0 for your reference.</center>
  
  '''Tagging'''
 
  
  '''*''' In the GL Code Breakdown Param., you will see a Tagging column, in that column, you will see a combo box containing; Breakdown per GL, Breakdown per Cost Center, Breakdown per Employee.
 
  
[[File:Sapp3.png|500px|center]]
 
  
  '''*'''In one GL Code, contains several SDSA Codes, and in one SDSA code contains several Employees transacted with that code.
+
[[File:c4.png|400px|center]]
 +
<center> '''Figure 1.2''' </center>
  
[[File:Tagg.png|500px|center]]
+
• '''Company Code''' – In this module the user can select the Company code entry to complete the process.
 +
• '''Name''' – In this module the user can select the Name entry to complete the process.
 +
• '''SSS''' – In this module the user can select the SSS Number entry to complete the process.
 +
• '''TIN No''' – In this module the user can select the TIN Number entry to complete the process.
 +
• '''PhilHealth No'''  – In this module the user can select the PhilHealth Number entry to complete the process.
 +
• '''HDMF No''' – In this module the user can select the HDMF Number entry to complete the process.
 +
• '''Address'''  – In this module the user can select the Address entry to complete the process.
 +
• '''Tel. No''' – In this module the user can select the Tel. number entry to complete the process.
 +
• '''ZIP Code'''– In this module the user can select the ZIP code entry to complete the process.
 +
• '''Company Signatory'''–  This module is the signature of Company to complete the process.
 +
• '''Position'''– In this module the user can select the Position entry to complete the process.
  
  '''*'''An '''SDSA code''' represents a Product to be transacted from, ex.( SDSA code is "1234" - RICE), which means when an employee transacted with SDSA code = "1234", that employee bought rice. That is why in one SDSA code it could contain several employees, because several employees bought rice.
+
  <center>Before you '''save''', make sure to fill out all the needed fields correctly.</center>
  
'''*'''Now in one '''GL code''', contains several SDSA Codes.
 
  
[[File:Tagg1.png|500px|center]]
 
  
'''*'''Now in one '''Company''' Contains different GL Codes.
 
  
  '''*'''Now that you know the Structure of codes, you will now proceed with the function of Breakdown per Gl, Breakdown per Cost Center, Breakdown per Employee.
+
  II.'''PAYROLL PERIOD'''
 +
[[File:c3.png|500px|center]]
 +
<center>  '''Figure 2.0''' </center>
  
  
[[File:Tagg2.png|500px|center]]
+
1.'''Pay Class''': In this module you can select Weekly, Monthly and VIP depends to your Pay class.
 +
2.'''Company''': In this module you can select the company name.
  
'''Using Breakdown per GL'''
+
<center>Once selecting the module, it will show table pay period. You may see figure 2.1 for your reference.</center>
  
  '''*'''In the '''GL code Breakdown Param., you will see the different GL codes of the Company of your choice, now look for the desired GL code, now that you have found the GL code, look at the Tagging column of that GL code, You will now see a Combo box press that and you will see choices that are: Breakdown per GL, Breakdown per Cost Center, Breakdown per Employee.
 
  
[[File:Tagg3.png|500px|center]]
+
[[File:c6.png|500px|center]]
 +
<center>  '''Figure 2.1''' </center>
  
  '''*'''Pick Breakdown per GL, now that will total out all the amount contained in that GL code. (Remember that in one GL code contains several SDSA code, and in one SDSA code, contains several employees who transacted with that SDSA code.)
+
1.'''Search Field''': Through this field, users can search Payroll Period on the system by the use of Pay Class and Company’s name.
 +
2.'''Add''': Allows you to add Payroll Period entry.
 +
3.'''Edit''': To edit the Payroll Period entry.
  
 
 
  
 +
[[File:pic6.png|500px|center]]
 +
<center>  '''Figure 2.2''' </center>
  
 +
•'''Month''' – In this module the user can select the Month of entry to complete the process.
 +
•'''Period''' – In this module the user can select the period entry to complete the process.
 +
•'''No. of days''' – In this module the user can select the number of days to complete the process.
 +
•'''Period From''' – In this module the user can select the start of the pay period.
 +
•'''Period To''' – In this module the user can select the end of the pay period.
 +
•'''Assumed To''' – In this module the user can select the assumed of date of pay period.
 +
•'''Remote Cut Off from''' - This module is the start cut off of the Payroll offsite.
 +
•'''Remote Cut Off to''' - This module is the end of cut off of the Payroll offsite.
  
  
 +
1.Before you '''save''', make sure to fill out all the needed fields correctly.
 +
2.If you check the '''posted''' below, the Payroll is not allowed to modify and if you want to modify the Payroll uncheck Posted below to '''modify''' your Payroll and press save button.
  
  
 +
<center>Note:  '''You can only modify those Payroll Period which is not posted yet'''.</center>
  
 +
[[File:pic7.png|500px|center]]
 +
<center>  '''Figure 2.3''' </center>
 +
1.You can only''' modify''' those Payroll Period which is not posted yet.
 +
2.If you want to '''modify''' the company entries just click '''edit'''.
  
  
 +
III.'''SDSA'''
 +
[[File:c7.png|500px|center]]
 +
<center>  '''Figure 3.0''' </center>
  
 +
1.'''Search Field''': Through this field, users can search employees on the system by the use of company’s name or SDSA
 +
2.'''Reset''': To reset the history you search.
 +
3.'''Print''': To print the important information.
  
 +
<center>Once you select company name and SDSA, it will show the information. You may see figure 3.1 for your reference.</center>
  
 +
[[File:c8.png|500px|center]]
 +
<center>  '''Figure 3.1''' </center>
  
  '''Branch Code'''
+
1.This form will show the information about the SDSA.
  
  '''*''' 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'''.
+
  IV.'''DEPARTMENT'''
  
[[File:35asd.JPG|500px|center]]
+
[[File:c9.png|500px|center]]
 +
<center>  '''Figure 4.0''' </center>
  
  '''*'''  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.
+
1.'''Search Field''': Through this field, users can search employees on the system by the use of company’s name or Cost Center.
 +
  2.'''Reset''': To reset the history you search.
 +
3.'''Print''': To print the important information.
  
 +
<center>Once selecting the company name, it will show table information. You may see figure 4.1 for your reference.</center>
  
[[File:36asd.JPG|500px|center]]
+
[[File:c10.png|500px|center]]
 +
<center>  '''Figure 4.1''' </center>
  
 +
1.'''Add''': Allows you to add Department Cost Center entry.
 +
2.'''Edit''': To edit the Department Cost Center entry.
  
[[File:37asd.JPG|500px|center]]
+
[[File:c11.png|500px|center]]
 +
<center>  '''Figure 4.2''' </center>
  
  '''*''' 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.
+
'''Department Cost Cente'''r – In this module the user can select the Dept. Cost Center to complete the process.
 +
'''Name''' – this module the user can select the Name of  department to complete the process.
  
  
[[File:38asd.JPG|500px|center]]
+
<center>Note: After fill up Department, if you check the Active below the department will be active. And if you uncheck the Active below the department will be inactive. And Press the save button.</center>
  
 +
1.Before you '''save''', make sure to fill out all the needed fields correctly.
 +
2.If you want to '''modify''' the Department Cost Center entries just click edit.  And check the Active button if you want to active this entry.
  
[[File:39asd.JPG|500px|center]]
+
V.'''WORK SCHEDULE'''
  
  '''Payroll Table'''
+
[[File:c12.png|500px|center]]
 +
<center>  '''Figure 5.0''' </center>
  
  '''*''' Under the Data maintenance is the Payroll Table, which includes the Pagibig Table, SSS table and Tax Table.
+
1.'''Search Field''': Through this field, users can search Work Schedule on the system by the use of Work Schedule.
 +
2.'''Reset''': To reset the history you search.
 +
3.'''Print''': To print the important information.
 +
4.'''Add''': Allows you to add Work Schedule entry.
 +
5.'''Edit''': To edit the Work Schedule entry.
  
[[File:40asd.JPG|500px|center]]
 
  
  '''*''' 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.
+
<center>Once you click Add Button, it will show table Work Schedule entry. You may see figure 5.1 for your reference.</center>
  
[[File:41asd.JPG|500px|center]]
+
[[File:pic14.png|500px|center]]
 +
<center>  '''Figure 5.1''' </center>
  
 +
<center>Note * '''In regular schedule''' will be start in 8am to 11am and then in PM in is 12pm to 6pm.
 +
'''Full night schedule''' will be start in 10pm to 2am and then 3am to 6am.
 +
'''AM in schedule fall on Night Shift''' example is when your schedule will fall in night shift.
 +
'''PM out schedule fall on night shift''' example is when your schedule will fall in before night shift.
 +
If you check the checkbox button, example in AM out you will out all day in AM out.</center>
 +
1.Before you '''save''', make sure to fill out all the needed fields correctly.
 +
2.If you want to modify the Work Schedule entry just click edit.
  
[[File:42asd.JPG|500px|center]]
 
  
  '''*''' 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.
+
  VI.'''HOLIDAY'''
  
 +
[[File:c13.png|500px|center]]
 +
<center>  '''Figure 6.0''' </center>
  
[[File:43asd.JPG|500px|center]]
+
1.'''Search Field''': Through this field, users can search Holiday Master on the system by the use of Holiday.
 +
2.'''Reset''': To reset the history you search.
 +
3.'''Print''': To print the important information.
 +
4.'''Add''': Allows you to add Holiday Master entry.
 +
5.'''Edit''': To edit the Holiday Master entry.
  
  
[[File:44asd.JPG|500px|center]]
+
<center>Once you click Add Button, it will show table Holiday Master entry. You may see figure 6.1 for your reference.</center>
  
+
[[File:c14.png|500px|center]]
  '''*''' 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.
+
  <center> '''Figure 6.1''' </center>
  
[[File:46asd.JPG|500px|center]]
+
•'''Holi Date''' – In this module the user can select the Holiday Date to complete the process.
 +
•'''Type''' – In this module the user can select the type of holiday if Regular holiday, Legal holiday, Special holiday or Area holiday.
 +
•'''Location''' – In this module the user can select the location to complete the process.
  
  
[[File:45asd.JPG|500px|center]]
 
  
 +
1.Before you '''save''', make sure to fill out all the needed fields correctly.
 +
2.If you want to modify the Work Schedule entry just click '''edit'''.
  
[[File:47asd.JPG|500px|center]]
+
  VII.'''SAP GL Proc Parameters'''
   
+
+
'''*''' 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 Rang'''e, '''Salary Credit''', '''Employer Contribution''', '''Employer Medicare''', '''Employer EC Contribution''', '''Employee Contribution''' and '''Employee Medicare'''. Then the user can now click the '''Save''' button.
+
  
[[File:48asd.JPG|500px|center]]
+
[[File:c15.png|500px|center]]
 +
<center>  '''Figure 7.0''' </center>
  
 +
1.Select the Company you want to View.
  
[[File:49asd.JPG|500px|center]]
+
<center>Once you select the Company you want to view, it will show GL Code Breakdown Parameters and SDSA Breakdown Parameters. You may see figure 2.0 for your reference.</center>
  
 +
[[File:pic18.png|500px|center]]
 +
<center>  '''Figure 7.1''' </center>
 +
1.After you choose a company this data will show. If you want to modify the GL Code Breakdown just click in the left side of form and choose. And if you want to modify the SDSA Breakdown just click the add icon in the right side.
 +
2.After this data press the save button bellow.
 +
[[File:pic19.png|500px|center]]
 +
<center>  '''Figure 7.2''' </center>
  
  '''*''' 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 '''Save'''the record.
 
  
[[File:50asd.jpg|500px|center]]
+
VIII.'''BRANCH CODE'''
 +
<center>Branch Code allows you to add Branch and Modify only</center>
 +
[[File:c16.png|500px|center]]
 +
<center>  '''Figure 8.0''' </center>
  
 +
1.'''Search Field''': Through this field, users can search Holiday Master on the system by the use of Holiday.
 +
2.'''Reset''': To reset the history you search.
 +
3.'''Print''': To print the important information.
 +
4.'''Add''': Allows you to add Holiday Master entry.
 +
5.'''Edit''': To edit the Holiday Master entry.
  
[[File:51asd.jpg|500px|center]]
 
  
 +
<center>Once you click '''Add Button''', it will show table Holiday Master  entry. You may see figure 8.1 for your reference.</center>
  
[[File:52asd.jpg|500px|center]]
 
 
  
  '''*''' 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.
+
[[File:pic21.png|500px|center]]
 +
<center> '''Figure 8.1''' </center>
 +
'''Branch Code''' – In this module the user can select the branch code to complete the process.
 +
'''Branch Name''' – In this module the user can select the branch name to complete the process.
  
[[File:54asd.JPG|500px|center]]
 
  
 +
1.Before you '''save''', make sure to fill out all the needed fields correctly.
 +
2.If you want to '''modify''' the Branch entry just click edit.
  
[[File:55asd.JPG|500px|center]]
+
IX.'''PAYROLL TABLE'''
 +
<center>In this Payroll Table you can add''' Pag ibig ,SSS''' and '''Tax''' Entries and it’s process is the same. In the Tax table there are two types of Tax , Tax Additional Rate and Annual Tax Table. It is the same Process of Pag Ibig Entry and SSS you can Add, Edit and Search.</center>
 +
[[File:c17.png|500px|center]]
 +
<center>  '''Figure 9.0''' </center>
  
 +
1.'''Search Field''': Through this field, users can search the Pag ibig ,SSS and Tax on the system by the use of the Pag ibig ,SSS and Tax entries.
 +
2.'''Reset''': To reset the history you search.
 +
3.'''Print''': To print the important information.
 +
4.'''Add''': Allows you to add Pag ibig ,SSS and Tax Entries.
 +
5.'''Edit''': To edit the Pag ibig ,SSS and Tax Entries.
  
  '''*''' 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.
 
  
[[File:57asd.JPG|500px|center]]
+
<center>Once you click Add Button, it will show the table. You may see figure 9.1 for your reference.</center>
  
  
[[File:56asd.JPG|500px|center]]
+
<center>This table is example of how to add Pag Ibig entry. In the SSS and Tax entry it is the same process of Pag Ibig entry</center>
  
  
[[File:53asd.JPG|500px|center]]
+
[[File:c18.png|500px|center]]
   
+
  <center> '''Figure 9.1''' </center>
  '''*''' 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'''.
+
  
[[File:58asd.JPG|500px|center]]
+
•'''Lower Range''' – This module contains to set the lower range of pag ibig entry.
 +
•'''Upper Range''' – This module contains to set the upper range of pag ibig entry.
 +
•'''Employee Percentage''' - This module contains to set the percentage of employee.
 +
•'''Employer Percentage''' – This module contains to set the percentage of employer.
 +
•'''Employee Fixed Contribution''' – This module contains to set the fixed Contribution of employee.
 +
•'''Employer Fixed Contribution''' – This module contains to set the fixed Contribution of employer.
  
 +
1.Before you save, make sure to fill out all the needed fields correctly.
 +
2.If you want to modify the data inputted just click edit.
  
[[File:59asd.JPG|500px|center]]
 
  
  '''*''' 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.
+
X.'''WAGE ORDER'''
 +
<center>In this table you can '''search, add''' and '''edit''' the '''Region, Region Area, Class''' and '''Wage Order''' of employee. And it’s process is the same.</center>
 +
[[File:c19.png|500px|center]]
 +
<center>  '''Figure 11.0''' </center>
  
[[File:60asd.JPG|500px|center]]
+
1.'''Search Field''': Through this field, users can search Region, Region Area, Class and Wage Order.
 +
2.'''Reset''': To reset the history you search.
 +
3.'''Print''': To print the important information.
 +
4.'''Add''': Allows you to Region, Region Area, Class and Wage Order entries.
 +
5.'''Edit''': To edit the Region, Region Area, Class and Wage Order entries.
  
 +
<center>Once you click Add Button, it will show the example table of Region Entry. You may see figure 11.1 for your reference.</center>
  
[[File:61asd.JPG|500px|center]]
 
  
 +
<center>This table is example of how to add Region entry. In the Region Area, Class and Wage Order.  It is the same Process of Region entry.</center>
  
== '''Reference''' ==
+
[[File:c20.png|500px|center]]
[[Media:Data_Maintenance.doc|Data_Maintenance document]]
+
<center>  '''Figure 11.1''' </center>
  
 +
•'''Region Code''' – In this module the user must select the Region Code to complete the process.
 +
•'''Region Name''' – In this module the user must select the Region Name to complete the process.
  
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Manual | System Manual]] > [[SPGC_EPAYROLL | SPGC EPAYROLL]]
+
I.Before you save, make sure to fill out all the needed fields correctly.
 +
II.If you want to modify the data inputted just click edit.

Latest revision as of 15:02, 18 February 2019

Headline text

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

Navigating to Data Maintenance

I.COMPANY


C1.png
Figure 1.0
C2.png
Figure 1.1
1.Search Field: Through this field, users can search employees on the system by the use of company’s name.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add company entry.
5.Edit: To edit the company entry.
Once you click Add Button, it will show table company entry. You may see figure 2.0 for your reference.



C4.png
Figure 1.2
Company Code – In this module the user can select the Company code entry to complete the process.
• Name – In this module the user can select the Name entry to complete the process.
• SSS – In this module the user can select the SSS Number entry to complete the process.
• TIN No – In this module the user can select the TIN Number entry to complete the process.
• PhilHealth No  – In this module the user can select the PhilHealth Number entry to complete the process.
• HDMF No – In this module the user can select the HDMF Number entry to complete the process.
• Address  – In this module the user can select the Address entry to complete the process.
• Tel. No – In this module the user can select the Tel. number entry to complete the process.
• ZIP Code– In this module the user can select the ZIP code entry to complete the process.
• Company Signatory–  This module is the signature of Company to complete the process.
• Position– In this module the user can select the Position entry to complete the process.
Before you save, make sure to fill out all the needed fields correctly.



II.PAYROLL PERIOD
C3.png
Figure 2.0


1.Pay Class: In this module you can select Weekly, Monthly and VIP depends to your Pay class.
2.Company: In this module you can select the company name.
Once selecting the module, it will show table pay period. You may see figure 2.1 for your reference.


C6.png
Figure 2.1
1.Search Field: Through this field, users can search Payroll Period on the system by the use of Pay Class and Company’s name.
2.Add: Allows you to add Payroll Period entry.
3.Edit: To edit the Payroll Period entry.


Pic6.png
Figure 2.2
Month – In this module the user can select the Month of entry to complete the process.
•Period – In this module the user can select the period entry to complete the process.
•No. of days – In this module the user can select the number of days to complete the process.
•Period From – In this module the user can select the start of the pay period.
•Period To – In this module the user can select the end of the pay period.
•Assumed To – In this module the user can select the assumed of date of pay period.
•Remote Cut Off from - This module is the start cut off of the Payroll offsite.
•Remote Cut Off to - This module is the end of cut off of the Payroll offsite.


1.Before you save, make sure to fill out all the needed fields correctly.
2.If you check the posted below, the Payroll is not allowed to modify and if you want to modify the Payroll uncheck Posted below to modify your Payroll and press save button.


Note: You can only modify those Payroll Period which is not posted yet.
Pic7.png
Figure 2.3
1.You can only modify those Payroll Period which is not posted yet.
2.If you want to modify the company entries just click edit.


III.SDSA
C7.png
Figure 3.0
1.Search Field: Through this field, users can search employees on the system by the use of company’s name or SDSA
2.Reset: To reset the history you search.
3.Print: To print the important information.
Once you select company name and SDSA, it will show the information. You may see figure 3.1 for your reference.
C8.png
Figure 3.1
1.This form will show the information about the SDSA.
IV.DEPARTMENT
C9.png
Figure 4.0
1.Search Field: Through this field, users can search employees on the system by the use of company’s name or Cost Center.
2.Reset: To reset the history you search.
3.Print: To print the important information.
Once selecting the company name, it will show table information. You may see figure 4.1 for your reference.
C10.png
Figure 4.1
1.Add: Allows you to add Department Cost Center entry.
2.Edit: To edit the Department Cost Center entry.
C11.png
Figure 4.2
Department Cost Center – In this module the user can select the Dept. Cost Center to complete the process.
•Name – this module the user can select the Name of  department to complete the process.


Note: After fill up Department, if you check the Active below the department will be active. And if you uncheck the Active below the department will be inactive. And Press the save button.
1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the Department Cost Center entries just click edit.  And check the Active button if you want to active this entry.
V.WORK SCHEDULE
C12.png
Figure 5.0
1.Search Field: Through this field, users can search Work Schedule on the system by the use of Work Schedule.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Work Schedule entry.
5.Edit: To edit the Work Schedule entry.


Once you click Add Button, it will show table Work Schedule entry. You may see figure 5.1 for your reference.
Pic14.png
Figure 5.1
Note * In regular schedule will be start in 8am to 11am and then in PM in is 12pm to 6pm.

Full night schedule will be start in 10pm to 2am and then 3am to 6am. AM in schedule fall on Night Shift example is when your schedule will fall in night shift. PM out schedule fall on night shift example is when your schedule will fall in before night shift.

If you check the checkbox button, example in AM out you will out all day in AM out.
1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the Work Schedule entry just click edit.


VI.HOLIDAY
C13.png
Figure 6.0
1.Search Field: Through this field, users can search Holiday Master on the system by the use of Holiday.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Holiday Master entry.
5.Edit: To edit the Holiday Master entry.


Once you click Add Button, it will show table Holiday Master entry. You may see figure 6.1 for your reference.
C14.png
Figure 6.1
Holi Date – In this module the user can select the Holiday Date to complete the process.
•Type – In this module the user can select the type of holiday if Regular holiday, Legal holiday, Special holiday or Area holiday.
•Location – In this module the user can select the location to complete the process.


1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the Work Schedule entry just click edit.
VII.SAP GL Proc Parameters
C15.png
Figure 7.0
1.Select the Company you want to View.
Once you select the Company you want to view, it will show GL Code Breakdown Parameters and SDSA Breakdown Parameters. You may see figure 2.0 for your reference.
Pic18.png
Figure 7.1
1.After you choose a company this data will show. If you want to modify the GL Code Breakdown just click in the left side of form and choose. And if you want to modify the SDSA Breakdown just click the add icon in the right side.
2.After this data press the save button bellow.
Pic19.png
Figure 7.2


VIII.BRANCH CODE
Branch Code allows you to add Branch and Modify only
C16.png
Figure 8.0
1.Search Field: Through this field, users can search Holiday Master on the system by the use of Holiday.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Holiday Master entry.
5.Edit: To edit the Holiday Master entry.


Once you click Add Button, it will show table Holiday Master entry. You may see figure 8.1 for your reference.


Pic21.png
Figure 8.1
Branch Code – In this module the user can select the branch code to complete the process.
•Branch Name – In this module the user can select the branch name to complete the process.


1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the Branch entry just click edit.
IX.PAYROLL TABLE
In this Payroll Table you can add Pag ibig ,SSS and Tax Entries and it’s process is the same. In the Tax table there are two types of Tax , Tax Additional Rate and Annual Tax Table. It is the same Process of Pag Ibig Entry and SSS you can Add, Edit and Search.
C17.png
Figure 9.0
1.Search Field: Through this field, users can search the Pag ibig ,SSS and Tax on the system by the use of the Pag ibig ,SSS and Tax entries.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to add Pag ibig ,SSS and Tax Entries.
5.Edit: To edit the Pag ibig ,SSS and Tax Entries.


Once you click Add Button, it will show the table. You may see figure 9.1 for your reference.


This table is example of how to add Pag Ibig entry. In the SSS and Tax entry it is the same process of Pag Ibig entry


C18.png
Figure 9.1
Lower Range – This module contains to set the lower range of pag ibig entry.
•Upper Range – This module contains to set the upper range of pag ibig entry.
•Employee Percentage - This module contains to set the percentage of employee.
•Employer Percentage – This module contains to set the percentage of employer.
•Employee Fixed Contribution – This module contains to set the fixed Contribution of employee.
•Employer Fixed Contribution – This module contains to set the fixed Contribution of employer.
1.Before you save, make sure to fill out all the needed fields correctly.
2.If you want to modify the data inputted just click edit.


X.WAGE ORDER
In this table you can search, add and edit the Region, Region Area, Class and Wage Order of employee. And it’s process is the same.
C19.png
Figure 11.0
1.Search Field: Through this field, users can search Region, Region Area, Class and Wage Order.
2.Reset: To reset the history you search.
3.Print: To print the important information.
4.Add: Allows you to Region, Region Area, Class and Wage Order entries.
5.Edit: To edit the Region, Region Area, Class and Wage Order entries.
Once you click Add Button, it will show the example table of Region Entry. You may see figure 11.1 for your reference.


This table is example of how to add Region entry. In the Region Area, Class and Wage Order. It is the same Process of Region entry.
C20.png
Figure 11.1
Region Code – In this module the user must select the Region Code to complete the process.
•Region Name – In this module the user must select the Region Name to complete the process.
I.Before you save, make sure to fill out all the needed fields correctly.
II.If you want to modify the data inputted just click edit.