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…
  • How to disable Convert to Opportunity until a certain state?

    Hi all, I want to create a Lead approval workflow. It is consist of few stages: Start, approved, not approved, resubmit, and Final Rejection. I do not want to allow the Lead to be Converted to Opportunity until it comes to the final state: Approved…
  • Product Site Clarifacation on What the Logic is

    Hello, am wondering if someone can explain the logic behind Product Site Default Location setup? Problem: Snap shot above is how we are picking our apparel for replenish to work, but I don't think it's setup right 100%. Does anyone have any expierence…
  • 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…
  • Display modified fields in a workflow programmatically

    Hello! I have created a simple workflow and script to display fields that have been modified in a PO where the cost is over $10,000. This works by checking the [M] field against the base [F:POH] field, and using RETVAL to display the changed information…
  • POHSIG Workflow signature

    Hi, I'm trying to modify a standard workflow rule POHSIG to automatically sign PO if [F:POH]TOTORD < [F:POH]CREUSR maximum value But it works only if user that creates PO is in the first line of Rule values. For Example how it works in standard…
  • ASYRWRKSIG Workflow approval link Error:

    Hi All, Please assist as to what might be a solution to the following error for workflow approval links: {"$diagnoses":[{"$severity":"error", "$message": "X3 engine error: D:\\Sage\\X3APP\\Folders\\X3\\TRT\\ASYRWRKSIG.src : File Non-existent ()…
  • 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…
  • 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…
  • 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…
  • 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?
  • 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…