• Monitoring SALES Price Changes

    Hello, I’m looking for a way to track Sales price changes over time in Sage. We work with three types of prices: FOB (Free on Board), customer prices, and customer region prices (which include freight). Right now, the SPRICLIST table only updates prices…
  • "Activating" 3 statistical group fields in screen POH2

    Our customer would like to be able to specify Statistical Groups for products on PO lines. Normally, when the stat. groups are assigned at the common data product level, reporting could retrieve the values from there. But these are generic products so…
  • Screen Modification

    We are using Sage X3 v12. In the Sales Order screen, we need to highlight closed sales orders with a "CLOSED" watermark when opening or selecting a sales order. How can I achieve this?
  • Compile all specific scripts

    As per title. Sage X3 v12p31. There are issues with the .adx copy of the specific script files and I want to know if Sage X3 has a function that can recompile all the .src specific scripts files. Tried dictionary validation but it does not include…
  • Import multiple files from a directory

    Good morning. What I want to achieve is that the user can select a folder (local or storage area), and X3 reads each file to process it. Currently I have done for 1 single file with COPSRV to open the file explorer and select the file to process. Is…
  • Unable to delete a user in X3

    I cannot delete a user in X3. Getting the below error: I would really appreciate a solution here.
  • W1SIH0$adx (580) Error 39 : Non-existent Label AM_BPCINV

    Sage X3 v12p31. For Sales Invoices screen, I have a custom field. After modifying the `Bill-to customer` (BPCINV) field, the custom field will be updated. A custom AM action was set to BPCINV field. I have added the necessary code to the AM_BPCINV…
  • Customized Screen

    I am using Sage X3 v12. There are some customized screen in the system that were created before, but it not appear in the navigation bar now. The window code is YWOOPT , the screen code is YWOOPT , and the function code is YFUNWOOPT . How can I fix this…
  • Custom Field automatically updating when re-saving record

    We have a custom dropdown menu field on the Product - Site (ITMFACILIT) level with a handful of options on it. We have an issue where if we create a new product-site record for a product, that field will remain blank, but if we update any other fields…
  • Pick Ticket Time Tracking

    Hello everyone, I'm looking for some advice in implementing time tracking for the amount of time that has elapsed since the pick ticket has been "in process", up until it is marked as "deliverable" Has anyone done this before and what's the easiest…
  • Product Number Character Length - Need 30 Characters

    Hello Sage Community, Is there a way to increase the item number field from 20 to 30 characters? Below is an example of an item that is 24 characters long. HDAMTLN450-3545-180TJ-25 HD = heavy duty version AMT = a particular style of #######, with…
  • Product Numbering

    Hello Sage X3 Community, We are in the early stages of implementing Sage X3. Several of our product numbers have a period in the number. Our product guides are printed with the numbers with periods and we do not want to have to retrain our customers…
  • Field Dependency

    Hi There, We have created a custom field (picklist) on the Pick Ticket. This field lists the names associated with the Shipment Site. When a pick ticket is created, it already has the associated Shipment Site there, we need the values in the picklist…
  • Mapping Custom Fields

    Hi There, We have created a custom field called External Shipping on the Order table and require the input of that field to map over to the External Shipping on the Pick Ticket. What are the steps to pass this information over. Thanks.
  • Adding a entry field from BOM on the MFGITM line

    Hello There I want to populate a field in the BOM Header called ZASSEMBD (Assembly Departments) and display this information on the MFGITM Line. I managed to create the field in the tables MFGITM and BOM, and I also added this to their respective screens…
  • How does Sage:X3 recommend we manage a supplier that has ONE SUPPLIER CODE and multiple locations, items and contacts?

    How does Sage:X3 recommend we manage a supplier that has ONE SUPPLIER CODE and multiple locations, items and contacts? Previously, our AP dept allowed us to create a new supplier code if the supplier had different locations/item numbers (so one supplier…
  • Populate custom field in a grid

    Hi all. I would appreciate it if someone can help me with the following: I need a custom ZLPNNUMBER field on the PKP2 screen to be populated from the STOCK table based on the line LOT and Sub-lot fields on a grid To do so I added the following…
  • ZONSUI no works

    Hi I try to use zonsui to move cursor in a grid. In After modif subprog field, I added zonsui = "NAMEFIELD", about another field from grid. This optioon no works. I try too zonsui = "NAMEFIELD("+num$(nolign-1)+")" , but no works too. Version…
  • How to call action flags in "Standard Processing" types of functions - FUNCLEAR (Close & Reopen Purchase Orders)

    Hello! I've added a field, ZMNSTA, to the CLE2 (Close & Reopen Purchase Orders) screen, in order to display a custom field from ITMMASTER for each product. However, upon entering my code into SPECLE2, it seems that no actions are being called at all…
  • add field in receipt with stored information product.

    Hello, Please i'm traying to add field to receipt line document with designation 3 information product. Can someone help me please?!
  • Difference of Table Fields and Screen Field

    Hi All, I have been using table fields to upload and connect it to its respective screens while working on an import template. But in address tab it uses "Screen fields" Does anyone understand the purpose or difference between the following fields…
  • Is it possible to change a field title in Sage X3?

    Is it possible to change a field title in Sage X3?
  • Use table from another folder

    Hello everyone In X3 documentation it is described that it is possible to use a table from Folder A in Folder B. https://lvexpertisex3.com/x3help/ENG/V7DEV/4gl_file.html I tried it like this: Unfortunately it doesn't work with the period between…
  • Call script method from another folder

    Hello folks Is there any way I can call in folder A a method from a script in folder B? Something like this? I'm writing an entry point which must be written in X3 folder. We have library scripts in not X3 folder. Instead of copying those library…
  • Undefined parameter LEG

    Hello All, Kindly help, I am getting error message when I try to validate payment screen (PAY00) I increase the description field length to 150 characters and when I validate the PAY00 screen, I am now getting the attached error message. How can…