• 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…
  • 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 ?

    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…
  • 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…
  • 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…
  • 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?
  • Creating new BP address field on Delivery

    The requirement is to print the company name, address, and contact details of the party responsible for paying for duties/taxes on a delivery. This may be different than the BPC listed on the delivery record. I am trying to add a BP number and related…
  • Progress bar in Sage X3 4GL

    Hi everyone, I'm using "Call OUVRE_BOITE From GESECRAN" to show a popup window with a progress bar while doing some stuffs. How can I show the same popup window but with 2 bars, the first for the main task and the second for the sub tasks? Thank you…
  • Screen Layouts - SOH1 in particular...

    I'm trying to insert a new block into the SOH1 screen, but no matter how I set the positions they are not interpreted the same way the function help describes (using the "grill"). Given these 3 blocks: BP, Position 1.1, line 1, col 2, sequence 5…