Inquiry Screens Modifications

SOLVED

Hi,

I was looking for a documentation or any guided steps to how I can make a modification on inquiry screens?
Ex: Steps to add the Customer Name/Description column to List of Orders (Sales) Inquiry screen. Thanks.

Parents
  • 0
    If you go to Setup - General Parameters - Inquiry Screens, you can view the built-in inquiry screens and screen codes and here you can modify the sequence of the fields or remove/add fields that you don't want as well as default the nblig(number of lines) that you want to show up on the grid per page. Remember to validate after changing.

    Hope this helps.
  • 0 in reply to Michael91
    Hi Michael,

    Thanks for your help. But I have tried the screen you mentioned before and was only able to modify the look of the screen and field positiong (existing fields only).
    Nevertheless I was not able to add a new field to the inquiry screen here, I think it is a bit more complicated than that..
    Have you tried it yourself? I appreciate your reply and feedback.
  • 0 in reply to Fadi B.
    Oh well in that case if you want to add fields to the inquiry, you have to find the screen and add the field to that screen, due to the fact that the inquiry screens are a mix of a header screen, criteria screen and grid. For example, lets say I want to modify purchase invoice lines, it is comprised of the following screens:

    CONSCPJ1 - header screen with filter criteria for the grid
    CONSCPJ2 - this is the field content grid screen from the relevant tables connected to the object
    CRITCPJ - this is the screen that displays when you hit the Criteria button to filter
    WMCPJALL - this is the window which holds the screens above
    WMCPJSTD - this is the window which holds the screens above (standard entry)

    From my experience, first I check the object that is connected the the inquiry screen. You can also find the list of screens used here. By checking the object, you can see which tables are connected to the object because you are going to add fields from tables and you want them to populate values.

    Once you're done that, go ahead and add the field to the CONSCPJ2 screen first. Make sure to set as display and choose the right source table. Save and validate. Also remember to use an activity code to protect the customization.

    You should then see your field available when you go to the window (WMCPJSTD). If you go to Setup-Gen Parameters -Inquiry Screens, you should also see your field at the bottom of the grid. Add the sequence number in this screen (or in the window as I just mentioned), save and validate.

    This should do the trick. Hopefully this works.

    Mike
  • 0 in reply to Mirabelli7
    Did this answer your question Fadi?
  • 0 in reply to Michael91

    Yep, Mirabelli7's advice works. I would add that you must close and reopen the Inquiry to see the change.

  • 0 in reply to Michael91

    Hi There,

    Is there a way to change the display of the screen?

    For example take a away the grid lines and just display  solid or blank rows?

    Regards

    Jean

  • 0 in reply to JeanMostert

    Hello,

    Question: I added a field TSICOD1 to the CONSCPP2 inquiry screen (PO Order lines) to show the first Statistical group only with ADI parameter as 20. When I ran the inquiry that specific column was blank (no value populated). I have validated both the screen and the inquiry screen CPP ( All > Setup > General parameters . Inquiry Screen). In the past had added other fields but never had this issue. But this is the first time adding statistical group.

    Also tried TSICOD with default ADI (indices +20) to show all the Statistical group. Even this does not show the values.

    Using SageX3 V11. 

    Any help is appreciated.

    Thanks

Reply
  • 0 in reply to JeanMostert

    Hello,

    Question: I added a field TSICOD1 to the CONSCPP2 inquiry screen (PO Order lines) to show the first Statistical group only with ADI parameter as 20. When I ran the inquiry that specific column was blank (no value populated). I have validated both the screen and the inquiry screen CPP ( All > Setup > General parameters . Inquiry Screen). In the past had added other fields but never had this issue. But this is the first time adding statistical group.

    Also tried TSICOD with default ADI (indices +20) to show all the Statistical group. Even this does not show the values.

    Using SageX3 V11. 

    Any help is appreciated.

    Thanks

Children
  • 0 in reply to Rajesh kannivadi

    Hello Rajesh,

    Have you able to resolve above issue. I face the same. I added the BP name to invoice inquiry screen in AP/AR accounting. The column shows but values are not populating. 

    Regards,

    Eranda 

  • 0 in reply to erandarg

    I have the same issue. I think a blank column means the screen isn't able to pull the data from the database because it's pulling from a table that isn't otherwise on the screen. I'm just not sure if we have to modify the script to change it or what.

  • 0 in reply to christycpa

    Hello

    You can read additional tables using a bespoke script on the SPE layer. Do NOT edit the stanard script. Instead you write a custom script, catch the ACTION "LECTURE" , and in your spe script call the Standard inquiry script before yours, so that it populates the screen for you, then you use a for loop over the screen to see the date loaded and you then read the additional table and populate the screen

    $ACTION

    Case ACTION

    When "LECTURE" : Gosub LECTURE

    Endcase

    Return

    $LECTURE

    Gosub LECTURE From XXX #Std inquiry script here instead of XXX

    [v]GPE=1 

    # Here your code to loop over the screen. You may check the [M]NBLIG field to see how many lines were loaded.

    Return

    Regards

  • +1 in reply to christycpa
    verified answer

    A quick workaround without coding. This only works with the description fields on the master data, for example, customer name, supplier names, and product description. 

    1) Find the screen on that is used by the inquiry. For example, for sales order inquiry, the screen would be CONSCSO2

    2) Find the field you want to display the description of. For example, If I want to display the name for sold-to customer on the inquiry, I would be looking for the BPCORD field.

    3) On the field setup, change the setting under the "link" column. "long" for long description. "Short" for short description. This should mirror to the "name" and "short description" fields under the customer setup.

    4) save and validate the screen. 

    5) Go to "Development -> Script dictionary -> Inquires". Find the inquiry and validate it.

    6) Go to "Setup -> General Parameters -> Inquiry screens", and validate all screens under the inquiry.

    That should be it. By doing so, the customer name should display next to the customer number.