Sage X3

Hi, In 4GL, I know for silent import, there is IMPORTSIL (From GIMPOBJ). How about, in 4GL, the silent export function with filter option? I know I can do a manual file write inside the 4GL script but it is very annoying to maintain. Web service…

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

Please excuse my ignorance, but I'm trying to read some scripts in X3 and I'm wondering what the '!' before a function or command means. Also, can anyone confirm if the : is an end of line notation? I'm looking for 4gl language references that might…

Hi all, as you can read i'm trying to import an invoice in my Sage X3 V9 PATCH 6 using Web Services, in my specific script(SPESIH) there is an action that i don't want to perform if i'm importing using web services. I wonder if there is a method to…

I made a new table (ZITEMECO) and a new screen (ZITF0) to use inside OITF window but i'm having trouble to read the table, it appears that $LIENS action not working at all, what am i doing wrong. Here is the code of the SPEITF: # Gestão da máscara…

Hello, Is it possible to make a for-loop with a SQL "group by" or "select distinct" statement? Br, Carl

Am interested in writing / developing an application that will export data from Sage x3. I want to do it from the application level not from the database level. Would really like help in getting the solution. Possibly if i can get documentation to read…

Hi, i'm using an import model that work on two tables... during (or after) the import process i need to update a field of a third table. Ho can i do? Thanks a lot!!!

I was wondering if there is a way to remove the : in datetime$. The reason why I want this removed is this because I am trying to export data to a text file and I want the file name for the text file to be datetime$, but windows won't let you create a…

Hey, I am having trouble linking multiple tables in 4GL. These are the fields and tables that I want to link. Name Field Name Table Reference Work Order Number MFGNUM MFGITM Product Label YPRODLBL…

I am trying to export data from sage to a text file on our server. So far, I got this in my code: --------------------------------------------------------------------------------------------------------- If clalev([F:SOH])=0 Local File SORDER [SOH…

Good day everyone, We are able to create deliveries using import templates but we will like to be able also to delete this created deliveries using the same procedure. There's any way to achieve this? We tried using the template setting the qty fields…

Hi I am trying to import a sales order using an import template, in the processing I can run some validations and stop the import by setting OK=0 if the validation fails, however it is my requirement that we just drop the one line of the import that…