Browse By Tags

  • Creating Delivery via web services, based on a Order

    I am trying to create a Delivery via web services, and have it attached to an existing Order. The order has been allocated, and ready for Delivery creation. I created a simple object web service using the SDH object. I am sending the order # in the header…
  • 4GL- Calling IMPORTSIL from grid contextual menu (GBOUT1) doesn't work

    Hi, I'm facing a weird behaviour. In my specific, I've developed a routine that uses IMPORTSIL to add a new line to an existing sales order. This routine is simple: Reads current SOH data and generates a text file Add a new text line from parameters…
  • Add certificate at pdf and send via email

    Hi Everybody IS there the possibility of adding a certificate when generating a pdf invoice, and automatically sendind it by email? Right now we send pdf invoices by email, but I don't know if can add a certificate to pdf before. Has anyone encountered…
  • Update Credit status field (CDTSTA)

    Is there a way to update the credit status field of a sales order on creation? I have tried setting the value on in APRES_CRE "[M:SOH1]CDTSTA = 4" without any luck. I have also tried using the entry point TRTVENCDT > CALCREDIT also without any luck. …
  • How to change record by code

    Hi, Anyone knows if it's possible to change a record by code without leaving and entering the object? For instance, a button on a window that forces the current record to other than the one currently loaded. Is there any standard call…
  • REST Web service Pagination

    Hi everyone, I'm using representations to use the REST web services in sage x3 v12, and it's working fine, but some parameters it seems not to work. I want to do a pagination when I use the $details facet, but it's not working. looking this page…
  • Deleting Sage X3 folder from database

    Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…
  • 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…
  • Is there an entry point or built in function to view an attachment?

    On X3 V12, I want to add a button or menu item that opens an attachment on an object without opening the attachments popup window. I know all of the parameters of the attachment and want to know what the code is for viewing the attachment. I see GOBJTXT…
  • How to Post Purchase Invoice via Code

    Hi, We want to post Purchase Invoices from code after it has been saved, we have done a similar customization for the Suppliers and it works perfectly. However, for the Purchase Invoices, it does not execute. Here is the code snippet we use. It…
  • Change Browser's label dynamically

    FormerMember
    FormerMember
    Hi, does anyone know how to change a browser label dynamically? At the moment, I´m using the variables TITLIS and TITSEL(1) at $TITRE action. Both variables change values but don´t display the new value. Best regards, Afonso Carvalho
  • Validate PO Invoice with Webservice

    Does anyone here have any idea how to validate a PO Invoice using a webservice, or other similar method?
  • Purchase Request workflow

    I am trying to prevent the signature circuit from restarting when the supplier is set or changed. Most of the end users will not know or care who the supplier is during the initial stages of the request. However, the purchaser is required to assign…
  • Custom field not saving to SPLW

    I have created a custom field (YUDF) to table PRICSTRUCT and class PRICSTRUCT. Then the field was added to screen SPLW. The field appears to work fine with no errors. However, when returning to the record, the data had not been save. Any ideas/
  • Sage X3 - Print reports to Email

    Good afternoon. With the need of one of my clients to send all kind of reporting by email we came across a problem. We used the ARP event to manage the workflows so they could send the message with their report as an attachment. This worked smoothly…
  • Cost Estimation tools

    Is there a BoM-based cost-estimation tool that is compatible with Sage EM v11? We’re in the subcontract electronics manufacturing industry and that is somewhat unusual in that the number of components is far in excess of the number of operations. Most…
  • 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?
  • Hybrid mode Development specifc/standard script management

    Hi everyone, Is there anyone who have experiance with Hybrid mode development for customer? I have a question how you handle Script managament below is my case: In standard Class PJMTSKITM we have property ITMREF this property has PROPAGATE…
  • Clone record through 4GL

    Hi, I would like to clone an invoice after posting, but the "Child" record will have few changes. Would anyone have a piece of script that clones one record to share, as an example? Just to learn the best way to do it. Thank you. Best regards…
  • Custom date field in table OPPOR (Sage X3)

    I added a custom date field to a table in Sage X3 (OPPOR). I have added the field to the table and class, I have also added the AM code to the SPE. After validation I enter a value in the field on the screen, when exiting the field, the value reverts…
  • Create new record from another object in 4GL

    Hi, I need to create in Sage X3 V9 (patch 6) a new analitycal dimension (object CCE) on creating new Project (object OPP) with some data from the last one, my client request an automatic function on create so any new button are forbidden, in my specific…
  • creating a web app using mertial picking adc functionality

    Has anyone every created an external web app and that app uses the adc functionality or know of a way to do this? So basically, I am trying to create an an external web app, but I want it to behave in the same functionality when I am doing the material…
  • Get REST webservice photo

    Hi, I created a specific table to store some information.. One of the columns is a photo (blob)... How can I consume them via web service to show the photo on an external HTML page? In the picture below, BLOB_0 is my field where the photo is. How…
  • 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…
  • How to do "find" in class with nested Collection?

    Hello, I try to make some development in PJM module V11. we have OPPORPJM class there which have Property TAS linked with class PJMTSK During Task planning I Have prepared 3 Phases If I look at Value in Instance GZINSPJM I can see: GZINSPJM…