• Where does a cash requirement table TMPCSRQ get populated?

    Does anyone know where or how a cash requirement table TMPCSRQ gets populated? The report code that is used is NA-CSHREQ.
  • 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?
  • 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…
  • 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…
  • 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…
  • 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.
  • 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…