• How to hide a field on Supplier screen for certain Function Profiles

    Hi, I want to hide Site tax ID no. field on Supplier screen to only certain function profiles. I tried creating an access code and adding it to function profiles but, access code is just preventing users to click on it. It is still visible to all the…
  • Error 26 : Internal error Inconsistent reference value (11026)

    Hello I get the error Error 26 : Internal error Inconsistent reference value (11026) at @X3.TRT/REQUETES$adx (153) when trying to read a custom table in a custom batch job script. Part of the key from the custom table is a counter variable which is…
  • Protect SQL Triggers from table validation and new releases

    Hello everyone When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched. Is there any way to create SQL triggers so that they are protected? Like activity codes…
  • Patch creation - include inquiry screen

    Hi togehter, we successfully modified an inquiry screen (added columns, changed order of the cloumns...). Now we want to share that inquiry screen with another X3 system. Unfortunately we cannot choose inquiry screens as an object in the patch creation…
  • AM_ call to update screen field does not update the field

    Hello, I am using a simple piece of code to display a field from another screen in Manual Matching (LETTRAGE). When placed in an infobox, the data displays correctly, but when trying to Affzo the field on the screen, nothing is displayed. When the…
  • Managed product status in Sage X3 ?

    Hello, I want to manage product status on X3. Our company rules define that no use of status Shortage and Not Renewed in our processes. So I don't want to see these 2 status on the "product status" list. Is it possible to change that and where …
  • Display an entered field from one screen on another

    Hello, I have added a text box to a product record screen to enter some notes related to the product. (table ITMMASTER, Screen ITM0) and called it ZITMNOTES I'd like to take this new field, and display it on another screen, for example, stock change…
  • I need your help with a small SPESDH modification

    Hello, I added the small piece of code below in SPESDH. The purpose is to calculate a field on the lines when the delivery is saved and/or validated. it only works if the delivery contains one single line. If I add a second line, the fields are calculated…
  • Editing Field to Screen

    Hi Everyone! I try to edit Column Type Input and chose Enter but after saving error will goes like this Does anyone know if I am doing this correctly? Thanks!
  • Code to query purchase pricing?

    We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…
  • Using a formula in sequence number definition

    Hi all, I'm new to Sage X3 so I need some help. I need to setup a custom sequence number definition for LOT managament. Let's say my number is 230623-A. The A would change and be typed in by the user. I figured I could use some custom fields from Entry…
  • Adding Field to transaction grid

    I am wanting to show a custom field in Pick ticket PRH1 from Item Master ITM. The field is showing, but it is duplicating the last line to all lines above. I have added the affzo, but I think I am missing the NBLIG and am not sure how to use it. The…
  • Fixed Assets - at expense creation pull in the ITMDES value to the Expense Description 1 instead of of ITMDES1

    Expense creation at the time of purchase invoice validation is pulling in the product's default description instead of the standard description ITMDES. Our users modify the ITMDES field with details we want captured on the FA Expense Description 1 field…
  • A processing line must not exceed 249 characters (line number in file)

    Hi, Was doing Patch creation (APATCH) to bring customization over. Noticed these errors: My temporary solution is to simply delete the linebreak character since if I do not do this it crashes the main screen function. Is there a way to resolve…
  • Intersite Stock Selection - Search by Status

    Hello, When selecting Stock for TSA - intersite transfers all (WT03TSA1), there is only a field to search for items individually. Last year, we had to intersite over 1000 products one at a time because each one had to be typed in in order to select…
  • How to tax specific line items when creating a PO?

    Rather basic question considering what I have seen on these forums, but, I cannot figure out how to do it. To further clarify my goal here, when creating a PO and entering each line item’s price and quantity, I would like an intuitive way to multiply…
  • Product selection fields in Stock Inquiries do not match definition in ITM object

    When using the Product selection icon in any of the STOCK inquiries (Stock by site used for example), the fields in the pop-up window for selection are not those defined by the Product ITM object selection. Where can I find the field definitions used…
  • What the equivalent of GPE = 1 in Class ?

    Hello, Using classic object, it's possible to use GPE = 1 in a specific process (a standard $ACTION-CREATION, MODIF.... ) ) to deactivate the standard action. What will be the equivalent in Class to pass by the standard $EVENTS? if possible? As an example…
  • On a screen with a table, how to identify a field code when I cannot click on the field?

    Hi, Rookie developer question here. This is on GESBIS, Screen code is: BIS3. Other than identify through Description and make best effort guess on the field's code, is there a way for me to identify the field name's code which I cannot edit on?…
  • How to add new field on sale invoice header for a specific entry transaction

    Hi all, I have added new field on sale invoice header section (screen SIH0), then the new customized field displays on all sale invoice entry transactions. How to add this field to a specific transaction or how to hide it on others transactions. I…
  • About ACTLSPE

    Hi, I used this: https://www.sagecity.com/us/sage_x3/b/sageerp_x3_product_support_blog/posts/how-to-determine-if-there-are-any-customization-in-my-installation Should I ignore the fatal errors here? The field was added for a very specific need with…
  • Dynamic field names in SEI

    Is there any way to have the fields/columns in an SEI report to have dynamic names controlled by a formula? My guess is "no", but thought I would ask. In my specific instance, I have fields like "Month 0" "Month+1" "Month+2" etc (the data is taken from…
  • New field on SOH2 screen but doesn't display

    I have added a new field ZPRDSCHD to the SOH2 screen, validated the screen, but it still won't display on the sales order. What step am I missing to make the display update to the changes I made on the screen?
  • 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
  • Grid Screen

    Hello! I'm Sage X3 developer and I having issues with Grid development. Does someone have a documentation about NBLIG, nolign, counters and grid screen? Thanks.