• 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…
  • Row Level Permissions

    Hi, Can anyone advise how to increase a limit of row level permissions (Parameters --> Users --> Users --> Organisation) in user setup? It is set to 10 in my organisation and I need to be able to add more to some users. Thanks Ania
  • 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…
  • Sage X3 V12 Shortcuts

    Hi everyone, I came across these excellent and useful to improve navigation on X3 V12. A. Right Panel Actions ESC + N – new ESC + B - save ESC + C - create ESC + D - delete ESC + E - cancel ESC + ALT + U - refresh ESC + ALT + P - print…
  • How to deal with an entry point called twice.

    I've been working on a workflow that triggers on creation of a shipment. I'm sure you're aware that these workflows will work just fine when creating the shipment manually, but when leveraging the batch tasks FUNAUTDLV and FUNPREDLV, the workflow doesn…
  • Trolley Build Function Sage

    I am wondering if anyone out here has had any experience with the trolley build features with Datalinx? We are thinking of exploring "picking to slot", "Trolley Build", "picking to Carton" functions in our warehouse. Would love to pick someone's brain…
  • Force to open [M:ENM] to modify stock movement through code or configuration

    Is there a way to force the popup screen on a qty line modification of a purchase receipt?
  • Adding ITMBPC field to screen ITU

    I've set up a custom field in the ITMBPC table to denote that a particular customer product needs to have a special dispatch label printed. It's a simple yes/no, so I have linked it to Local menu 1. How do I get it to display in the ITU screen so that…
  • 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…
  • I am trying to create Fixed asset, following error occurred

    I am trying to create Fixed asset, following error occurred. help required. Fixed Assets>Fixed Assets> in the field Accounting code>ITEQP ITEQP The Co. fixed asset account associated with the accounting code is invalid or its nature is incorrect
  • How to generate/download SEPA Credit Transfer XML file

    Hello Everyone, Can anyone let me know that how to download SEPA (FRA legislation) XML file after posting payments through manual remittance. I am not sure whether any other software required to download SEPA XML bacs file or any special setup required…
  • Packaging Consumption in Work Orders

    I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
  • PAYMENT DESCRIPTION NOT FLOWING TO GACCENTRYD DESCRIPTION TABLE

    Hello All, Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table. I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
  • Recursive Funprog 4GL not working

    Hi all, i have a problem with this function: Funprog SUM_TOTAL(PROJECT,BUDGET) Value Char PROJECT Value Char BUDGET Local Decimal TOTAL If !clalev([F:PJBU]) Local File PJMBUD [PJBU] : Endif If !clalev([F:PJLB]) Local File PJMBUDLIG [PJLB] : Endif If…
  • Clob Field not Pulling Values(Menu item)

    Hi I have a task where I have to add a Text Field(CLOB) on the customer screen as a menu item(on right side) So far this is what I accomplished 1.Added menu item and Enabled it in SETBOUT 2.Created a new screen(ZACLOB) with a CLOB field When…
  • Integration with MS Office: The object does not accept the property or the 'getLanguage' method // El objeto no acepta la propiedad o el método 'getLanguage'

    Hi There, I am trying to integrate Sage x3 v12 with MS Office, and I am facing the error below, when setup the datasource: Cannot read property 'shortDate' of null --------------------------------------------------------------------------------------…
  • 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?
  • Attach pictures to sales invoice - several pictures at once.

    Hi there, I have been attaching images in sales invoices in the Attachment section of the Invoice record, it takes time to do but in the long run when we have more images then one. Question: When attaching the Images I have to do them one at a time…
  • 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…
  • Updating totals through code

    Hi Guys I'm quite new to how the development works in Sage X3 Am trying to calculate totals based on a currency on the Purchase order Screens Have added a new field to the Purchase Order table and POH3 screen field: ZTTVORD so based on the currency…