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.
Yep, Mirabelli7's advice works. I would add that you must close and reopen the Inquiry to see the change.
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
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
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
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
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.
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
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.
*Community Hub is the new name for Sage City