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…

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…

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…