Difference between revisions of "DATA MAINTENANCE"

From SPGC Document Wiki
Jump to: navigation, search
 
(105 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Manual | System Manual]] > [[SPGC_EPAYROLL | SPGC EPAYROLL]]             
 
−
  '''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 within the company. Next the user can also use the search box button to find the '''Employee'''. And the '''Reset''' button to go back to the main page of the '''data maintenance'''.
+
== Headline text ==
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[System_Manual | System Manual]] > [[SPGC_EPAYROLL | SPGC EPAYROLL]] 
  
−
[[File:11111.jpg|400px|center]]
+
'''Navigating to Data Maintenance'''
  
−
  * When the user click ('''+'''), The '''company entry''' will display. Then the user can input data to the entry which includes the '''company code''', '''Name''' and the '''Abbr.''' This button is use to create new '''Data''' for the company. After that the user can now click on the '''save''' button then the records will save.
+
I.'''COMPANY'''
  
−
[[File:2222.jpg|500px|center]]
 
  
 +
[[File:c1.png|400px|center]]
 +
<center>  '''Figure 1.0''' </center>
  
−
[[File:3333.jpg|500px|center]]
+
[[File:c2.png|400px|center]]
 +
<center>  '''Figure 1.1''' </center>
  
−
  * When the user click ('''=>]'''), The '''Company Entry''' will display. It will display also the '''Company code''', '''Name''', '''Abbr''' 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.
+
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:4444.jpg|500px|center]]
+
<center>Once you click '''Add Button''', it will show table company entry. You may see figure 2.0 for your reference.</center>
  
  
−
[[File:5555.jpg|500px|center]]
 
  
−
  '''Pay Period'''
 
  
−
  * In the '''Data Maintenance''' it include the '''Pay Period''', When the user click it, the '''Payroll Period Setup''' will display.
+
[[File:c4.png|400px|center]]
 +
<center>  '''Figure 1.2''' </center>
  
−
[[File:1asd.jpg|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.
  
−
  * When the user select '''weekly''' in the '''pay class''' and select any '''company''',it will display automatically below that no records found.
+
<center>Before you '''save''', make sure to fill out all the needed fields correctly.</center>
  
−
[[File:2asd.jpg|500px|center]]
 
  
−
  * Then when the user select '''Monthly''' in the '''Pay Class''', and select any '''company''' it will display the information below .
 
  
−
[[File:5asd.jpg|500px|center]]
 
  
−
  * And when the user select '''VIP''' on the '''Pay Class''' and select any company it will display below that no records found. It's like in the weekly in the pay class option
+
II.'''PAYROLL PERIOD'''
 +
[[File:c3.png|500px|center]]
 +
<center>  '''Figure 2.0''' </center>
  
−
[[File:6asd.jpg|500px|center]]
 
  
−
  * When the user click ('''+'''), the '''Payroll Period Entry''' will display which is the new entry for '''Payroll'''. 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'''.
+
1.'''Pay Class''': In this module you can select Weekly, Monthly and VIP depends to your Pay class.
−
  After the user input the data on the entry, the user can now click the save button then the new entry will be saved.
+
2.'''Company''': In this module you can select the company name.
  
−
[[File:7asd.jpg|500px|center]]
+
<center>Once selecting the module, it will show table pay period. You may see figure 2.1 for your reference.</center>
  
−
[[File:4asd.jpg|300px|center]]
 
  
−
  '''SDSA'''
+
[[File:c6.png|500px|center]]
 +
<center>  '''Figure 2.1''' </center>
  
−
  * 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.
+
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:9asd.jpg|500px|center]]
 
  
−
  '''*''' When the user select any company it will display below that No data was found.
+
[[File:pic6.png|500px|center]]
 +
<center>  '''Figure 2.2''' </center>
  
−
[[File:10asd.jpg|500px|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.
  
−
  '''*''' 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.
 
  
−
[[File:11asd.jpg|500px|center]]
+
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.
  
−
[[File:13asd.jpg|300px|center]]
 
  
−
  '''Department'''
+
<center>Note:  '''You can only modify those Payroll Period which is not posted yet'''.</center>
  
−
  '''*''' 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'''.
+
[[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'''.
  
−
[[File:14asd.jpg|500px|center]]
 
  
−
  '''*''' 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'''.
+
III.'''SDSA'''
 +
[[File:c7.png|500px|center]]
 +
<center>  '''Figure 3.0''' </center>
  
−
[[File:15asd.jpg|500px|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.
  
−
  '''*''' 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.
+
<center>Once you select company name and SDSA, it will show the information. You may see figure 3.1 for your reference.</center>
  
−
[[File:16asd.jpg|500px|center]]
+
[[File:c8.png|500px|center]]
 +
<center>  '''Figure 3.1''' </center>
  
 +
1.This form will show the information about the SDSA.
  
−
  '''Work Schedule'''
+
IV.'''DEPARTMENT'''
  
−
  '''*''' 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:c9.png|500px|center]]
 +
<center>  '''Figure 4.0''' </center>
  
−
[[File:19asd.JPG|500px|center]]
+
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.
  
−
  '''*''' 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'''.
+
<center>Once selecting the company name, it will show table information. You may see figure 4.1 for your reference.</center>
  
−
[[File:20asd.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:21asd.JPG|500px|center]]
+
[[File:c11.png|500px|center]]
 +
<center>  '''Figure 4.2''' </center>
  
−
  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.
+
•'''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: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.
+
<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>
  
−
[[File:22asd.JPG|500px|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.
  
 +
V.'''WORK SCHEDULE'''
  
−
[[File:23asd.JPG|500px|center]]
+
[[File:c12.png|500px|center]]
 +
<center>  '''Figure 5.0''' </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.
+
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:25asd.JPG|500px|center]]
 
  
−
  '''Holiday'''
+
<center>Once you click Add Button, it will show table Work Schedule entry. You may see figure 5.1 for your reference.</center>
  
−
  '''*''' 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.
+
[[File:pic14.png|500px|center]]
 +
<center>  '''Figure 5.1''' </center>
  
−
[[File:26asd.JPG|500px|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.
  
−
  '''*''' 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]]
+
VI.'''HOLIDAY'''
  
 +
[[File:c13.png|500px|center]]
 +
<center>  '''Figure 6.0''' </center>
  
−
[[File:28asd.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.
  
−
  '''*''' 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]]
+
<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]]
 +
<center>  '''Figure 6.1''' </center>
  
−
[[File:30asd.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.
  
−
  '''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'''.
+
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:31asd.JPG|500px|center]]
+
VII.'''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'''.
+
[[File:c15.png|500px|center]]
 +
<center>  '''Figure 7.0''' </center>
  
−
[[File:32asd.JPG|500px|center]]
+
1.Select the Company you want to View.
  
−
  '''*''' 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.
+
<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:33asd.JPG|500px|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>
  
  
−
[[File:34asd.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>
  
−
  '''Branch Code'''
+
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.
  
−
  '''*''' 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'''.
 
  
−
[[File:35asd.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>
  
−
  '''*'''  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.
 
  
 +
[[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:36asd.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:37asd.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>
  
−
  '''*''' 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.
+
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.
  
  
−
[[File:38asd.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:39asd.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>
  
−
  '''Payroll Table'''
 
  
−
  '''*''' Under the Data maintenance is the Payroll Table, which includes the Pagibig Table, SSS table and Tax Table.
+
[[File:c18.png|500px|center]]
 +
<center>  '''Figure 9.1''' </center>
  
−
[[File:40asd.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.
  
−
  '''*''' 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.
+
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:41asd.JPG|500px|center]]
 
  
 +
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:42asd.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.
  
−
'''*''' 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.
+
<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:43asd.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>
  
 +
[[File:c20.png|500px|center]]
 +
<center>  '''Figure 11.1''' </center>
  
−
[[File:44asd.JPG|500px|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.
  
−
   
+
  I.Before you save, make sure to fill out all the needed fields correctly.
−
'''*''' 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.
+
  II.If you want to modify the data inputted just click edit.
−
 
+
−
[[File:46asd.JPG|500px|center]]
+
−
 
+
−
 
+
−
[[File:45asd.JPG|500px|center]]
+
−
 
+
−
 
+
−
[[File:47asd.JPG|500px|center]]
+
−
+
−
+
−
'''*''' 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:49asd.JPG|500px|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]]
+
−
 
+
−
 
+
−
[[File:51asd.jpg|500px|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:54asd.JPG|500px|center]]
+
−
 
+
−
 
+
−
[[File:55asd.JPG|500px|center]]
+
−
 
+
−
 
+
−
  '''*''' 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]]
+
−
 
+
−
 
+
−
[[File:56asd.JPG|500px|center]]
+
−
 
+
−
 
+
−
[[File:53asd.JPG|500px|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]]
+
−
 
+
−
 
+
−
[[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.
+
−
 
+
−
[[File:60asd.JPG|500px|center]]
+
−
 
+
−
 
+
−
[[File:61asd.JPG|500px|center]]
+
−
 
+
−
 
+
−
== '''Reference''' ==
+
−
[[Media:Data_Maintenance.doc|Data_Maintenance document]]
+

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.
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=DATA_MAINTENANCE&oldid=6443"