Browse By Tags

  • Customer BP Invoice Function , Field (TAX) allows for display/input.

    Hi Sage X3 Folks! Can the 'Tax' be inputted/edited in the Customer BP invoice? I am not sure about this process. I already changed the input to enter, but still no luck. Any of you know this process?
  • Setting Zones in Sage X3

    Hey All, My company has purchased a wave picking function in Datalinx. During our first brainstorming session we've brought up Zones(zoning our warehouse). We believe we need to set zones as we go down this road. Problem is where to start? My question…
  • Home Pages - Process flow

    Hi folks! I am working on landing pages and I am still not getting this right. Has anyone been able to customize pages? I would like to make this visible in my Test Page
  • 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…
  • Third Party Developer Recommendation

    Hi Everyone, We are looking for a third-party developer that can assist us with the following: Custom Development of an application that replaces our current developer. Our current developer has created a ton of 'apps' over 10 years that simply…
  • VIREBOUT DON'T DISABLE NEW BUTTON

    Hi. I have v12 (2023 R2 (12.0.34)) and I create new window type Miscelaneus and Display = Full screen. I add two new buttons with code z an i , one validating and another no validating. In SETBOUT ACTION, I add this lines: Call VIREBOUT(CHAINE…
  • Running a Crystal Report with a range parameter from Web Services using (CWSGPRTRT) Generic Print Report

    We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
  • Call script method from another folder

    Hello folks Is there any way I can call in folder A a method from a script in folder B? Something like this? I'm writing an entry point which must be written in X3 folder. We have library scripts in not X3 folder. Instead of copying those library…
  • Filter of registers to be exported by Script from model export

    Hi, Is it possible to create an specific script, in model export, in order to filter by code some registres to be exported? I need it to check a value from a table that is not linked to the model's object Thnkx
  • SafeX3 - 4GL - BlbFile conversion

    Hi, I need to convert a string from base64, I use the function YLEN=b64Decode(YB64RES, YBLOB). Then I would have to convert the BlbFile back to a ClbFile or Char (I need to parse it) but I wouldn't want to have to write YBLOB to the filesystem and then…
  • 404 not found error when creating new request object

    In code block below I am getting a 404 error when creating the request. I assume i need to provide the full path but can't find the documentation as to what that path is. This began with the lastest patch level. It worked as is before this. Anyone…
  • Use SOAP Web Service to create quote issue.

    I have a integration service do so a series integration. If there is any error, when create quote SQH, it will give error: @X3.TRT/SUBSFIT$adx (149) Error 7 : Class Non-existent [M:SFIT] 0 : Sage X3 errors After restart the X3 SOAP Web Service then…
  • Default value for specific components

    Hello, Im looking for solution to add default component value in function GESDBY Disassembly. I tried to use something like this: $APRES_CRE For i=0 To max([M:DBY1]NBLIG -1) if [M:DBY1]ITMREF(i) = "X" [M:DBY1]PRIORD(i) = 17 Affzo [M:DBY1]PRIORD…
  • Filter by comparing 2 columns value error

    Hi all, I have this SQL query where I have a whereclause l.LineQuantity>six.TriggerQty select c.CustomerAccountNumber, c.CustomerAccountName, h.DocumentNo, si.Code as ItemCode, si.[Name] as ItemName, pg.Code as ProductGroupCode, six.TriggerQty…
  • Much weirdness Creating Purchase Order via the SDK

    i'm creating purchase orders via the SDK using the examples in the help as a template. basically create a poporder, assign the supplier, add lines confirm and post. What appears to be happening randomly (on customer site, i have not managed to see it…
  • Join tables produce ambiguous error

    Hi all, I want to join StockItems and StockItemSupplier table using Sage.ObjectStore.Join below. StockItems sis = new StockItems(); try { Sage.ObjectStore.Join join = new Sage.ObjectStore.Join(); join.RightTable = "StockItemSupplier"; join.RightTableAlias…
  • Historical Data Conversion in X3

    What is the best way to convert history from a legacy system to X3. Import templates are excellent for AP, AR, GL, SO, PO, etc. However, these are open balances. What is required to import several years of transactional history? Gosh, this is a good…
  • 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…
  • Convert GMT datetime to local datetime

    Hello I want to delete database entries which are older than 15 minutes. datetime$ returns the date in GMT time zone. But the database entries are stored in CET time zone (CREDATTIM column). The comparison not work as intended because of the 2 hours…
  • More information about web server errors

    Hello everyone When trying to create a sales invoice in a custom function we get the following error: Unfortunately it is very hard to find the source of the problem with only this information. Can I get more information on web server errors? For…
  • Confirming of Purchase Order

    Hi All :) Good day, what are the ways to confirm PO? I know there are many processes, such as supplier confirmation and signing workflow, but I would like to customize it by having a field called 'Confirmed to'.
  • 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…
  • How do I trace Transaction Listings in Sage 200C On-premise

    We have Sage 200c On-premise. The schema comprises of a Cube, Warehouse and Finally Sage Database. How do I know how data is being surfaced? Example: How do I trace data from Opening Balance, Transaction Listings (movements) through to Closing balance…
  • Need explanation how POPStandardItemLine works

    Hi all, I am looping the POPStandardItemLine or an Order using foreach loop. The item lines in the order consists of standard order line and a charge line. While looping, I encounter an error. this is because 1 item in the POPStandardItemLine is…
  • 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…