• how to create a new stock record via 4GL?

    How would I write 4Gl code that will create a new record in the stock table? Thanks, Chris
  • Same code return different results

    When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL. When I execute the query in SQL, it returns the correct results. For example: When testing the same…
  • 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
  • Data in customized window not Saved

    FormerMember
    FormerMember
    I created screens and window which is shown below. The first problem I face is that when I clicked Save button, only the first row of the table in RFQ is saved. Both "RFQ1810002" and "RFQ1810003" did not save. Besides, the second question is that when…
  • Adding A New field

    I am looking to a add new field at the product Level. The field should have the option to hold options the user can pick from. Does anyone have steps on how I can do that.
  • How to do "find" in class with nested Collection?

    Hello, I try to make some development in PJM module V11. we have OPPORPJM class there which have Property TAS linked with class PJMTSK During Task planning I Have prepared 3 Phases If I look at Value in Instance GZINSPJM I can see: GZINSPJM…
  • does GPE=1 work on ouvre

    Hi, I added GPE=1 to a OUVRE action, but it is still reading the standard script. Does GPE=1 not work on the action OUVRE? I am doing this for the SUBENTL script. I created a ouvre in the SPEENTL script.
  • Product Desc 2 On Screen

    Is is it possible to have the product Desc 2 show up on Purchase order Screen? I looked at the screen level on PO and it is not hidden or available. Product screen:
  • 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…
  • syntax for reading a string starting from the right

    What 4GL command would I use if I want to start reading a string from the right. I kind of want it to work how left$ works. Right$ is not what I am looking for since you have a define the number of characters starting from the left. Thanks.
  • Printing a A NEWLY field in a new SAGE X3 SINVOICE table

    Good day. I created a new field called RTNCODE which is seen in figure ask1 from the directory : Development>Data and parameters>Tables>Tables FIGURE ASK1 ON printing a crystal report of the sales invoice, THE NEWLY CREATED FIELD CAN NOT BE SEEN.…
  • Where can I find the logic for product status?

    Where do I find the logic for all of these options (see picture)? I looked in the standard script for this screen and it is not there. The screen is ITM0 and it is located on Common Data -> Products -> Products. Using Sage x3 version 11 patch 2. …
  • How to split PO lines when using Grouping Workbench after MRP

    When checking the technical manual you can find ways to separate Purchase Order lines, instead of merging: Entry point ECLBESOINS for script TRTACHCDE1, but it seems that it is only possible to do it via the reordering process, and in this case we need…
  • ADDING Product Description Field To Subcontracting Order Screen

    Is it possible to add the product description to the subcontract order screen. I looked at the screen level and did not see that field available.
  • Vendor Lot Number on Count

    Does x3 have a field where we can enter the Vendor Lot number on the count?Currently it only has the system generated ones.
  • How to execute custom Menu button

    How do I execute a custom button? The button/menu created has a Code of 1 I want to be able to click on that button from code. Thanks, Mario
  • Grouping workbench Screen WT53ACH1 *Screen Modification

    Hi, I have a requirment to add a column on the screen that can be access on X3 via Purchase->Supply->Grouping Workbench->ACH Buyer. I did a screen look up and it was WT53ACH1 screen. I tried going to that screen and add the column "Supplier Name" and…
  • 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…