• 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…
  • Unknown warning upon login - Access to the ERPMAN badge(s) has not been granted

    Hello, One of our user groups randomly started experiencing this warning upon logging in. Does anyone know a fix? Thank you, Zoey
  • Home Pages - Process flow

    Hi folks! I am working on landing pages and I am still not getting this right. Has anyone been able to customize pages? I would like to make this visible in my Test Page
  • Graphical Query tool - selection criteria based on Expression

    Trying to create a query based on items that are out on loan to customers. My query includes an Expression calculation based on what has been delivered to a customer minus what has been returned. So using two tables QTY on SORDERQ-RETURND, therefore…
  • Cost production export for comparasion purpose

    Good Afternoon, I need to know if it's possible to export the BOM structure massively and with a connection to the my Sales Products for consulting the consumption history of components, and if possible, also export the Operations for consulting the…
  • 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…
  • Vendor or Supplier Grading

    Group, A question from a co worker was asked of me a couple weeks back, and I'm late asking this question. Does Sage have report cards, vendor grading capabilities? Doesn't have to be anything too complicated. The basics would be a great start. I really…
  • Entry point not called

    Hello everyone I try to implement the entry point https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR.htm#APE_30_10 with action REQUETE. I created the entry point and the processing script in the X3 folder…
  • Customizations in X3 folder

    Hello everyone We sometimes have problems when a batch job runs more than once. In order to prevent this we want to use the entry point SERVEUR with action REQUETE https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/OBJ/ADC_SERVEUR…
  • 404 not found error when creating new request object

    In code block below I am getting a 404 error when creating the request. I assume i need to provide the full path but can't find the documentation as to what that path is. This began with the lastest patch level. It worked as is before this. Anyone…
  • pass a field from sales order to sales delivery based on the sales order number

    I want to pass the sales order qty field to the delivery to compare and control the delivery qty(control table ) i see the control table work on the same screen.
  • Target entity not found

    Hello everyone, When trying to create a sales invoice in a custom development we get the application error 162: Target entity not found[D,A,A2,464]. Error code is 102. Unfortunately the error message not helps me to identify the cause of the problem…
  • custom field

    Need help with new custom field formula. I create custom field "Net Available Stock" I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…
  • Projected stock for all raw materials

    Hello Community! My company has a large database of raw materials, currently the purchasing plan is done manually using MRP results along with checking Projected for each raw material , one at a time. As such it's a very tedious and inefficient process…
  • Convert GMT datetime to local datetime

    Hello I want to delete database entries which are older than 15 minutes. datetime$ returns the date in GMT time zone. But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…
  • Adding Total Deposit to Left List On Manual Remittance Screen (GESFRM)

    I'm trying to add the total deposit on the left list on the Manual Remittance Screen. This value is a summation from the PAYMENTH table on the field AMTCUR and is present on the screen as "Company Total." I'm struggling with how to go about this because…
  • Confirming of Purchase Order

    Hi All :) Good day, what are the ways to confirm PO? I know there are many processes, such as supplier confirmation and signing workflow, but I would like to customize it by having a field called 'Confirmed to'.
  • Entry point when report is finished printing

    Hello We have the problem that sometimes the print server not prints out a report. Even though we started the print for a document (e.x. purchase order) in 4GL with the following code: For a custom development we are looking for an Entry Point which…
  • 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…
  • Add search criteria to inquiry screen

    Hi there, I successfully added the "internal reference" field from the purchase order to the "Order lines inquiry" screen. Now we want to add the field to the filter. I already added and "linked" the header and cirteria fields in the "CPP" inquiry…
  • 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…