Sage X3

I was asked about a shortcut to print a screen array to an Excel export, instead of the user having to click "Excel Export". Thanks, Zoey

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…

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…

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…

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…

Hello We have the problem that sometimes the print server not prints out a report. Even though we started the print for a document (e.x. purchase order) in 4GL with the following code: For a custom development we are looking for an Entry Point which…

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…

Hello! I'm Sage X3 developer and I having issues with Grid development. Does someone have a documentation about NBLIG, nolign, counters and grid screen? Thanks.

BOMs I am trying to add a custom long description field to our Manufacturing BOM screen (BOH0) and receiving this error - I've added a "Before Field" Action to the ITMREF field and added this as the script. Subprog AV_ITMREF(VALEUR) Variable…

Hello everyone, For our customer we developed a specific screen to manage plans. In order to edit a plan the user has to press a check out button. The user who checked out the plan can modify the plan. In the FILTRE action we use the global Variable…

I have a need to set the format of fields on a screen to "Display" when a certain value is detected in a field. I know how I could suppress it conditionally, but that's not what I want to do. Basically... if I were writing the suppress for it I would…

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…

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…

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…

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…

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…

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…

Hi all, i have a problem with this function: Funprog SUM_TOTAL(PROJECT,BUDGET) Value Char PROJECT Value Char BUDGET Local Decimal TOTAL If !clalev([F:PJBU]) Local File PJMBUD [PJBU] : Endif If !clalev([F:PJLB]) Local File PJMBUDLIG [PJLB] : Endif If…

Hello Guru's, One of our customers noted that Sales Delivery Module doesn't have the standard capability of filtering the Sales Order Selection like the function currently available in Purchase Invoice where the module has a line menu for Purchase Order…

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…

Hi I have a customized report ZSORDERS I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…

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…

Hi all, I am trying to build a SPE to capture a number (Field is a text), split the digits, multiply each one, sum all and validate the result. I have some questions: 1 - Now, I am working with STRING and I need convert this String to a Integer, so I…

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…

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…