Sage X3

Hello Does anyone work with Bank of America and develop a Mapping between Sage and their interface? we are starting this process and help and advice will be welcomed. Thanks Patrick

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…

We have a line at the bottom of our invoice about our terms that needs to be updated on our invoices that are printed and sent to customers. We are using Sage X3 and cannot figure out where to go to update that template.

Hi, I want to create new Purchase Order Print code.

Hi everyone, The current report name in the email : jobrpt_YNA-CUSSTA2.pdf (The YNA-CUSSTA2 is the name of the report) Expected report name: if the user selects one business partner : SOA_BusinessPartnerName.pdf If the user selects more than one…

Good day Everyone I am trying to make an email notification trigger (not the problem this time) and one of the fields is formatted to RTF. Therefore when the system sends the email it includes the RTF formatting. Is there anything I should be putting…

Group, A question from a co worker was asked of me a couple weeks back, and I'm late asking this question. Does Sage have report cards, vendor grading capabilities? Doesn't have to be anything too complicated. The basics would be a great start. I really…

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…

I have several company logo in png format that I wish to link to my SAP Crystal Report as in (Able to use the company logo on the SAP Crystal Report) by extracting the company logo from Sage X3. I would like to know how to do so. I need clarification…

Hi All, I've have created an import template for Technical Sheet. However it did not succeed in uploading the description. Mind to point out which part is wrong? Regards Meng

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 everyone, Does anyone know how to run 4GL functions in a class/rep? I have added a method in the SPE but from this one when executing a function it gives an error, the function is ASYRVISU to display a pdf that is in a directory, but I see that other…

Hi, Somebody can help me to implement a generator invoice by code with the entry point GENSIH please?

I'm trying to setup a new Financial Data Extraction form for a Balance Sheet and Income Statement in X3 for a different format, but I'm not finding helpful instructions from start to finish. Does anyone have a good resource for creating different formats…

I want to save the filename of the file being imported. It is disaplyed in the log, but I don't know in what variable it is stored. It is NOT "FICHIER" or "[M:IMP2]NOMIMP".

I'm trying to work out the correct format for the I_FILE parameter when using AOWSIMPORT to do an import, when the template specified in I_MODIMP is an XML template. I can get it working fine with a flat file structure for I_FILE, but I can't work out…

Hi everyone ! Appreciate your support on this On the sales invoice screen, (All - sales - Invoice (full entry invoice), we added a template for the client to print the Proforma Invoice. However when we give the print option for the 'Proforma Invoice…

Hi all, We are working on new non-standard legislation on sageX3 V12, we have done some specific customization such as crystal report, new data types, Miscellaneous table 909,..... We need to patch all these customization then apply it to our customer…

Hello, Currently, we are trying to copy/clone an existing report from a current folder to a new folder. Everything works well except for the SQL Server Stored Procedure that is used to query the data. Inside this stored procedure, we must declare…

Hi, In the past, I remember adding custom header lines to an export file when using export templates via specific script processing. I believe it was done using wrseq once the file was opened in the background by Sage to write to the export file. I…

Is there a standard Sage report that would display customer details (name/ quantity/ that was shipped from a given PO? I need to create such report and I'm just looking for a simple way to go about. Basically all the customer details for what PO's were…

Hi everyone, I have a customer that is planning to go live with X3 Version 12. They make tech modules and have complex BOMs which require version management (Major Versions Only). They have many historical BOMs that they need to have in the system and…

Hi I make some customization on import/export template for PO and add some costume field, when I try to import the file the PO is successfully created and the field is populated with data that I imported except for the custom field, I try to run test…

Hello, is there a convenient way in X3 to show the trade debtors that have a credit balance in other liabilities on the balance sheet? We would like to avoid manual G/L reposting entries during monthly closing process. Thanks for your ideas! …