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…
  • 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…
  • 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?
  • Adding new Document Type for Doc Transmittal

    Hello, Using customizer, we are able to add a new document type for document transmittal into the 'other contacts' window (from maintain customers). We have created a custom table to store the value and can join back to tcicontact through the cntctkey…
  • Blank stock AP check printing and signature, Sage 500?

    Is there a way to print blank stock checks in Sage 500? My AP person doesn't want to use pre-printed checks. Also, how do I add a signature to the AP check print form, Sage 500? I'm so used to having source code, I was a former developer, so I'm having…
  • 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…
  • How to add What's This? help to a custom field?

    I am missing the link (secret handshake) somewhere and would appreciate someone pointing me to the right direction. My goal is to enable What's This? right-click context-sensitive help for a new screen that I am building with the Sage 500 framework…
  • Is there a way to access the db connection(for temp tables) that Sage uses in vbscript?

    On the customization of the SO form, can we access the db connection that Sage is on for updating the temp tables, which otherwise are not accessible from another connection.
  • Looking for way to restrict labor progress entry to certain users.

    I'm looking for a method to restrict labor progress entries to certain users, user groups, ect... Possibly a vb script through customizer?
  • Cannot change script language from VBScript to JScript

    I would like to change the scripting language in an event in a Form Script Editor, when when I change the Language pulldown menu from VBScript to JScript, I get an error dialog with the text Script language changed. Modify existing script's syntax to…
  • Looking for Form_Save Event documentation

    I am trying to find documentation on what is in the oDM parameter ("data manager object") in the Form_Save subroutine in the Save Event, specifically in the Enter Receipt of Goods Form (PO Module). Can someone post info on what what I have available to…
  • Error calling DLL code from VBScript

    Back again with a specific bug... I have customized the Save Event in the frmBatch object in the Process Receipt of Good form: Sub Form_Save(oDM, bSave) Dim objApp, result Set objApp = CreateObject("LMNO.PrintNewLabel.FormSave") result = objApp.PrintBatchLabels…
  • Change default PDF Attachment on Customer Statement

    Is there a way to change the default naming convention on the PDF attachments when performing document transmittals in the AR module? MAS500 by default uses the customer number. We would like to use the customer's name so that the email looks more business…
  • How to implement Dashboards

    I'm new and would like to implement so i can learn, business insights dashboards. sage 500 7.40.8.0