Browse By Tags

  • 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…
  • Planning work order material import for BOM change

    What is the best way to update planning work order material based on the updated BOM? There is no standard import template for MFGMAT. Users requested that they have three old components that is in 189 open work orders that "builds" phantom part# to…
  • Workflow line not working

    Hello, I am trying to get ITMREF into a workflow when sales order is deleted. Below is my setting, but it does not send any email. Any clue to troubleshoot this?
  • What data is passed through AWRKMEL? Workflow code [F:AWA]CODE is null

    Hello, I want to change the workflow sender depending on the workflow code [F:AWA]CODE. The workflow code in question is ZTEST However, in a custom ZAWRKMEL script, the [F:AWA]CODE value does not seem to pass through. The result is an email sent by…
  • Manual Matching (LETTRAGE) screen - actions are not being called?

    Hello, I want to make a simple specific script modification for the manual matching screen (SPELTR) however, it seems that actions do not work on the screen. The code is as follows: $ACTION Case ACTION When "AVANTBOUT" : gosub ZSOLCPT When default…
  • Menu item - type: query - "where" parameter operators

    Good morning, I'd like to filter a query for a landing page on my X3 v11. I see on X3 online help that you can add a "where" parameter to a menu item and add sdata conditions, but the help says: Only simple conditions using "le", "ge", "eq", "lt"…
  • Display a screen field as a searchable entry in the browser object - is it possible?

    Hi there, I have a need to display the total debit [M:HAE2]TOTDEB and total credit [M:HAE2]TOTCDT screen fields seen in the bottom left of this screen (GESGAS) in the Accounting Entries browser object (GAS) shown on the left. You can see where I've…
  • View Archive Folder scripts from the Web Service script editor

    Hello, I want to make some modifications to SPEITM, but I noticed that our Sage x3 provider has done some of their own in a custom file, YSPEITM which they've called at the action runtime in SPEITM: Unfortunately, this script does not exist in the…
  • Delete/insert lines with SOAP web service

    Hi, I don't understand how to set up the parameters to insert and delete lines via web service; actually, I can't find much on those parameters in general (their definition, when should I use which, etc). A simple example would do the job as well, I…
  • 1) Mass delete BPS Invoices 2) DocLink/DocAlpha

    1) Is there a way to mass delete BPS Invoices? I have 1900 to delete. 2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha. This is the second or third time it has happened. Does anyone have advice on what might…
  • Batch server difference between U9 and V11/V12

    Hello, I'm curious to know what is the main reason to change the batch server from the application server to the syracuse server level. Any idea about the advantage or the improvement reason behind this major modification ? Can we always check by…
  • Connect Existing DB Server to Brand New App Server

    Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…
  • Slow performance on CREATE invoice after upgrade to Sage x3 v11 patch 18

    We get more that 30 seconds to be able to CREATE an invoice. After create we can work/change/validate/print the invoice with no problem or delay. Any ideas or same problem\ solution ? Best Regards,
  • Which is the right Syracuse Hotfix for v11?

    There was a KB article #106630, which was for Syracuse 11.22.4.1, which was a hotfix for 11.22.2.1 and addressed the & being replaced with &. But now that KB article no longer exists. If you search the KB for Syracuse you'll find the original security…
  • Setup User Profession Code

    Within the General tab of the Setup User screen there is a field for Profession Code. 1. What does that equate to in the scheme of things? (Role/Group?) 2. Is it necessary to have a value in that field? Typically we only enter Login, Menu Profile…
  • Folder validation takes forever to complete

    Folder validation on Sage X3 V11 Patch 13 takes forever to complete. The process is taking over 6 hours after which the server will not be accessible. IT team will have to restart it and the validation will have to be started afresh. The applcation…
  • Action that opens a window

    I've started doing some very basic scripts in house but I've run into a wall recently. I'm trying to emulate the same behavior that is seen with MANHLDREL tied with the manual hold button on the SO screen. That is, when the action is triggered, a window…
  • Requirement parameters

    In requirements parameters, replanning rules, if I set the type WOF to simulation, I don't get any WOS's. When I set the method to Messages only, I get WOS's but the message is to Cancel. Also it seems to be planning for way too much expected stock. I…
  • Is it possible to automate the printout of the Recurring task log?

    when running FUNAUTDLV via a recurring task batch job, we would like to be able to print the log file that gets generated as the task completes. Is this possible ? we are using V11 Patch 11
  • Journals on hold when accounting task active also

    Hi All, In my Sage X3 database journals are on hold when the accounting task active. When i post supplier invoice it does not go to GL. Any idea?? This is new database.
  • Import/Export template for PJM in Sage X3 V11

    Hi all, are there any default import export template for the object PJM in Sage X3 v11? I can't find it anywhere in my Sage X3.
  • 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?
  • SAGE X3 V11 Fixed Assets Subsidies Calculation

    Hi All, i am looking for fixed assets subsidies calculation, can any have setup by setup calculation please help me. Thanks,
  • Error in enabling Invoice function - No transaction authorized

    Hello, I enabled the module "Purchasing" for a user, most of the sub-functions are working, however, some functions are running into the error below: I'm trying to enable the Invoice function: These are the user settings, it is a test user…
  • 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') …