• Add field EANCOD in the inventory screen

    Hello everyone, Please I have a problem with adding the EANCOD field in the inventory screen, when I add it in the screen the field is displayed but empty. Please help me to solve this problem. thank you
  • Non-Conformance - help needed to add custom fields

    Does anyone know of any resources, tutorials, training sessions, etc... on how to edit the Non-conformance screens to add additional fields. I created a custom field to the table NCSRECENT, added it to a custom screen, added that customer screen to the…
  • ACLA: Opening the same table twice

    Hi, Planning to move a customized activity code from a Sage X3 server to another Sage X3 server. On the customized activity code Sage X3 server: Did a patch creation. Picked the custom activity code. Pre-load the object. When I press…
  • 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…
  • calculate available stock

    Hello, i want to add a field in my MGB screen that contain avaible stock , so i added a field type QTY but i have no idea how to write function in spe script that calculate availble stock !!!!! please help!! i'm under X3 V11
  • within generate porder from prequest

    Hello everybody i'm about generating purchase order from purchase request , the probleme that i want to pass a field value as params from request line or header to all line in the order thank you
  • Looking for the sales FOB field in sage x3

    Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. Thank you in advance!
  • How can I link the following tables (SDELIVERYD, MFGITMTRK, ITMMVT, ITMMASTER, STOJOU) "Graphical query"

    I tried with all possible keys, but I still have a problem with the connections in between the table. Please, can anyone help me? I intend to create a query that presents all shipments and all production follow-ups made on a date and the respective accumulated…
  • Error when updating product codes in Sage X3

    Hello all, on Sage X3 v8 I get the foolowing error when trying t update a product description. The data that are being updated are locked by another user () Do you want to try again? Any ideas or thoughts on what could be causing this?
  • 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 .
  • 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…
  • 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…
  • Validation rule on a custom field

    Hi all, I would like to know what is the best way (step by step) to create a rules/automation on a custom field. I have a field on SIH0 screen, It is a type A field: 1 - When creating the register, the system populates the field with a sequential…
  • 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…
  • 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…
  • 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…
  • Exeception error with Eclipse editor

    Exeception error with Eclipse editor .Working wth Sage X3 6.5 .I opened, Developement>>Processing>>eclipse editor null/eclipse.exe java.ioExeception: Cannot run program"null/eclipse.exe": CreateProcess error=2. The system cannot find the file specified…
  • Date 4GL incompatibility

    Hi, How do I write this 4gl statement for a Date Datatype? Subprog C_DAT(VALEUR) Variable Date VALEUR If VALEUR = "" mkstat=2 GMESSAGE = "Date is Mandatory" Endif End This is throwing an incompatibility error because I think you cant write…
  • User Groups

    Hi All, In Administration > Administration > Users > Groups , is there a way (in code or otherwise) to get hold of the Role, users linked to group and Endpoints? I've tried to get into the representation but it is not listed in the dictionaries. I…
  • 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…
  • 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…