Solved

How to get a field into a screen view Apps9

  • 9 July 2021
  • 1 reply
  • 73 views

Userlevel 4
Badge +10

Hello,

In the Service and Maintenance module in Apps9 the ‘Prepare Work Order’ screen and ‘Report In Work Order’ screen both use the ActiveSeparate logical unit and the ACTIVE_SEPARATE_UIV view.

However the field Err_Class is only available in the Report In screen, is it possible to pull this field into the Prepare screen as an insertable and updatable field, and if yes how? 

The values for Err_Class are determined by another table, the WorkOrderClassCode logical unit, not sure if this impacts what I want to do.

Thanks Sarah

icon

Best answer by Thushitha Chandrasiri 9 July 2021, 12:35

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +20

Hi @sholmes ,

I think the reason for the class (Err_class) not in the Prepare work order is that, the class is to be determined when reporting in the work order, since the class is used for financial analysis purposes. So, class is entered (connected) to the work order at the stage of reporting to the work order.

If you want the Class to be visible in the Prepare work order screen, one thing you can do is to add a referenced custom field to the Prepare work order screen referencing the Class in the Report In work Order. But, since it is referenced, it cannot be entered/updated. And it is automatically fetched with the Class of the related Report In work order once it is entered there, and until then, it will be empty.

Other thing you can do is to add a persistent custom field in the Prepare work order to enter the Class  as a LOV field, and LOV can be set to the WORK_ORDER_CLASS_CODE view, so the same classes will be there for selecting. But, for the integrity of the data, you may have to create an event with event action that validates the same Class is entered or automatically updated in the report in work order as the class in prepare work order.

 

Thanks,