Browse By Tags

  • 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…
  • 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…
  • Code to query purchase pricing?

    We have a scenario where we direct ship product from a supplier to a customer. Because of this and because we want to see accurate sales margins on the sales order, we have a need to change the cost of goods on our sales order entry screen so that it…
  • "Tax Excluded" invoicing element still charges tax

    Hey Everyone, About a year ago, someone had set up a "Fuel Surcharge" invoicing element that applies a $5.00 charge to every order. However, it was supposed to have tax excluded. To this day, the $5.00 charge is actually $5.60 because it is being charge…
  • 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…
  • Script does not update field value if the line is not entered

    $VERIF_MOD Local Char ZPRODCOD(30) Local Char ZPRODCODOLD(30) Local Integer YESNO YESNO =2 For i=0 To max([M:POH2]NBLIG -1) For [F:ITM] Where [F:ITM]ITMREF = [M:POH2]ITMREF(i) ZPRODCODOLD = [M:POH2]ZPRODCOD(i) ZPRODCOD=[ITM]ZPRODCOD if…
  • How to store Blob image's type in a table ? / Comment stocker le type d'image Blob dans une table ?

    I created a custom screen where I am displaying images related to drivers. I am using a datatype of ABB, Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen ITM1 there is the…
  • How to store Blob image's type in a table ?

    I created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen…
  • Patch Upgrade 12.0.20 => 12.0.30

    Hello, I need help with a question is it possible to upgrade our sage x3 release from 12.0.20 directly to 12.0.30? or or do I need to upgrade patch by patch ? appreciate the quick response Regards A.K
  • 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?
  • Implementation problems with specific inquiry

    Hello everyone We have programmed a specific inquiry for our client. There should be a back and next button. Only a part of the data records should be displayed. When you click on next other records should be loaded. In the function GESGTC (Inquiry…
  • Is there a documentation for useful standard x3 functions?

    Hello As a Sage X3 developer, I have found that there are many useful standard X3 methods. One example is closing a purchase order with 4GL code via script. https://www.greytrix.com/blogs/sagex3/2020/12/29/how-to-close-po-programmatically-using-4gl…
  • What is EOQ?

    is it estimated order quantity? Does anyone know the name of the column in sql? As always, your responses are greatly appreciated!
  • ADC location override

    So I have been presented with an interesting challenge. In our company we've set X3 to batch allocate all available stock to meet all demand in the system. We also heavily leverage X3's ADC functionality. Our warehouse users are able to override the…
  • How import assembly doc?

    Hi everybody. I need import assembly doc, but now in X3 V12 this object hasn't active import check. I try to active and create import template, but all time system says that first line are not completed, and don't create doc. First, in BBY Object…
  • X3, Errors after Update to X3 v12.0.23

    Hello Everyone we updated a X3 system from v12.0.21 to v12.0.23 , but just the X3 folder was updated (not the other live folder)! and now we get these errors like this (and the .src files are not in the TRT folder) is it that we should just select…
  • How To Replicate Same Folder, Same SQL Database from a Production Server to a Data Recovery Server Automatically

    Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks
  • I cannot set the item's Sales Unit when I register an order via SOAP

    Hi, I cannot set the item's Sales Unit when I register an order via SOAP. The POST request sends something like: ... SAU: "UN", QTY: "", SAUSTUCOE: "1", STU: "UN", ... But the order resets to the standard "PCT" sales unit. can anybody help me…
  • 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…
  • Validate PO Invoice with Webservice

    Does anyone here have any idea how to validate a PO Invoice using a webservice, or other similar method?
  • 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?
  • i can't add new field to screen

    i'm trying to add field to screen ,in the first level i add a field to table then i used it in screen but an error has displayed thank for helping me to solve the problem