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

Hi, I would like to update 100 function profile's functional authorization. I developed an import template (based on AFP and GESAFP; I did something on AFP object to allow import) but I got this error for special supervisor functions like: AIMP or…

Hi, For context: - There are two custom scripts each using own custom import template. -- The only difference between the two custom script is just the custom import template used. Both opens same tables for import. - Both are scheduled in Recurring…

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…

Hi, How do you subtract time with the 4GL language? Thanks, Chris

Hi Guys I've implemented create report functionality. The following part is calling report creator: Call ETAT("ZLETTREVIRR", "FILEPDF", "", 0, PROP, TPAR, TVAL) From AIMP3 Where "FILEPDF" destination - output file type pdf. I also added FICHER for saving…

Hi! I'm editing a customization inside a sales order program (file SPESOH), of our Sage ERP. I'm not able to understand the meaning of variable "status": I think status is a "system" variable, but what kind of status it contains? Thanks for…

I'm curious to understand the difference between using a trbegin - commit - rollback sequence to update a value(s) on a table vs. using an Update With statement . the Trbegin statement would look like this: Trbegin [TBL] If !fstat Write [F:TBL]…

I was wondering how it would be possible to disable the print icon so that documents may not be printed in a specific window. I have tried using Call VIREBOUT(CHAINE,E) but it unfortunately doesn't work. Is there a different subprogram that handles icons…

Hi All, For one of our customer we have written a sub program based web service in which we have used standard import export template to create the sales order in the system. The reason behind using the import export template is, we have sales kit product…

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?

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…

What is the difference between ETAT and ETATN when it comes to automatically printing out reports? ETAT () from AIMP3 ETATN () from ETAT

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…

Hello, I need sum a number of days in a Date in 4GL. Anywhere now a simple formule to make this? For exemple: Field: Actualy day -> 24/09/2018 Number: 10 I need the new date will be 04/10/2018 Thank you for your help.

Is there a way to automatically print the order acknowledgement when somebody presses the create button on the sales order?

Hi, Currently trying to send an email through code using following snippet: Send GSERMES With & "__TO="+chr$(1)+"[email protected] & "__CC="+chr$(1)+" user2@no reply.com ", & "__SUJET="+chr$(1)+"message title", & "__NOTE="+chr$(1)+"message text", &…

I am calling web services, using update 9, and I am receiving the following error: protocol error: 3 bytes missing^ It seems to be completely intermittent - sometimes it works and other times I receive this error. Has anybody had this same issue?