Browse By Tags

  • Customization Error

    Dear All, I am creating a new tab on OE Shipment Entry. I achieve the UI that I want, and now I want send post request on a click of a button. Instead, I am getting an error: Unexpected Error: Your request could not be completed within the time…
  • 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…
  • 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 modify the quantities of a delivery and its movements of stock through code or import / export template

    I have a validated delivery to which I want to modify both the delivery quantities and the quantities of the stock movements made; I need to do it by code or template. Would anyone know what template to use or how could I develop it?
  • Filter itmref field based on category selected in the management screen in order

    Hi, Please I need serious help, in solving this issue. I created a new field in the management tab called category that is jumps to the product category table. So I am trying to make the selection of itmref field in the line tab in order filter…
  • Class not returning table field when using representation?

    I'm having an interesting issue at the moment. I'm trying to call the TCWPOHTOSIGM representation and TCWPOHSIG class via the $details facet. It is not returning the supplier name though. The supplier name exists in the table, and the field BPRNAM1…
  • How to add dimensions in account pyramids

    Hello Everyone, Is it possible to add Dimensions in account/nominal ?? I am able to add dimension under account 31100 (on screen). However, when I click on SAVE button, it throw error " Error in pyramid 31100 " and records didn't save in database…
  • 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…
  • GROSS PRICE AND DISCOUNT CALCULATION ON PO LINE SCREEN?

    Hi, I am trying to get a value display on a field on the PO line screen. This is the concept: field description data type [M:POH2]GROPRI entered md8 (internal type: decimal) [M:POH2]DISCRGVAL entered md8 (internal type…
  • How to select a transaction with CALL OBJET

    I'm using CALL OBJET in this way to open a sales order: GBIDC1 = [M:ZC3D0]SOHNUM Call OBJET ("SOH", GBIDC1, GBIDC2) From GOBJET Can I set the transaction that should be used and avoid the selection screen?
  • 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…
  • Printing a crystal report via webservices

    Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…
  • Line Menu - Data not stored

    Hi I created a custom field in table BPCustomer table. Enabled the item in SPEBPC script.When I enter text it does get stored in TEXCLOB table.(The save button also doesn't get enabled) When I enter text in this field I want to store it.How can…
  • 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…
  • Hello friends, I would like to know how to add a bundle node.js to X3.

    I would like to make a bundle in node.js, for Webservice consumption and add to X3.
  • How to create 2+ records in V7 style "simultaneously"?

    Hi, How can I create two or more instances in V7 Style code ( Leave request representation) ? In this specific case I want to create as many entrys in the table as contracts registered for the Employee. I tried with a For Cycle in "AINSERT_AFTER…
  • Insert new line in AOWSIMPORT web service

    Hello, I'm trying, on Sage X3 V11, to import a Task using the specific X3 Model with the help of AOWSIMPORT WebService. The X3 Model for Tasks defines the field separator as a new line (\010\013), but as soon as I put a newline inside the I_FILE in…
  • 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…
  • Validation rule on a custom field

    Hi all, I would like to know what is the best way (step by step) to create a rules/automation on a custom field. I have a field on SIH0 screen, It is a type A field: 1 - When creating the register, the system populates the field with a sequential…
  • 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…
  • ADC Soap API

    Has anybody created an API call for an ADC function? More specifically, I am looking at the ADC Material picking screen and looking for information on how to write a write api call for this. Thanks, Chris
  • I need help with cloning a capability.

    Please any help will be appreciated. I am trying to clone a functionality from Customer BP Invoices under the AP/AR Accounting. In the Distribution field in Lines where you can perform analytical distribution I am trying to clone same functionality for…
  • 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…
  • 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…