• Use table from another folder

    Hello everyone In X3 documentation it is described that it is possible to use a table from Folder A in Folder B. https://lvexpertisex3.com/x3help/ENG/V7DEV/4gl_file.html I tried it like this: Unfortunately it doesn't work with the period between…
  • 404 not found error when creating new request object

    In code block below I am getting a 404 error when creating the request. I assume i need to provide the full path but can't find the documentation as to what that path is. This began with the lastest patch level. It worked as is before this. Anyone…
  • Menu item - type: query - "where" parameter operators

    Good morning, I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says: Only simple conditions using "le", "ge", "eq", "lt"…
  • Code to query purchase pricing?

    We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…
  • SageX3 - Left List Personalization

    Hi, how can I add custom view fields into standard (browser) object Left List ? It's easy to add other tables but , what about views ? Example:this is a standard object I've added my custom view into Viste tab: But in Selezione tab (Selection…
  • ADC location override

    So I have been presented with an interesting challenge. In our company we've set X3 to batch allocate all available stock to meet all demand in the system. We also heavily leverage X3's ADC functionality. Our warehouse users are able to override the…
  • How to change record by code

    Hi, Anyone knows if it's possible to change a record by code without leaving and entering the object? For instance, a button on a window that forces the current record to other than the one currently loaded. Is there any standard call…
  • How to add dimensions in account pyramids

    Hello Everyone, Is it possible to add Dimensions in account/nominal ?? I am able to add dimension under account 31100 (on screen). However, when I click on SAVE button, it throw error " Error in pyramid 31100 " and records didn't save in database…
  • Clob Field not Pulling Values(Menu item)

    Hi I have a task where I have to add a Text Field(CLOB) on the customer screen as a menu item(on right side) So far this is what I accomplished 1.Added menu item and Enabled it in SETBOUT 2.Created a new screen(ZACLOB) with a CLOB field When…
  • Printing a crystal report via webservices

    Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…
  • Line Menu - Data not stored

    Hi I created a custom field in table BPCustomer table. Enabled the item in SPEBPC script.When I enter text it does get stored in TEXCLOB table.(The save button also doesn't get enabled) When I enter text in this field I want to store it.How can…
  • ADC Soap API

    Has anybody created an API call for an ADC function? More specifically, I am looking at the ADC Material picking screen and looking for information on how to write a write api call for this. Thanks, Chris
  • I need help with cloning a capability.

    Please any help will be appreciated. I am trying to clone a functionality from Customer BP Invoices under the AP/AR Accounting. In the Distribution field in Lines where you can perform analytical distribution I am trying to clone same functionality for…
  • Reading data from the REST Web Service

    Hi All, We are calling a REST Web Service via the classic 4GL code with " Func EXEC_REST_WS" . I am using a simple GET to retrieve information. The parameters that are described in the Online Help ( link here ) make use of a Return s parameter.…
  • Customizing the date widget

    Hi all. Is it possible at all to customize the standard date widget? For example, i s there a way that the week number displayed at the footer of the date picker can reflect the week of financial year rather than the calendar year? Thanks in advance…