Service and Maintenance (VA075_)

1. Inactive two tabs Work log and Requisition because these are shown in tab panels so no need to show as tabs. 

Window : Maintenance work order 

Tab : Work log and Requisition 

Note :  Inactive two tabs Work log  and requisition by script and set screen width 65 

1. Functional Location, Utility Window needs to be hide from Menu folder.

Window: Functional Location, Utility

Note: Hided through script from Menu

2. Description character limit should be up to 2000 characters.

Window: Priority Level, Maintenance group, Maintenance activity, Service type, Equipment application, Equipment category, Equipment class, Equipment rating, Counter, Skill, Resource Type, Resource, Service Request, Maintenance Work Order, Maintenance Work Schedule.

Tab: Priority Level, Maintenance group, Maintenance activity, Service type, Equipment application, Equipment category, Equipment class, Equipment rating, Counter, Skill, Resource Type, Resource, Service Request, Work Order, Maintenance Work Schedule.

Table: VA075_Priority ,VA075_MaintenanceGroup,VA075_MaintenanceActivity, VA075_ServiceTypes, VA075_EquipmentApplication,VA075_EquipmentCategory, VA075_EquipmentClass, VA075_EquipmentRating, VA075_Counter, S_ResourceType, S_Resource, VA075_ServiceRequest, VA075_WorkOrder, VA075_WorkSchedule

Field: Description

Note: Description field limit change to 2000 characters on field level

3. Fields Renaming on MWO Screen
Window: Maintenance work order
Tab: Task Schedule
Table: VA075_WOTaskSchedule
Field: Schedule Date/Time from and Schedule Date/Time to
Note: Rename fields Schedule Date/Time from=Schedule Time from and Schedule Date/Time to=Schedule Time to

4. Make Travel Time Spent and Time Spent Fields Read Only
Window: Field Service Request
Tab: Task Group and Task
Table:VA075_WorkOrderTaskGroup and VA075_WorkOrderOperation
Field: Travel Time Spent and Time Spent
Note: Read only mark true on field level for Travel Time Spent and Time Spent fields

5. Maintenance tool Line No Unique key constraints required
Window: Field Service Request and Maintenance work schedule
Tab: Maintenance Tools
Table: VA075_WorkOrderMaintenanceTool and VA075_WorkScheduleMaintenTool
Field: Line No.
Note: Mark Unique checkbox true and copy checkbox false at column level

6. Able to save the BD Range From and BD Range To on value at zero. It should contain minimum 1 day value.
Window: Equipment Rating
Tab: Equipment Rating
Table:VA075_EquipmentRating
Field: BD Range From and BD Range To
Note: Set minimum value 1 on both fields at column level

7. On maintenance tool tab, same product can be added multiple times. It should be unique.
Window: Maintenance work order , Field Service Request and Maintenance work schedule
Tab: Maintenance Tools
Table:VA075_WorkOrderMaintenanceTool ,VA075_WorkOrderMaintenanceTool and VA075_WorkScheduleMaintenTool
Field: Product
Note: Mark Unique checkbox true at column level

8. On MWO>sparepart tab Charge amount Field should be read only.
Window: Maintenance work order
Tab: Spare part tab
Table: VA075_WorkOrderComponent
Field: Charge Amount
Note: Apply Read only logic on charge amount field at column level

9. Time Spend and Travel Time should be read only

Window: Field Service Request

Tab: Task Group and Task

Table: VA075_WorkOrderTaskGroup , VA075_WorkOrderOperation

Field: Time spent , Travel Time Spent

Note: Mark read only checkbox true on Time spent ,Travel Time Spent field

10. Amount field read only

Window: Maintenance Work Order

Tab: Task

Table: VA075_WorkOrderOperation

Field: Amount

Note: Mark read only checkbox true on Amount field

11. Copy Record on MWO Screen Should not be there in Right Action Panel

Window: Maintenance Work Order

Note: Make a New Record in Action Tab in Screen level and hide copy record from it .

12. On maintenance tool tab, same product can be added multiple times. It should be unique.
Window: Maintenance work order , Field Service Request and Maintenance work schedule
Tab: Maintenance Tools
Table:VA075_WorkOrderMaintenanceTool ,VA075_WorkOrderMaintenanceTool and VA075_WorkScheduleMaintenTool
Field: Product, Tenant , Organization, Field service request , schedule task
Note: Mark Unique checkbox true at column level for tenant, organization , product , VA075_WorkOrderOperation_ID, VA075_ScheduleTask_ID columns

13. Changes done to Set WO Task Status and Solution data on Work Log tab from Work Order Tab when click on Update Status Process of work order tab of Maintenance Work Order Window.

14. Inactive two tabs Work log and Requisition because these are shown in tab panels so no need to show as tabs. 

Window : Maintenance work order 

Tab : Work order 

Note :  Inactive two tabs Work log and requisition and set screen width 65

15. Validations on Requisition screen> Maintenance Work Order field.  

Maintenance work order field only fetch those records from MWO screen where same organization is selected in Requisition screen. 

Window :Requisition 

Tab : Requisition 

Field : Maintenance Work Order 

Note : Apply Data validation on column level

1. Added Work Order Tab Panel on Work Order Tab of Maintenance Work Order window to show Down Time Hours, Task Estimated Hours, Cumulative Task Hours, Expense Amount, Currency, Cause Code, Work Order Status, Solution, Status Updated At and Progress Bar Percentage on Work Order tab panel.

2. Added Tab Panel on Requisition Tab on Maintenance Work Order window to show Requisition Number, Requisition Date, Document Status that record on Requisition tab panel.

3. Added VA075_WOTaskStatus and VA075_Solution columns in VA075_WorkLog table and Added Solution and WO task Status Fields in the Work Log Tab of Screen VA075_WorkOrder to show solution and Work order status of the Document in Work Log Tab.

4. Added two Columns on VA075_WorkLog Table

Column Name:VA075_Solution

Column Name:VA075_WOTaskStatus

Screen:VA075_WorkOrder

Tab Name: Work Log

Fields :WO Task Status, Solution

Note: Added two fields on the work log tab.

5. Add tabs on Mentioned window:
Screen: Maintenance Group, Resources, Skill, Equipment Master
Tab: Group Member, Skills, Equipment Product, Spare parts/Services (New).
Create New Tables: VA075_GroupMember, VA075_ResourceSkills, VA075_ProductSkills
Field: Organization, Maintenance Group, Resource, Active, Description, Skill, Skill Level, Product, Asset Product, Quantity, UOM(New), Related Product, Related Product Type

Note:

a. Add display logic in related product type field. When selected “Spare part” & “Service” in Lov of related product type then to display fields “UOM” and “Quantity".

b. Add values in Skill field LOB

c. Marking Asset Product, Tenant, Org, skill unique.

d. Add validation on Asset/Services Tab when asset product checkbox is true select product from asset table and when false select products from product table.

e. On Resource window make asset/service tab read only.

f. Add query in SQL Where on sparepart/services tab. Show only Spare parts and services values records.

g. Add read only logic on IsAssetProduct checkbox.

h. Add validation in RelatedProductType field of Equipment master window's Spareparts/Services tab. Show only Spareparts and service option in LOV.

i)Mark Tenant, Organization, Maintenance Group, Resource fields unique in Group Member tab of Maintenance group window.

6. Create fields on mentioned tabs:

Screen: Resource, Field Service Request, Maintenance work order

Tab: Resource, Task Schedule

Fields: Base Location, Resource Tracking, Longitude, Latitude, Resource, Current Travel Estimate.

7. Create New Table: VA075_SMViewSets

Note:

a. Add read only logic on Resource field. If there is any value in Actual start date/time, Actual End date/time, Travel Start Date/Time, Travel End Date/Time In Task Schedule tab of Resource window.

b. Add read only logic in Resource field on task tab of Resource window.

c. Add default logic on resource field of task schedule tab. Fetch data from resource field of task tab.

d. Add Organization based validation on resource field of task schedule tab.

e. Add display logic on suspend reason field. If suspend checkbox is true then display suspend reason.

f. Renaming of Actual start date/time, Actual End date/time, Travel Start Date/Time, Travel End Date/Time fields.

g. Mark read only checkbox true in Actual hours, Schedule Hours, Travel Estimate(in hours).

1. Write Separate DROP VIEW and changes in System date field for VA075_MAINTENANCEWORKORDER_V, VA075_WORKSCHEDULE_V, VA075_WORKORDER_V PostgreSQL 15. 

2. Zoom also not working on Service Request Tab on Service Request  

Window: Service Request 

Tab:  Service Request 

Field: Component Asset 

Note :Bind Zoom window on this field of Equipment Master

3. Component Asset was not filtering data according to Asset

Window: Equipment Master  

Tab: Asset Component 

Field:  Component Asset 
Note: Updated Reference key of Component Asset  

4. Total Task estimate should not be copied from copy record functionality. While creating new record. 

Window-VA075_TaskListGroup 

Tab-Task group 

Table-VA075_TaskListGroup 

Field – Total Task Estimate (In Hours) 

Column-VA075_TimeEstimate 

Note: Total Task Estimate (In Hours) are getting copied. 

5. Data should be filtered as per selected Org.

Window-VA075_WorkOrder 

Tab-Work Order 

Table-VA075_WorkOrder 

Field – Maintenance activity 

Column-VA075_MaintenanceActivity_ID 

Note:- The Data Should be come according to selection of Particular Organization. Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

6. Window – VA075_WorkSchedule 

Tab- Maintenace work schedule 

Table-VA075_WorkSchedule 

Column-VAMFG_M_WorkCenter_ID 

Field –work center 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

7. Window – VA075_WorkSchedule 

Tab- Maintenace work schedule 

Table-VA075_WorkSchedule 

Column-VA075_ServiceTypes_ID 

Field – Service types 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

8. Window – VA075_Counter 

Tab- Counter 

Table-VA075_Counter 

Column-C_UOM_ID 

Field - UOM 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

9. Window – VA075_EquipmentClass 

Tab- Equipment Class 

Table-VA075_EquipmentClass 

Column-VA075_Priority_ID 

Field - Priority 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

10. Window – VA075_WorkOrder 

Tab- Task 

Table-VA075_WorkOrderOperation 

Column-S_Resource_ID 

Field - Resource 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

11. Window – VA075_WorkSchedule 

Tab- Sparepart/Service 

Table-VA075_ScheduleSparePart 

Column-C_Charge_ID 

Field –Charge 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization

12. Window – VA075_WorkSchedule 

Tab- Maintenace work schedule 

Table-VA075_WorkSchedule 

Column-VA075_MaintenanceStrategies_ID 

Field –Maintenance stratergies 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

13. Window – VA075_WorkSchedule 

Tab- Maintenance work schedule 

Table-VA075_WorkSchedule 

Column-VA075_Priority_ID 

Field –Priority 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

14. Window – VA075_ServiceRequest 

Tab- Service Request 

Table-VA075_ServiceRequest 

Column-C_Project_ID,VAMFG_M_WorkCenter_ID 

Field - Work center 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

15. Window – VA075_ServiceRequest 

Tab- Service Request 

Table-VA075_ServiceRequest 

Column-VA075_MaintenanceGroup_ID,VAMFG_M_WorkCenter_ID 

Field –Maintenance Group 

Note-The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

16. Window – VA075_FieldServiceReq 

Tab- Field Service Request 

Table-VA075_FieldServiceReq 

Fields-Priority 

Columns-VA075_Priority_ID-VA075_Priority_ID,VA075_ServiceTypes_ID,VA075_DowntimeReason_ID 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

17. Window – VA075_ServiceRequest 

Tab- Service Request 

Table-VA075_ServiceRequest 

Column-VA075_DowntimeReason_ID,VA075_DowntimeReasonValid 

Field –Downtime Reason 

Note:- The Data Should be come according to selection of Particular Organization 

18. Window – VA075_ServiceRequest 

Tab- Service Request 

Table-VA075_ServiceRequest 

Column-VA075_ServiceTypes_ID 

Field – Service type 

Note:- The Data Should be come according to selection of Particular Organization 

Bind Validation according when we choose particular organization on window then data should come based on that particular organization 

19. Window – Field Service Request 

Tab- Field Service Request 

Field – Asset Components 

Note:- 

Handle the issue of asset component currently on this Field asset data Is coming  so make change according to selected Asset the asset Component Should be come. 

20. Header panel Changes For Field Service Request 

21. Need to wrap up all the Field Values For Field Service Request 

22. Window – Work Schedule 

Tab - Maintenance Tool 

Field- Line 

Table - VA075_WorkOrderMaintenanceTool 

Column - LineNo 

Note- Line Field Mark as Read Only 

Every Line should be Unique and right now it is editable and Can Provide Same no  as the Existing One. 

23. Window- Work Schedule 

Tab-Checklists 

Field- Line 

Column - LineNo 

Note:- Line Field Mark as Read Only 

Every Line should be Unique and right now it is editable and Can Provide Same no  as the Existing One 

24. Window -  Work Order 

Tab – Work Order 

Field – Work  Schedule 

Column – VA075_WorkSchedule_ID 

Note:- Bind Validation on this Field 

Data Validation to provide based on Organization selected on screen Maintenance Work Order Currently showing all record is showing  

25. Window- Equipment Master 

Tab- Expense 

Field-Inventory use 

Column-  M_Inventory_ID  

Note:- Zoom window is not working map it on inventory use window.

26. Window-Field Service Request 

Tab-Field Service Request 

Field – Service Request status 

Column-VA075_SRStatus 

Note: Request status are getting copied. 

Should not copy these fields. 

27. Window-Field Service Request 

Tab-Field Service Request 

Field – Request Date 

Column-VA075_RequestDate 

Note: Request date are getting copied. 

Should not copy these fields. 

28. Window:-Field Service Request 

Tab:-Task Schedule 

Note:-Able to create schedule after task is performed. If task is performed then task schedule cannot be added. 

29. Window:-Maintenance work order 

Tab:-Work order 

Field:-Warehouse 

Column:- M_Warehouse_ID 

Note:-Warehouse field should be on read mode in maintenance work order. it Should be read only

30. Window-Field Service Request 

Tab – Task 

Table-VA075_WorkOrderOperation 

Column-VA075_Task_ID 

Field- Task  

Note:- Bind Zoom window of task Group Window on Field 

When we zoom this Field it will take to maintenance Work Order So it Should be Bind With Task Group Window. 

31. Window – Service Request 

Tab – Service Request 

Table – VA075_ServiceRequest 

Column - Description 

Field Name- Description 

Note:- Mark Always Updatable Checkbox False 

Currently Able to edit description after completion of Doc, then mark always updatable checkbox False so the document will complete then no field in it should be available for edit.  

32. Window – Field Service Request 

Tab – Field Service Request 

Table – VA075_FieldServiceReq 

Column - Description 

Field Name- Description 

Note:- Mark Always Updatable Checkbox False 

Currently Able to edit description after completion of Doc, then mark always updatable checkbox False so the document will complete then no field in it should be available for edit.  

33. Window – Work Order 

Tab-Work Order 

Table-VA075_WorkOrder 

Column-VA075_WorkInstructions 

Field-Description 

Note:-Mark Always Updatable Checkbox False 

Currently Able to edit description after completion of Doc, then mark always updatable checkbox False so the document will complete then no field in it should be available for edit.  

34. Window- Work Schedule Maintenance 

Tab-Maintenance Work Schedule 

Table:-VA075_WorkSchedule 

Column:-Description 

Field - Description 

Note:-Mark Always Updatable Checkbox False 

Currently Able to edit description after completion of Doc, then mark always updatable checkbox False so the document will complete then no field in it should be available for edit.  

35. Window – Equipment Master 

Tab-Equipment Details 

Table-VA075_EquipmentDetails  

Columns- VA075_InstallationDate,VA075_EquipmentManufacturerVA075_EquipmentModel,VA075_ManufacturingDate 

Fields- Date of Installation, Date of Manufacturing, Model, Manufacturer 

Note:- Mark mandatory UI as True 
If user choice to provide details of Equipment then it should be mandatory to Fill Installation and Manufacturing Details  

36. Window-Service Request 

Tab-Service Request 

Table-VA075_ServiceRequest  

Column-C_Project_ID 

Field- Project 

Note :- Bind Zoom Window on Project Field 

When we zoom this Field it will take to Opportunity Window So it Should be Bind With Project Window so when we zoom it then it goes to Project Window. 

37. Window – Work Order 

Tab - MaintenanceTool 

Field- Line 

Table- VA075_WorkOrderMaintenanceTool 

Column-LineNo 

Note- Line Field Mark as Read Only 

Every Line should be Unique and right now it is editable and Can Provide  

Same no  as the Existing One 

38. Window- Work Order 

Tab-Checklists 

Field- Line 

Column-LineNo 

Note:-Line Field Mark as Read Only 

Every Line should be Unique and right now it is editable and Can Provide  

Same no  as the Existing One 

39. Window- Field Service Request 

Tab- Task 

Field- Task End Date/Time 

Column- VA075_TaskEndDate 

Table- VA075_WorkOrderOperation  

Note:-Remove Read Only Logic For VA075_TaskEndDate Column 

User Needs to Edit the Field ,So right now it is Read Only Form 

40. Window- Work Order 

Tab- Task 

Field- Task End Date/Time 

Column- VA075_TaskEndDate 

Table- VA075_WorkOrderOperation 

Note:-Remove Read Only Logic For VA075_TaskEndDate Column 

User Needs to Edit the Field ,So right now it is Read Only Form 

41. Window – Service Request 

Tab – Service Request 

Field- Request No. 

Column- Document No 

Table – VA075_ServiceRequest 

Note: – Mark Mandatory UI as False on Document No Column 

42. Window- Field Service Request 

Tab- Task 

Field- Task 

Column- VA075_Task_ID 

Table- VA075_WorkOrderOperation 

Note :-  Bind Validation VA075_ValidTask on VA075_Task_ID 

43. Window - Maintenance Work Order 

Tab- Maintenance Work Order 

Table-VA075_WorkOrder 

Column-VA075_ReuseSchedule 

Field -Reuse Schedule 

Note:- Apply display Logic on Field Reuse Schedule 

44. Window-Field Service Request 

Tab- Field Service Request 

Table-VA075_FieldServiceReq 

Column-A_Asset_ID 

Field-Asset 

Note:- Bind Validation VA075_Asset_Record on A_Asset_ID Column

45. Bind the Callout on Fields service Req window Request date, Expected date, Actual Up time date for valid dates.

46. Changes done for fixing the issue on WO update status for setting the status to service log. 

47. Changes done for setting the update status dropdown on Field Service req Window same as WO 

48. Worked over setting the Task group child travel time count on parent and header tab. 

49. Changes done for setting the update status dropdown on Field Service req Window same as WO. 

50. Verified the working of Task performed checkbox on Task Group tab. 
51. Window – Maintenance work order 

Tab – Task Schedule 

Note – Applied display logic – If the data will be available in resource field then this tab will be enable otherwise it will be in disable mode. and Read only logic as per requirement.   

52. Window- Work Schedule  

Tab- Task  

Field- Skill  

Column-C_Skill  

Table- VA075_ScheduleTask  

Note – Bind  ValidationVA075_SkillVal  

53. Window-Work Order  

Tab-Task  

Field- Skill  

Table-VA075_WorkOrderOperation  

Column- C_Skill  

Note-Bind Validation VA075_SkillVal  

54. Window – Equipment Category  

Tab- Equipment Category  

Field-Serial no Cntrl  

Table -VA075_EquipmentCategory  

Column- M_SerNoCtl_ID 

Note:- Bind Validation VA075_SerialControlValiDation  

1. Window: Maintenance Work Order 
Tab: Task Group 

Note: Data unmarked VA075_MaintenanceWorkOrder quick search and bind it on Task Group Tab Work Order field

2. Window – Maintenance work order 

Tab – Task Schedule 

Note – Applied display logic – If the data will be available in resource field then this tab will be enable otherwise it will be in disable mode. and Read only logic as per requirement.

3. Window- Work Schedule

Tab- Task 

Field- Skill

Column-C_Skill

Table- VA075_ScheduleTask 

Note – Bind  ValidationVA075_SkillVal 

4. Window-Work Order

Tab-Task

Field- Skill 

Table-VA075_WorkOrderOperation

Column- C_Skill

Note-Bind Validation VA075_SkillVal

5. Window – Equipment Category 

Tab- Equipment Category 

Field-Serial no Cntrl 

Table -VA075_EquipmentCategory

Column- M_SerNoCtl_ID

Note:- Bind Validation VA075_SerialControlValiDation 

6. Bind the Callout on Fields service Req window Request date, Expected date, Actual Up time date for valid dates. 

7. Changes done for fixing the issue on WO update status for setting the status to service log. 

8. Changes done for setting the update status dropdown on Field Service req Window same as WO 

9. Worked over setting the Task group child travel time count on parent and header tab.

10. Changes done for setting the update status dropdown on Field Service req Window same as WO. 

11. Verified the working of Task performed checkbox on Task Group tab. 

1. Updated VA075_ Warehouse Validation & Updated all the tabs of field service window. 

2. Sequencing has updated for the following windows:

- Maintenance Work Schedule, Maintenance Work Order. 

Screens-  Service Request 

Maintenance Work Schedule 

Maintenance Work Order 

Field Service Request 

Note – All above mentioned screens, window type change from ‘Maintain’ to 'Transaction' 

Window – VA075_DowntimeReason                                Tab – Downtime Reason 

Table –VA075_DowntimeReason 

Column – VA075_ActivityType 

Note :-  Created two List of Values of VA075_ActivityType Field (Repair and Fabrication)       

1. Added data validation on Equipment Master Window of Equipment Details tab  
fields : 

Equipment Class 

Equipment Application 

Maintenance Group

2. Added data validation On Counter Tab:

Counter field

3. Added new fields Task Performed on 3 windows:

Field Service Request Window>Task Tab

Work Order Tasks Window>Task Tab

Maintenance Work Order Window>Task Tab

4. Added a script related to ReadOnly Logic of Resource field on task tab >Maintenance Work Order Window. 

5. Added SQL Order By on Master windows header tab. 

6. Added Datavalidation on checklist tab of Maintenance Work Order window.

7. Added a SQL ORDER BY Script On Skill Window header tab.

8. Added a Read Only Logic on Work Order window >Task Group Tab>Task Group Field 

9. Sorted on Work Order Tasks on the basis of latest created records. 

10. Added data validation on Work Order and Work Schedule Window>Header tab>Maintenance Activity Field.

11. Work done on Before delete logics on Work Order window tabs for checking the Processed Records.

12. Work done Work Order window Task tab Process Now button for setting Task performed checkbox true.

13. Fixed the callout issue on Work Order window Task tab.

1. Added new field Material Issued on Spareparts tab of Maintenance Work Order. 

1. DB changes on Maintenance Work Order Window, Service Request, Maintenance Work Order related to Copy checkbox and also changes done on  Asset  and Asset Component field. 

2. Added the check on WO window when record is Voided or Close. 

1. Header panel changes For Field Service Request Window. 

2. DB changes on Maintenance Activity window child tab. 

1. Added new fields and applied logics on  Task Confirmation, Request Confirmation, Asset Location , Use Asset Location  on Field service request, work order, document type windows. 

2. Done BI report ID changes  on MTBF Menu Report 

1. Changes done on Maintenance work schedule header tab on organization field and also on Asset field. 

Changes Description on Value Field for VA075_(Window.). 

Add Mandatory logic on warehouse, locator for VA075_WorkSchedule, VA075_WorkOrder Window. 

2. Made New replica window Equipment Master and new tabs. 

Done Field Sequence and Multi Row Sequence 

3. Added 2 fields Product and Charge on Equipment Master window. 

4. Done DB changes on Maintenance Work Schedule header tab, Equipment

Master header tab and Service Request applied Data Validation

5. Done DB Changes on Maintenance Work Schedule header tab, Services

Request Header tab, Work Order  Header Tab, Equipment Rating Window.

1. Changes done on Maintenance Work Schedule checklist tab Restrict change. 

1. Menu Setup for service and maintenance sequencing. 

1. Change done in Equipment Rating Window Active field. 

1. Rename the field on Task Group ,Maintenance Work Order, Maintenance Work Schedule ,Window 'completion notes'

2. Added Script for rename of fields for Service Request, Maintenance Work Order and Maintenance Work Schedule. 

3. Added Script for Rename of fields on Work Order tasks, Equipment Category. 

4. Added Restrict on Maintenance Work Schedule tab and field Maintenance Strategies.

5. Added Script for Restrict constraint change for windows Service Request, Maintenance Work Order, Maintenance Work Schedule, Resource 

1. Rename of fields on  Windows

(a) Maintenance Work Order,

(b) Maintenance Work Schedule,

(c) Service Request 

(d) Asset Window >Equipment Details Tab 

(e) Removed Identifier from Description field on Functional Location Window. 

2. Bind callout on Reading date, present reading, difference  fields on counter line tab. 

3. Implement code for processed button on counter line tab.

4. Implement the code for counter and counter line tabs on asset window functionality for vehicle maintenance.

5. Bind callout on VA075_counter filed in counter tab.

6. Implement callout code on counter tab for fetching the UOM value from counter window.

1. Rename the fields of Work Order tasks Window>Task Tab 

(a) Work Schedule Field

(b) Service Request Field

(c) Asset Field

(d) Asset Component Field 

(e) Work Order No

(f) Maintenance Type 

2. Add Description and Comment on VA075_WorkSchedule(Field and Column Level).

3. Add Description and Comment on VA075_WorkOrder Window(Field and column Level).

4. Add Description and Comment on VA075_ServiceRequest Window(Field and Column Level).

5. Add Description and Comment on Work Order Tasks Window(Field and Column Level).

6. Add Description and Comment on VA075_CauseCode Window(Field and Column Level).

7. Add Description and Comment on VA075_TaskListGroup Window(Field and Column Level).

8. Add Description and Comment on VA075_DowntimeReason Window(Field and Column Level).

9. Add Description and Comment on VA075_MaintenanceGroup Window(Field and Column Level).

10. Add Description and Comment on VA075_MaintenanceStrategies Window(Field and Column Level).

11. Add Description and Comment on VA075_MaintenanceActivity Window(Field and Column Level).

12. Add Description and Comment on VA075_Priority Window(Field and Column Level).

13. Add Description and Comment on VA075_FunctionalLocation Window(Field and Column Level).

14. Add Description and Comment on VA075_ServiceTypes Window(Field and Column Level)

15. Add Description and comment on VA075_CauseCode Window (on Window level).

16. Add Description and Comment on VA075_DowntimeReason Window ( on Window level ).

17. Add Description and Comment on VA075_MaintenanceGroup Window ( on Window level ).

18 .Add Description and Comment on VA075_MaintenanceStrategies Window ( on Window level ).

19. Add Description and Comment on VA075_Priority Window ( on Window level ).

20. Add Description and Comment on VA075_TaskListGroup Window ( on Window level ).

21. Add Description and Comment on VA075_EquipmentApplication Window ( on Window level ).

22. Add Description and Comment on VA075_EquipmentCategory Window ( on Window level ).

23. Add Description and Comment on VA075_EquipmentClass Window ( on Window level ).

24. Add Description and Comment on VA075_EquipmentRating Window ( on Window level ).

25. Add Description and Comment on VA075_FunctionalLocation Window ( on Window level ).

26. Add Description and Comment on VA075_MaintenanceActivity Window ( on Window level ).

27. Add Description and Comment on VA075_ServiceTypes Window ( on Window level ).

28. Add Description and Comment on Utility Window ( on Window level ).

29. Add Description and Comment on VA075_ServiceRequest Window ( on Window level ).

30. Add Description and Comment on VA075_WorkSchedule Window ( on Window level ).

31. Add Description and Comment on VA075_WorkOrder Window ( on Window level ).

32. Add Description and Comment on Work Order Tasks Window ( on Window level ).

33. Made 2 new tabs along with the description/comments on Asset Window
(a) Counter Tab and fields on Asset Window
(b) Counter Line Tab and fields on Asset Window

34. Bind job on process column on Asset window- Counter tab.

35. Changes done for calculation downtime when asset is not selected and fix the messages in wo, ws windows.

36. Bind callout on Reading date field on counter line tab.(VA075.Model.VA075_RunTime.CounterLine)
=>Bind process on filed button Process .

37. Implement code on process for not allowing to processed record with reading if current reading is higher or any future processed record find with future date.

38. Implement code for checking the records on counter line tab for checking the future reading date or processed record reading date.

39. Implement callout code for present reading and difference filed on counter line tab ,for allowing data only in one filed from both.

40. Implement code for work order task window spare part tab for setting quantity fields data.

41. Changes done for setting the WOtaskstatus and FStaskstatus on wo and field serv req window for checking the task progress.

42. Development of new Window tab and fields
(a) Counter Window

43. Rename of fields on Windows

44. Maintenance Work Order,
Maintenance Work Schedule,
Service Request
Asset Window >Equipment Details Tab
Removed Identifier from Description field on Functional Location Window.

45. Bind callout on Reading date, present reading, difference fields on counter line tab.

46. Implement code for processed button on counter line tab.
47. Implement the code for counter and counter line tabs on asset window functionality for vehicle maintenance.

48. Bind callout on VA075_counter filed in counter tab.

49. Implement callout code on counter tab for fetching the UOM value from counter window.

50. Added new field FS Work Status on Field Service Request Window

51. Added new field WO Status on Maintenance Work Order Window

52. Rename the fields of Maintenance Work Schedule Window>Status to 'Asset Status' and Status Updated On to 'Status Updated At'

53. Filter the locator data according to Warehouse field on Work Schedule Window.

1. Made read only Organization on Task Schedule Tab>Maintenance Work Order Window. 

2. Added Display Logic on Task Schedule Tab>Maintenance Work Order Window. 

3. Made read only Available Quantity on Spare parts tab>Maintenance Work Schedule. 

1. Added a new Print Format on Maintenance Work Order Screen for ( Maintenance Work Order Report) . The data was fetching All records. Process   is VA075_MaintenanceWorkOrderPrint

2. Added a new Print Format on Maintenance Work Schedule Screen for ( Maintenance Work Schedule Report) . In Maintenance Work Schedule window there was one Print button top of the  section . The data was fetching All records. And process attached by Maintenance Work Schedule tab . Process is  VA075_WorkSchedulePrint

3. Added a new Print Format on  Service Request Screen for ( Service Request Report) . In Service Request window there was one Print button top of the  section . The data was fetching All records. And process attached by Service Request  tab . Process is  VA075_ServiceRequestPrint 

4. Changes done for Spare part for calculating the total cost on parent tabs. 

5. Changes done for task schedule tab for inserting the record in task activity tab. 

6. Changes done for task schedule tab for updating the total cost on all tabs when record deleted 

7. Add VA075_TravelStartTime,VA075_TravelStopTime new fields in VA075_WOTaskSchedule table 

8. Added changes related update travel time on task, group and field service bases on work order task schedule. 

9. Changes done for set travel time hours based on start travel time and stop travel time on add work order task schedule screen on field service request.

10. Changes done on completion of Work Order Total cost will be calculated from spare parts and updated on all parent tabs.

11. Added a new Print Format on Maintenance Work Order Screen for ( Maintenance Work Order Report) . Update Tab query in script . Process   is VA075_MaintenanceWorkOrderPrint 

12. Rearrange Multi Row of Cause Code, Downtime Reason, Maintenance Group, Maintenance Strategies, Priority Level, Task Group, Equipment Application, Equipment Category, Equipment Class, Equipment Rating, Functional Location, Maintenance Activity, Service types, Utility 

13. Added new field "Equipment Category" on Product Category Window 

14. Added Read only logic on Locator, Warehouse field on Work order window and Maintenance work Schedule Window 

15. Made line No read only on task group window checklist tab and maintenance tools tab 

16. Made Organization Read only as according to its parent tab on Resource window.

17. Added a new Print Format on Maintenance Work Order Screen for ( Maintenance Work Order Report) . The data was fetching All records. Process   is VA075_MaintenanceWorkOrderPrint. 

18. Added a new Print Format on Maintenance Work Schedule Screen for ( Maintenance Work Schedule Report) . In Maintenance Work Schedule window there was one Print button top of the  section . The data was fetching All records. And process attached by Maintenance Work Schedule tab . Process is  VA075_WorkSchedulePrint 

19. Added a new Print Format on  Service Request Screen for ( Service Request Report) . In Service Request window there was one Print button top of the  section . The data was fetching All records. And process attached by Service Request  tab . Process is  VA075_ServiceRequestPrint.

20. Set the Field sequence of Maintenance work order>Spare parts tab

21. Line No field read only on task group window>Maintenance tools and checklist tab 

22. Added new field document status on schedule history tab of Maintenance Work Schedule Window.

23. Set the multi row sequence of Equipment Rating Window.

DB Changes

1. Made new field Color on Priority window.

2. On work order window asset and work center field read only

3. Overwrite reference of Description field to text in Skill window.

4. Added unique constraints on WO

5. After save organization field should be read only Skill Window.

6. Added unique constraints on Resource Type

7. Added process now button on Task Schedule Tab in Maintenance Work Order Window

8. Unhide Restrict issuance on Completion checkbox on document type window

9. Unhide Breakdown maintenance Checkbox on document type window.

10. Mark Next Service Date as read only field on Maintenance Work Schedule Window

11. Rename Work Schedule date- Planned Work Order Date
Show all contract in the dropdown of Contract reference field of Maintenance Work Schedule window

12. Rename Work Schedule date- Planned Work Order Date
Show all contract in the dropdown of Contract reference field of Maintenance Work Schedule window

13. Remove Field Service request from the LOV of Maintenance Type field of Maintenance Work Order

14. On Selection of Service Request on Maintenance Type field of Maintenance Work order unhide the Maintenance Work Schedule and make read only field and vice versa.

15. Mark Work Center field as Non Mandatory field on Service request & Maintenance Work Schedule Window

16. Hide Unit Price, Tax, Tax Amount, Discount, Discount % ,total amount fields from Spare parts tab of Maintenance Work Order

17. Added fields Task Description( Task) & Checklist description(Checklist tab) fields on Maintenance Work order Window

18. Hide Last Unit, Next Unit, Last Maintenance & Next Maintenance Field from Asset header.

19. Make Service request field as read only field on Maintenance Work order header

20. Change Range unit field display length to 15 in Equipment Rating Window

21. Overwrite reference of Description field to text in Work center window.

22. Function location field should be drop down instead of search field (Service Request/Work schedule

23. Unhide Color in Priority window

24. On WO Service Request/WO field should be drop down instead of search field

25. Asset Window>Utilities Tab >Done changes in Line No field added default logic and made this field read only

26. Asset Window>Asset Tab>Equipment Category field Created

27. Serial No Control Window >Serial No Control Tab>Control Basis field Added List Value

28. Service Request Window>Done change in work order status field read removed default logic

29. Added Default logic on Line Number field on Utilities tab>Asset Window

30. Added Data Validation on Equipment Genre field on Equipment Details Tab>Asset Window

31. Window : Equipment Application, E.Rating, E.Class,E.Category, Utility - Unique constraints added on value field

32. Service Request Window>Service Request Tab>Hide fields(Product, Equipment, Campaign, Complete note)

33. Maintenance Work Order Window>Work Order Tab>Hide Product Field, Sales Order, Customer, Admin notes, Campaign, Equipment

34. Maintenance Work Schedule Window>Maintenance Work Schedule Tab>Hide Product Field

35. Work Order Task Window>Work Order Task Tab>Hide Campaign Field

Add new Fields : 

1. Maintenance Work Order Window>Spare Parts/Services Tab>On Hand qty Field 

2. Maintenance Work Order Window>Spare Parts/Services Tab>Reserve qty Field 

3. Maintenance Work Order Window>Spare Parts/Services Tab>Ordered qty Field 

4. Maintenance Work Order Window>Spare Parts/Services Tab>Available qty Field 

5. Maintenance Work Order Window>Task Tab>New Task Description Field 

6. Maintenance Work Order Window>Task Tab>Add Task Field

Made new windows-

(a) Equipment Category,

(b) Equipment Application, 

(c) Utility,

(d) Equipment Class, 

(e) Equipment Rating 

Made new Tabs- 

(a) Asset window>Equipment Runtime

(b) Asset window>Utilities 

(c) Asset window>Utilities

(d) Maintenance Work Order Window> Requisitions New Tab

Code Changes: 

1. Work done on Runtime class for avoiding the same time slot in runtime tab.

2. Work done on Update status for calculating the downtime hours on maintenance work order window.

3. Work done for create lines from work order on Inventory use window

4. Created Process to update the rating on equipment details tab.

5. Created Process for invoice and Quotation generation.

6. Changes done for Task Activity for showing error if activity not found.

7. Set Reuse Checkbox same as in Work Order in Work Schedule.

8. Added task update processes for work order and field service request.

9. Changes done for task schedule tab on WO for checking un availability of days and time slot on resource window

10. Changes done for Create Task on Work Order for checking resource un-availability.

1. Work done on Maintenance Work Order to check if Task activity exist for every task and processed.

2. Service Request - Cost/Profit Center will be Mandatory UI

3. Maintenance Work Order - Cost/Profit Center will be Mandatory UI

4. Service Request - When selected the Service Type as Mechanical then the filtered Cost/Profit Center will come in the drop-down list which are linked with the Mechanical service type at second tab.

5. Correction in Work Order Print (Missing Column name was added in Job & Report – Sql Query)

6. Change reference type to search of functional location field on Service Request, Work Schedule and Work order windows.

7. Work done for create lines from work order on Inventory use window

8. Added new field Create Lines From Work Order on Inventory Use Window > Header tab

9. Added 4 new Fields on Inventory Use Window >Inventory Use Line.

(a) Work Order

(b) Task Group 

(c) Task

(d) Line No

1. Window Name - Service Types.

2. New Tab - Cost Center 
New Fields - LineNo, VA075_ServiceTypes_ID, Trx Organization 

1. Correction in Work order print 

1. Added columns  C_BPartner_ID, Location, C_Order_ID, C_Contract_ID, Contract validity on Work Schedule and Work Order 

1. Added Maintenance Work Order and Field Service Request references on AR Invoice window.

2. Added checkbox SM Invoice on Document Type window. 

3. Marked editable Customer and Location fields on Work Schedule. 

4. Added Validation on Contract type to show contracts based on selected Business Partner on Work Schedule. 

5. Added Generate Invoice Process  and bind it on Generate Invoice button on Work Order

6. Done change to set Consumption type while creating Internal use inventory from Maintenance Work Order 

7. Added Generate Invoice Process for Work Order and Field Service Request windows. 

8. Done changes in callout to set work center from functional location on Work Schedule and Service Request windows 

9. Removed callout from Work center column and added on Functional location on Work schedule and Service request.

10. Done change for re-activate option on Work schedule and Service request windows.

1. Done changes to set Consumption type on Inventory Use while completing Work Order.

2. Done change in callout to set total amount on Spare part tab under Maintenance Work Order.

1. Table : VA075_WorkOrder,VA075_ServiceRequest , VA075_WorkSchedule—Added Functional Location and Equipment fields and data validation on equipment. 

2. Added Product, ASI, UOM and Qty fields on Equipment tab under Functional Location window.

3. Changes in callout to set Service Types reference on work order from work schedule and service request.

4. Window: Functional Location

Tab : Function Location , Table : VA075_FunctionalLocation

Equipment, Table : VA075_Equipment

Added checkbox VA075_IsMaterialConsumption under Document Type window

Added VA075_ServiceTypes table and window

5. Changes in callout to set functional location and equipment fields on work order from work schedule and service request.

6. Integrate map on Field Service Request Window.

Integrate map on Field Service Request Form.

Plot marker for customer and resources. 

7. Create tab panel to show customer location map on Field service request window.

8. This version of this module is now compiled with .NET framework version 4.8.

1. Set Cost Center at Service Request, Maintenace Work Schedule and Maintenance Work Order.

2. Fetch Cost Center from Work Center of respective Service Request and Work Schedule.

3. Window: Productio time Ticket

Tab: Activities Table:VA073_ActualHours

(a) Column:VA075_DowntimeReason_ID

(b) Message Entry: VA075_DowntimeReason

4. Set value on Product field on Maintenance Work Order window

5. Window: ServiceRequest>> Tab: ServiceRequest>>

Table:VA075_ServiceRequest:

New Columns/Fields added (Trx Organisation, Activity, Campaign, Project, User List 1, User List 2)

6. Window: WorkSchedule>> Tab: WorkSchedule>> Table:VA075_WorkSchedule:

New Columns/Fields added(Trx Organisation,Activity,Campaign,Project,User List 1,User List 2)

7. Window: Work Order>> Tab: Work Order>> Table:VA075_Work Order:

New Columns/Fields added(Trx Organisation,Activity,Campaign,Project,User List 1,User List 2)

1. Bug Fixes

1. Bug Fixes

1. New work as per the Industry requirement.

1. Bug Fixes

Note: On priority, this module is released for the Oracle users. This module also is marked as the private modules and are to be released only for the specific clients (SCB) using oracle DB.  

1. Bug Fixes.

1. New work as per the Industry requirement.

1. Plant Maintenance module captures information of equipment maintenance, breakdown analysis, and schedule maintenance task calendar for all equipment/Assets. 

Service and Maintenance module is updated with the new features into the following Windows.

(a) Cause Code - New Master window created. 

(b) Downtime Reason - New Master window created. 

(c) Maintenance Group - New Master window created.

(d) Maintenance Strategies - New Master window created. 

(e) Priority Level - New Master window created. 

(f) Task List Group - New Master window created. 

(g) Reason for Variance - New Master window created. 

(h) Service Request - New transaction window is created. 

(i ) Work Schedule - New transaction window is created. 

(j) Work Order - New transaction window is created. 

(k) Work Order Report - New Report is created.