Browse By Tags

  • Is there a documentation for useful standard x3 functions?

    Hello Slight smile

    As a Sage X3 developer, I have found that there are many useful standard X3 methods.

    One example is closing a purchase order with 4GL code via script.
    https://www.greytrix.com/blogs/sagex3/2020/12/29/how-to-close-po-programmatically-using-4gl-script…

  • What is EOQ?

     is it estimated order quantity? Does anyone know the name of the column in sql? As always, your responses are greatly appreciated!

  • Adding Field to Screen

    Good morning Everyone and Happy Monday!

    I'm attempting to add PTHNUM to screen POH2, but I am receiving this error "Fields PTHNUM: Undefined parameter OBJZON ( Type VCR)." Does anyone know what I'm doing wrong and how to resolve this?…

  • Trying to read the products of Magento from X3 using rest api integration and Node JS Error

    Hi All,

    We are trying to read the product of Magento from Sage X3 using integration methods such as Rest webservices, Node.Js for one of our client. The Magento API endpoints uses 'OAUTH1' type of authorization for authentication of the Rest API…

  • How can I go about joining the SINVOICED table to the STOJOU table?

    As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

  • Previous record loaded after refresh

    Hello everyone Smiley

    Our customer wants to copy a plan by clicking on the corresponding right list entry. The copied plan should be shown afterwards.

    After clicking the right menu entry the following code is executed:

    This creates the new plan based on the…

  • Sage X3 How to modify window that shows up when i click selection icon?

    Hello,

    Im looking for a way to modify a numer of columns( i would like to add field from [BOM] table) in window that shows up after I click the selection icon(first screenshot). 

    Thanks for help

  • Switching between edit and read only Mode with global variable GCONSULT

    Hello everyone,

    For our customer we developed a specific screen to manage plans.

    In order to edit a plan the user has to press a check out button.

    The user who checked out the plan can modify the plan.

    In the FILTRE action we use the global Variable GCONSULT…

  • How to change Screen Input type from "Enter" to "Display" via 4GL?

    I have a need to set the format of fields on a screen to "Display" when a certain value is detected in a field.

    I know how I could suppress it conditionally, but that's not what I want to do.

    Basically... if I were writing the suppress for…

  • 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…

  • How to detect the newly added currencies in Currencies and Exchange Rate form on save button click?

    Hi all,

    On the form Currencies and Exchange Rate, I need to detect if user have added new currency on the currenciesGrid and prompt user and at the moment the Save button is clicked. But I am not getting much information about it.

    OnClick Save button…

  • Unable to Autoprint the Crystal Report in Sage X3 from web application

     We are creating Sales delivery from web application(Source code Java) into Sage X3 using Soap web services which is succesful. At the same time We are trying to autoprint the delivery crystal report after creating delivery in Sage X3 for which code was…

  • why i can't set query of VACITM facet to yes in ITMMASTER representation

    when i click on the query cell to change it to yes it just jump for initial state, but for some others columns it's ok

  • # in the screens evaluated titles

    Hello,

    I was manipulating the screens in the V12 (P24) and I have remarked that the # used in the beginning of formulas of the evaluated title is blocking the evaluation of the title in different languages.

    For example, in the screen BPR1, the evaluated…

  • Developer keys are no longer provided?

    Hello Community, I have learned that developer keys are no longer provided.

    Now I am facing a problem because I manage several customers that have different databases and components.

    What is the current procedure when my developer licenses expire.

    Should…

  • Insert/update row to tables of all other companies

    Hi all, 

    is it possible to do the following:

    - user update some foreign exchange rate on Maintain Exchange Rates Form of company A,

    - on click Save button, it will update on company C,D, and E as well.

    I know it is possible on executable application according…

  • How import assembly doc?

    Hi everybody.

    I need import assembly doc, but now in X3 V12 this object hasn't active import check.

    I try to active and create import template, but all time system says that first line are not completed, and don't create doc.

    First, in BBY Object…

  • Sage 50 CA integration

    I have an application that I need to have integrated with sage 50 CA.  I need to pull info and push back ap and AR invoices, projects and time entries.  Who can help me?

  • New Developer Community - Sage Developers

    Hi Developers, 

    We have just released our new and improved developer community. 

    The community is designed as a space for you to get social. Help each other out with technical and business issues, share your knowledge, thoughts and ideas, and keep you…

  • Change Report Name when printing

    Hi There

    For Sage X3 V12 

    I am trying to get Sage to print/save with different file name than the Crystal Report name

    Have added entry point AIMP3 custom script ZAIMP3

    Here is my code

    $ ACTION 
    Case  ACTION 
        When  "PARAM"     : Gosub PARAM
     Endcase…

  • AP - AR Accounting Supplier Invoice did not create accounting document after posting

    I posted two supplier Invoices and observed it does not create a journal. I checked the accounting task and the journal on hold shows two. I check recurring tasks for the active time and it's okay. I deactivated the accounting task. Restarted batch server…

  • C# web service wrapper on new net core/standard frame

    I’m trying to develop a c# wrapper to communicate with x3 SOAP web services with the new frameworks NET CORE, NET STANDARD 2.0 (on Xamarin).

    With this wrapper:

    https://www.rklesolutions.com/blog/x3-soap-web-services

    I can easily connect with old…

  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might).

    I have some ideas, but I'd like to know how others…

  • Script editor V12 & debug

    hi all

    how do you write & debug code in V12 ?

    I was told that I can only use eclipse and it is very slow to debug + performance is bad + weird to attach eclipse to a process.

    eclipse also disconnect from unknown reason during debug.

    thx

    Barak

  • Error on using ACCPAC libraries for custom 3rd Party Application

    Hi all, 

    I am developing an app using ACCPAC libraries:

    I have difficulty to do an Order Entry from my application, especially on setting the value of CUSTOMER (OE0520) and ITEM(OE0500), to do RecordCreate(ACCPAC.Advantage.ViewRecordCreate.Insert) fu…