Browse By Tags

  • Create new record from another object in 4GL

    Hi, I need to create in Sage X3 V9 (patch 6) a new analitycal dimension (object CCE) on creating new Project (object OPP) with some data from the last one, my client request an automatic function on create so any new button are forbidden, in my specific…
  • creating a web app using mertial picking adc functionality

    Has anyone every created an external web app and that app uses the adc functionality or know of a way to do this? So basically, I am trying to create an an external web app, but I want it to behave in the same functionality when I am doing the material…
  • Error in enabling Invoice function - No transaction authorized

    Hello, I enabled the module "Purchasing" for a user, most of the sub-functions are working, however, some functions are running into the error below: I'm trying to enable the Invoice function: These are the user settings, it is a test user…
  • Sequence number with 0-9 and A-Z

    I hope someone can help me. I need to create a unique identifier that consists of 5 characters, and the characters are numbers 0-9 and letters A-M. I also need the identifier to be created in order (i.e. a sequence number). I am not really seeing how…
  • 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?
  • Creating new BP address field on Delivery

    The requirement is to print the company name, address, and contact details of the party responsible for paying for duties/taxes on a delivery. This may be different than the BPC listed on the delivery record. I am trying to add a BP number and related…
  • 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…
  • 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…
  • 13th Period on Enterprise Management (X3)

    How do you deal with 13th period on X3? Making the last day of the financial year to be the 13 th period is not an option since we have transactions to post on the last day of the financial year. Anyone else who needs this functionality?
  • Add available stock qty columns from multiple sites

    One of the customizations we've added to our Sales/Bid Order entry line item screens is a column showing a product's available qty at the specified site. This is working correctly, however I would like to add more columns showing available quantities…
  • Entry Point FILTER in Process PAYPROPAL: Payment Proposals

    I have a problem with this Entry Point. I think it should be FILTRE not FILTER as stated in the Technical Help I created a specific script YPAYPROP1.src (see below) and assigned to standard process PAYPROPAL in Entry Points I have records in table…
  • Change text color

    I am trying to change the font color of particular records on a selection list. The selection list is built upon entering the SELECT action in GACTION. Below is the code that builds the selection list. When 7 Choose [F] & Where evalue(CRITERE) & evalue…
  • How to do I get a substatus to show in the recontrol box?

    Hi, I am having trouble getting the substatus to show in the recontrol box. I got the substatus to show as a select but when I select it, it shows the name of the parent status which is A. I want the box to show the sub status AR which I created. How…
  • 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…
  • Lock a Sales Order in V11

    Hello, I am currently trying to find a way to lock sales orders that are included in a specific table created when a user accesses sales orders (GESSOH). When I try to do this, however, X3 will not lock the sales order. I believe it is because of the…
  • Sage x3 Mobile interface, propagate fields by code or hardware button (Andriod)

    Hi all, We have SAGE x3, V11 patch 80.003, and we're facing some problems to propagate information after field insertion in the Mobile interface. What we pretend to do, is similar to the "propagate" action in classic Representations or "After Modification…