x Want to participate? Join the group to interact

  • Querying the SEI database directly

    What I am trying to do is write a query that will list all SEI processes and the Folders they are located in. I can't seem to find any table in the SEI database that contains the folder structure. Is what I'm trying to do possible? My organization is…

  • Pulling Calculated Values from One Report or Data Model Into another for further calculations.

    I have 2 different reports one is a Statement of Financial Position while the other is an Income statement, how can I get calculated fields value from my Income Statement Into my Statement of Financial Position noting that the IS has it's Data Model just…

  • Script to rename report in Preview

    Hi I have a customized report ZSORDERS I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…

  • How can we prefix the order of a list in the representation?

    We have a representation of purchase documents, and in the list we want that by default we appear ordered by date in descending order. How can we do it?

  • How to do a select distinct in Query tool

    I'm trying to create a new query so that my user can have a list of new prep lists on their landing page. using table STOPRELIS, I was able to create a query but there is a line per product, when I only want the prep list, pick ticket, and so number.…

  • How to make a field from a statistical group mandatory?

    The Product Statistical Groups in our system has 5 lines, one of which is Country of Origin. We would like to make this field mandatory, and leave the others optional. I see that in the Screens I can set the whole group to be mandatory with the TSICOD…

  • Object Link Expression ITM -> ITP

    I am trying to add the manufacturer's product as a field in the selection list so that our purchasing dept. can have an easier time finding the products that they need. I know that I need to link the ITM object to the ITP object, but when I try to do…

  • Lenght Item Description

    I there, I'm new in Sage X3 V8 My Company has large Item descriptions with more than 30 chars lenght so we need to use both description fields, description 1 and description 2, but this 30 chars limit start to make a lot of troubles for the user becaus…

  • How do I make a field on the line tab mandatory?

    My customer has a field that was designed for them called the 'exchange rate' so that they can keep track of the exact rate at which they sold the goods. -> They want these fields to be mandatory when entering the direct order, the user must not be…

*Community Hub is the new name for Sage City