Browse By Tags

  • Deleting Sage X3 folder from database

    Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…
  • Packaging Consumption in Work Orders

    I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
  • How to modify the quantities of a delivery and its movements of stock through code or import / export template

    I have a validated delivery to which I want to modify both the delivery quantities and the quantities of the stock movements made; I need to do it by code or template. Would anyone know what template to use or how could I develop it?
  • A Pen Sign appeared in right list

    Dear Mates. I am working on X3PU9 with a fully customized screen, however, a pen sign appear in the right list and blocking me to do any action on the screen. The message showing "You only have viewing rights...". I am accessing with 'ADMIN' Id, which…
  • BPSNAM: key too long 505(500) error appears when trying to save a new field in BPSUPPLIER table

    Hi, Please I was trying to add a new field to a table when trying to save it pops up this error..please help me Thank you .
  • Accounting task issue after migration from V6.5 to V11

    PLease i need help. I m doing a migration from v6.5 to v11 on Oracle database.The migration went without error but the challenge is that i can't run the migration plan because the accounting task is still on progress. I tried to delete the value of…
  • 'Jump to' function navigate to Journal Entry

    Hi to all brothers & sisters I am currently working on X3PU9 navigation function (Jump to) in table (NBLIG) from customized screen to Journal Entry. I did realized the GAS object is using HAE3 as index key. However, when i apply the code, it not able…
  • What is a variable

    A variable is used to store information to be referenced and manipulated in a computer program. It can also be defined as a keyword used after a Subprog or a Func declaration, to define the type of arguments transmitted to the called code. A variable…
  • Misc. Table Value deletion

    Good day, Has any one encountered an issue where they try to delete values from a misc. Table and get a type incompatibility error? When deleting the table, I know you have to remove the references on tables, screens and classes, but even then you…
  • Sage X3 - Print reports to Email

    Good afternoon. With the need of one of my clients to send all kind of reporting by email we came across a problem. We used the ARP event to manage the workflows so they could send the message with their report as an attachment. This worked smoothly…
  • Add Line to Grid

    HI all, in Sage X3 v11 I need to fill a grid on click but I can't find a way to add lines to my grid, can someone share a script to help me, i'm currently working on Sage X3 SPE Script of that window?
  • 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…
  • List folder content in native mode

    Hi We have tried listing folder contents using this two approaches without success. First approach used to work in classic mode. 1. Call SYSTEME2(adxmac(0),"LSADX"-FOLDER,"",FILCOUNT, FILLIST) From ORDSYS (error, 'Unexpected end of JSON input') …
  • Get REST webservice photo

    Hi, I created a specific table to store some information.. One of the columns is a photo (blob)... How can I consume them via web service to show the photo on an external HTML page? In the picture below, BLOB_0 is my field where the photo is. How…
  • [Sage X3 V9] How mass save Object for dependencies and consistencies?

    Hi, I'm new here, currently using mass update function for increase of contracts' price by a fixed amount, how can I, after that, save all contracts so dependencies and consistencies are calculated? (refer object CON) A button with script method would…
  • 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…
  • 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.…
  • How to filter a field in classes and representations

    Hi, I'm a SAGE X3 Developer and I'm trying to filter a property (the ALOOKUP popup) in classes and representations... I need something similar as FILTSUP / CRITERE that used to work in Classic Mode. The highlighted field in the right (Artigo sem…